Dynamic DataTable Bind from DataTable after Filtering by any value of DataTable

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

কোন মন্তব্য নেই:

একটি মন্তব্য পোস্ট করুন