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) ...

MySQL DayofWeek And Weekday Functions

DayOfWeek ------------------ Returns the weekday index for date (1 = Sunday, 2 = Monday, …, 7 = Saturday). These index values correspond to the ODBC standard. Weekday ------------ 0 = Monday , 1 = Tuesday, 2 = Wednesday, ...... Sunday = 6). DayName ------------ Weekday name of the date.

Saving an Image to Database

Step1 : Show OpenFileDialog OpenFileDialog strGetImage = new OpenFileDialog(); strGetImage.InitialDirectory = strDirectory; strGetImage.Filter = "Image Files(*.BMP;*.JPG;*.GIF)|*.BMP;*.JPG;*.GIF|All files (*.*)|*.*"; strGetImage.FilterIndex = 1; strGetImage.Multiselect = false; strGetImage.RestoreDirectory = true; DialogResult Result = strGetImage.ShowDialog(); Step2: After selecting the image convert the image into Bytes. if (Result == DialogResult.OK) ...

My Tech Blog

Dieses Blog durchsuchen