Private Sub gridfill() ds = employee.Getsearchemp(Trim(txtsearch.Text)) Gridsearch.RowCount = 0 For i As Integer = 0 To ds.Tables(0).Rows.Count - 1 Gridsearch.RowCount += 1 Gridsearch(Gridsearch.RowCount, 1).CellValue = ds.Tables(0).Rows(i)("regionname") Gridsearch(Gridsearch.RowCount, 2).CellValue = ds.Tables(0).Rows(i)("unitname") Gridsearch(Gridsearch.RowCount, 3).CellValue = ds.Tables(0).Rows(i)("first_name") Gridsearch(Gridsearch.RowCount, 4).CellValue = ds.Tables(0).Rows(i)("fathername") Gridsearch(Gridsearch.RowCount, 5).CellValue = ds.Tables(0).Rows(i)("DOB") Gridsearch(Gridsearch.RowCount, 6).CellValue = ds.Tables(0).Rows(i)("designationname") Gridsearch(Gridsearch.RowCount, 7).CellValue = ds.Tables(0).Rows(i)("probation_date") Gridsearch(Gridsearch.RowCount, 8).CellValue = ds.Tables(0).Rows(i)("DOJ") Gridsearch(Gridsearch.RowCount, 9).CellValue = ds.Tables(0).Rows(i)("Resignation Date") Next End Sub
Gridsearch.DataSource = ds Gridsearch.DataBind()
Gridsearch.Rows.Count
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)