Loading

HOW TO SHOW SELCET QUERY RESLUTS ON TO WINDOWS FROM

anveshreddy amaravadi

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

1 Reply

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

rajesh kumar17y ago
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!!
0