I agree with Ennis that it's a 'bad' practice to let the autogeneration to create the statements. But if you want to use it, there are two conditions you must meet: - you must use command builder when select statement is created - there must be a key column present in the dataset I think it's the later that may be causing problems. Another possible cause may be column names that contain illegal characters or reserved words. So you should check if for example UpådateCommand is generated correctly. More info: Generating Commands with CommandBuilders (ADO.NET)[^] The need to optimize rises from a bad design.My articles[^]

Thanks a lot. That was very helpful information. :) Prateek

You're welcome. The need to optimize rises from a bad design.My articles[^]

Glad to help you :) Giorgi Dalakishvili #region signature My Articles Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^] My blog #endregion

Glad to help you :) Giorgi Dalakishvili #region signature My Articles Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^] My blog #endregion

If anybody is looking for the answer, do check this link [^] out. Also, be careful with the ReceiveTimeouts. ReceiveTimeout is for synchrounous receive only. So, if you don't want your loop to get stuck, make sure you include some way of identifying the end of message. Good Luck, Prateek

Never Mind. I was able to find out how to do it. DirectoryEntry iis = new DirectoryEntry("IIS://" + Environment.MachineName + "/w3svc"); foreach (DirectoryEntry site in iis.Children) { if (site.SchemaClassName == "IIsWebServer") //Web Sites have the IIsWebServer schema{ { String siteName = site.Name; foreach (String propertyName in site.Properties.PropertyNames) { PropertyValueCollection values = site.Properties[propertyName]; foreach (object val in values) { Console.WriteLine(propertyName + ": " + val); } } } } This will get the list of web sites on IIS and their properties. I don't know if this will work for IIS 7 right now.

After the data gets added to the database, I read and print out the data in nUnit's console from the database. There are times when I can't read all of the data from the table. e.g. if the table has 5 rows, it will sometimes show me only 2 rows. And then there are times, when it would print out incorrect values from the data e.g. if a column has an integer value of '2', it will print out '0'. My guess for this would be that it wasn't able to read the data from that particular column. What other type of information would you like to know?