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

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

Get Data From Multiple Tables

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us