Hope so it will help you.
class MultiPleValues
{
DataTable dt;
private void Insert()
{
try
{
dt = GetDataTable();
DataRow dr = dt.NewRow();
dr.BeginEdit();
dr["S_NO"] = "You Values";
dr["Name"] = "Your Name";
dr.EndEdit();
dt.Rows.Add(dr);
string strQuer = "Select * from --Your Table Name Here";
dt = InsertQuery(strQuer, dt);
}
catch (Exception)
{
throw;
}
}
private DataTable GetDataTable()
{
try
{
DataTable dtTemp = new DataTable();
dtTemp.Columns.Add("S_NO");
dtTemp.Columns.Add("Name");
return dtTemp;
}
catch (Exception)
{
throw;
}
}
public static DataTable InsertQuery(string SelectQuery, DataTable dt)
{
try
{
SqlConnection sqlconn = new SqlConnection("Your Connection String here");
sqlconn.Open();
SqlCommand sqlcommand = new SqlCommand(SelectQuery, sqlconn);
SqlDataAdapter adapter = new SqlDataAdapter(sqlcommand);
SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(adapter);
cmdBuilder.ConflictOption = ConflictOption.OverwriteChanges;
adapter.Update(dt);
return dt;
}
catch (Exception)
{
throw;
}
}
}
Don't hesitate in asking any question?
Thanx