textbox

ta mu13y ago

i am using this now i can access the returend value increament it ant dispaly at textbox text SqlCommand cmd = new SqlCommand("Select MAX[Account_No] from addcustomer ",my); SqlDataReader dr = cmd.ExecuteReader();

0

Kunal Vaishya13y ago

Hi ta mu,

You can use this type of query to get Next Database no for your purpose

Examples

Select IsNull(Max(ColumnName),0) + 1 AS MaxID From TableName

Select IsNull(Max(ContactID),0) + 1 AS MaxID From tblContacts

0

Nimit Joshi13y ago

Hey ta mu,

So, what do you want? You want to show the added 11th id from the database or add 11th id in the database by clicking new Add Button?

If you want to add next row by Add button, then it will automatically increase into 11 as you described in your post.

Please post your cs file code to know more about.

0