Display form in VB based on user's choice

[ASHER]

Sponsored Links

In fact I have several from which have the same layout and same features (display list and buttons to add, edit, delete), its just the data exchange. And I want (if possible) to form a single window and data will be filled according to the user's choice when he will click on a field in the menu. I'm already in PHP and is very practical, it avoids making the same transaction and it's faster if modified. I would like to do it on my VB project but I do not know how

[Katty]

You can create your Form Generic. And when you call, depending on what the user click you do not load the same data. As you'll say that my answer makes sense (to logical question), I anticipate:

I guess:
- Your list will contain lines that come from your database.
- So you have to load your data into a dataset
- This dataset will be the source of your DataGrid that will display lines
- Depending on the call button, and well you use it the same query to populate the dataset.
- And for your functions Add, Edit, etc. well if you're making based on the case.

[Praetor]

For the most part call and make a parametrized constructor; if the form differs value as an identifier you pass; if the function changes depending on the type of form you can use an enum

Examples for the 2 cases

public sub new (Id as long)
  initiliazecomponent
  ' treatment by id for managing display
end sub

or with an enum

public enum TypeOpen
  add = 1
  modify = 2
end enum
 
public sub new (open as TypeOpen)
  select case open 
    case add
       ' layout for the add
    case modify 
      ' layout for the modify 
  end select
end sub

[ASHER]

- Your list will contain lines that come from your database.

Great

- So you have to load your data into a dataset
- This dataset will be the source of your DataGrid that will display lines

I never used the DataSet (I'm beginner ), I use DataGridView (there was only that in the tutorial that I read ). What's the point if we can directly display with DataGrid?

For the most part call and make a parametrized constructor; if the form differs value as an identifier you pass;

No, it does not change compared to the identifier. It is more compared to the table. I explain: I have a menu where you can choose between Ram, processor or motherboard. When the user clicks on one of the 3 it to a page with:
- Left: the list (eg processors)
- Right: 3 buttons (Add, Modify, Delete)

if the function changes depending on the type of form you can use an enum

I did some research on ENUM for the first time, but I have not quite understood the functioning and usefulness?

[Praetor]

Usefulness is to appoint an integer value, that avoids coding errors and that makes the code readable. Imagine your form or you have your requests in 3 variables

private _RqRam as string = "select * from ram"
private _RqProcessors as string = "select * from processors"
private _RqCms as string = "select * from cms"

you could very well filtered against a value

public sub new (typeopen as integer)
  select case typeopen 
     case 1
       mycmd.commandtext = _rqram
     case 2
       mycmd.commandtext = _rqprocessors
     case 3
       mycmd.commandtext = _rqcms
   end select
    ' execution of the application and filling datagrid
end sub

So you can arbitrarily say that if you want to display it sends 1 ram etc. So on another form that calls it that you would

dim f as new frmdisplayPieces(1)
f.show

usefulness of the enum is therefore as I said to improve readability

public enum TypeOpen as integer
  ram = 1
  processors = 2
  cms = 3
end enum
 
public sub new (typeopen as TypeOpen)
  select case typeopen 
     case ram
       mycmd.commandtext = _rqram
     case processors 
       mycmd.commandtext = _rqprocessors
     case cms
       mycmd.commandtext = _rqcms
   end select
    ' execution of the application and filling datagrid
end sub

and

dim f as new frmdisplayPieces(ram)
f.show