Archive for the ‘ADO.NET’

  • Return the value for the specific attribute using XPathNodeIterator
    I 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" Age ="17" /> < user FirstName ="Bill"...
    by Nauman at November 1st, 2009 at 08:11 am
  • Row already belongs to another table
    When 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 = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(sConnString,CommandType.Text,...
    by Nauman at November 1st, 2009 at 08:11 am
  • Debugging Stored Procedures in SQL Serrver 2005
    Pre-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. The filename reads rdbgsetup because, we are going to debug a stored procedures of a database...
    by Nauman at November 1st, 2009 at 06:11 am
  • Different operations on Datatable (Add, Edit, delete, Sort etc) and XML
    Introduction 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 and DataView. In this tutorials, I will explain how to work with DataTable. I have tried to cover most of the frequently used activity in the DataTable, I...
    by Nauman at November 1st, 2009 at 06:11 am