I have 2 tables Station and Contract. Contract have a foreign key relationship with Station table IDStation auto increment . How i get IDStation number at same time i do insert statement.
cmd.CommandText = "Insert into Stations (CityID," + "StartDate,Space,Owner)" + "values (@CityID,@StartDate," + "@Space,@Owner)" + "Insert Contract (IDStation,ContractStart,ContractEnd) values (@IDStation,@ContractStart,@ContractEnd) "; cmd.Parameters.AddWithValue("@CityID", drpCity.Value); cmd.Parameters.AddWithValue("@StartDate", txtStartDate.Value); cmd.Parameters.AddWithValue("@Space", txtSpace.Text); cmd.Parameters.AddWithValue("@Owner", txtOwner.Text); // cmd.Parameters.AddWithValue("@IDStation",drp ); cmd.Parameters.AddWithValue("@ContractStart", txtConStart.Value); cmd.Parameters.AddWithValue("@ContractEnd", txtConEnd.Value); cmd.ExecuteNonQuery();