Styjun

What's the best way to update Homebrew when upgrading macOS?

How does Howard Stark know this?

Is "now" UTC time in Solidity?

Can the sorting of a list be verified without comparing neighbors?

Does a member have to be initialized to take its address?

How to make the table in the figure in LaTeX?

Why can't RGB or bicolour LEDs produce a decent yellow?

Should these notes be played as a chord or one after another?

Why in a Ethernet LAN, a packet sniffer can obtain all packets sent over the LAN?

Are there variations of the regular runtimes of the Big-O-Notation?

Unit Test - Testing API Methods

Is the schwa sound consistent?

Cropping a message using array splits

Is there a faster way to calculate Abs[z]^2 numerically?

How to select certain lines (n, n+4, n+8, n+12...) from the file?

How do I get past a 3-year ban from overstay with VWP?

Control variables and other independent variables

Looking for a simple way to manipulate one column of a matrix

Why does increasing the sampling rate make implementing an anti-aliasing filter easier?

Remove everything except csv file Bash Script

Composite Factor Soup

How can I answer high-school writing prompts without sounding weird and fake?

How old is Captain America at the end of "Avengers: Endgame"?

Why use steam instead of just hot air?

how to fill combobox in datagridview from database in vb.net and load default first unit or items in combobox

selecting value from DataGridViewComboBoxColumn?How do you sort an unbound DataGridView filled from a DataTable with added rows?How to add a combobox to a datagridview bound to a datatable as datasource in vb.net?How to load the state of checkboxlist in database asp.net?How to display default values in bound form?populate combobox from datatable but change datatable selected itemHow to browse MDB file to DataGridView and TIF Images to ImageViewerDatagridview with combobox cannot fill inhow to insert checked items from checkedlistbox to SQL database?Display Data in DatagridView with condition

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

my issue is how to fill in specific column and make load first unit by default when load form

 Dim com As New DataGridViewComboBoxColumn


 Dim dt As New DataTable
 Dim da As New SqlDataAdapter
 dt.Clear()


 da = New SqlDataAdapter("select name_unit from unit where item_code =" & DataGridView1(0, DataGridView1.CurrentRow.Index).Value & " ", Con)

 da.Fill(dt)



 com.Name = "name_unit"
 com.DataSource = dt


 com.ValueMember = "name_unit"
 DataGridView1.Columns.Add(com)

vb.net

share|improve this question

edited Mar 23 at 11:08

Mohamed Faysal

asked Mar 23 at 8:05

Mohamed FaysalMohamed Faysal

11

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Use the DataTable.DefaultView as the ComboBox DataSource, set the DisplayMember to the name of the Field or the ColumnName used for display (since you have just one Field here, in this case is what is used, but anyway...). Dispose of the objects you created: the DataAdapter and the DataTable. Since you're using a DataGridView1.CurrentRow, you should also show when/where this code is called.
  
  – Jimi
  Mar 23 at 12:27
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i want to select deference unit in database must to call it so i use dataadapter and this code load combo box by unit as example kilo or ton .my problem is what is code to link between combobox in datagrid view and this code
  
  – Mohamed Faysal
  Mar 23 at 15:58
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I really don't know what you're trying to say here. It's ok to use a DataAdapter to fill the DataTable. However, you need to dispose of it. More important, use the DataTable.DefaultView as a ComboBox.DataSource. Then, dispose of the DataTable, too.
  
  – Jimi
  Mar 23 at 16:04
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i'm sorry , but how i can use DataTable.DefaultView as combobox
  
  – Mohamed Faysal
  Mar 23 at 17:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  com.DataSource = dt.DefaultView.
  
  – Jimi
  Mar 23 at 17:18
  

  
  
  
  

 | 
show 1 more comment

0

my issue is how to fill in specific column and make load first unit by default when load form

 Dim com As New DataGridViewComboBoxColumn


 Dim dt As New DataTable
 Dim da As New SqlDataAdapter
 dt.Clear()


 da = New SqlDataAdapter("select name_unit from unit where item_code =" & DataGridView1(0, DataGridView1.CurrentRow.Index).Value & " ", Con)

 da.Fill(dt)



 com.Name = "name_unit"
 com.DataSource = dt


 com.ValueMember = "name_unit"
 DataGridView1.Columns.Add(com)

vb.net

share|improve this question

edited Mar 23 at 11:08

Mohamed Faysal

asked Mar 23 at 8:05

Mohamed FaysalMohamed Faysal

11

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Use the DataTable.DefaultView as the ComboBox DataSource, set the DisplayMember to the name of the Field or the ColumnName used for display (since you have just one Field here, in this case is what is used, but anyway...). Dispose of the objects you created: the DataAdapter and the DataTable. Since you're using a DataGridView1.CurrentRow, you should also show when/where this code is called.
  
  – Jimi
  Mar 23 at 12:27
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i want to select deference unit in database must to call it so i use dataadapter and this code load combo box by unit as example kilo or ton .my problem is what is code to link between combobox in datagrid view and this code
  
  – Mohamed Faysal
  Mar 23 at 15:58
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I really don't know what you're trying to say here. It's ok to use a DataAdapter to fill the DataTable. However, you need to dispose of it. More important, use the DataTable.DefaultView as a ComboBox.DataSource. Then, dispose of the DataTable, too.
  
  – Jimi
  Mar 23 at 16:04
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i'm sorry , but how i can use DataTable.DefaultView as combobox
  
  – Mohamed Faysal
  Mar 23 at 17:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  com.DataSource = dt.DefaultView.
  
  – Jimi
  Mar 23 at 17:18
  

  
  
  
  

 | 
show 1 more comment

my issue is how to fill in specific column and make load first unit by default when load form

 Dim com As New DataGridViewComboBoxColumn


 Dim dt As New DataTable
 Dim da As New SqlDataAdapter
 dt.Clear()


 da = New SqlDataAdapter("select name_unit from unit where item_code =" & DataGridView1(0, DataGridView1.CurrentRow.Index).Value & " ", Con)

 da.Fill(dt)



 com.Name = "name_unit"
 com.DataSource = dt


 com.ValueMember = "name_unit"
 DataGridView1.Columns.Add(com)

vb.net

share|improve this question

edited Mar 23 at 11:08

Mohamed Faysal

asked Mar 23 at 8:05

Mohamed FaysalMohamed Faysal

11

 Dim com As New DataGridViewComboBoxColumn


 Dim dt As New DataTable
 Dim da As New SqlDataAdapter
 dt.Clear()


 da = New SqlDataAdapter("select name_unit from unit where item_code =" & DataGridView1(0, DataGridView1.CurrentRow.Index).Value & " ", Con)

 da.Fill(dt)



 com.Name = "name_unit"
 com.DataSource = dt


 com.ValueMember = "name_unit"
 DataGridView1.Columns.Add(com)

share|improve this question

edited Mar 23 at 11:08

Mohamed Faysal

asked Mar 23 at 8:05

Mohamed FaysalMohamed Faysal

11

share|improve this question

edited Mar 23 at 11:08

Mohamed Faysal

asked Mar 23 at 8:05

Mohamed FaysalMohamed Faysal

11

asked Mar 23 at 8:05

Mohamed FaysalMohamed Faysal

11

asked Mar 23 at 8:05

Mohamed FaysalMohamed Faysal

11