Loading

return value of sql querry

ta mu

SqlCommand cmd = new SqlCommand("SELECT (MAX[Account_No] + 1) FROM addcustomer ", my);

            cmd.ExecuteScalar();
             int result = ((int)cmd.ExecuteScalar());
             textBox1.Text =Convert.ToString( result);

i want to save the return value of this query in a integer like abve but nothing displayed on textbox.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

SUNIL GUTTA13y ago
Possible error's :::

1. Connection string is not correct

2. If above one is working .. i doubt ur select statement i.e u quoting like MAX[account_no]+1 So Max function will get u last Account NO assuming ur PK as ACCOUNT_No ..

So by adding +1 to the coming account_no i.e which does not exist fetches u NULL values ..

Once check it .. Use Convert.toint32 which can handle null values better
0
Saber Shaikh13y ago
hi, shaikh saber use this link http://www.c-sharpcorner.com/UploadFile/rohatash/stored-procedure-with-a-return-value-in-sql-server-2012/ and use this http://www.codeproject.com/Questions/224585/how-to-call-stored-procedure-in-asp-net-csharp-cod
0