Insert values to sql server databse if id is auto increment

Question

i created table Id is Auto Increment column I need Insert data into sql server asp.net c# Submit button

Ankit Sharma · Answer

Hi, Please look into this example of employee table CREATE TABLE [dbo].[tblEmployees]( [EmployeeID] [ int ] IDENTITY(1,1) NOT NULL , [ Name ] [ varchar ](20) NULL , [Gender] [ varchar ](6) NULL , [City] [ varchar ](20) NULL , [Salary] [ int ] NULL ) ON [ PRIMARY ] GO here EmployeeID is identity field which is auto incremented. Use below code in aspx.cs page on button click public void InsertRecord(Employee objEmployee) { try { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[ "mycon" ].ToString()); string query = "INSERT INTO tblEmployees VALUES(@Name, @Gender, @City, @Salary) " ; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue( "@Name" , objEmployee.Name); cmd.Parameters.AddWithValue( "@Gender" , objEmployee.Gender); cmd.Parameters.AddWithValue( "@City" , objEmployee.City); cmd.Parameters.AddWithValue( "@Salary" , objEmployee.Salary); con.Open(); cmd.ExecuteScalar(); con.Close(); } catch { throw ; } } Please try after putting your own connectionstring and let me know if it works for you