auto generate the id after data sucessfully inserted

sandeep sandy

10y889.NET

HI,

the id should auto incremented after the data inserted into database,

here in my code after page refresh id is increasing can u modify my code and send it,

thanks in advance

----------------------------------------------------------------------------------------------

namespace Help_Desk

{

public partial class WebForm2 : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString());

//string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

string str;

SqlCommand com;

int count;

protected void Page_Load(object sender, EventArgs e)

{

//SqlConnection con = new SqlConnection(strConnString);

str = "select count(*) from employee1";

com = new SqlCommand(str, con);

con.Open();

count = Convert.ToInt16(com.ExecuteScalar()) + 1;

txt_empid.Text = "E00" + count;

con.Close();

}

protected void btn_insert_Click(object sender, EventArgs e)

{

//SqlConnection con = new SqlConnection(strConnString);

con.Open();

str = "insert into employee1 values('" + txt_empid.Text.Trim() + "','" + txt_empname.Text.Trim() + "'," + txt_sal.Text.Trim() + ")";

com = new SqlCommand(str, con);

com.ExecuteNonQuery();

con.Close();

Label4.Text = "Records successfully Inserted";

}

------------------------------------------------------------------------------------------------------------------------

2 Replies

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

Shakti Singh Dulawat10y ago
Accepted answer
Check below more easy using SQL IN this way you don't need to insert EmpCode Every time http://www.webcodeexpert.com/2015/08/auto-generate-auto-incremented-unique.html
CREATE TABLE tbEmployee
(
                EmpId INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
                EmpCode AS 'EMP' + RIGHT('0000'+ CONVERT(VARCHAR(5),EmpId),5) PERSISTED,
                EmployeeName VARCHAR(50),
                Age        INT,
                Gender VARCHAR(10)
)
--INSERT RECORDS IN TABLE
INSERT INTO tbEmployee (EmployeeName,Age,Gender)VALUES
('Mayank',25,'Male'),
('Ankita',24,'Female'),
('Anuj',26,'Male'),
('Jaswinder',25,'Male'),
('Simran',25,'Female')

--CHECK INSERTED RECORD
SELECT * FROM tbEmployee
Ravi Patel10y ago
Hi ,
try this
namespace Help_Desk
{
public partial class WebForm2 : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString());
//string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
string str;
SqlCommand com;
int count;
protected void Page_Load(object sender, EventArgs e)
{
//SqlConnection con = new SqlConnection(strConnString);
if (!IsPostBack)
{
str = "select count(*) from employee1";
com = new SqlCommand(str, con);
con.Open();
count = Convert.ToInt16(com.ExecuteScalar()) + 1;
txt_empid.Text = "E00" + count;
con.Close();
}
}
protected void btn_insert_Click(object sender, EventArgs e)
{
//SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "insert into employee1 values('" + txt_empid.Text.Trim() + "','" + txt_empname.Text.Trim() + "'," + txt_sal.Text.Trim() + ")";
com = new SqlCommand(str, con);
com.ExecuteNonQuery();
con.Close();
Label4.Text = "Records successfully Inserted";
}
}
}