private void TableInterest_Load(object sender, EventArgs e)
{
try
{
obj_sqlProvider = new sqlProvider();
mtd_BindDataGrid();
}
catch (Exception ex)
{
}
obj_sqlProvider = null;
}
private void btn_Update_Click(object sender, EventArgs e)
{
try
{
obj_sqlProvider = new sqlProvider();
obj_sqlProvider.con.Open();
// Insert or update row.
DataTable v_DTbl = (DataTable)dataGridView1.DataSource;
DataTable v_DTblChange = v_DTbl.GetChanges();
v_DTbl.AcceptChanges();
obj_sqlProvider.tbl_TableInterest_InsUpdDel(v_DTblChange);
}
catch (Exception ex)
{
}
//dataGridView1.DataSource = obj_sqlProvider.tbl_TableInterest_Gets();
mtd_BindDataGrid();
obj_sqlProvider = null;
//obj_sqlProvider.con.Close();
}
private void btn_Search_Click(object sender, EventArgs e)
{
try
{
obj_sqlProvider = new sqlProvider();
string v_ColName = txt_ColName.Text;
if (v_ColName.Trim() == "")
{
v_ColName = "%%";
}
else if (!cbx_SearchExact.Checked)
{
v_ColName = "%" + v_ColName + "%";
}
dataGridView1.DataSource = obj_sqlProvider.tbl_TableInterest_GetByMoney("50000");
}
catch (Exception ex)
{
}
obj_sqlProvider = null;
}
