web analytics

Category: ADO.NET

Return the value for the specific attribute using XPathNodeIterator 0

Return the value for the specific attribute using XPathNodeIterator

Reading Time: 1 minuteI will use the following XML document in the example below. <? xml version="1.0" encoding="utf-8" ?> < users > < user FirstName ="Tom" LastName ="Adams" Age ="23" /> < user FirstName ="Jhon" LastName ="Brams"...

Row already belongs to another table 0

Row already belongs to another table

Reading Time: 1 minuteWhen copying a row from one datatable to another you might get the error "this row already belongs to another table". Typically you might write code like this: string sConnString = ConfigurationManager.ConnectionStrings["NorthwindConn"].ConnectionString; DataSet ds...

Debugging Stored Procedures in SQL Serrver 2005 0

Debugging Stored Procedures in SQL Serrver 2005

Reading Time: 2 minutesPre-requisites 1. Find the .exe file under the directory, C:\Program Files\Microsoft SQL Server\90\Shared\1033\rdbgsetup.exe or similar path where the SQL Server was installed. The file rdbgsetup.exe stands for ‘RemoteDeBuGsetup’. Look for the emphasis on letters....

Different operations on Datatable (Add, Edit, delete, Sort etc) and XML 6

Different operations on Datatable (Add, Edit, delete, Sort etc) and XML

Reading Time: 5 minutesIntroduction DataTable is a central object in the ADO.NET library. If you are working with ADO.NET – accessing data from database, you can not escape from DataTable. Other objects that use DataTable are DataSet...