How to bind data in datagridview using Short Proc

Question

1.00/5 (1 vote)

See more:

Good day

I want to display my tables data in a datagridview using a Stored Procedure that I have created in Sql server 2005.

My Stored Procedure is working and executing. All my data is displaying in Sql from the Stored Procedure.

Here are my C# code: I have written a method inside of my class.

public string display()
       {
          SqlDatabase sqldb = new SqlDatabase(ConnectionString);
          IDataReader reader = sqldb.ExecuteReader("pSEL_mLearner", new Object[] { });


          return reader.ToString();
       }

And here is the code that I use to call my method in the main unit on my Display button.

C#

private void btnDisplay_Click(object sender, EventArgs e)
       {
           dataGridView1.DataSource = login.display();

No data is displayed inside my datagridview.

What is wrong?

Posted 16-Jan-12 2:02am

JacoBosch

Updated 23-Jan-12 0:30am

v2

Add a Solution

4 solutions

Solution 1

public string display()

instead of return string value

U can return DATASET and Then Try...
I Hope It Will WOrk..

Posted 16-Jan-12 3:21am

dilip.aim11

Solution 2

Hi,

dataGridView1.DataSource = login.display()

After writting the above line you forgot the binding the data to grid view.Thats why It will not display the data to grid view.
At your this code after that line you insert below line.It will shows data to the grid view.

dataGridView1.DataBind()

Posted 16-Jan-12 5:32am

londhess

Updated 17-Jan-12 19:08pm

v2

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)

JacoBosch · Accepted Answer · 2012-01-17T18:57:00

Hi, here is the Solution to my question

public DataTable display()
       {

 SqlDatabase sqldb = new SqlDatabase(ConnectionString);
 DataTable dt = new DataTable();
 IDataReader reader = sqldb.ExecuteReader("pSEL_mLearner", new object[] { });

 dt.Load(reader);

return dt;
       }

C#

private void btnDisplay_Click(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();
            dt = login.display();

                dataGridView1.DataSource = dt;
        }

JacoBosch · Accepted Answer · 2012-01-17T23:34:00

Here is another why how you can do it

public DataTable display()
        {
     DataSet dsGlobalConfig = null;
     SqlDatabase sqldb = new SqlDatabase(ConnectionString);
     dsGlobalConfig = sqldb.ExecuteDataSet("pSEL_mLearner", new object[] { });

     return dsGlobalConfig.Tables[0];                   
 
       }


private void btnDisplay_Click(object sender, EventArgs e)
      {
          DataTable dt = new DataTable();
          dt = login.display();

          dataGridView1.DataSource = dt;
      }

How to bind data in datagridview using Short Proc

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0