Get Data From Multiple Tables

Question

0.00/5 (No votes)

See more:

hello friends,
I am using MVC 2.0.

I have a problem that I want to get data in my view for two tables.

data from table1 is needed to fill my grid.

and data from table 2 to provide user the choices of items that i have in another table(I want to show item as checkbox for selecting).
I have no idea how can I do this task.

can you please help me on this.

Posted 28-May-10 22:09pm

darora85

Updated 29-May-10 4:43am

Henry Minute

v2

Add a Solution

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)

Abhinav S · Answer 1 · 2010-05-28T22:53:00

Solution 1

Why don't you join the two tables using a JOIN clause. If you want to show related table data together, there must be a key that should be common to both tables.

Posted 28-May-10 22:53pm

Abhinav S

Henry Minute · Answer 2 · 2010-05-29T04:47:00

Neo Arora wrote:
and data from table 2 to provide user the choices of items that i have in another table(I want to show item as checkbox for selecting)

If you have more than two choices it is going to be very difficult to use a CheckBox to represent them. Do you not think that you would be better to use a ComboBox?

ANSAL P R · Answer 3 · 2010-12-21T05:14:00

Hi,

Actually normal html code doesn't support checked list box. So ur need is not get by normal condition.

Please try this.

in controller

VB

Function CheckBox() As ActionResult

            Dim strCheckBoxGroup As String
            strCheckBoxGroup = "<table border='1'> "
            For x As Integer = 1 To 10
                strCheckBoxGroup = strCheckBoxGroup + " <tr> "
                strCheckBoxGroup = strCheckBoxGroup + " <td> "
                strCheckBoxGroup = strCheckBoxGroup + " <input id='" + x.ToString + "' name='" + x.ToString + "' type='checkbox' value='true' />"
                strCheckBoxGroup = strCheckBoxGroup + x.ToString + " Description "
                strCheckBoxGroup = strCheckBoxGroup + " </td> "
                strCheckBoxGroup = strCheckBoxGroup + " </tr> "
            Next
            strCheckBoxGroup = strCheckBoxGroup + " </table>"
            ViewData("chkBox") = New HtmlString(strCheckBoxGroup)
            Return View(ViewData("chkBox"))
        End Function

In View

XML

<body>
<%
    Html.BeginForm()
    If True Then
    %>
    <div>
        <%: ViewData("chkBox")%>
    </div>
    <% End If%>

</body>

Get Data From Multiple Tables

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0