DataRow from DataGridView

Let me give a little background about what I'm trying to accomplish. I'm developing a small Trade Show Registration App (Winforms). A company runs a trade show and registers who attends the show on behalf of their various customers. Prior to the trade show beginning, the customer data is loaded into the underlying database. During the show, the registration app begins with a simple search form that allows the user to search for customers in various ways. The search criteria will be passed to a Stored Procedure which will fill a DataSet or DataTable with possible matches. That DataSet/DataTable will be bound to a DataGridView on another form that I will display for the user to choose the correct customer.

Now, my plan at this time is to pass the DataRow represnted by the selected row on the DataGridView to another form where the user could then enter appropriate information about the attendee(s) and save that to the database. My thnking is that I'll pass the entire DataRow so that I can display the information about which customer these attendees represent on that form.

So, the question for me is, how do I get at the underlying DataRow that the slected row on the DataGridView represnts so that I can pass it on?

Any help or code snippets would be appreciated. Feel free to ask for further info if you need it. I'm a bit of a noob with this stuff, so feel free to suggest another way of handling the process.

Thanks,

Steve

Hello Steve, I had a similar situation to this a short while ago, and I developed this simple code to resolve it. First, Identify the row number as follows: //Get the Row Number int row = dataGridViewSiteSubjects.CurrentCell.RowIndex; Then, convert each cell in each row to a string that you can pass as follows: //Convert each cell to string if ((String)dataGridViewSiteSubjects["Subject ID", row].Value.ToString() != "") { string subId = (String)dataGridViewSiteSubjects["Subject ID", row].Value; labelIdenSubjId.Text = subId; } if ((String)dataGridViewSiteSubjects["Randomization Number", row].Value.ToString() != "") { string random = (String)dataGridViewSiteSubjects["Randomization Number", row].Value; labelIdenRandomizationNumber.Text = random; } string initials = (String)dataGridViewSiteSubjects["Initials", row].Value; labelIdenIntials.Text = initials; string screeningNumber = (String)dataGridViewSiteSubjects["Screening Number", row].Value; labelIdenScreeningNumber.Text = screeningNumber; string status = (String)dataGridViewSiteSubjects["Status", row].Value; labelIdenStatus.Text = status; For a bunch of rows, you can use a foreach loop to make it easier: foreach(DataRow dr in ArrayName) { "code" } Hope that points you in the right direction. Best Regards, Pat

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Pat Tum19y ago
Hello Steve, I had a similar situation to this a short while ago, and I developed this simple code to resolve it. First, Identify the row number as follows: //Get the Row Number int row = dataGridViewSiteSubjects.CurrentCell.RowIndex; Then, convert each cell in each row to a string that you can pass as follows: //Convert each cell to string if ((String)dataGridViewSiteSubjects["Subject ID", row].Value.ToString() != "") { string subId = (String)dataGridViewSiteSubjects["Subject ID", row].Value; labelIdenSubjId.Text = subId; } if ((String)dataGridViewSiteSubjects["Randomization Number", row].Value.ToString() != "") { string random = (String)dataGridViewSiteSubjects["Randomization Number", row].Value; labelIdenRandomizationNumber.Text = random; } string initials = (String)dataGridViewSiteSubjects["Initials", row].Value; labelIdenIntials.Text = initials; string screeningNumber = (String)dataGridViewSiteSubjects["Screening Number", row].Value; labelIdenScreeningNumber.Text = screeningNumber; string status = (String)dataGridViewSiteSubjects["Status", row].Value; labelIdenStatus.Text = status; For a bunch of rows, you can use a foreach loop to make it easier: foreach(DataRow dr in ArrayName) { "code" } Hope that points you in the right direction. Best Regards, Pat