GridView not displaying data in VS2012

Hi Riddi,


The reason for not showing columns is, you set AutoGenerateColumns property to false neither you have created column templates in gridview, then how it will bind the columns to gridview.


Set the column template like 


 
  


 


Hoe this answers your question

Hi..

Did all things...

Finally... made up a new project all together...

Now working...

Thanks a ton to all guys.....

Yes,
obj.LoadUsers(); is returning the datatable with data.
The return type is datatype.

Method -
 #region LoadUsers
        public DataTable LoadUsers()
        {
            try
            {
               
                    cmd = new SqlCommand();
                    cmd.Connection = con;
                    cmd.CommandText = "SP_LOADUSERS";
                    table = new DataTable();
                    adp = new SqlDataAdapter();
                    cmd.ExecuteNonQuery();
                    adp.SelectCommand = cmd;
                    adp.Fill(table);
                    if (table.Rows.Count > 0) { return table; }
                    else return null;
               
            }
            catch (Exception err) { err.Message.ToString(); return null; }
        }
        #endregion


 GridView1.DataSource = obj.LoadUsers(); 
  GridView1.DataBind(); 

Property - AutoGenerateColumns="True" is set to True.

Hi
Is ur obj.LoadUsers(); returning dataTable ?
if not make that function return type dataTable and then use 

 GridView1.DataSource = obj.LoadUsers(); 
  GridView1.DataBind();  

mark the AutoGenerateColumns="True" for ur grid view 

Hi

http://www.c-sharpcorner.com/UploadFile/47548d/how-to-bind-data-from-mysql-database-to-gridview-in-Asp-Net/