How to convert DataReader to DataTable?

Just Drag and drop Grid view control to your web page

[code]
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
ConvertDateReadertoTableUsingLoad();
}
private void ConvertDateReadertoTableUsingLoad()
{
SqlConnection conn = null;

string connString = "server=servername;database=databasename;uid=userid;password=password;";
conn = new SqlConnection(connString);
string query = "select * from Tablename";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
DataTable dt = new DataTable();
dt.Load(dr);
conn.Close();
GridView1.DataSource = dt;
GridView1.DataBind();

}

}



[/code]

No comments:

Post a Comment

Plz Share your comments...