My gridview are not display on webform

Question

hello everyone ;

the question is, my gridview are not display in the webform. this is my code. there is no error in my code, but gridview are not display.

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
load_grid_doctor();
}
}

protected void Button_show_Click(object sender, EventArgs e)
{
load_grid_doctor();
}

public void load_grid_doctor()
{
SqlCommand cmd = new SqlCommand("select * from [doctor]",connection.get());

SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.SelectCommand=cmd;
da.Fill(ds);
GridView_doctor.DataSource = ds;
GridView_doctor.DataBind();
}
}

regards
sumaira

Satyapriya Nayak · Answer

Is your problem solved?

Satyapriya Nayak · Answer

Hi sumaira, There might be space in the bound filed i saw check it "doctor id " HeaderText="doctor id" /> "user id " HeaderText="user id name" /> Thanks

Prabhu Raja · Answer

hi sumaira, i saw it. i got it. 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. ---------------------------------------- If this helps you, mark it as "Correct Answer"

sumaira manzoor hussain khan · Answer

respected sir; i am sending u my code file .can u check this. after this code , my gridview is not displaying. regards sumaira

sumaira manzoor hussain khan · Answer

no

Prabhu Raja · Answer

Hi sumaira, I have also got the same problem like you. i attached my source code. It will show the way to solve this issue. If any query, reply me.

Satyapriya Nayak · Answer

Is your problem solved?

Satyapriya Nayak · Answer

For testing of data is showing or not in gridview i have close it.As per your requirement you do it. I have not created connection class in my system.So iam writing it.As you have created it ,accordingly you change it.

sumaira manzoor hussain khan · Answer

respected sir; why i used connection string in the start of the code. because i make a separate connection class like this . public class connection { static SqlConnection my_connection = null; public static SqlConnection get() { if (my_connection == null) { my_connection = new SqlConnection("Server =.;Initial Catalog = fyp;Integrated Security = True"); my_connection.Open(); } return my_connection; } } protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { load_grid_doctor(); } } protected void Button_show_Click(object sender, EventArgs e) { load_grid_doctor(); } public void load_grid_doctor() { SqlCommand cmd = new SqlCommand("select * from [doctor]",connection.get()); //cmd.Connection = SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.SelectCommand=cmd; da.Fill(ds); GridView_doctor.DataSource = ds; GridView_doctor.DataBind(); }

sumaira manzoor hussain khan · Answer

hello sir; sir, why you closed "load_grid_doctor" in show button. because if i insert some information via insert query then how i can see my desire information.

Satyapriya Nayak · Answer

Hi sumaira, Try this using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { load_grid_doctor(); } } public void load_grid_doctor() { SqlConnection con = new SqlConnection(strConnString); con.Open(); //SqlCommand cmd = new SqlCommand("select * from [doctor]", connection.get()); SqlCommand cmd = new SqlCommand("select * from t2",con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds, "t2"); //da.SelectCommand = cmd; da.Fill(ds,"t2"); GridView_doctor.DataSource = ds; GridView_doctor.DataMember = "t2"; GridView_doctor.DataBind(); con.Close(); } protected void Button_show_Click(object sender, EventArgs e) { //load_grid_doctor(); } }

sumaira manzoor hussain khan · Answer

hello sir; there is no effect of AutoGenerateColumns="true" in my code. sir , this is my real code. protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { load_grid_doctor(); } } protected void Button_show_Click(object sender, EventArgs e) { load_grid_doctor(); } public void load_grid_doctor() { SqlCommand cmd = new SqlCommand("select * from [doctor]",connection.get()); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.SelectCommand=cmd; da.Fill(ds); GridView_doctor.DataSource = ds; GridView_doctor.DataBind(); } } and in the asp.net plateform, i placed some labels and textbox and one gridview in the webform. after this i rum code . this is my code of asp.net                                                                      Width="53px" /> regards sumaira

Satyapriya Nayak · Answer

Hi sumaira, If you have written the below code in gridview as AutoGenerateColumns="false" then change it to AutoGenerateColumns="True" Your code is ok. Thanks If this post helps you mark it as answer