how to autoincrement the u value in asp.net?

Preetham Thangamma

7y911Learn iOS Programming

for ex:how to autoincrement

ES320P72041921750 by 1 value and end the value by ES320P72041921755 in ASP.NET without using stored procedure

6 Replies

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

Tamil Selvan7y ago
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 < 56)
{
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
0
Preetham Thangamma7y ago
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
0
Amit Mohanty7y ago
Hey Preetham is there any fixed partten in ES320P72041921751 ?
0
Jaimin Shethiya7y ago
"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
0
Preetham Thangamma7y ago
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
0
Jaimin Shethiya7y ago
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
+1