Binding Columns in DatagridView C#

adrian Wonder

17y5.8k.NET

My problem is in my webpage i have a datagridview and i would like to populate it with data from my sql Db. my way was to link the Datagridview with a table from my Dataset, also as long as i have Data fields linking to the correct columns from table mentioned in my markup page(). it all works. i did not like the way how i bounded the columns to the datagridview columns. could somebody please suggest a better way? using pure c# code only and not have to do anything with the markup page. Thanks for your time Adrian

5 Replies

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

Master Billa17y ago
welcome and answer for the second question

When you are allow to gridview AutoGenerateColumns is true, then it will handle the all columns(you don't give the data fields name to every columns).

Just give make it your gridview is AutoGenerateColumn is true then take look.

Thank you
adrian Wonder17y ago
Thanks buddy... that was good. one more question...is there any other way to fill in data into the datagridview without knowing the exact name of columns from the table??? Thanks Adrian

Master Billa17y ago

HI

You add gridview in htm page.

Then add code like this way

 protected void Button1_Click(object sender, EventArgs e)
{

            GridView1.AutoGenerateColumns = false;
            BoundField minPurchase = new BoundField();
            minPurchase.HeaderText = "Minimum Purchase";
            minPurchase.DataField = "MINIMUM";
            GridView1.Columns.Add(minPurchase);

            BoundField pricePer = new BoundField();
            pricePer.HeaderText = "Price Per Item";
            pricePer.DataField = "PRICE_PER";
            pricePer.DataFormatString = "${0}";
            GridView1.Columns.Add(pricePer);


        }

Then you can bind data to gridview.

thank you

adrian Wonder17y ago
I am connecting the same way. my problem is not connecting to the dataset. my problem is when we do it the following way , we also have to bind the columns in the mark up(aka source page) page saying DATAFILD="NAME OF COLUMN" in ASP tags; can we achieve the same goal in the code page using pure c# code???
Roei Bar17y ago
well, the easiest way to bind to a datagrid is to use "ExecuteDataSet" on the Data Retrieved from the SQL Server.

you will get back a dataset

and no the dataset you can do the following
you can use DAAB here is the download link :

http://geekswithblogs.net/mnf/archive/2007/03/19/109142.aspx
DataSet ds = spCommand.ExecuteDataset(); gView.DataSource = ds.Tables[0]; gView.Bind();