salmah
دوشنبه 17 آذر 1393, 23:54 عصر
سلام .
من میخوام توی لود صفحه مقدار ماکسیمم idکه Identity yes هست را از جدول1 بگیرم
به این صورت نوشتم ولی ارور داره
string cnc = ConfigurationManager.ConnectionStrings["abcdeConnectionString"].ConnectionString;
SqlCommand cmd = new SqlCommand("select max(id) from table1");
string sid = cmd.ExecuteScalar().ToString();
ارور
An exception of type 'System.InvalidOperationException' occurred in System.Data.dll but was not handled in user code
Additional information: ExecuteScalar: Connection property has not been initialized.
من میخوام توی لود صفحه مقدار ماکسیمم idکه Identity yes هست را از جدول1 بگیرم
به این صورت نوشتم ولی ارور داره
string cnc = ConfigurationManager.ConnectionStrings["abcdeConnectionString"].ConnectionString;
SqlCommand cmd = new SqlCommand("select max(id) from table1");
string sid = cmd.ExecuteScalar().ToString();
ارور
An exception of type 'System.InvalidOperationException' occurred in System.Data.dll but was not handled in user code
Additional information: ExecuteScalar: Connection property has not been initialized.