Get data from database, pass this data with grid columns?

Mahmoud Omar

i want Get values or data from database and pass every columns from database with columns that i add it in gridview.

i used this cold but this code don't give me what i want :-

 con.Open(); SqlCommand cmd = new SqlCommand("Select code,Name,Salary,desc FROM tableName", con); SqlDataReader dr = cmd.ExecuteReader(); GridView1.DataSource = dr; GridView1.DataBind();         con.Close();

How i cgange this code and pass this columns(code ,Name ,salary ,Desc) to the columns that i add it in gridview

1 Reply

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

Midhun Tp10y ago
Hi,

Please follow below articles-
http://www.aspsnippets.com/Articles/Retrieve-Get-data-from-SQL-Server-database-and-display-in-ASPNet-GridView-using-C-and-VBNet.aspx
http://www.aspdotnet-suresh.com/2015/04/bind-data-in-gridview-in-aspnet-using-dataset-datatable-in-csharp-vbnet.html?m=1