With a DropDown box which is bound to a datasource, how do I do the
following:
1.  Cause the first item in the drop down box to not show up as already
selected.

I'll try this one again now that I have my registration in order
combobox shows fields only when I change datasets
This is the first time the problem has arisen
For the table - Authors - I want updated, inserted, selected - and for the four comboboxes I created separate dataadapters ...

I'm interested in searching a column of type text for specific words withing the field. I need the search to be rapid. Currently, I use a LIKE predicate in the RowFilter of a DataView
For best results, should I explore Full Text Indexing and using a CONTAINS predicate? Would it be ...

I have an intermittent problem with an SQLDataAdapter.Fill command.  Every
now and then the system returns an "Object reference not set to an instance
of an object" right after filling the Address table.
   Public Sub GetProfileTables(ByVal strSQL As String)

Head-scratcher here .... I have a routine that updates manufacturer data
using the dataAdapter and dataSet. My code correctly opens the connection,
loads up the existing table, and adds a row to the DataTable. But when it
gets to updating the adapter, gives an exception with the ...

how do I access a row within a DataTable object, after marked for deletion using row.Delete()
It seems to throw an exception, even though the data is available if I call The data_table.rejectChanges()
please help, I basically want access to all deleted rows, for reading before ...

  I have to add some rows of data into a datatable say "DT" containing data queried from a database.  The data queried is sorted on a column called currency.  I have six rowsets of data each rowset is based on currency. This data needs to be added to table "DT".  After adding ...

If this forum is the wrong place to discuss this issue please point me to
the right forum...
We have an ASP.NET application (InterNet app) originally written in .NET 1.0
running for about 2 years. Recently we installed .NET 1.1 and upgraded the

I'm filtering a DataView. After that I know that filter result only ( and
only) in one row with 4 or 5 columns. Now I want to pic up the value of one
of that columns (that I know only the name, eg. Code).
How can I take this value of that column of my DataView?

I am trying to update a DataTable using LoadDataRow.
Sometimes I reload records that I have read before.
According to the documentation LoadDataRow handles this automatically if the
primary key on the incoming row is the same as a row already in the

I have created a DataTable with several columns and then added some
rows and data in the rows.  It seems that when you access the data in
a particular row/column it is of type Object and not the data type
that you specified when you created the column.  So it seems that to

I need help writing a query. Im trying to use the access wizards but i cannot get it to work
This is what i need to do
I want to retrieve all the details of the last inserted booking from my database. I can do this by selecting the Max(BookingNo). I dont know if there is a better ...

What would be the best way to decompose a valid sql server connection
string? I am looking for four items (server name, db name, username,
password)
I guess I can use SqlConnection class to decompose the connection string;

I'm using the OleDbDataAdapater to Fill a DataSet using MS Access as the
data source. The select command includes a memo field in the result set.
Everything works fine, except only the first 255 characters of the memo
field make it to the DataSet - the rest is truncated.

Can I connect to sql server ce database with ado.net ???
Is it possible ??? Thankss