Problem with inserting data

hello i have been experiencing some problems with inserting data into a table in the database. i keep getting this error: Cannot insert the value NULL into column ‘location_ID’, table even though i did set the location ID on auto increment

this is the code im using to insert:

 private void addbtn_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandType = CommandType.Text; con.ConnectionString = Properties.Settings.Default.DatabaseConnection; con.Open(); // locationIDtxtOutput = Console.WriteLine(12); cmd.CommandText = "insert into [dbo].[Location] (country, location_region, location_house_number, location_road_number, location_block_number, location_description) values('@country', @location_region, @location_house_number, @location_road_number, @location_block_number, @location_description)"; cmd.Parameters.AddWithValue("@country", countryCmbx.Text); cmd.Parameters.AddWithValue("@location_region", regionCmbx.Text); cmd.Parameters.AddWithValue("@location_house_number",int.Parse(houseNumtxtInput.Text)); cmd.Parameters.AddWithValue("@location_road_number", int.Parse(rdNumtxtInput.Text)); cmd.Parameters.AddWithValue("@location_block_number", int.Parse(blockNumTxtInput.Text)); cmd.Parameters.AddWithValue("@location_description", descriptiontxtInput.Text); cmd.ExecuteNonQuery(); con.Close(); } 

ps. im new to using C#, i usually use Java

submitted by /u/t_sharqi
[link] [comments]

Leave a Reply