How to retrieve tabledata in sqlserver and display it in asp.netwebpage in a gridview

Hi sriram,


using System.Data.SqlClient;

public class WebForm1 : System.Web.UI.Page
    {
        SqlConnection con=new SqlConnection("connection string");
        SqlCommand com;
        SqlDataAdapter sqlda;
        DataSet ds;
        string str;


private void Page_Load(object sender, System.EventArgs e)
        {
           
            con.Open();
            str="select * from employee";
            com=new SqlCommand(str,con);
            sqlda=new SqlDataAdapter(com);
            ds=new DataSet();
            sqlda.Fill(ds,"employee");
            Gridview1.DataSource=ds;
            Gridview1.DataBind();
            con.Close();

        }
}

Is this Helpful ? Please make this as ANSWER.

hi sriram,

There is so many ways to retrieve the data from Sql server and store it in GridView...

First way:

Ado.Net provides default datasources like Sqldatasource, XMLDatasource etc.

Refer this link to know more about Data sources: click Here

                Accessing Data with the DataSource Controls

Using data sources and storing values in gridview is easy approach.

Second way:

Manually you can do that: refer this Link

you can found more articles regarding this topic....

i hope it help you....