|
[x]
Posted via EE Mobile
|
|
| Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
|
|
|
|
Asked by northfields in C# Programming Language, Miscellaneous Programming, Microsoft Visual C#.Net
Hi
I have a datagridview with data populated in Col 1 and Col 2. The user captures data in Col 3, which can be Numeric,AlphaNumeric or Date type data. The data in Co1 and Col 3 must be inserted into one of 3 tables:
tbNumeric OR
tbAlphanumeric OR
tbDate
based on the indicator in Col 2 (d_date OR d_Alpha OR d_Num). AND only if data is supplied in Col 3.
Further, i have the insert statements for the 3 tables.
Question: How do i iterate through the rows in the datagridview and fire the appropriate INSERT Statement based on the Indicator in Col 2?
Thanks
20091111-EE-VQP-92 - Hierarchy / EE_QW_3_20080625