My grid is not display on the web form

Hi sumaira,

There might be space in the BoundField DataField i saw check it

"doctor id " HeaderText="doctor id" />

 "user id " HeaderText="user id name" />


Thanks
If this post helps you mark it as answer

Hi sumaira,

The Problem is with Select Query.

In your markup language, you Set GridView DataField to Various names, So use your Select query to alias in name with datafield. Like this

Select doctoorid as doctor id , userid as user id, name as name, days as days, timing as timing from table.

the Alias names in query should match your Datafield in gridview.


I attached my Source Code Here. Its Working. See it.

public void load_grid_doctor()
{
SqlCommand cmd = new SqlCommand("select doctorid,userid,name,days,timing from [doctor]");//,connection.get());
cmd.Connection = connection.get();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.SelectCommand = cmd;
da.Fill(ds);
GridView_doctor.DataSource = ds.Tables[0];
GridView_doctor.DataBind();


}

In ASPX File change

       
       
        "doctorid" HeaderText="doctor id" />
        "userid" HeaderText="user id name" />