I have a web service that tries to fetch data from a Visual FoxPro database
sitting on a remote PC. The database is accessible by a file share with
everyone set to full control.
IIS and ASP.NET authentication are set to use windows integrated and

I previously used DataSets in a project where there was not backing
database, and now I'm trying to use a DataSet in a WinForms project that
needs to edit data in a SQL Server database, but I'm having problems.
My first problem is how to detect if anything has changed in the DataSet

I don't know how to put the datarow value into a string value, can you
please help?
For example: cmdBatchName SQL command will return 3 file_name
121104_14

I know that I can programatically hide a column in a DataGridView but I'd
like to be able to specify in my DataView or DataTable that a column should
not be displayable.  I tried using DataColumn.ColumnMapping and setting it
to MappingType.Hidden but that works only for some types.  ...

I put in the question below several days ago without an answer.  However, there really was a problem.  I finally figured it out.  It seems whenever I create a bound form with a currency manager that includes DateTimePicker(s) for Date Fields, the values in the controls don't show ...

I've used ADO 2.x in VB6, and now moving to ADO.NET.
Anyone have a simple example? (Any NET language is fine).
All I want to do is connet to a database. How do I do that?

If you want to create a DataSet, you can drag tables from Server explorer
into it, but not stored procedures.  Is there any other way than using a
DataAdapter and calling Generate DataSet to get a typed dataSet that uses
sprocs instead of tables?

I have a SQL2000 table where one field is text and contains an XML document.
What I need to do is query the row and take the contents of the XML field
and create a DataSet from it.  That DataSet will then be bound to a control.
Updates can be made and then I need to convert the ...

I have a ComboBox (cb) that shows the Employees in the Northwind database.
The SelectedValue property of the cb is bound to the ReportsTo field of the
Employees table. One of the employees however is at the top of the pile and
does not report to anyone. For that employee, the ...

In my SQL database, I have a "text" column type that can contain null values.
I want to loop thru my data using a sqldatareader and store the value in net
string variable.  How would I check the sqldatareader value for null prior to
attemping the assignment to my net string ...

I have a DataSet that I populated with an SqlDataAdapter with a SelectCommand.
Once I have the DataSet I insert some new rows, delete some other rows, and
update some existing rows.
I would like to process the "inserts" only at a specific time. The

how do you pass a null into an oracle parameter?
i am doing the following which works fine when there is data to be passed in
but when the string is blank it wont accept "" or even as a system.dbnull
'Parameter for Address1

Is it ever possible for a RowUpdating event (SqlRowUpdating, etc.) handler
to cause the Update to skip the row? For instance, if e.Status is set to
UpdateStatus.SkipCurrentRow, is the current row still updated?
If so, it's not clear from the documentation, and I'd love to see a

I'm a former Access developer who would like to implement a many-to-many
relation in about the same way you do in Access: With a subform and a combo
box.
Is it possible to use a combobox in a datagrid?

try
{
    OleDbCommandBuilder bldr = new OleDbCommandBuilder(da);
    da.Update(tbl);