Join two Tables In GRIDVIEW

Question

3.00/5 (1 vote)

See more:

Hi i have two tables the first have many fields including department_id.The other one have department_id and department description i want to display in gridview first table fields including department description related with department_id

Query:

SQL

SelectCommand="SELECT [report_no], [datesubmision], [complainee_name], [complainee_surname], [complainee_idnumber], [complainee_tel], [policynumber], [claimnumber], [typeofperson],[department_id],[status_id], [id] FROM [accusationform]"

Please help me

Posted 13-Nov-13 2:45am

nikolas_ar

Updated 13-Nov-13 17:02pm

♥…ЯҠ…♥

v2

Add a Solution

Comments

♥…ЯҠ…♥ 13-Nov-13 8:47am

Do you want to display department_name in place of department_id in grid view,dont you?

nikolas_ar 13-Nov-13 8:48am

Yes

nikolas_ar 13-Nov-13 8:49am

Thanks for your quick reply

♥…ЯҠ…♥ 13-Nov-13 8:49am

Next time be more specific in your question....Now update your table schema and query that you used to get the record

nikolas_ar 13-Nov-13 8:57am

Sorry about that

♥…ЯҠ…♥ 13-Nov-13 8:59am

No problem just update the question with your query.....

nikolas_ar 13-Nov-13 9:02am

SelectCommand="SELECT [report_no], [datesubmision], [complainee_name], [complainee_surname], [complainee_idnumber], [complainee_tel], [policynumber], [claimnumber], [typeofperson],[department_id],[status_id], [id] FROM [accusationform]"

♥…ЯҠ…♥ 13-Nov-13 23:06pm

Only one table? So where is another table schema to join with this table?

JoCodes 14-Nov-13 1:51am

Use a Sql Join operation for the 2 tables with the deptid

1 solution

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)

♥…ЯҠ…♥ · Accepted Answer · 2013-11-13T17:15:00

Hi Nikolas,

Here is the query you can make use of

SQL

SELECT [acussfrm.report_no], 
       [acussfrm.datesubmision], 
       [acussfrm.complainee_name], 
       [acussfrm.complainee_surname], 
       [acussfrm.complainee_idnumber], 
       [acussfrm.complainee_tel], 
       [acussfrm.policynumber], 
       [acussfrm.claimnumber], 
       [acussfrm.typeofperson], 
       [secfrm.department_name], --Here department name is replaced 
       [acussfrm.status_id], 
       [acussfrm.id] 
FROM   [accusationform] AS acussfrm, 
       [secondform] AS secfrm -- Rename secondform to your second table name
WHERE  [acussfrm.department_id] = [secfrm.department_id] --Here is the condition that reads the common data from two tables with having department_id as common id.

Hope this helps you a bit.

Regards,
RK