DataReader into DataGrid

Question

Hi! I want to use a DataGrid and fill it with a DataReader, but I don't know how to do it. I don't want to have DataSet. Can someone help me? Thanks

neeraj_sharma13978 · Answer

sorry the soloution given by me it is correct for ASP.NET plz don't concider that code. in ASP.NET datagrig contains the databind property but in C# for wind. App. there is no DataBind Property so i wii try to give u another saoloution if possible

neeraj_sharma13978 · Answer

hello this the soloution of ur problem. i m using the SqlClient object for database connectivity. and all coding is on button click sysmols: which r enclosed in blocks in connection string, means write there ur parameter according to ur environment. not use symbols. private void btnClick_Click(object sender, System.EventArgs e) { System.Data.SqlClient.SqlConnection conMyConnection; System.Data.SqlClient.SqlCommand cmdMyQuery; conMyConnection= new System.Data.SqlClient.SqlConnection ("server= ;database= ;uid=sa;password= "); conMyConnection.Open(); cmdMyQuery=new System.Data.SqlClient.SqlCommand(); cmdMyQuery.Connection = conMyConnection; cmdMyQuery.CommandType=CommandType.Text ; cmdMyQuery.CommandText="select * from EMPLOYEE"; SqlDataReader dsEmp ; dsEmp=cmdMyQuery.ExecuteReader(); this.dtgMyGrid.DataSource =objObject.GetData(); this.DataBind(); }

DataReader into DataGrid

Answers (2)