DataRow dr = dt.Rows.Find(new object[] { custm_id });
if (dr == null)
{
// dt.Rows.Add(dr);
dr = dt.NewRow();
val=true;
dr["custmid"] = custm_id;
}
else
{
dr.BeginEdit();
}
dr["fieldname"] = "test";
if (val)
{
dt.Rows.Add(dr);
}
else
{
dr.EndEdit();
}
like this i have edited table.
changes affected in datatable
SqlDataAdapter adapter;
using (adapter = new SqlDataAdapter("SELECT fieldname FROM customlist", con))
using (new SqlCommandBuilder(adapter))
{
Ananth GPosted Nov 2, 2016, 3:08 AM
Prakash KumarPosted Nov 2, 2016, 2:08 AM