how to autoincrement the u value in asp.net?

Question

for ex:how to autoincrement ES320P72041921750 by 1 value and end the value by ES320P72041921755 in ASP.NET without using stored procedure

Jaimin Shethiya · Answer

Hello, can you please try to below code for increment value. var text = "ES320P72041921751"; var str1 = text.Substring(0, 6); var no = Convert.ToInt64(text.Substring(6)); Console.WriteLine(str1); Console.WriteLine(no); Console.WriteLine("{0}{1}", str1, no + 1); let me know if you have needed any other help from myside. Thanks

Jaimin Shethiya · Answer

"Hello, In that you have check with the value " ES320P72041921755 " var no = GetNumber(" ES320P72041921751 "); if(no == " ES320P72041921755 ") { return false; } else { return true; } public string GetNumber(string text) { var text = "ES320P72041921751"; var str1 = text.Substring(0, 6); var no = Convert.ToInt64(text.Substring(6)); return $"{str1}{no+1}"; } can you please chech the above code for that and whatever end number just check with the if statement and go ahead. Thanks

Tamil Selvan · Answer

Hi, use below code for database related autoincrement method. aspx: "server" id= "txt_id" ReadOnly= "true" Height= "22px" Width= "155px" > web config: "conn" connectionString= "Data Source=testserver;Initial Catalog=Test_app;Persist Security Info=True;User ID=sa;Password=sa; integrated security=false; " /> cs: SqlConnection Conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[ "conn" ].ToString()); protected void btnsub_Click( object sender, EventArgs e) { getid(); } public void getid() { SqlCommand cmd = new SqlCommand( "SELECT MAX (CAST(INT_UID as NVARCHAR)) FROM TEST_AUTOINCREMENT" , Conn); Conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { string Value = reader[0].ToString(); if (Value == "" ) { txt_id.Text = ( "ES320P72041921751" ); //ES320P72041921751 } else { txt_id.Text = reader[0].ToString(); var myString = txt_id.Text; txt_id.Text = myString.Substring(15); int check = Convert.ToInt32(txt_id.Text); if (check > 50 && check { txt_id.Text = (Convert.ToInt64(txt_id.Text) + 1).ToString(); string code = "ES320P720419217" + txt_id.Text; txt_id.Text = code; Session[ "sdid" ] = txt_id.Text; } } } Conn.Close(); } Thanks

Preetham Thangamma · Answer

Hello Amit Mohanty, Yes there is a fixed pattern.... i need to add to data base directly from textbox with the following number ES320P72041921751 and i have to end it at ES320P72041921755 .Please help me regarding that it will be great help Thank you.. https://www.c-sharpcorner.com/members/amit-mohanty2

Amit Mohanty · Answer

Hey Preetham is there any fixed partten in ES320P72041921751 ?

Preetham Thangamma · Answer

thanks jaimin shethiya for immediate response i need to add to data base directly from textbox with the following number ES320P72041921751 and i have to end it at ES320P72041921755 .Please help me regarding that it will be great help