26-02-16, 05:24 AM
كود :
void me1()
{
string connectionString = ConfigurationManager.ConnectionStrings["myconstr"].ToString();
SqlConnection connection = new SqlConnection(connectionString);
DataSet dss = new DataSet();
string sql = "INSERT INTO amounts (code, d_amount,d_on,d_date)"+
"SELECT code, d_amount,d_on,d_date" +
" FROM temp WHERE code NOT IN (SELECT code FROM amounts )";
try
{
connection.Open();
SqlDataAdapter adapter = new SqlDataAdapter(sql, connection);
adapter.Fill(dss);
Response.Write("Number of rows " + ds.Tables[0].Rows.Count.ToString());
connection.Close();
}
catch (Exception ex)
{
Response.Write("Error in execution " + ex.ToString());
}
}
اخواني اريد ان ارجع عدد الصفوف التي تم ادخالها الى الجدول
الكود المرفق يعمل عدا السطر
كود :
Response.Write("Number of rows " + ds.Tables[0].Rows.Count.ToString());
can not find table 0
م الحل جزاكم الله كل خير