How to display a table on windows application in c#

[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

[iamthwee]

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

When working with databases, ideally the best information you can get will be from a book which goes through it step by step.

[campkev]

what you probably want to use is a gridview (or datagrid, if your are not on 2.0) and bind it to the database

[amithasija]

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),

[Emmaliu]

Thanks a lot.

[Killer_Typo]

Thanks a lot.

hey i hope this helps you out some 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.

[kool.net]

can i pass multiple quries to datagrid view, if yes then pls tell me how.

[ddanbe]

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.:)

[kanchanraaj]

I Think this is the complete code dude

private void Form1_Load(object sender, EventArgs e)
        {
            
            string connectionString = GetConnectionString();
            SqlConnection con = new SqlConnection(connectionString);
            string sqlSelect = "Select * from authors";
            SqlCommand cmd = new SqlCommand(sqlSelect,con);
            SqlDataAdapter adp = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            adp.Fill(dt);
            dataGridView1.DataSource = dt;
           
        }  
         
        static private string GetConnectionString()
        {
            return "Data Source=localhost ; Initial Catalog = pubs;" + "Integrated Security=SSPI ";
        }