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 :