Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>if i don't misunderstand you want to set the datagridview's combobox column's datasource..You can set by this : </p> <pre><code>/// if you use OfType Method then you will get advantage of to use as normal control /// means this method will give you advantage of can use all method and properties /// of the control which you want to implement in DataGridView /// Controls.OfType method will check all the columns and get an array with /// what you give as search criteria..here, the criteria is ComboboxColumn.. /// depends of your need you can give comboboxcell also.. /// Element at method selects the zero based index in array which filtered by criteria /// if you use only one of the given type then you can use .First() instead of .ElementAt() yourDataGridViewName.Controls.OfType&lt;DataGridViewComboBoxColumn&gt;() .ElementAt(indexNoOfTheDGVComboBox).DataSource = YourDataRetrievingMethod; //i.e. ds.Tables[indexNoOfTheTable].Columns[IndexOfTheColumn] /// and you can set DisplayMember and ValueMember as the same way.. /// i give combocell and combocolumn together to show the syntax. yourDataGridViewName.Controls.OfType&lt;DataGridViewComboBoxCell&gt;() .ElementAt(0).DisplayMember = "YourDisplay"; yourDataGridViewName.Controls.OfType&lt;DataGridViewComboBoxCell&gt;() .ElementAt(0).ValueMember = "YourValue"; </code></pre> <p>About the second Question.. if you ask me then i prefer : To control "accidentally savings" put a buttonCell at the end of the row..when user change something on row should click the save button..And then in your button click method you can save changes as normal insert or update method..</p> <p>just 2 differences there..</p> <p>1-) you need to use <code>Cell_Click</code> Event and to be sure that is button check with <code>OfType()</code> method instead of normal <code>Button _Click</code> event</p> <p>2-) Depends to project needs, you will need to get DataGridView's <code>RowIndex</code> and / or <code>Cell Address()</code> before to get and pass values to the SQLQuery</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to DataGridViewComboBoxColumn set value from dataset
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USsihirbazzz
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to DataGridViewComboBoxColumn set value from dataset
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COthanks, did it in similar way as you mentioned. I thought if is some 'easyer' way with `SqlCommandBuilder` but i didn't found it.
      singulars
      1. PO
      1. USJanOlMajti
    2. CO@JanOlMajti you can't do everything with commbuilder and you don't need to ;) if i needed to create a control as yours then i preferred this way : i create a table which has integers (i.e. your combobox column's selectedindex no and others' date and id etc.) and crud (ins-upd-del) procedures for this table..if project_name must have some attributes then another table for these and bring id/name to the combobox from there with datareader(dreader is faster)..if project_name has only needs name and id then i prefer to create a dictionary and set the dgv combocell's datasource with it
      singulars
      1. PO
      1. USsihirbazzz
    3. CO(as a securer and faster option always prefer use datareader and stored procedures for your Sql actions..) and after these steps i can pass row values to the stored procedure as much as easier and securer than sqlcommandbuilder and query
      singulars
      1. PO
      1. USsihirbazzz
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload