Iam looking a good solution for wrapping around records in the table. The
requirement is to keep only last n (eg. 20000) number of records in the
table.
After inserting the n+1 record the first record need to be removed from the

Iam working with a custom grid control to navigate
navigate large number of records from a table.
The control need to have row up, row down, page up, page
down features.

I'm looking for some advice. I have developed a system for a client using
the DataSet object within a business layer. There are various points in the
application were I need to perform a transaction over multiple datatable
objects within said Dataset. How is transactions best ...

I have a DataTable with a UniqueConstraint defined for columns A and B:
ds.tables("myTab").constraints("myUC") has columns A and B in its Columns
collection
But ReadXML will load an XML document that has duplicate values for columns

Does ADO.NET support ways of  locking  table, row, database ?
Regards,
Chak.

I can set the properties Namespace and Prefix on datasets, datatables and
datacolumns.
I beleive this is handy in my situation (specially for tables and columns),
however I cannot find any way to set the namespace and prefix properties in

When I first heard about VB.NET it should be so easy to update
"Mother/child" tables. Just build at datasett with all the tables, do the
changes and run .Update.
Well, I cant get this to work that easy. Do anyone have some pointers on how

I have a combo box with DropDownStyle set to DropDownList. I bind it
as follows:
cmboOperators.DataSource = opTable
cmboOperators.DisplayMember = "OperatorName"

(Type your message here)
--------------------------------
From: John Mairs
Hi Folks,

I was wonderring what was the best method in ADO.Net regarding wrapping a
transaction around 2 seperate databases. Is it even possible?
Thanks.

I should know this but I dont and cant find an answer via Google...
If my table as a primary key bases on multiple fields and I do a
select with a Where statement using those fields, will the select be
faster because of the primary keys?

I have a asp app that works well on local host. The connection string is as
follows in the web.config
<appSettings>
<add key="cs" value="Provider=Microsoft.Jet.OLEDB.4.0;Data

VB.net issue here.
I've a strange event that I can't seem to figure out...
On my Form, I've a TabControl (two Tabs)...
On my first tab, I load an Ascii file and dump some info onto my ListView

I'm new in programming programming in VS.NET 2003. I have some experience in
Embedded Visual Basic and VB.6. In these programming languages i use adoce
and adodb to access an MS Access database. But I don't know how to do this
in vb.net.

Has anyone come across any elegant frameworks that allows writing to
multiple data sources? I'm looking for something that allows a typical
master data source for storing and retrieving data, but I'd also like
it to be able send select data to other datasources. IOW, the other