Hello out there.
I am new to .Net and I am trying to use the datagrid to show some data from my access DB. Here are the following columns that I want to display.
I want to be able to fill the data grid with these fields but I want to change the column headers to more user friendly names (Stock #, Description, Asking Price)
and also I want the last column (Asking Price) to be formatted in currency and aligned to the right.
here is my relevant code:
Private dvInventory As DataView
Private mydaInventory As OleDbDataAdapter
Dim ds As New DataSet
.CommandText = "Select StockNum, Desc, AskingPrice From Inventory"
.Connection = cnn
mydaInventory = New OleDbDataAdapter
mydaInventory.SelectCommand = cmdSelect
dvInventory = ds.Tables(0).DefaultView
.DataSource = dvInventory
.AllowNavigation = False
How do get this to look the way I want?