how to correspond gridview's columns with SQL's columns

Question

Hello there I'm new in c#. I stack in a point and I need your help! I am working on a windows form app on visual studio 2012. In the form Users I have a gridview with columns; id name password fullname. Alse I've placed and buttons; insert edit delete; despite the fact I don't know how to set the code there. The thing is that THIS form especially this gridview I want to connect it with a table of SQL database (2012). BUT I don't want just to load the datas I want to correspond each column of gridview with that of Sql database. For ex. I want column id (VS) to correspond the datas of column id (SQL). How is that possible?? Can anyone provide me an example code? Anything helpfull??

Sumit Jolly · Answer

Use something like below: SqlConnection sqlcon = new SqlConnection(connection string); sqlcon.Open(); SqlCommand sqlcmd = new SqlCommand(select * from table sqlcon); //sqlcmd.ExecuteNonQuery(); SqlDataAdapter sqlda = new SqlDataAdapter(sqlcmd); DataSet ds = new DataSet(); sqlda.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind();