design gridview in code_behind

bahare g

16y3.1k.NET

hi there
i have a web page.i want to have a gridview in it,but i want to design my gridview and bind it in code_behind.for example any record in gridview that must have 2 rows and 1 column. row and column show a field of determined record.i want to bind it with sqldatareader.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Lalit M16y ago
formatting of gridview show file
0

Amit Choudhary16y ago

hi friend,
Here how create a grid programmatically bind it to sqldatareader and add it to form from code behind:

 protected void Page_Load(object sender, EventArgs e)

            SqlConnection cn = new SqlConnection(@"Data Source=NODE007\SQLSERVER2005;Initial Catalog=MenuDb;Integrated Security=True");

            cn.Open();

            SqlCommand cmd = new SqlCommand("select Text from Menu", cn);

            SqlDataReader rdr = cmd.ExecuteReader();
            
            GridView gv = new GridView();

            gv.EnableViewState = true;

            gv.DataSource = rdr;

            gv.DataBind();

            form1.Controls.Add(gv);

Please mark as answer if it helps you.