Tuesday, February 23, 2010

How to convert SqlDataReader or DataReader to DataSet in Asp.Net




Please visit my new Web Site WWW.Codedisplay.com



In some cases most of the asp.net C# vb.net developers need to convert or converting SqlDataReader or DataReader to a DataSet to meet some technical challenges. Here i will show you converting SqlDataReader to a DataSet in a simple way. The code sample is given below:












protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string sql = "SELECT B.Name [Brand Name],C.Name [Category Name], " +
                    "P.Name [Product Name] FROM " +
                    "Brand B, Category C, Product P " +
                    "WHERE B.ID=P.BrandID AND C.ID=P.CategoryID Order BY 1,2,3";
            DataTable dt = new DataTable();
            DataSet ds = new DataSet();
            using (SqlConnection oConn = new SqlConnection(ConfigurationManager.ConnectionStrings["TestConnection"].ConnectionString))
            {
                oConn.Open();
                SqlCommand cmd = new SqlCommand(sql, oConn);
                System.Data.SqlClient.SqlDataReader dr = cmd.ExecuteReader();
                dt.Load(dr);
                ds.Tables.Add(dt);
            }

            Response.Write("Dataset Row count: "+ds.Tables[0].Rows.Count.ToString());
        }
    }
Look at the code its self explanatory. So i hope that no need any explanation.

0 comments:

Want to say something?
I WOULD BE DELIGHTED TO HEAR FROM YOU

Want To Search More?
Google Search on Internet
Subscribe RSS Subscribe RSS
Article Categories
  • Asp.net
  • Gridview
  • Javascript
  • AJAX
  • Sql server
  • XML
  • CSS
  • Free Web Site Templates
  • Free Desktop Wallpapers
  • TopOfBlogs
     
    Free ASP.NET articles,C#.NET,VB.NET tutorials and Examples,Ajax,SQL Server,Javascript,Jquery,XML,GridView Articles and code examples -- by Shawpnendu Bikash