locked
How to display data in the grid RRS feed

  • Question

  • I have two tables.there is no relationship in these two tables.suppose table names are t1,t2.

       table t1 have 3 columns c1,c2,c3.

      table t2 have 4 columns x1,c2,x3,x4.

    i have to retrieve c2 data from t1 and display the t2 table in the c2 column into the gridview.

    Please reply me.

    Thanks in advance.

    Saturday, February 25, 2012 5:06 AM

Answers

  • you create a query for t2 (let's call it t2c2) adding where clause c2 = c2parameter

    you add this t2c2 query to your screen and you have a c2parameter query parameter. You also add t1 to your form.

    You add t1 as a collection view (list or grid) if collection or detail if single or default.

    Then you click on the left on c2parameter and on the right (properties) you bind to t1.SelectedItem.c2.

    You add t2c2 to the screen as Grid.

    If you want to select t1 from a combo, you add a property of type t1 in your screen and drag the property where you want. This will automatically generate an AutocompleteBox. Then you bind c2parameter to  property's name.c2.

    If I undestand what you want to do correctly.

    P.S. Questions regarding using LS is better to be posted to General Questions Forum. I mention this as posting to the correct forum increases the possibility to get a proper answer.


    1+1 = 3 for large values of 1

    Saturday, February 25, 2012 10:20 AM