maybe I'm OT, but I don't know where else I can put this question.
Say you have to write a program for a very small company (5 pc). They just
need to store some data in a database which is on a server and they need to
access this database from some other computers, with client ...

A DateTimePicker control on my form is bound to a datetime field in a
DataTable.
When inserting a new record the default value for DateTimePicker is today's
date.

I have Users table in my database which stores usernames, passwords and other
information about users. When starting the application the user logs in
providing username and password.
This is why I want the connection string (including database username and

Is there a preferred way to obtain one row of data based on the PK?  I can
retrieve the record onto my C# app using a dataset or datareader, but then I
have to loop thru this result set even though I know there will always be
either zero or one row retrieved.  Isn't there a more ...

I have problem with implementing strongly typed dataset (with tableadapter)
as singleton (A very large amount of data loaded at startup of winforms app,
I need this data at numbers of forms, and I need to bind this
dataset/datatable at designtime) . At first I realized ...

Good Day to all.
I have a store procedure that makes many queries, use cursors and some other
complicated calculations. If I run it on Management Studio it takes around 3
minutes and work fine. But when I run it from VB.Net it gives me connection

I'm trying to move a row from one table to another.  I get the error message that
the row already belongs to another table even though I have removed it from the table.
I'm trying to avoid recreating the row for performance reasons.
DataTable dataTable1 = dataTable2.Clone();

I have been tasked with load testing our .NET 2.0 web service, which is
really just wraps 1 or 2 very simple and light weight SQL queries.  Under
light load (less than 20 requests per second), everything works fine.  Each
transaction takes about 10-12 ms to complete.  As the load ...

I recently realized that I need IBM's iSeries Access installed to use
Provider=IBMDA400.DataSource.1 in an OleDB connection string.
Is there any .NET 2.0 class or dll that provides DB2 data access
without any other software installs besides the .NET 2.0 Framework? Or,

what will happend if SqlBulkCopy violate constraints. and how i can solve
this problem.

Hello Everyone .......i created menu using Css and HTML code..but i
want it to display submenu when mouse is over on the horizontal
strip...but it's not working and either it show all the menu or not
when the page is loaded......so what should i do?

I'm building a program to navigate through a database. The user chooses
either ODBC or OleDb and provides a connection string. With OleDb I can get
the database names from the connection. Is there a way I can do this with an
ODBC connection?  Programs like DTM Data Editor can do ...

This is driving me nuts!  I've got a form that is giving me fits.  I've done
the same thing that I've done on dozens of other forms.  When the data
adaptor update command is executed I get the "Must declare scalar variable
@p7CYCLEDAY"  Here are various pieces of my code.

I would like to remove all the rows of a DataTable - but not by using a
loop through all the DataRows - but by using a single command.
I tried - dataTable.Clear() which is supposed to remove all rows of the
dataTable - but it doesn't seem to work - the table is still full.

hello, am in a bit of a problem.. wonder if anyone can help?
I got two tables one is tblOrders and the other is tblDeletedOrders
I'm handling the UserDeletingRow to insert the deleted row (order) into the
tblDeletedOrders to sort out some kind archive or log.