HOW TO SHOW SELCET QUERY RESLUTS ON TO WINDOWS FROM

Question

HI I HAVE CREATED A FORM CONTAINING A TEXTBOX AND A BUTTON MY INTENTION IS TO DISPLAY THE RESULTS OF A SELECT QUERY ON THE WINDOWS FORM WHEN THE BUTTON IS CLICKED CAN ANY ONE HELP ME I JUST NEED INFORMATION HOW TO SHOW MY RESULTS ON THE FOMR

rajesh kumar · Answer

hi if u need to display just a single result retriving from database this code works private void btnGetResults_Click( object sender EventArgs e) { SqlConnection con = new SqlConnection ( Your connection string  ); con.Open(); SqlCommand cmd = new SqlCommand ( select count (*) from Test_r_Login  con); //just retriving count txtResults.Text=cmd.ExecuteScalar().ToString(); con.Close(); } or if you need to retrive a tabel and display datagird helps better!!