questions about datagridview

[sphericalx]

i'm currently using vb 2005 express edition and sql server 2000 and i've manage to get the data out from the server and place them into a datagridview.

so here's the problems that i'm facing. is it possible that when the user click on a certain cells in the datagridview, that ROW of cells get highlighted? And also if the user were to double-click on a certain cells, all the values from that ROW appear on a messagebox?

thanks,

ron

Previous Thread.
http://www.vbforums.com/showthread.php?t=538670

[jmcilhinney]

1. Set the SelectionMode property of the grid to FullRowSelect.

2. You can loop through the values in the cells like this:

For Each cell As myDataGridView.SelectedCells
    MessageBox.Show(cell.Value.ToString())
Next

That will show each cell value individually. If you want to show them altogether then you need to get each value and join it into a single larger string, then call MessageBox.Show once only and pass that string. I'll leave that to you as an exercise.

[sphericalx]

For Each cell As myDataGridView.SelectedCells

not a correct syntax. tried changing "myDataGridView" to "DataGridView" and also to the name of my datagridview but can't.

[sphericalx]

got it working alr. below is my attached code ^^


Dim cells As DataGridViewCell
For Each cells In DataGridView1.SelectedCells
MessageBox.Show(cells.Value.ToString)
Next

[jmcilhinney]

Ah, my apologies. That's what happens when i don't have an IDE to check my typing. My original code should have been:

For Each cell As DataGridViewCell In myDataGridView.SelectedCells

[sphericalx]

haha.. its ok.. it gave me room to explore on how to get it done. haha.. ^^

[sphericalx]

below is the code on how i retrieve the data from the database and place it into a datagridview? however, is it possible for mi to do some changes to the data before filling it into the dataviewgrid?

SQLstr = "SELECT ID 'Product ID', Name 'Description',Size,Make,StockCount 'Stock Count',WholeSale,Retail FROM ProductsAndServices where PS='P'"
                    mycon = New SqlConnection(str_connection)
                    comUserSelect = New SqlCommand(SQLstr, mycon)
                    Dim dataadapter As SqlDataAdapter = New SqlDataAdapter(comUserSelect)
                    Dim ds As DataSet = New DataSet()
                    mycon.Open()
                    dataadapter.Fill(ds, "Product_table")
                    mycon.Close()
                    My.Forms.Main1.DataGridView1.DataSource = ds
                    My.Forms.Main1.DataGridView1.DataMember = "Product_table"
                    Me.Close()

[jmcilhinney]

Sure. You can get a DataTable from a DataSet by indexing its Tables property by table name or number. You can get a DataRow from a DataTable by indexing its Rows property. You can get or set a field in a row by indexing it by column name or number.

That said, what exactly is it that you wanted to do? It might be something that the SQL code can take care of for you.

[sphericalx]

err.. do u have coding exmples for references?

i have a smallmoney datatype value. but as u know, when u retrieve the smallmoney out from the database it will be something like this-> 8.0000

however i wan it to display in the datagridview as $8.00 therefore i'm tinking of editing it before i place it into the datagridview

[jmcilhinney]

Then it's a good thing I asked what you wanted to do, because there's no need of any editing. You should just be binding your data to the grid as is and letting the grid worry about formatting. Each column has a DefaultCellStyle property that controls the default style for cells in that column. That has a Format property that accepts a format string, which you can use to format numbers or dates in numerous ways. The format string for currency is "c", assuming that you want to use the currency format of the local system. So, you need to set the DefaultCellStyle.Format property of your grid column to "c", which you can do in the designer or in code.

[sphericalx]

oh really? hmm..but do u have any code or source which i can do a reference from?

[Deepak Sakpal]

DataGridView1.Columns("Column1").DefaultCellStyle.Format = "c"

[sphericalx]

Q1: if i had pre-added all the column header. how is it possible that when i doubleclick on the empty cell in "ID" column, a form dialog appear? whereas if i doubleclick on any of the other column, nothing will happen.
_______________________________________________________
|Employee |StartTime |ID |Mins |Type |Description |Price |Total |
|________|_________|__|____|_____|_________|____|_____|

Q2: and how can i add values into specify cells?
For Example:

Add '200' into ID, '3' into Mins, 'P' into Type, 'Body Massage' into Description, '$20.00' into Price. If first row is empty, it will be added into the specific cell in row 0. But if Row 1 is alr filled, it will be placed into row 1 instead.

|Employee |StartTime |ID |Mins |Type |Description |Price |Total |
|________|_________|___|_____|______|__________|_____|______|

[jmcilhinney]

Please ask new questions in new threads. One thread per topic and one topic per thread.

[sphericalx]

Please ask new questions in new threads. One thread per topic and one topic per thread.

but the topic is generally about datagridview.

[jmcilhinney]

but the topic is generally about datagridview.

Well the topic should NOT generally be about the DataGridView. You could ask a thousand different questions about the DataGridView because it's such a complex control. Will they all be asked in this one thread? Formatting currency in a DataGridView is one topic and belongs in its own thread. Your latest questions have nothing to do with formatting currency in a DataGridView so they are new topics and belong in new threads.