Recent content by paulhudson

Many thanks for such a prompt response. It works a treat. Amazingly enough in all this sunshine, my day has become brighter still. Thanks again.

I am querying a database - the query can only have one row/cell returned. The query works fine when run against the database. What I am doing is using the result to form part of a url for a redirection. Trouble is I cannot see how you can retrieve a value without creating a bindable object...

Using the script below I create an editable datagrid. In edit mode all changes are successfully made to the dataset and are displayed on reloading page. The problem occurs when I attempt to write changes back to the datasource using the update method on the last line of the subroutine...

Sorry about using the wrong forum! Can I move this post? neilharris - I was under the impression that I could use stored procedures: Public oDataAdapter As New OleDbDataAdapter("spTeamByMatchDataID", oConnect) Public UpdateCMD As OleDbCommand = New OleDbCommand("UpdateTeamPlayer", oConnect)...

Using the script below I create an editable datagrid. In edit mode all changes are successfully made to the dataset and are displayed on reloading page. The problem occurs when I attempt to write changes back to the datasource using the update method on the last line of the subroutine...

I have a logon page which has three textboxes. On clicking submit the following procedure is called. Needless to say it fails. Essentially I am trying to count a number of records that match username password etc from within an access database. If the count is one then the logon is a success...

I am attempting to use FindControl on datarow but keep getting the following error: Input string was not in a correct format The column is created thus: <code> tpDataColumn = New DataColumn() tpDataColumn.DataType = System.Type.GetType("System.Int32") tpDataColumn.ColumnName = "UniqueID"...

I have a datgrid bound to a dataset. I am using dataset.acceptchanges() to update the edited parts of the datagrid - but it fails to do this. The OnEditCommand works fine, OnUpdateCommand simply returns datagrid exactly as it was prior to edit. The code is: Sub DoItemUpdate(ByVal sender As...