i want to search datagrid content with textbox and button

Nagendra Panyam

i had a datagrid with no sql or no backend by buttonclick events i passed values to grid

now i want to search those values by one textbox and button

that means when i entered text in text box by clicking search button want to grid show the matched values .this done in wpf

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta7y ago
Can you please be specific to your question, what you are asking? Your question and post has been changing significantly
Nagendra Panyam7y ago
please help how i add rows and columns by using loops..
am tried the fallowing one
am able to insert only one row...

DataTable _datatable=new DataTable("Empinfo");
public DataTable DataTable
{
get { return _datatable; }
set { _datatable = value; }
}

public void CreateNewRow()
{

this._datatable = new DataTable("Table");
this._datatable.Columns.Add("Name");
this._datatable.Columns.Add("Id");
this._datatable.Columns.Add("Age");
this._datatable.Columns.Add("Title");
this._datatable.Rows.Add(txtName.Text, txtId.Text, txtAge.Text, txtTitle.Text);

this.gridtest.DataContext = this;

}
private void Submitbtn_Click(object sender, RoutedEventArgs e)
{
CreateNewRow();
Amit Gupta7y ago
Thats what I had asked about the datasource in my first post. There is no need to copy the contents to clipboard and reading and putting it on a datatable. The most optimized process is to use a datatable and bind it with datagrid and then you can perform search, filters etc.
Nagendra Panyam7y ago
i had done with fallowing code please guide me if any wrong
i want to search values in datagrid with a textbox content by clicking the search button
am new to wpf please guide
public static DataTable DatagridtoTable(DataGrid dg)
{
dg.SelectAllCells();
dg.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader;
ApplicationCommands.Copy.Execute(null, dg);
dg.UnselectAllCells();
string result = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue);
string[] lines = result.Split(new string[] { "\r\n", "\n" }, StringSplitOptions.None);
string[] fields;
fields = lines[0].Split(new char[] { ',' });
int cols = fields.GetLength(0);
DataTable dt = new DataTable();
for (int i = 0; i < cols; i++)
dt.Columns.Add(fields[i].ToUpper(), typeof(string));
DataRow Row;
for (int i = 1; i < lines.GetLength(0) - 1; i++)
{
fields = lines[i].Split(new char[] { ',' });
Row = dt.NewRow();
for (int f = 0; f < cols; f++)
{
Row[f] = fields[f];
}
dt.Rows.Add(Row);
}
return dt;
Amit Gupta7y ago
Okay, then you must have to use loop through the Datagrid items, like below
foreach(DataRowView row in grid.Items)
{
    for(int i = 0; i < row.Row.ItemArray.Length; i++)
    {
   var CRow=  row.Row[i];
   //CRow contains the row items, do your stuff here
    }
}
Nagendra Panyam7y ago
thanq
no its not a datatable,
that values passed by textboxes to datagrid every time when i run the application.
Amit Gupta7y ago
What is the source of datagrid? Is it a datatable or something else, can you brief