private void btnSearch_Click(object sender, EventArgs e)
{
try
{
if (tbxSearch.Text != "")
{
string parameter = tbxSearch.Text;
dsView ds = new dsView();
dsViewTableAdapters.vEmployeeGridTableAdapter taEmployee = new dsViewTableAdapters.vEmployeeGridTableAdapter();
DataTable dt = taEmployee.GetDataByString(parameter);
grdEmployee.AutoGenerateColumns = false;
grdEmployee.Rows.Clear();
int count = 0;
foreach (DataRow item in dt.Rows)
{
count++;
grdEmployee.Rows.Add(item[0], item[1], item[2], item[3], item[4], item[5], item[6]);
}
tbxCount.Text = count.ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void FillGrid()
{
dsView ds = new dsView();
dsViewTableAdapters.vEmployeeGridTableAdapter taEmployeeGrid = new dsViewTableAdapters.vEmployeeGridTableAdapter();
DataTable dt = taEmployeeGrid.GetData();
grdEmployee.AutoGenerateColumns = false;
grdEmployee.Rows.Clear();
int count = 0;
foreach (DataRow item in dt.Rows)
{
count++;
grdEmployee.Rows.Add(item[0], item[1], item[2], item[3], item[4], item[5], item[6]);
}
tbxCount.Text = count.ToString();
}
