DataGridView with columns from two tables and rows filtered by a where condition

Question

0.00/5 (No votes)

See more:

Dear all,

I want to display and UPDATE the data of a certain table using DataGridView.
I need help to create a typed DataSet to be the DataSource for my BindingSource object.
My problem is :

1- Not all of my columns come from one table. One column (dept_name) should be retrieved from another table by a subquery, but It’s not gonna be updated.

2- Select statement that should be used by the TableAdapter has a (where condition) with parameters inserted by the user before populating the grid with correct data.

Here's a simplified version of my query:

SQL

Select   dept_id ,  SEQ ,time_stamp ,  
(selec dept _name from Departments  D where D.dept_id  = H.dept_id)
From History H
Where   seq = v_input_seq

Note: i don't want to use JOIN in my query, because TableAdapter wouldn't generate (insert, update...) statements automatically for me.

Can anyone help me with creating the DataSet and configuring and TableAdapter throw the WIZARD, please?

Thanks in advance

Posted 6-Jun-13 1:23am

nina4ever

Updated 9-Jun-13 1:02am

v2

Add a Solution

Comments

Sunasara Imdadhusen 6-Jun-13 8:15am

Have you written anything for the same?

nina4ever 10-Jun-13 15:49pm

i am sorry, i did not get your question. what do you mean?

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)

Piyush Dixit · Answer 1 · 2013-06-06T02:21:00

Solution 1

For select query, you can try this:

SQL

Select   H.dept_id , SEQ ,time_stamp , dept _name
From History H inner join Departments D on D.dept_id  = H.dept_id
Where   seq = v_input_seq

Posted 6-Jun-13 2:21am

Piyush Dixit

Updated 6-Jun-13 2:22am

v2

Comments

nina4ever 9-Jun-13 6:48am

thank you Piyush. I would have written my query using JOIN as you have suggested, but TableAdapter would not generate (insert,update...) statements automatically... that's why i am trying to avoid joins

Piyush Dixit 10-Jun-13 6:21am

In that case you can create a view in database for the above select statement and then query it.

nina4ever 10-Jun-13 15:52pm

Would that allow TableAdapter to generate correct Update statements? How could it know which table to update since it sees a "view"?