I have two questions regarding the use of DataAdapters:
1. If I am going to retrieve multiple tales to a DataSet using
multiple DataAdapter Fill's is it best to create a separate
DataAdapter for each table or to create one and change it's

Hi guys my name is Ralph, i am kinda new to this so please bear with
me.
I have written a .net web service which accepts a stream of data
see relevent source code).

I want add a new record using a text box,
but when I click the new button it should clear the text of textbox and
textbox should be binded to datasource.
pls help!

I've 2 stored procedures in Sql Server 2000 by name QA_User_Insert and
QA_Insert_Candidate.
Am using Oledb connection to connect to Sql server 2000. and i wrote
following code in ASP.Net

Hi,
I use VS2003 and C# with windows form.
I have one combobox bind to an Objsourcelist (CollectionBase) who contains
some ObjSource object with "Description" and "ID".

sorry if this is a repsot, but I can't see my 1st post. Lost my connection
in the middle of posting
I don't know what's happening here. I can run the sp in query analyzer and
(using PRINT) see that it returns a positive record number. But when I run

could you help with this problem?
Updating an integer, as tring  ok, but a decimal ??
Update tblprice  Set article = '  " & this & " ' WHERE ...
what signs do I have to put?

I have a table in my SQL Server that I am loading into a datatable. I am
then saving the dataset that this table is a member of (it's the only
table in the dataset) to an XML file so that I can use it offline in
another part of my program. The code I use for this is:

In eVB I made a simple application for my PocketPC (2003) that made
connection with a (converted) access database. I'm now trying to write the
same application in VB.NET. I just can't figure out how to make the
connection with the database. I tried connecting with the use of a

In my DB layer, I have a monitoring tool. This tool logs every access
to the database, and writes out the SQL and the time it takes to get
the results.
I want to add another important figure: the size of the result. It's

When I open a worksheet and display it in a grid some cells are empty that
are populated when opening it in Excel.
First I noticed that some of these cells had formulas so I tried saving the
xls as csv and opening it but then I get the missing ISAM error.

I'm trying to write efficient C# code to execute a stored procedure.
The stored procedure takes in 5 arguments. I'm doing a foreach loop to write
a lot, and I mean a lot of data to the DB.
Is the following the most efficient and best way to write tons and tons of

I need to get a return value from the procedure that follows. For some
reason I am not able to asign a value to @returnval and get it back to
the C# code executing it. The procedure does not return any errors. Here
is the code:

Forgive me if this is the wrong forum for this question, but I'm not really
sure where I should ask it.
I am using Crystal Reports to produce a report against a SQLServer database.
Up until 2 weeks ago, the report worked fine.  No event was noticed that

How I can store rtf format in SQL Server. (C#)