copy data from a tabel to a gride view in c#

Question

0.00/5 (No votes)

See more:

i want to connect to db and read data from a table then show it in grid view but after do this tabel header add to my gridview header but i want to data be in my gride view
my code is:

C#

DataTable k = new System.Data.DataTable();
           try
           {

               string str = "Data Source=C:\\Documents and Settings\\almas\\Desktop\\BazarKhodro\\khodro.sdf";
               Qconnection.ConnectionString = str;
               Qcommand.Connection = Qconnection;


               string commandText = "select name,lname,phone,mobile,address from moshtari where name=@name and lname=@lname";
               Qcommand.Parameters.AddWithValue("@name", textBox3.Text);
               Qcommand.Parameters.AddWithValue("@lname", textBox4.Text);
               Qcommand.CommandText = commandText;
               Qcommand.CommandType = CommandType.Text;
               SqlCeDataAdapter a = new SqlCeDataAdapter();
               a.SelectCommand = Qcommand;
               a.Fill(k);
               Qconnection.Open();
               Qconnection.Close();
               dataGridView1.DataSource = k;

           }
           catch (Exception ex)
           {

               throw new Exception(ex.Message);

           }

Posted 6-Nov-12 22:25pm

f.sarikhani

Add a Solution

Comments

saud_a_k 7-Nov-12 4:27am

dataGridView1.DataBind();

helloworld2020 7-Nov-12 4:30am

And, what is error? Please, provide more information!

f.sarikhani 7-Nov-12 4:31am

c# not know this method

f.sarikhani 7-Nov-12 4:36am

i havenot error I want the gridview header that I set myself, but after running the tabel header add to my grideview

faisal23 7-Nov-12 5:16am

go to gridview properties and set column name

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

helloworld2020 · Answer 1 · 2012-11-06T22:40:00

Try this:

C#

try
{
     DataTable k = new System.Data.DataTable();
    string str = "Data Source=C:\\Documents and Settings\\almas\\Desktop\\BazarKhodro\\khodro.sdf";
    Qconnection.ConnectionString = str;
    Qcommand.Connection = Qconnection;


    string commandText = "select name,lname,phone,mobile,address from moshtari where name=@name and lname=@lname";
    Qcommand.Parameters.AddWithValue("@name", textBox3.Text);
    Qcommand.Parameters.AddWithValue("@lname", textBox4.Text);
    Qcommand.CommandText = commandText;
    Qcommand.CommandType = CommandType.Text;
    SqlCeDataAdapter a = new SqlCeDataAdapter();

     a.SelectCommand = Qcommand;


      a.Fill(k);
      BindingSource bSource = new BindingSource();

      bSource.DataSource = k;

      dataGridView1.DataSource = bSource;

    Qconnection.Close();


}
catch (Exception ex)
{

    throw new Exception(ex.Message);

}

Zasky · Answer 2 · 2012-11-06T23:08:00

If you're saying that you want to use your own names for the column headers istead of the field names defined in the database, you can do this:

C#

...
Qconnection.Open();
Qconnection.Close();
dataGridView1.DataSource = k;

dataGridView1.Columns[0].Name = "My Name For Column 0";
dataGridView1.Columns[1].Name = "My Name For Column 1";

Braj_12 · Answer 3 · 2012-11-07T01:24:00

Solution 3

You can change the HeaderText = "Column Name" in source code also.

Posted 7-Nov-12 1:24am

Braj_12

KiranKumar Roy · Answer 4 · 2012-11-07T01:40:00

Solution 4

it seems you forgot below line after asigning datasource to DataGrid.

C#

dataGridView1.DataBind();

Posted 7-Nov-12 1:40am

KiranKumar Roy

copy data from a tabel to a gride view in c#

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0