Add new row to an unbound data grid view

[darude]

Good Afternoon,
I have a bound data grid view. When a user double-clicks it I want the selected row to populate an unbound data grid view. This is for a survey and I want the second data grid unbound so the user can change the order of the contents before I add the data to a production table.

So, I searched the internet and found that I could create 2 columns AnswerID, AnswerText. When I run it, I get System.Windows.Forms.DataGridViewSelectedRowCollection. It's something, so I feel like I'm close. Am I wrong?

This what I have so far:
dgvSurveyAnswers = New DataGridView()
dgvSurveyAnswers.Columns.Add("AnswerID", "AnswerID")
dgvSurveyAnswers.Columns.Add("Answer_Text", "Answer_Text")

Controls.Add(dgvSurveyAnswers)
dgvSurveyAnswers.Rows(0).Cells(0).Value = dgvAnswers.answerid

Thanks in advance.

 

[jebenson]

Create an unbound DataTable and bind the DataGridView to that. When you add records to the DataTable they will show up in the DataGridView.

Dim dtSurveyAnswers As DataTable
Dim dcAnswerID As DataColumn
dim dcAnswerText As DataColumn

dcAnswerID = New DataColumn("AnswerID")
dcAnswerText = New DataColumn("Answer_Text")

dtSurveyAnswers.Columns.Add(dcAnswerID)
dtSurveyAnswers.Columns.Add(dcAnswerText)

dgvSurveyAnswers = New DataGridView()
dgvSurveyAnswers.DataSource = dtSurveyAnswers

Controls.Add(dgvSurveyAnswers)

To add a row to the DataTable:

Dim dr As DataRow

dr = dtSurveyAnswers.NewRow

dr.Item("AnswerID") = dgvAnswers.answerid
dr.Item("Answer_Text") = "Some text goes here"

dtSueveyAnswers.Rows.Add(dr)

dgvSurveyAnswers.Refresh()

Hope this helps.


I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!

 

[darude]

Awesome, thank you.