|
|
Code (VB.NET)
Dim connection As New SqlConnection("Data Source************************************************************")
Dim command3 As New SqlCommand("insert into MAT_OUT(SIZE,SPEC,TYPE,CUSTOMER,QTY,DATE,TIME,SERIAL_NO,DOC_NO) values(@1,@2,@3,@4,@5,@6,@7,@8,@9)", connection)
command3.Parameters.Add("@1", SqlDbType.VarChar).Value = TextBox7.Text
command3.Parameters.Add("@2", SqlDbType.VarChar).Value = table.Rows(0)(2).ToString
command3.Parameters.Add("@3", SqlDbType.VarChar).Value = table.Rows(0)(3).ToString
command3.Parameters.Add("@4", SqlDbType.VarChar).Value = table.Rows(0)(4).ToString
command3.Parameters.Add("@5", SqlDbType.VarChar).Value = TextBox1.Text
command3.Parameters.Add("@6", SqlDbType.VarChar).Value = DateTimePicker1.Text
command3.Parameters.Add("@7", SqlDbType.VarChar).Value = **********
command3.Parameters.Add("@8", SqlDbType.VarChar).Value = *************
command3.Parameters.Add("@9", SqlDbType.VarChar).Value = TextBox5.Text
connection.Open()
command3.ExecuteNonQuery()
connection.Close()
|
ประวัติการแก้ไข 2018-12-09 01:07:30
|
|
|
|
Date :
2018-12-09 01:06:44 |
By :
nutpopo |
|
|
|
|
|
|
|
|