 |  |  |  |  |  |  |  |
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,903
Reputation:
Solved Threads: 273
0
#8 15 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 api array asp.net barchart bitmap box broadcast c# check checkbox client combobox control conversion csharp custom database databaseconnection datagrid datagridview dataset datetime dbconnection degrees design development draganddrop drawing encryption enum eventhandlers excel file firefox form format forms function gdi+ grantorrevokepermissionthroughc#.net image index input install java label libraries list listbox loop mandelbrot marshalbyrefobject math mouseclick movingimage mysql netcfsvcutil.exe operator path photoshop php picturebox pixelinversion platform post programming radians regex remoting resourcefile richtextbox server sleep socket sql statistics stream string study system.servicemodel table tcpclientchannel text textbox thread time timer update usercontrol validation visualstudio webbrowser windows winforms wpf wpfc# xml
