-
Mar 17th, 2021, 04:01 PM
#1
Thread Starter
Fanatic Member
How can I use fill from a typed dataset to be applied to my datagridview datasource?
Hello:
I have a typed dataset query that produces exactly what I want. How can I use fill from a typed dataset to be applied to my datagridview datasource?
Code:
Private Sub frmHistory_Load(sender As Object, e As EventArgs) Handles Me.Load
Dim Requester As String = frmRequest.cboRequestor.Text
MessageBox.Show(Requester)
Dim ta_History As PurchasingRequestDataSetTableAdapters.PartsTableAdapter = New PurchasingRequestDataSetTableAdapters.PartsTableAdapter
ta_History.FillBy_GetHistory(DS.Parts, "Jerome Vanderlinde")
' How can I use the fill above to be applied to my datagridview datasource?
dgvHistory.DataSource = TBD
End Sub
Thanks!
- A 'Hyperactive Member' trying to make a difference in a hyperactive world! And recently, I've been promoted to a 'Finatic Member,' whatever that means!
-
Mar 17th, 2021, 05:27 PM
#2
Re: How can I use fill from a typed dataset to be applied to my datagridview datasour
Ummmm... by assigning the datatable to the datasource... just like you would anything else... Using a typed dataset doesn't really change anything.
Code:
Private Sub frmHistory_Load(sender As Object, e As EventArgs) Handles Me.Load
Dim Requester As String = frmRequest.cboRequestor.Text
MessageBox.Show(Requester)
Dim ta_History As PurchasingRequestDataSetTableAdapters.PartsTableAdapter = New PurchasingRequestDataSetTableAdapters.PartsTableAdapter
ta_History.FillBy_GetHistory(DS.Parts, "Jerome Vanderlinde")
' How can I use the fill above to be applied to my datagridview datasource?
dgvHistory.DataSource = DS.Parts
End Sub
-tg
-
Mar 18th, 2021, 08:10 AM
#3
Thread Starter
Fanatic Member
Re: How can I use fill from a typed dataset to be applied to my datagridview datasour
DS.Parts just returns the entire table, all cells in an undesired order. The query spits out the data in the desirable order, with fewer fields. This is what I am trying to control.
Thoughts on this? Thanks!
- A 'Hyperactive Member' trying to make a difference in a hyperactive world! And recently, I've been promoted to a 'Finatic Member,' whatever that means!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|