increment with last id

Durga Velusamy

11y1.2k

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(CustomerId,1,0) 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();

}

6 Replies

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

Syed Shanu11y ago
You can also change your query like this : select top(1) SUBSTRING(CustomerId,len(CustomerId),1) as Last_Id from devi order by CustomerId Desc
saravanagopi s11y ago
Your parameter of substring (1,0) will always return empty value
saravanagopi s11y ago
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 1,1 change what you need to split)
//as you entered 1,0 it wont return any value
Syed Shanu11y ago
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 Velusamy11y ago
SqlCommand com = newSqlCommand("select top(1) SUBSTRING(CustomerId,1,0) 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 Shanu11y ago
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/