How get datas from table to display on screen

Question

i have data in a table .now i need to get the data when page is loaded the data which are in the database should be display.

Upendra Pratap Shahi · Answer

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

Rakesh · Answer

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

Sujeet Suman · Answer

Durga please once go through following link: http://www.c-sharpcorner.com/UploadFile/b43a5b/retrieving-data-in-gridview-in-Asp-Net/

Manoj Bhoir · Answer

Hi, You can use gridview to display data from Database on page. See this example : 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; } Check this link : http://www.c-sharpcorner.com/UploadFile/b43a5b/retrieving-data-in-gridview-in-Asp-Net/

How get datas from table to display on screen

Answers (4)