how to increment the Serial Number

Question

i have one combo box and one text box.

when i click the combo box the serial number to be increment.

porpertylocation combobox

serial number S000001

in the above when i click the above combo box the serial number to be increment.

Jignesh Trivedi · Answer

Hi Narasiman you have one combobox and click of combobox you required to increament Serial Number. Am I right? what is perpose of doing this? Each Time When you click on combo then you need produced New Serial number? From where you get the existing serial number? Thx.

sudharsan s · Answer

use this function to your code. and call the function inside of your combo box click event private void comboboxfunction() { SqlConnection con = new SqlConnection(constring);// db connection string con.Open(); string sql = select max(combobox_id)from Fileupload;// use primary key name SqlCommand cmd = new SqlCommand(sql con);// fileupload is table name use your table nam SqlDataReader dr; object combobox_id= cmd.ExecuteScalar(); if (combobox_id == DBNull.Value) { ViewState[id] = 1; } else { int m=Convert.ToInt32(ref_id.ToString()); int n = m + 1; ViewState[id] = n.ToString(); } }