display list in gridview

[farjadab]

i want to dispaly generic list in grid view. in asp.net
i m using this code

SqlConnection con = new SqlConnection(@"Data Source= HOME-B28AEA71FF; Initial Catalog= Hospital Management; Integrated Security= TRUE");
        con.Open();
        SqlCommand cmd = new SqlCommand("Select Patient_ID,Patient_FName,Patient_LName,Father_Name,Guardian_ID,Admit,Ward_ID,Room_ID,Bed_ID,Refer_doctor,Admission_date,Doctor_fee,Room_type from Admission_Detail", con);
        SqlDataReader rdr = cmd.ExecuteReader();
        do
        {
            while (rdr.Read())
            {p_id=rdr[0].ToString();
 
                f_Name = rdr[1].ToString();
                l_Name = rdr[2].ToString();
                fa_Name = rdr[3].ToString();
 
                g_Id = rdr[4].ToString();
                adm = Convert.ToBoolean(rdr[5]);
                w_Id = rdr[6].ToString();
                r_Id = Convert.ToInt32(rdr[7]);
                b_Id = Convert.ToInt32(rdr[8]);
                ref_doc = rdr[9].ToString();
                adm_date = rdr[10].ToString();
                doc_Fee = Convert.ToInt32(rdr[11]);
                room_typ = rdr[12].ToString();
                Admission_Detail adm_detail = new Admission_Detail(p_id, f_Name, l_Name, fa_Name, g_Id, adm, w_Id, r_Id, b_Id, ref_doc, adm_date, doc_Fee, room_typ);
                list.Add(adm_detail);
            }
        } while (rdr.NextResult());
 
        con.Close();
 
        GridView1.DataSource = list;
        GridView1.DataBind();

///////////////
i m getting this error

The data source for GridView with id 'GridView1' did not have any properties or attributes from which to generate columns. Ensure that your data source has content.
////////
note that i m using prperties nor variable.don't tell me that

public int doc_Fee
    {
        get
        {
            return _doc_Fee;
        }
        set
        {
            value = _doc_Fee;
        }
    }

[Frinavale]

Does your "Admission_Detail" class have any properties?
Did you specify that the GridView should AutoGenerateColumns?

[farjadab]

@Frinavale
no it has variables same that i have made properties in this class.
do i have to make them properties as well????
yes i have autogenerationcolumn=true

[Frinavale]

Well I'm not sure what you're doing wrong...but in the above posted property, in the "set" method you are setting value=_doc_Fee....I'm not sure why you're doing that. You should be setting _doc_Fee = value.

This is what I tested and it works fine....

The GridView:

<asp:GridView ID="testGrid" runat="server" ForeColor="#333333" GridLines="Horizontal"
    CellPadding="4" AutoGenerateColumns="true">
    <RowStyle BackColor="#F7F6F3" ForeColor="#000000" />
    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
    <HeaderStyle BackColor="#284775" ForeColor="AliceBlue" Font-Bold="true" />
</asp:GridView>

The C# code:

namespace WebApplication2
{
  public partial class _Default : System.Web.UI.Page
  {
    protected void Page_PreRender(object sender, EventArgs e)
    {
      testGrid.DataSource = retrieveFooSource();
      testGrid.DataBind();
    }
    private List<Foo> retrieveFooSource() {
        List<Foo> source = new List<Foo>();
        if (HttpContext.Current.Session["FooSource"] != null)
        {
            source = (List<Foo>)HttpContext.Current.Session["FooSource"];
        }
        else
        {
            String[] names = { "Bob", "Sally", "Frank", "Steve", "Beth", "Pat", "Joan", "Howard" };
 
            int i = 0;
            foreach (string name in names)
            {
                source.Add(new Foo(name,i+100,DateTime.Today.Date));
                i++;
            }
        }
 
        HttpContext.Current.Session["FooSource"] = source;
        return source;
    }
 
    private class Foo {
        private int _doc_Fee;
        private DateTime _doc_Date;
        private string _doc_name;
        public int doc_Fee {
            get { return _doc_Fee; }
            set { _doc_Fee = value; }
        }
        public DateTime doc_Date{
            get { return _doc_Date; }
            set { _doc_Date = value; }
        }
        public string doc_Name {
            get { return _doc_name; }
            set { _doc_name = value; }
        }
        public Foo(string name, int fee, DateTime date) {
            _doc_Fee = fee;
            _doc_name = name;
            _doc_Date = date;
        }
    }
  }
}