I've rolled out some .NET applications to client sites. They all work fine
at first, but for some reason I am getting a ".NET SQL Client Data Provider
Error" message on some machines. These machines also used to work fine.
What is causing this?

i have just read something about "application rolls" in MSSQL Server.
Is it possible to use application rolls in ADO.Net?
best regards,
Jan

I want to analysis a database's schema and get all data from it.
So I need to load the DB's all tables into a dataset, and I don't know there
are how many tables in it.
what should I do? or there is any other way?

I have a datalist that is returning a currency value, how can I format it? I
tried the code below but it did not work, could someone help me out with the
syntax please?
Sean - thanks in adavance for your answer

Can I insert a new column into a DataTable after it is filled with data?
I'd like to insert at an index and not to the end of the columns collection.
Thanks in advance
Jaga

I have a web app that loads into Session Memory a datatable object.
I'd like to evaluate the memory used by the datatable object before loading
it...
I would iterate thru all records accepted (because there is a filter on it)

iam new here well ill say directly what i wanna know
what is the diffrance between connected and disconnected  techniuques
in ado.net and  when to use disconnected and when to use connected in
your application and if your application is gonna run on a LAN and you

I need to fill a VarBinary Field in a table with +-19000 bytes (depends) The
Documentation says that the field can only be 8000 bytes long, and if I
change it to anything over that I get an exception.
There must be a way I can do this.

I have an OleDb connection string to an SQL server provided by the Data Line
Properties dialog.  What do I need to do to convert this OleDb connection to
an SQL connection.
Can I just remove the Provider property?

in sql server when you do a command like this in a stored procedure
CREATE PROCEDURE [DBO].[APPSP_PrintMessage]
AS
print "Beginning transaction..."

I'm starting to run into timeout issues on my web application with my connection object trying to get a connection from the connection pool.  I use this connection object on every page.  I make sure I Close() it after I use it, but now I think I need to call it's Dispose() method ...

I need to pick up the retyurn value from an Oracle function. Is it modeled as an output parameter ?

This is the Code ;
cnSQL = New SqlConnection(ConnectionString)
cmSQL = New SqlCommand(strSQL, cnSQL)
strSQL = "INSERT tb_product VALUES(@ServiceCode,@ServiceName,@Price)"

I have an old system written in Clipper that I was required to move to .Net
platform. I will use C#.
I would like to make this move in two steps, moving first all graphic
interfase but keep using same database as backend and lately move all the

I am having a problem with the Oracle DataReader.  The issue is that when I have a text field which has the exact same value for a particular field, the datareader is returning garbage in the second and subsequent rows for that value.
Say for instance I have a field called ...