increment with last id

Question

increment with last id  how to get the counted value of particular field in a variable to perform some function using the counted value. { SqlConnection con = newSqlConnection(@server=CSE-PC; integrated security=true; Database=Bas); con.Open(); SqlCommand com = newSqlCommand(select top(1) SUBSTRING(CustomerId10) as Last_Id from devi order by Last_Id desc con); strc00 = com.ExecuteScalar().ToString(); com.ExecuteNonQuery(); here i have gave code like this but it does not work any one please give syntax for this question. if (i == 0) here I need to increment with last id how to get the counted value in a variable. { strc00 = 001; } else { int j = i + 1; strc00 = 001 + j.ToString(); } comboBox1.Items.Add(strc00); i++; MessageBox.Show(Id Created); con.Close(); } }

Syed Shanu · Answer

You can also change your query like this : select top(1) SUBSTRING(CustomerIdlen(CustomerId)1) as Last_Id from devi order by CustomerId Desc

saravanagopi s · Answer

Your parameter of substring (10) will always return empty value

saravanagopi s · Answer

SqlCommand com = new SqlCommand(select top(1) CustomerId from devi order by CustomerId desc conn); conn.Open(); string strc00 = com.ExecuteScalar().ToString(); string substr = strc00.Substring(1 1); com.ExecuteNonQuery(); conn.Close(); //In substr you will get the substring value(instead of 11 change what you need to split) //as you entered 10 it wont return any value

Syed Shanu · Answer

Check my article. You can find the Store Procedure.it will be good to use Stored Procedure .You can find the Max value.Increment the value and return the final result as you needed .

Durga Velusamy · Answer

SqlCommand com = newSqlCommand(select top(1) SUBSTRING(CustomerId10) as Last_Id from devi order by Last_Id desc con); strc00 = com.ExecuteScalar().ToString(); com.ExecuteNonQuery(); sir how to Store the Max value result to a Variable . if i store the max value in variable means then i can use that variable to increment. like if the variable count c; then i have count the id . how to buy the counted value to variable. how to get counted value in a variable c.

Syed Shanu · Answer

Check this SQL query Hope this will help you. --Create Sample Table create table devi (CustomerID varchar(30)) --Insert one sample Record Insert into devi(CustomerID) Values ('C001') --Declare Variable Declare @maxCustID nvarchar(30); --Store the Max value result to a Variable Set @maxCustID='C00' + Convert(Varchar(10)(Select MAX(RIGHT(CustomerId 1))+1 from devi)) -- Display the Max Customer ID select @maxCustID CustIds You can also check my article which has related example to save the Item master with incremetn value. http://www.c-sharpcorner.com/UploadFile/asmabegam/insert-select-update-delete-in-Asp-Net-with-simple-login/