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(11) 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