how to data in gridview ?

Question

GridView1.DataSource=command.executeReader(); GridView1.DataBind();

Iftikar Hussain · Answer

Hi Try like this private void LoadData() { string strConnString = @Data Source=SQLEXPRESS;Initial Catalog=MyDb;Persist Security Info=True;User ID=MyUser;Password=Mypassword; using (SqlConnection con = new SqlConnection(strConnString)) { string query = select *from YourTable; DataSet ds = new DataSet(); con.Open(); SqlCommand cmd = new SqlCommand(query con); SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd); dataAdapter.Fill(ds); con.Close(); GridView1 .DataSource = ds; GridView1 .DataBind(); } } Regards Iftikar

Sanjeeb Lenka · Answer

hi What the error you are getting.. try like this: protected void BindGridview() { using ( SqlConnection con = new SqlConnection ( Data Source=Sanjeeb;Integrated Security=true;Initial Catalog=MySampleDB )) { con.Open(); SqlCommand cmd = new SqlCommand ( Select UserNameLastNameLocation FROM UserInformation  con); SqlDataReader dr = cmd.ExecuteReader(); gvUserInfo.DataSource = dr; gvUserInfo.DataBind(); con.Close(); } }