DataReader into DataGrid

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

2 Replies

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

neeraj_sharma1397822y ago
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_sharma1397822y ago
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(); }