Datagrid and SQL 2005

Question

1.00/5 (1 vote)

See more:

Hi,
My code below is working fine. I have three column in my table( TypeID,Description,Rating). As of now all is populated in my datagrid.

But what I need is My datagrid should pull only 2 coulmn from my table( TypeID and Description). How to alter the code?

Please help with code.
Thanks.

My code:

C#

namespace MovieProject
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }

        private void AutoradioButton1_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection("Server=CHRIS-PC\\SQLEXPRESS;Database=MovieDesc;" +"Integrated Security=True");

            SqlCommand scmd = new SqlCommand("SELECT * FROM MovieType", conn);
            DataSet sds = new DataSet();
            conn.Open();

            SqlDataAdapter sadptr = new SqlDataAdapter(scmd);
            sadptr.Fill(sds, "MovieType");

            if (sds.Tables["MovieType"].Rows.Count == 0)
            {
                MessageBox.Show("There are no DB.");
            }
            else
            {
                this.listBox1.DataSource = sds.Tables["MovieType"];
                this.listBox1.DisplayMember = "Description";
            }

            checkedListBox1.DataSource = sds.Tables["MovieType"];
            checkedListBox1.DisplayMember = "Rating";
            dataGridView1.DataSource = sds.Tables[0];
          }
        }
    }

Posted 29-Sep-10 20:39pm

Vista007

Updated 30-Sep-10 2:28am

Sandeep Mewara

v2

Add a Solution

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

JimHacker · Answer 1 · 2010-09-29T20:55:00

Solution 1

The SQL "Select" statement uses the wildcard, * and so returns all columns in the table.

Change your SQL SELECT statement to select exactly the columns you want.

so

SELECT * FROM MovieType

becomes:

SELECT TypeID, Description FROM MovieType

You also need to change your display member from "Rating" to one of the columns that is being returned.

That should be it.

Posted 29-Sep-10 20:55pm

JimHacker

Comments

Vista007 30-Sep-10 3:09am

As from code i am also populating some colum into listbox and checked list box. So SELECT * FROM MovieType is correct for that.
To populate only 2 coulmn form a table of 3 column. code below is not working.

this.dataGridView1.DataSource = sds.Tables[#Quote#MovieType#Quote#];
this.dataGridView1.DisplayMember = #Quote#Rating#Quote#,#Quote#TypeID#Quote#;

Please help. also Datagrid doesnt have property of DisplayMember .

Please help

AshiqueAhammed · Answer 2 · 2010-09-30T19:15:00

Solution 3

Try this one

DataTable dt1 = sds.Tables[0];
dt1.Columns.Remove(dt1.Columns[0]);
dt1.AcceptChanges();
dataGridView1.DataSource = dt1;

Posted 30-Sep-10 19:15pm

AshiqueAhammed

Comments

Vista007 1-Oct-10 4:21am

DataTable dt1 = sds.Tables[0];
dt1.Columns.Remove(dt1.Columns[2]);
dt1.AcceptChanges();
dataGridView1.DataSource = dt1;

hi, The above code removes the column which i want to remove from data grid. but simultaneously tha checkedlistbox populating the column 3 value is now showing "System.data.datasource " in all coulmn in checklist box?

how now?

AshiqueAhammed 1-Oct-10 6:22am

I think the better way to do it is
dataGridView1.Columns[0].Visible = false;

tim_gunning · Answer 3 · 2010-09-30T05:56:00

Solution 2

or build your DataGrid yourself, select all and then show only the columns you want, best practice to do the above though really, less data pulled = less overload etc etc

Posted 30-Sep-10 5:56am

tim_gunning