Code to bind gridview with DataAdapter
Code to bind gridview with DataAdapter using Asp.Net
Note:
->The ConnectionString index value will get from web.config file.
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bindRecord();
}
}
Public void bindRecord()
{
SqlConnection con =new SqlConnection(ConfigurationManager.
ConnectionStrings["ConnectionString"].ConnectionString.ToString();)
SqlCommand cmd=new SqlCommand();
cmd.connection=con;
con.open();
cmd.commandText="SELECT * FROM tablename";
SqlDataAdapter da=new SqlDataAdapter(cmd);
Dataset ds=new Dataset();
da.fill(ds);
cmd.ExecuteNonQuery();
grdview.DataSource=ds;
grdview.DataBind();
con.close();
}
use cmd.ExecuteReader();
instead of cmd.ExecuteNonQuery();