 |  |  |  |  |  |  |  |
How to display a table on windows application in c#
Please support our C# advertiser: Intel Parallel Studio Home
 |
Hi everyone, I'm new here and I'm new to C# program.
I want to create a user name and passward verify windows application. I did some research, and finally get to connect to the database. Now I want to display the whole table which stores all the information. I know this does not help to verify the username and passward but help me to familiar with C# and database. Can anyone help me to point out the procedure or give me some hints? I will very very appreciate it.
Thanks.
Emma
I want to create a user name and passward verify windows application. I did some research, and finally get to connect to the database. Now I want to display the whole table which stores all the information. I know this does not help to verify the username and passward but help me to familiar with C# and database. Can anyone help me to point out the procedure or give me some hints? I will very very appreciate it.
Thanks.
Emma
•
•
Join Date: Aug 2005
Posts: 5,264
Reputation: 
Solved Threads: 377
•
•
•
•
Originally Posted by Emmaliu 
Hi everyone, I'm new here and I'm new to C# program.
I want to create a user name and passward verify windows application. I did some research, and finally get to connect to the database. Now I want to display the whole table which stores all the information. I know this does not help to verify the username and passward but help me to familiar with C# and database. Can anyone help me to point out the procedure or give me some hints? I will very very appreciate it.
Thanks.
Emma
*Voted best profile in the world*
•
•
Join Date: Jul 2005
Posts: 483
Reputation:
Solved Threads: 19
Posting Pro in Training
what you probably want to use is a gridview (or datagrid, if your are not on 2.0) and bind it to the database
use datagridview ,which will definately solve ur problem
string sqlSelect = "select * from usertest";
SqlCommand cmd = new SqlCommand(sqlSelect, conn);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adp.Fill(dt);
dgView.DataSource = dt;
dgView.DataBind();
here is the code which will help u to bind the database values to the grid(dgview),
string sqlSelect = "select * from usertest";
SqlCommand cmd = new SqlCommand(sqlSelect, conn);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adp.Fill(dt);
dgView.DataSource = dt;
dgView.DataBind();
here is the code which will help u to bind the database values to the grid(dgview),
•
•
•
•
Originally Posted by Emmaliu
Thanks a lot.
http://www.daniweb.com/techtalkforums/thread62112.html
its a HOWTO i wrote that covers how to query a database and return all of the information in a particular table.
Dont forget to spread the reputation to those that deserve!
•
•
Join Date: Oct 2008
Posts: 1,908
Reputation:
Solved Threads: 274
0
#8 18 Days Ago
Hey kool.net, don't resurrect old threads. Post your question in a new thread, where if needed you can refer freely to old threads if you want to.
Today is a gift, that's why it is called "The Present".
Make love, no war. Cave ab homine unius libri.
Danny
Make love, no war. Cave ab homine unius libri.
Danny
|
Similar Threads
- Capturing "Enter" key event in C# windows application (C#)
- to make checkboxes visible in datagrid C# windows application (C#)
- Displaying an Excel document in a windows application (C#)
Other Threads in the C# Forum
- Previous Thread: Hi, I dont get what Iv done wrong
- Next Thread: SMS Sender in C#.NET
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest C# Posts
- Today's Posts
- Unanswered Threads
.net access algorithm array backup barchart bitmap box broadcast buttons c# check checkbox client clock combobox control conversion csharp custom database datagrid datagridview dataset datetime degrees developer development draganddrop drawing dynamiccreation encryption enum excel file form format forms function gdi+ hospitalmanagementsystems httpwebrequest image index input install interface java label list listbox mandelbrot math microsystems mouseclick mysql operator password path photoshop picturebox pixelinversion post priviallages. programming property radians regex remoting richtextbox running... serialization server sleep soap socket sql sqlserver stack statistics stream string table temperature text textbox thread time timer update usercontrol validation visualstudio webbrowser windows windowsformsapplication winforms wpf write xml
