Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
all groups > dotnet ado.net > august 2003 > threads for monday august 4

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

retrieve a single entry
Posted by Eddie at 8/4/2003 10:46:28 PM
Hi, I've created an asp.net(vb.net) page which is for a user login. Very simple, it connects to an access database. I was wondering, is it possible to retrieve a single entry without using the DataSet or DataGrid. In vb.net I have used dbRead.Item("username') (just to let you know what dbRead ...more >>


Syntax to connect to Mysql
Posted by Raymond at 8/4/2003 10:10:04 PM
Dear all, What is the syntax of create connection and recordset of using ADO. Net to connect to Mysql database, especially the connection string? I am eager for your help. Any links are welcome? Thanks, ...more >>

Retrieving heirarchical data from SQL into a DataSet
Posted by DJ Miller at 8/4/2003 9:52:24 PM
We have a stored procedure that returns a data set that is the result of several Joined tables. Is there any way to have that data fill an ADO.Net DataSet object in hierarchical form, so that the DataSet has the same number of DataTables as there are tables in the SP, with DataRelations already ...more >>

System.Data.SqlClient.SqlException - Cannot sort a row of size 8111, which is greater than the allowable maximum of 8094.
Posted by rsomers NO[at]SPAM macroent.com at 8/4/2003 2:32:36 PM
Is this a limitation of the data reader, the database, or the driver? Is there a way to return the result of a query that returns rows larger than 8094 bytes? The maximum my current dataset should have is: 8330 (Based on the size of the combined fields in the query.) ToString() output: --...more >>

ADO.NET Cleanup
Posted by Tom Archer at 8/4/2003 1:29:51 PM
Besides closing the connection, is there any other cleanup I should be doing for the adapter, dataset, datatable and commandbuilder objects upon application exit? ...more >>

Get the correct data row in an own DataGridColumn class
Posted by Frank at 8/4/2003 10:33:43 AM
Hello, i created an own DataGridColumn. In this class i get the corresponding data with the GetColumnValueAtRow method. Now i will display all new lines in the DataGrid in Red. So i inserted an additional field called 'New'. My problem is that i cannot access the correct data row. I tried to...more >>

Connection String Security
Posted by Steve - DND at 8/4/2003 10:16:20 AM
I'm curious about connection string security within a network. We have a setup with many webservers going out to a clustered DB server. Is all the effort I put forth to secure my connection strings(whether it be DPAPI, encrypted and stored in the registry, etc...) in vain, since at some point I ...more >>

Datatable for a multi valued column?
Posted by STom at 8/4/2003 9:56:26 AM
I have a requirement to create a DataTable that relates to information on a particular web screen. This wouldn't be too difficult except that one of the fields is a multi-select listbox. What is the best way to do this with a Datatable? Thanks. STom ...more >>



Incremental search in dataset
Posted by yuraukar at 8/4/2003 4:44:02 AM
Is there a way to acomplish incremental searching (search as you type) in a dataset? For example, I would like to bind a grid or list to the dataset and then provide an edit box where the user can type for searching. As the user types, the grid scrolls to the first row matching the text as...more >>


DevelopmentNow Blog