R
Ramin
Hi, I have 2 textboxses on asp.net page
textbox=description, textbox2=quantity
What I want when I enter values for them it stored temporarily or smth. like
that and then when I click order button it should submit it to SQL Server
(order, orderdetails)
it is like shopping basket bit without products. I enter products manually
(discription and quantity) and then click add. So I want to add many
orderdetails to single order
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
SqlConnection1.Open()
SqlCommand1.CommandText = "NewOrder"
SqlCommand1.CommandType = CommandType.StoredProcedure
Dim p As New SqlClient.SqlParameter()
p.ParameterName = "@empID"
p.Direction = ParameterDirection.Input
p.SqlDbType = SqlDbType.Int
p.Value = 1
SqlCommand1.Parameters.Add(p)
p = New SqlClient.SqlParameter()
p.ParameterName = "RETURN"
p.Direction = ParameterDirection.ReturnValue
p.SqlDbType = SqlDbType.Int
SqlCommand1.Parameters.Add(p)
SqlCommand1.ExecuteScalar()
Dim RFID As Integer = CType(SqlCommand1.Parameters("RETURN").Value, Integer)
SqlCommand1.CommandText = "NewOrderLine"
SqlCommand1.CommandType = CommandType.StoredProcedure
SqlCommand1.Parameters.Clear()
p = New SqlClient.SqlParameter()
p.ParameterName = "@RFID"
p.Direction = ParameterDirection.Input
p.SqlDbType = SqlDbType.Int
p.Value = RFID
SqlCommand1.Parameters.Add(p)
p = New SqlClient.SqlParameter()
p.ParameterName = "@Description"
p.Direction = ParameterDirection.Input
SqlCommand1.Parameters.Add(p)
p = New SqlClient.SqlParameter()
p.ParameterName = "@quantity"
p.SqlDbType = SqlDbType.Int
SqlCommand1.Parameters.Add(p)
'add order
p = SqlCommand1.Parameters("@description")
p.Value = TextBox1.Text
p = SqlCommand1.Parameters("@quantity")
p.Value = TextBox3.Text
SqlCommand1.ExecuteNonQuery()
SqlConnection1.Close()
End Sub
textbox=description, textbox2=quantity
What I want when I enter values for them it stored temporarily or smth. like
that and then when I click order button it should submit it to SQL Server
(order, orderdetails)
it is like shopping basket bit without products. I enter products manually
(discription and quantity) and then click add. So I want to add many
orderdetails to single order
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
SqlConnection1.Open()
SqlCommand1.CommandText = "NewOrder"
SqlCommand1.CommandType = CommandType.StoredProcedure
Dim p As New SqlClient.SqlParameter()
p.ParameterName = "@empID"
p.Direction = ParameterDirection.Input
p.SqlDbType = SqlDbType.Int
p.Value = 1
SqlCommand1.Parameters.Add(p)
p = New SqlClient.SqlParameter()
p.ParameterName = "RETURN"
p.Direction = ParameterDirection.ReturnValue
p.SqlDbType = SqlDbType.Int
SqlCommand1.Parameters.Add(p)
SqlCommand1.ExecuteScalar()
Dim RFID As Integer = CType(SqlCommand1.Parameters("RETURN").Value, Integer)
SqlCommand1.CommandText = "NewOrderLine"
SqlCommand1.CommandType = CommandType.StoredProcedure
SqlCommand1.Parameters.Clear()
p = New SqlClient.SqlParameter()
p.ParameterName = "@RFID"
p.Direction = ParameterDirection.Input
p.SqlDbType = SqlDbType.Int
p.Value = RFID
SqlCommand1.Parameters.Add(p)
p = New SqlClient.SqlParameter()
p.ParameterName = "@Description"
p.Direction = ParameterDirection.Input
SqlCommand1.Parameters.Add(p)
p = New SqlClient.SqlParameter()
p.ParameterName = "@quantity"
p.SqlDbType = SqlDbType.Int
SqlCommand1.Parameters.Add(p)
'add order
p = SqlCommand1.Parameters("@description")
p.Value = TextBox1.Text
p = SqlCommand1.Parameters("@quantity")
p.Value = TextBox3.Text
SqlCommand1.ExecuteNonQuery()
SqlConnection1.Close()
End Sub