Database and Table Bindings

Question

1.00/5 (2 votes)

See more:

Hello friends, this is actually my first post here, good to have you people.
I am new to database creation. I created a database using visual studio, it has two tables in them, I am finding it difficult displaying fields from the two tables to one datagridview, please I need help on how to solve this problem. Thanks in advance.
Lovely day.
SUNNY OKORO

This is the code I wrote for it,

SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DB2TABS.mdf;Integrated Security=True;User Instance=True");
            SqlCommand cmd = new SqlCommand();
            conn.Open();
            SqlCommand CMD = conn.CreateCommand();
            CMD.CommandType = CommandType.Text;
          
//TABCOS, TABDETS ARE THE TABLE NAMES

            CMD.CommandText = "SELECT TABCOS.REGNO. TABDETS.FIRSTNAME FROM TABCOS, TABDETS WHERE TABCOS.REGNO = TABDETS.REGNO";

            SqlDataAdapter DA = new SqlDataAdapter();
            DA.SelectCommand = CMD;

I don't know what to do next, Please help. Thanks.

Posted 5-Apr-11 20:20pm

SUNNY OKORO

Updated 5-Apr-11 21:29pm

Wayne Gaylard

v3

Add a Solution

Comments

m@dhu 6-Apr-11 2:33am

Using capital letters is shouting over the net.

Toli Cuturicu 6-Apr-11 3:11am

DON'T SHOUT AT ME!
Or, I'll shout back at you and vote 1.

Wayne Gaylard 6-Apr-11 3:30am

I edited the title to remove the Capital Letters. This is considered shouting in public forums.

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

Wayne Gaylard · Answer 1 · 2011-04-05T21:13:00

Solution 3

Try this:-
"SELECT `TC.REGNO`, `TD.FIRSTNAME` FROM `TABCOS` TC INNER JOIN `TADDETS` TD ON `TC.REGNO` = `TD.REGNO`" as your query.

Hope this helps

Posted 5-Apr-11 21:13pm

Wayne Gaylard

Updated 5-Apr-11 21:15pm

v2

Mahendra.p25 · Answer 2 · 2011-04-05T20:28:00

Solution 2

use Join to get data from two tables then

SqlDataAdapter dt = new SqlDataAdapter(CommandObject)
//Declare DataSet and assign dataadapter value to dataset
using System.Data
DataSet ds = new dataSet ();
dt.fill(ds);
//to bind gridview Use
gridview1.DataSource = ds 
gridview1.DataBind();

Posted 5-Apr-11 20:28pm

Mahendra.p25

Updated 5-Apr-11 20:34pm

v2