Adding datagrid rows programmically

[Sebastian Santacroe]

Hello,
I've got a datagrid with two columns and no data. I want
to add data programmically (from DB).
When I try to use sintax like:
dataset.Tables("Department").Rows(0).Item("Percent age
Used") = 10
(you can assume the grid is binded to this dataset table)

I get an error telling me row 0 does not exist. I'm
assuming I need to use a New command to add rows in a
datagrid programmincally. How would I do this? whats the
syntax?

My second question is: One of the columns is a comboBox.
Can I still use methods like Findstring and set properties
like SelectedIndex=-1 even though its in a datagrid. If
not how can I select an item in the combobox that is in
the datagrid programmically?

Thank you.

[Ken Tucker [MVP]]

Hi,

You have to create a new row then add it to the dataset.
Dim dr As DataRow = dataset.Tables("Department").NewRow

dr.item("Percentage Used") = 10
dataset.Tables("Department").Rows.Add(dr)

Ken

------------------
"Sebastian Santacroe" <ss*********@ilogic.com> wrote in message
news:04****************************@phx.gbl...

Hello,
I've got a datagrid with two columns and no data. I want
to add data programmically (from DB).
When I try to use sintax like:
dataset.Tables("Department").Rows(0).Item("Percent age
Used") = 10
(you can assume the grid is binded to this dataset table)

I get an error telling me row 0 does not exist. I'm
assuming I need to use a New command to add rows in a
datagrid programmincally. How would I do this? whats the
syntax?

My second question is: One of the columns is a comboBox.
Can I still use methods like Findstring and set properties
like SelectedIndex=-1 even though its in a datagrid. If
not how can I select an item in the combobox that is in
the datagrid programmically?

Thank you.