how to call a view from sql server2005 and display its content in datagridview in c#

Question

2.00/5 (2 votes)

See more:

C#

private void btnView_Click(object sender, EventArgs e)
        {
            
            SqlDataAdapter da = new SqlDataAdapter("select * from view_SpareParts ", con);
            DataSet ds = new DataSet();
            da.Fill(ds, "ca");
            dataGridView1.Show();
        }

Posted 11-Aug-12 22:19pm

Gilbertinino

Updated 11-Aug-12 22:21pm

Mehdi Gholam

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 12-Aug-12 4:22am

What "calling a view" supposed to mean? :-) It is not a method, function, procedure, property or operator...
--SA

Gilbertinino 12-Aug-12 4:24am

i mean to display a content of a view from sql server 2005 in datagridview

Sergey Alexandrovich Kryukov 12-Aug-12 4:23am

It looks like ADO.NET, but tag it.
--SA

Gilbertinino 12-Aug-12 4:25am

how can i do it?

Sergey Alexandrovich Kryukov 12-Aug-12 12:13pm

To change the tags, use "Improve question" above.
--SA

2 solutions

Solution 2

First of all, there no such concept as "call a view". Moreover, a database view does not exist for a client code, mode exactly, it is absolutely transparent to it. From a client perspective, a view behaves exactly like a table. Please see:
http://en.wikipedia.org/wiki/View_%28database%29[^].

And to show a table in DataGridView, you can use data binding. Please start here:
http://msdn.microsoft.com/en-us/library/k39d6s23.aspx[^],
http://msdn.microsoft.com/en-us/library/fbk67b6z.aspx[^] (binding is explained here).

—SA

Posted 11-Aug-12 22:29pm

Sergey Alexandrovich Kryukov

v2

Comments

Mehdi Gholam 12-Aug-12 5:15am

5'ed

Sergey Alexandrovich Kryukov 12-Aug-12 12:12pm

Thank you, Mehdi.
--SA

Espen Harlinn 12-Aug-12 12:59pm

5'ed!

Sergey Alexandrovich Kryukov 12-Aug-12 23:15pm

Thank you, Espen.
--SA

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)

Mehdi Gholam · Accepted Answer · 2012-08-11T22:22:00

Solution 1

You have to bind the grid view to your data :

C#

private void btnView_Click(object sender, EventArgs e)
        {
            
            SqlDataAdapter da = new SqlDataAdapter("select * from view_SpareParts ", con);
            DataSet ds = new DataSet();
            da.Fill(ds, "ca");

            dataGridView1.DataSource = ds.Table[0];
        }

Posted 11-Aug-12 22:22pm

Mehdi Gholam

Comments

Sergey Alexandrovich Kryukov 12-Aug-12 4:30am

Correct, my 5.
I also explained about views and provided some links, please see my answer.
--SA

Espen Harlinn 12-Aug-12 12:58pm

Good reply :-D

Mehdi Gholam 12-Aug-12 13:08pm

Thanks Espen!