locked
using combobox in dgv RRS feed

  • Question

  • I have two combobox in my DGV

    1) bill_ch_code & 2) ch_ name

    the code which I use to fill them is:

     Dim da As New SqlDataAdapter("Select ch_code, ch_name from [Charges_Master] ORDER BY ch_type ASC", con2)
                con2.Open()
                Dim ds As New DataTable
                da.Fill(ds)
                Bill_Ch_Code.DataSource = ds
                Bill_Ch_Code.DisplayMember = "ch_code"
                ch_name.DataSource = ds
                ch_name.DisplayMember = "ch_name"
                con2.Close()

    everything is working except one thing I want if the vale of any combo box is changed it will automatically change the other.

    same code on normal combo box works fine for the same.


    Pradeep Yadav (Social MSDN)

    Wednesday, March 13, 2013 7:37 AM

Answers

  • Hi Pradeep,

    In Reporting Services, cascading parameters enable us to get the list of values for one parameter depends on the value chosen in preceding parameter. After the value for the independent parameter is changed, the available values for the dependent parameter will change automatically. To create cascading parameters, we can reference the proper parameter in the Where clause in the dataset query. For example, let’s assume there is a parameter named code, the query can be like:

    Select ch_code, ch_name 
    From [Charges_Master]
    Where ch_code=(@code)

    References:
    Adding Cascading Parameters (SSRS)

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here


    Mike Yin
    TechNet Community Support

    • Marked as answer by Mike Yin Tuesday, March 19, 2013 5:15 PM
    Friday, March 15, 2013 2:56 AM