Binding Columns in DatagridView C#

Question

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

Master Billa · Answer

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 Wonder · Answer

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 Billa · Answer

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 Wonder · Answer

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 Bar · Answer

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();