inserting Data to SQL DB

chanaka anurada

7y877

please help me to to slove this matter!!!

SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\RmDb.mdf;Integrated Security=True");
con.Open();
SqlCommand com= new SqlCommand("INSERT INTO RmPro(AOD_Number,Material_type,Lot_Number,ID_Number,Gross_weight,Pallet_weight,Net_weight,Expire_date,Shift)VALUES(@AOD_Number,@Material_type,@Lot_Number,@ID_Number,@Gross_weight,@Pallet_weight,@Net_weight,@Expire_date,@Shift)", con);
com.Parameters.AddWithValue("@AOD_Number", txtGrAod.Text);
com.Parameters.AddWithValue("@Material_type", txtGrMt.Text);
com.Parameters.AddWithValue("@Lot_Number", txtGrLot.Text);
com.Parameters.AddWithValue("@ID_Number", txtGrId.Text);
com.Parameters.AddWithValue("@Gross_weight", txtGrGw.Text);
com.Parameters.AddWithValue("@Pallet_weight", txtGrPw.Text);
com.Parameters.AddWithValue("@Net_weight", txtGrNw.Text);
com.Parameters.AddWithValue("@Expire_date", dtpGrxp.Text);
com.Parameters.AddWithValue("@Shift", txtGrShift.Text);
com.ExecuteNonQuery();
con.Close();

giving Error :

2 Replies

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