I was not been able to delete a row from an mdb file, so I started with Edit tasks first...<BR><BR>I been debugging a little time, and now it don't returns errors, but the aplication don't works aniway.<BR><BR>I imagine that the problem should be in the sql string or in the definition of my Primary Key (IdF) or maybe in the quotes (but I'm not sure of that because it compile..)<BR><BR>This is the sourcecode, you can try it with any mdb (adapting it to your tables..):<BR><BR>---------------------------------------<BR><%@ Page Language="VB" Debug="True"%><BR><%@ Import Namespace="System.Data" %><BR><%@ Import Namespace="System.Data.OleDb" %><BR><script language="VB" runat="server"><BR> sub Page_Load(obj as Object, e as EventArgs) <BR><BR> 'set up connection<BR> dim myConnection as new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("borrala.mdb") & ";")<BR><BR> 'open connection<BR> dim myCommand as new OleDbDataAdapter ("select * from tbdownloads", myConnection)<BR><BR> 'fill dataset<BR> dim ds as DataSet = new DataSet()<BR> myCommand.Fill(ds, "tbdownloads")<BR><BR> 'select data view and bind to server control<BR> DataGrid1.DataSource = ds<BR> DataGrid1.DataMember = "tbdownloads"<BR> DataBind()<BR> end sub<BR> <BR> sub DataGrid1_Edit(obj as object, e as DataGridCommandEventArgs)<BR> DataGrid1.EditItemIndex = e.Item.ItemIndex<BR> DataGrid1.DataBind()<BR> end sub<BR><BR> sub DataGrid1_Update(obj as object, e as DataGridCommandEventArgs)<BR> Dim myConn As OleDbConnection<BR> Dim connStr, sqlStr, strNomFich, strEnlace As String<BR> Dim myUpdateCommand As OleDbCommand<BR> Dim intPid As Integer<BR> <BR> intPid=e.Item.ItemIndex<BR> strNomFich=(Ctype(e.Item.Cells(1).Controls(0), Textbox)).Text<BR> strEnlace=(Ctype(e.Item.Cells(2).Controls(0), Textbox)).Text<BR> sqlStr="Update tbdownloads set NomFich=' " + strNomFich + " ', DescF=' " + StrEnlace + " ' WHERE IdF=" +intPid.ToString<BR> connStr="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("borrala.mdb") & ";"<BR> myConn=New OleDbConnection(connStr)<BR> <BR> myConn.Open() <BR> myUpdateCommand=New OleDbCommand(sqlStr, myConn)<BR> myUpdateCommand.ExecuteNonQuery<BR> myConn.Close() <BR> DataGrid1.EditItemIndex=-1<BR> DataGrid1.DataBind()<BR> end sub<BR><BR> sub DataGrid1_Cancel(obj as object, e as DataGridCommandEventArgs)<BR> DataGrid1.EditItemIndex = -1<BR> DataGrid1.DataBind()<BR> end sub<BR> <BR> sub DataGrid1_SortCommand(obj as Object, _<BR> e as DataGridSortCommandEventArgs)<BR> ' sort the data using the SortField property<BR> ' of the eventargs<BR> DataGrid1.DataBind()<BR> End Sub<BR><BR> sub DataGrid1_PageIndexChanged(obj as Object, e as DataGridPageChangedEventArgs)<BR> DataGrid1.CurrentPageIndex = e.NewPageIndex<BR> DataGrid1.DataBind()<BR> end sub<BR><BR><BR></script><BR><BR><html><BR><body><BR><BR> <form runat="server"><BR> <asp
ataGrid id="DataGrid1" runat="server"<BR> BorderColor="black"<BR> GridLines="Vertical"<BR> cellpadding="4"<BR> cellspacing="0"<BR> width="450"<BR> Font-NameFont-Names="Arial"<BR> Font-Size="8pt"<BR> ShowFooter="True"<BR> HeaderStyle-BackColor="#cccc99"<BR> FooterStyle-BackColor="#cccc99"<BR> ItemStyle-BackColor="#ffffff"<BR> AlternatingItemStyle-Backcolor="#cccccc"<BR> AutoGenerateColumns="false"<BR> AllowSorting=true<BR> OnEditCommand="DataGrid1_Edit"<BR> OnCancelCommand="DataGrid1_Cancel"<BR> OnUpdateCommand="DataGrid1_Update"<BR> AllowPaging="True"<BR> PageSize=2<BR> PagerStyle-Mode=NumericPages<BR> PagerStyle-PageButtonCount = 2<BR> OnPageIndexChanged="DataGrid1_PageIndexChanged" ><BR> <BR> <Columns><BR> <BR> <asp:TemplateColumn HeaderText="Descripci
