G
Guest
hi,
i managed to populate my datagris and add a template colum to update the database. when i click the update button i get an error. is there something wrong with my code.
------------------code that populate the grid ar load
Dim conPos As SqlConnection
Dim cmdSel As SqlDataAdapter
Dim ds As DataSet
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
conPos = New SqlConnection("Server = prod01\enterprise;UID=sa;PWD=xxxx;Database=POS")
If Not Page.IsPostBack Then
BindGrid()
End If
End Sub
-----------------Bind Grid-----------------
Sub BindGrid()
cmdSel = New SqlDataAdapter("LoadOrderRegulation", conPos)
cmdSel.SelectCommand.CommandType = CommandType.StoredProcedure
cmdSel.SelectCommand.Parameters.Add(New SqlParameter("@productName", SqlDbType.VarChar, 15))
cmdSel.SelectCommand.Parameters("@productName").Value = "HELLO!"
ds = New DataSet
cmdSel.Fill(ds, "Oreg")
DataGrid2.DataSource = ds.Tables("Oreg").DefaultView
DataGrid2.DataBind()
End Sub
-----------------here is the update............
' Read values of the row
Dim productNumber As String = productNumber = e.Item.Cells(0).Text
Dim storeNumber As String = storeNumber = e.Item.Cells(1).Text
Dim accountNumber As String = accountNumber = e.Item.Cells(2).Text
Dim adjustment As Integer = CType(e.Item.Cells(7).Controls(0), TextBox).Text
'this is an update stored proc
Dim cmdDA As New SqlDataAdapter("UpdateOrderRegulation", conPos)
cmdSel.UpdateCommand.CommandType = CommandType.StoredProcedure
cmdSel.SelectCommand.Parameters.Add(New SqlParameter("@productNumber", SqlDbType.VarChar, 10))
cmdSel.SelectCommand.Parameters.Add(New SqlParameter("@storeNumber", SqlDbType.VarChar, 10))
cmdSel.SelectCommand.Parameters.Add(New SqlParameter("@accountNumber", SqlDbType.VarChar, 10))
cmdSel.SelectCommand.Parameters.Add(New SqlParameter("@adjustment", SqlDbType.Int))
cmdSel.SelectCommand.Parameters("@productNumber").Value = productNumber
cmdSel.SelectCommand.Parameters("@storeNumber").Value = storeNumber
cmdSel.SelectCommand.Parameters("@accountNumber").Value = accountNumber
cmdSel.SelectCommand.Parameters("@adjustment").Value = adjustment
cmdSel.Update(ds, "Oreg")
DataGrid2.EditItemIndex = -1
BindGrid()
can you guys see anything wrong with my update section.
thanks
i managed to populate my datagris and add a template colum to update the database. when i click the update button i get an error. is there something wrong with my code.
------------------code that populate the grid ar load
Dim conPos As SqlConnection
Dim cmdSel As SqlDataAdapter
Dim ds As DataSet
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
conPos = New SqlConnection("Server = prod01\enterprise;UID=sa;PWD=xxxx;Database=POS")
If Not Page.IsPostBack Then
BindGrid()
End If
End Sub
-----------------Bind Grid-----------------
Sub BindGrid()
cmdSel = New SqlDataAdapter("LoadOrderRegulation", conPos)
cmdSel.SelectCommand.CommandType = CommandType.StoredProcedure
cmdSel.SelectCommand.Parameters.Add(New SqlParameter("@productName", SqlDbType.VarChar, 15))
cmdSel.SelectCommand.Parameters("@productName").Value = "HELLO!"
ds = New DataSet
cmdSel.Fill(ds, "Oreg")
DataGrid2.DataSource = ds.Tables("Oreg").DefaultView
DataGrid2.DataBind()
End Sub
-----------------here is the update............
' Read values of the row
Dim productNumber As String = productNumber = e.Item.Cells(0).Text
Dim storeNumber As String = storeNumber = e.Item.Cells(1).Text
Dim accountNumber As String = accountNumber = e.Item.Cells(2).Text
Dim adjustment As Integer = CType(e.Item.Cells(7).Controls(0), TextBox).Text
'this is an update stored proc
Dim cmdDA As New SqlDataAdapter("UpdateOrderRegulation", conPos)
cmdSel.UpdateCommand.CommandType = CommandType.StoredProcedure
cmdSel.SelectCommand.Parameters.Add(New SqlParameter("@productNumber", SqlDbType.VarChar, 10))
cmdSel.SelectCommand.Parameters.Add(New SqlParameter("@storeNumber", SqlDbType.VarChar, 10))
cmdSel.SelectCommand.Parameters.Add(New SqlParameter("@accountNumber", SqlDbType.VarChar, 10))
cmdSel.SelectCommand.Parameters.Add(New SqlParameter("@adjustment", SqlDbType.Int))
cmdSel.SelectCommand.Parameters("@productNumber").Value = productNumber
cmdSel.SelectCommand.Parameters("@storeNumber").Value = storeNumber
cmdSel.SelectCommand.Parameters("@accountNumber").Value = accountNumber
cmdSel.SelectCommand.Parameters("@adjustment").Value = adjustment
cmdSel.Update(ds, "Oreg")
DataGrid2.EditItemIndex = -1
BindGrid()
can you guys see anything wrong with my update section.
thanks