DataTable Bind Method
1: public DataTable FilterDataTable(DataTable iDt, string FilterBy) //Desired DataTable
2: {
3: DataTable ndt = new DataTable();
4: int v;
5: // Query String are generate here
6: string FilterQuery = "";
7: for (v = 0; v <= iDt.Columns.Count - 1; v++)
8: {
9: ndt.Columns.Add(iDt.Columns[v].ColumnName); // Binding Output DataTable Colums
10: if (FilterQuery == "")
11: {
12: FilterQuery = dt.Columns[v].ColumnName + " Like '%" + FilterBy + "%' ";
13: }
14: else
15: {
16: FilterQuery += " or " + iDt.Columns[v].ColumnName + " like '%" + FilterBy + "%' ";
17: }
18: }
19: DataRow[] dtr;
20: dtr = iDt.Select(FilterQuery); // Query Run
21: foreach (DataRow row in dtr)
22: {
23: DataRow drt = ndt.NewRow();
24: for (v = 0; v <= iDt.Columns.Count - 1; v++)
25: {
26: drt[v] = row[v];
27: }
28: ndt.Rows.Add(drt); // Binding Output Rows
29: }
30: return ndt; // Return DataTable after Filtering
31: }
1: //Calling DataTable
2: dataGridView2.DataSource = FilterDataTable(InputDataTable, SearchbyValue);
কোন মন্তব্য নেই:
একটি মন্তব্য পোস্ট করুন