First let me thank everyone on the forum(s) for all the great (and timely)
help!!!
I am writing a help desk app in asp.net that allows people to input work
orders for IT.  I used to use data adapters and datasets until someone here

I have a master table that I would like to display on a form with a
navigator, and I would like to display the detail records in a grid
for each master record.
Right now, I am getting all the records for both tables using

I've heard that SQLDMO can generate scripts for a table or sproc or
group or whatever.  But I can't find any examples.
Also, I have 2 databases with slightly different versions of the table.
 Is there a way that SQLDMO can generate a script that syncs up the

I have a resultset with different columns which I would use to group the
data by. For examle:
Name     Categ     Year
AAA      1         2003

I am trying to find the most efficient way to send record UPDATES from a
client to my webservice. I am already using GetChanged to only send the
records that have actually been modified, but I would like to further reduce
network traffic by not sending individual columns that ...

How do I ensure that the current row's changes will be included in the DA's
Update call?  If I move off the row it is included, but if I make a change
then call Update, the changes are lost.

I have an <asp:DataGrid> control to which I'm trying to bind an
SqlDataReader. When I do so, I get the following error:
AllowCustomPaging must be true and VirtualItemCount must be set for a
DataGrid with ID dgrdTimesheet when AllowPaging is set to true and the

What is the most effective way to migrate an access DB to MSDE / SQL Server
using only code, C# in this case. I do not have access to the MSDE other
than via code and I was looking for a reliable solution.
Thanks.

ok, I've been on this for a long time...How can I get the most recent
identity from this insert into a string?(with using this code as the insert):
string strSQL5 = "INSERT INTO tblTravelDetail(MemberId, " +
                " Comments, " +

I have created a simple web application using ASP.NET, which queries an
SQL-Server database, but every time the application is run, I get the
following error: (truncated for brevity)
Exception Details: System.Data.SqlClient.SqlException: SQL Server does

I am trying to create a visualisation of a many-to-many
relationship in VB.NET.  The tables, columns and
relationships are detailed below (Sorry for all the code).
The cables and columns match those found in the

I'm using a SqlDataAdapter to update my DataSet. The updates all take place
within an single transaction. If I rollback the transaction how do I reset
the DataSet such that it knows the recent updates are still outstanding?

I want to be able to check an SQLServer database to determine if it is not damaged or in need of repair.  I looked into the DBCC CHECKDB SQL call to accomplish this.  However, I cannot figure out how to check the status of the database after making this call in ADO.NET.  I tried ...

Hi
Can we use DataView.RowFilter for filteing special charactered column data
like
if the column data includes the characters like "<" ">" "(".I have tried by

I have the following code that is getting (or should get) the max value
from an xml file.  Even though the max value should be 21, it is always
returning 9:
DataSet ds = new DataSet();