TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
chanaka anurada
NA
22
1.1k
inserting Data to SQL DB
May 8 2019 7:04 AM
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 :
Reply
Answers (
2
)
QR Code in Crystal report of a Web application in VS2008
Where does the code go in Step 10 of the article below?