SteveInBeloit
Well-known member
- Joined
- May 22, 2006
- Messages
- 132
- Programming Experience
- 10+
Here is what I have:
Dim daGrid1 As New SqlDataAdapter(Me.SqlCommand1) (a stored proc)
Dim dsGrid1 As New DataSet
dsGrid1.Clear()
daGrid1.Fill(dsGrid1, "top")
DataGrid1.DataSource = dsGrid1.Tables("top").DefaultView
It will display the returned rows in the datagrid on the form.
If I am doing these in a poor manner, please let me know.
Now that I have the datagrid populated, I see that every column returned by the stored proc is showing. I only want a subset of these fields to show, and I want to set the column headers to different names, not the names of the table columns. I also want to be able to click on a record, or button to the right of the record, and go to another form with information about that record. I must be seaching on the wrong topics because I cannot find that covered anywhere in datagrids.
Any help?
Steve
Dim daGrid1 As New SqlDataAdapter(Me.SqlCommand1) (a stored proc)
Dim dsGrid1 As New DataSet
dsGrid1.Clear()
daGrid1.Fill(dsGrid1, "top")
DataGrid1.DataSource = dsGrid1.Tables("top").DefaultView
It will display the returned rows in the datagrid on the form.
If I am doing these in a poor manner, please let me know.
Now that I have the datagrid populated, I see that every column returned by the stored proc is showing. I only want a subset of these fields to show, and I want to set the column headers to different names, not the names of the table columns. I also want to be able to click on a record, or button to the right of the record, and go to another form with information about that record. I must be seaching on the wrong topics because I cannot find that covered anywhere in datagrids.
Any help?
Steve
