Joing 3 Table and Bind to an gridview

Question

0.00/5 (No votes)

See more:

Hi frnds am joing 3 table from database and bind that to an grid view it my task.... I done the coding but my form is no responding and struck at this line

C#

da.Fill(dt);

And my complite code is

C#

da = new SqlDataAdapter("SELECT classify21.Age, classify21.workclass, classify21.fnlwgt, classify22.maritalstatus, classify23.educationnum FROM classify21 INNER JOIN classify22 on classify21.workclass=classify22.workclass INNER JOIN classify23 on classify22.workclass = classify23.workclass",cn.con);
           dt = new DataTable();
           da.Fill(dt);
           dataGridView1.DataSource = dt;

Pls do help me Thank You...,

Posted 16-Jul-13 20:32pm

usha C

Updated 16-Jul-13 20:33pm

v2

Add a Solution

Comments

Nirav Prabtani 17-Jul-13 2:39am

has datatable contains count or not??

usha C 17-Jul-13 2:41am

This query wrks when i execte in sql server... oly problem with binding the data in gridview i thnk...

Gautam Raithatha 17-Jul-13 2:42am

can u please provide more details? what error actually is thrown if any? Also check that connection state is opened before executing - da.Fill(dt)

usha C 17-Jul-13 2:45am

Am nt geting any error The form view as not responding....

praks_1 17-Jul-13 2:51am

Check id ur dt is populauted or not then check 4 the connection and the bind

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)

M.R.A. · Answer 1 · 2013-07-16T20:49:00

Solution 2

then use gridview1.databind();

Posted 16-Jul-13 20:49pm

M.R.A.

Comments

usha C 17-Jul-13 2:53am

No sir still same issue...

M.R.A. · Answer 2 · 2013-07-16T20:53:00

Solution 3

please check your sql query in backend

Posted 16-Jul-13 20:53pm

M.R.A.

**Nirav Prabtani** · Answer 3 · 2013-07-16T20:54:00

Solution 4

C#

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
	//
	// You need to access the project's connection string here.
	//
	string connectionString ="your connection string";
	//
	// Create new SqlConnection object.
	//
	using (SqlConnection connection = new SqlConnection(connectionString))
	{
	    connection.Open();
	    //
	    // Create new SqlCommand object.
	    //
	    using (SqlCommand command = new SqlCommand("SELECT classify21.Age, classify21.workclass, classify21.fnlwgt, classify22.maritalstatus, classify23.educationnum FROM classify21 INNER JOIN classify22 on classify21.workclass=classify22.workclass INNER JOIN classify23 on classify22.workclass = classify23.workclass", connection))
	    {
		//
		// Invoke ExecuteReader method.
		//
		SqlDataReader reader = command.ExecuteReader();
		while (reader.Read())
		{

                  GridView1.DataSource=reader;
                  GridView1.DataBind();
	        }
	    }
	}
    }
}

Posted 16-Jul-13 20:54pm

Nirav Prabtani

Updated 16-Jul-13 23:21pm

v3

Comments

usha C 17-Jul-13 2:58am

sir am using c# code here the data bind is nt supporting wat to do???

Nirav Prabtani 17-Jul-13 3:00am

who told you that databind does not support in c#????

Nirav Prabtani 17-Jul-13 5:21am

see updated , i have not checked it yet.

Nirav Prabtani 17-Jul-13 5:34am

i am very sorry to say this but rohan,
this code is working check and then suggest...:)

Nirav Prabtani 17-Jul-13 5:37am

ya but you can not say this is incorrect answer.

Thanks7872 17-Jul-13 5:39am

I have not mentioned that anywhere. I pointed you to mistake. The answer should be such that it should work in each and every situation.

Nirav Prabtani 17-Jul-13 5:40am

you mentioned that "the correct answer is...."
then what is d meaning of that??

Thanks7872 17-Jul-13 5:42am

It means that you wrote abcd....y,but the correct answer is abcd....yz,you missed 'z'.I mentioned my comment on the previous code,try it if you have it,It will throw an error.

Nirav Prabtani 17-Jul-13 5:45am

no boss you wrote comment on this code the comment of infinite loop.
remember?????

Nirav Prabtani 17-Jul-13 5:46am

you also wrote the previous code is better then that code but it is working but the previous one is not...:)

Nirav Prabtani 17-Jul-13 5:38am

any way thanks for suggestion.

Thanks7872 17-Jul-13 5:39am

You are welcome.

usha C 17-Jul-13 6:00am

Hello sir sry i where in meeting and just finished my lunch and came back.....am not geting the result cant use GridView1.DataBind(); i got an error as
"Error 24 Non-invocable member 'System.Windows.Forms.Control.DataBindings' cannot be used like a method"

Thanks lot fr ur effort...........

Nirav Prabtani 17-Jul-13 6:03am

have you tried updated solution ??

usha C 17-Jul-13 6:06am

Ya tried sir pls look at my error...
"Error 24 Non-invocable member 'System.Windows.Forms.Control.DataBindings' cannot be used like a method"

Nirav Prabtani 17-Jul-13 6:10am

try without databind().

usha C 17-Jul-13 6:13am

Ya tried tht too...no result was found on the gridview..

Nirav Prabtani 17-Jul-13 6:19am

have u got count of datatable check by break point.

usha C 17-Jul-13 6:22am

Ya sir datas where gt counted...