Hi all,
I have created a simple database table in ACCESS named as "Users" that
contains only two fields "UserID" ( Primary key )and "Password". I am
having problems while UPDATING the records in DataGrid. When i click
Edit button in datagrid and edit my values it actually doesn't update
the vales with newly entered values rather it keep on showing the
previous records. following is the code I used to create datagrid
--------------------------------
<asp:DataGrid id="DataGrid1" runat="server" OnEditCommand=" DoItemEdit"
DataKeyField="U serID" AutoGenerateCol umns="false"
onUpdateCommand ="DoItemUpda te" CellPadding="2" >
<COLUMNS>
<asp:EditComman dColumn HeaderText="Edi t"
EditText="Edit" ButtonType="Lin kButton" CancelText="Can cel"
UpdateText="Upd ate"></asp:EditCommand Column>
<asp:BoundColum n HeaderText="Use r Name"
DataField="User ID" ></asp:BoundColumn >
<asp:BoundColum n HeaderText="Pas sword"
DataField="Pass word" ></asp:BoundColumn >
</COLUMNS>
</asp:DataGrid>
------------------------------------
and following are my Edit and update methods in Vb.net
Sub DoItemUpdate(ob jSource as Object, objArgs as
DataGridCommand EventArgs)
Dim username as TextBox
Dim password as TextBox
Dim u,pass,userid as string
username=objArg s.Item.Cells(1) .Controls(0)
u = username.Text
password=objArg s.Item.Cells(2) .Controls(0)
pass=password.T ext
Label2.Text=u
userid= DataGrid1.DataK eys(objArgs.Ite m.ItemIndex)
Label1.text =pass
'"UPDATE [Users] SET [UserID]=@UserID, [Password]=@Password WHERE
([Users].[UserID]"& _
'" = @UserID)"
Dim sql as String="UPDATE [Users] SET [UserID]='" & u & "',
[Password]='" & pass & _
"' WHERE [Users].[UserID]='"& userid &"'"
Dim connectionStrin g As String = "Provider=Micro soft.Jet.OLEDB. 4.0;
Ole DB Services=-4; Data Source=C:\Issue Tracker"& _
"\Access.md b"
Dim dbConnection As OleDbConnection = New
OleDbConnection (connectionStri ng)
Dim dbCommand As OleDbCommand = New OleDbCommand
dbCommand.Comma ndText = sql
dbCommand.Conne ction = dbConnection
dbConnection.Op en()
dbCommand.Execu teNonQuery()
dbConnection.Cl ose()
DataGrid1.EditI temIndex = -1
BindData()
end sub
--------------------------
Sub DoItemEdit(objS ource as Object, objArgs as
DataGridCommand EventArgs)
DataGrid1.EditI temIndex=objArg s.Item.ItemInde x
BindData()
end sub
----------------------------
and here is the BindData ()
Sub BindData()
Dim connectionStrin g As String =
"Provider=Micro soft.Jet.OLEDB. 4.0; Ole DB Services=-4; Data
Source=C:\Issue Tracker"& _
"\Access.md b"
Dim dbConnection As System.Data.IDb Connection = New
System.Data.Ole Db.OleDbConnect ion(connectionS tring)
Dim queryString As String = "SELECT [Users].* FROM
[Users]"
Dim dbCommand As OleDbCommand = New OleDbCommand
dbCommand.Comma ndText = queryString
dbCommand.Conne ction = dbConnection
Dim dataAdapter As OleDbDataAdapte r = New
OleDbDataAdapte r
dataAdapter.Sel ectCommand = dbCommand
dataAdapter.Fil l(dataSet,"User s")
DataGrid1.DataS ource=dataSet
DataGrid1.DataB ind()
end sub
----------------------------------------------
I understand that it's a lengthy question and might take your time. But
being new to asp.net I am really stumped and I have posted my question
after turning pages of a book and relentless GOOGling and I couldn't
find a solution to above.
Any help, suggestions or insights will be highly appreciated. I really
appreciate your time and help.
Thanks in advance.
Thanks,
Erland
