searching a text in a Datatable

DataRow[] filesWithAA = dt.Select("Column_name LIKE '%KS%'");
dt.DefaultView.RowFilter = "[Column_name] LIKE '%(KS)%'";
DataTable dtOutput = dt.DefaultView.ToTable();

Kommentare

Beliebte Posts aus diesem Blog

How to - Web browser Control

Creating a simple HTML Editor using Web brower control Create a basic Winform Appln. Drag a Webbrowser( end in the list ) from Toolbox. To create buttons drag a Toolstrip control (near webbrowser ctrl in the list 'Commoncontrols' ) from Toolbox. You can add buttons, text box, progressbar etc by clicking. c To make the Web browser control editable you have to write the following code while initializing. InitializeComponent(); webBrowser1.DocumentText = "<HTML><BODY contentEditable='true'></BODY></HTML>"; toolStripComboFontSize.SelectedIndex = 2; Double click on buttons to generate events. Variable possibilities are there . Some are given below, 1. Change text color if (colorDialog1.ShowDialog() == DialogResult.OK) ...

Select the rows depending upon the occurence

SELECT `id` FROM table GROUP BY id HAVING COUNT(*) = 1 id column1 column2 -------------------------- 1 value1 value2 1 value1 value2 2 value1 value2 Executing the above query will get a result id --- 2 while occurence of the id = 2 is only once

Floating Webbrowser control Images

foreach (HtmlElement im in webBrowser1.Document.Images) { im.Style="FLOAT:left;"; }

My Tech Blog

Dieses Blog durchsuchen