Datagrid Update

ahptintantnoun · Apr 28, 2012

I have been through several examples and this still doesn't work. I want to update a row in the datagrid. It updates the row but with the original values from the db not the values in the cell. I don't know why. Here is the code. Any Ideas Imports sd = System.Data Imports sql = System.Data.SqlClient Public Class WebForm1 Inherits System.Web.UI.Page Protected WithEvents dgInventory As System.Web.UI.WebControls.DataGrid Protected WithEvents TextBox1 As System.Web.UI.WebControls.TextBox Protected WithEvents TextBox2 As System.Web.UI.WebControls.TextBox Protected WithEvents TextBox3 As System.Web.UI.WebControls.TextBox Protected WithEvents TextBox4 As System.Web.UI.WebControls.TextBox Protected WithEvents lblstatus As System.Web.UI.WebControls.Label Protected WithEvents lblDepCode As System.Web.UI.WebControls.Label Protected WithEvents lblType As System.Web.UI.WebControls.Label Protected WithEvents lblDescription As System.Web.UI.WebControls.Label Protected WithEvents Button1 As System.Web.UI.WebControls.Button Protected WithEvents Label1 As System.Web.UI.WebControls.Label #Region " Web Form Designer Generated Code " 'This call is required by the Web Form Designer. <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() End Sub Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init 'CODEGEN: This method call is required by the Web Form Designer 'Do not modify it using the code editor. InitializeComponent() End Sub #End Region Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim DS As DataSet Dim strConn As String = "Server=dev01; Database=exhibitManagement; UID=sa; PWD=moremoney;" Dim myConnection As sql.SqlConnection = New sql.SqlConnection(strConn) Dim MyCommand As sql.SqlDataAdapter Dim sqlStr As String = "SELECT invID, Description, Type, Status from inventory where clientid = 1" MyCommand = New sql.SqlDataAdapter(sqlStr, myConnection) DS = New DataSet() MyCommand.Fill(DS, "Inventory") dgInventory.DataSource = DS dgInventory.DataBind() myConnection.Close() End Sub Private Sub DataGrid1_EditCommand(ByVal source As Object, _ ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs ) _ Handles dgInventory.EditCommand dgInventory.EditItemIndex = e.Item.ItemIndex dgInventory.DataBind() End Sub Private Sub DataGrid1_CancelCommand(ByVal source As Object, _ ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs ) _ Handles dgInventory.CancelCommand dgInventory.EditItemIndex = -1 dgInventory.DataBind() End Sub Public Sub DataGrid1_UpdateCommand(ByVal source As Object, _ ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs ) _ Handles dgInventory.UpdateCommand Dim txtDescription As TextBox = e.Item.Cells(2).Controls(0) Dim txtType As TextBox = e.Item.Cells(3).Controls(0) Dim txtStatus As TextBox = e.Item.Cells(4).Controls(0) Dim txtinvID As TextBox = e.Item.Cells(1).Controls(0) 'take values and update the db Dim sqlStr As String = "UPDATE Inventory Set Description = '" & txtDescription.Text & "', Type = '" & txtType.Text & "', Status = '" & txtStatus.Text & "' where invID = '" & txtinvID.Text & "'" Response.Write(sqlStr) Dim strConn As String = "Server=dev01; Database=exhibitManagement; UID=sa; PWD=moremoney;" Dim myConnection As sql.SqlConnection = New sql.SqlConnection(strConn) Dim MyCommand As sql.SqlCommand MyCommand = New sql.SqlCommand(sqlStr, myConnection) myConnection.Open() MyCommand.ExecuteNonQuery() myConnection.Close() dgInventory.EditItemIndex = -1 dgInventory.DataBind() End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click End Sub Private Sub dgInventory_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dgInventory.SelectedIndexChanged End Sub End Class Just for the hell of it... In your Page_Load function cap the database read with a if(!IsPostBack) { //All of your original Page_Load code goes here. } It may be an order of execution problem you're looking at. Just give it a shot, who knows. (I'm pretty new to this myself, but I've found that ASP will persist your data across postbacks, allowing you to modify it incrementally)I put this code in If Not IsPostBack Then BindDataGrid() End If And Everytime I click a button the whole grid disappears. I am guessing because it goes through the whole load_page funciton and since its a post back it doesn't rebind the grid. So maybe that is my problem if that data is persisting with the postback but how can I see my grid? Or maybe this isn't the problem at all. I am not sure. I know the db is being updated but not with the edited values in the text boxes on the grid.OK I have the ispostback checking I found out if I take the whold binding process like the one below and put it in its own procedure. Then I call this whole procedure after every event it works. The new data updates. This seems very costly in resources to rebind the whold grid every time. Maybe that is exactly what the typical databind command does but it wasn't working in this case. Any other way to save on the resources. I can just imagine what this piece of code would cost me when several hundred people hit this page. Sub BindDataGrid() Dim DS As DataSet Dim strConn As String = "Server=dev01; Database=exhibitManagement; UID=sa; PWD=moremoney;" Dim myConnection As sql.SqlConnection = New sql.SqlConnection(strConn) Dim MyCommand As sql.SqlDataAdapter Dim sqlStr As String = "SELECT invID, Description, Type, Status from inventory where clientid = 1 order by invID" MyCommand = New sql.SqlDataAdapter(sqlStr, myConnection) DS = New DataSet() MyCommand.Fill(DS, "Inventory") dgInventory.DataSource = DS dgInventory.DataBind() myConnection.Close() DS = Nothing End Sub

Datagrid Update

ahptintantnoun

New Member