for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
String m = ds.Tables[0].Rows[i].ItemArray[0].ToString();
String m1 = ds.Tables[0].Rows[i].ItemArray[6].ToString();
String m2 = ds.Tables[0].Rows[i].ItemArray[12].ToString();
string m3 = ds.Tables[0].Rows[i].ItemArray[13].ToString();
string insert = "insert into table(aaa,aa,aa,aa) values('" + Gpcode + "','" + m + "','" + m1 + "','" + m2 + "')";
SqlHelper.ExecuteNonQuery(con, CommandType.Text, insert);
}
{
String m = ds.Tables[0].Rows[i].ItemArray[0].ToString();
String m1 = ds.Tables[0].Rows[i].ItemArray[6].ToString();
String m2 = ds.Tables[0].Rows[i].ItemArray[12].ToString();
string m3 = ds.Tables[0].Rows[i].ItemArray[13].ToString();
string insert = "insert into table(aaa,aa,aa,aa) values('" + Gpcode + "','" + m + "','" + m1 + "','" + m2 + "')";
SqlHelper.ExecuteNonQuery(con, CommandType.Text, insert);
}
No comments:
Post a Comment