using parameters in the configuration wizard in vb.net?

Hi,

I have a question regarding how to congure parameters in the configuration wizard instead of writing code in the code behind page in vb.net. I have configured and designed the dataadapter, theconnection, the dataset using the configuration wizards, just to avoid writing code.

I have a combobox populated with some values. I need to select a value from it during run time. Now, I have to insert this selected value into an empty column in a different table in my dataset during runtime. I know, I could use the parameters. But as I said, I want to configure the parameters collectioin using the configuration wizard instead of writing code.

Does anybosy has any idea about this Any online help is greatly appreciated. Need it urgently.

Thanks.

- Ron



Answer this question

using parameters in the configuration wizard in vb.net?

  • Thams

    When you use a DataSource you can edit the select, update, insert and delete query from the property grid. For each of these querys you have an option to edit the parameters.

    Is this what you're looking

    Regards,
    Bjorn


  • Peter Jausovec

    As you know, for the insert and update commands for the dataadapter object has a parameters collection in the properties window. I need a way how to configue the parameters so that when I select some value in the combobox at run time, I need to inser that into the a table.

    Have any idea

    Thank you.

    - Ron



  • MSDNMAN

    Hi,

    If you are trying this in a windows app, it's just not possible without writing code!
    In the other case if you are using a web app, you can select wich control to use to fill in the parameter. This is a functionality that is not (yet) implemented in windows forms applications.

    You don't have to write much code in the other hand. I supose you generated your insert statement on the DataAdapter In that case you can write one line of code to do the insert in the database.

    DataAdapterName.Insert(parameter1,paramter2,...)

    where you can replace parameter1 by combobox.SelectedText.

    Hopefully this helps you out of you're problem

    Regards,
    Bjorn


  • using parameters in the configuration wizard in vb.net?