How get datas from table to display on screen

Note : string config in proiect web.config file  

 

string conString = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;

 

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

DataGrid();

}

}

private void DataGrid()

{

using (SqlConnection con = new SqlConnection(conString))

{

using (SqlCommand cmd = new SqlCommand("select * from DB"))

{

SqlDataAdapter dt = new SqlDataAdapter();

try

{

cmd.Connection = con;

con.Open();

dt.SelectCommand = cmd;

DataTable dTable = new DataTable();

dt.Fill(dTable);

SqlDataReader sdr = cmd.ExecuteReader();

GridName.DataSource = dTable;

GridName.DataBind();

}

catch (Exception)

{

// Error msg display here

}

}

}

}

 

 

Any problem give reply  

Durga please once go through following link:

 

http://www.c-sharpcorner.com/UploadFile/b43a5b/retrieving-data-in-gridview-in-Asp-Net/

Hi,

 

You can use gridview to display data from Database on page.

 

 

 protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GridView1.DataSource = GetData();
GridView1.DataBind();
}

}
DataTable GetData()
{
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["testconection"].ConnectionString))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("select id , name from tableName ",con))
{

SqlDataAdapter adpt = new SqlDataAdapter(cmd);
adpt.Fill(dt);
}
}
return dt;
}

 

http://www.c-sharpcorner.com/UploadFile/b43a5b/retrieving-data-in-gridview-in-Asp-Net/