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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|