We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
VB.Net - DataRow Declartion Assistance
Posted on 2012-12-31
Good Day Experts!
I am looking for assistance with my DataRow declaration. Right now I have it declared in my For Next Loop:
For Each sqlRSGetProcessing As DataRow In sqlRStbl.Rows
Next
This works great with no issues. After the Next, I am trying to reference the DataRow in a line of code for a messageBox in event there is an error. However, it tells me the DataRow is not declared.
So, up above the For statement I declare it. That makes the issue about it not being delcared go away in my code for the messageBox. But the "For Each sqlRSGetProcessing As DataRow In sqlRStbl.Rows" line barks at me saying the DataRow is alread delcared.
How can I make the DataRow in the For statement visible to the code below it?
Thanks,
jimbo99999
I am looking for assistance with my DataRow declaration. Right now I have it declared in my For Next Loop:
For Each sqlRSGetProcessing As DataRow In sqlRStbl.Rows
Next
This works great with no issues. After the Next, I am trying to reference the DataRow in a line of code for a messageBox in event there is an error. However, it tells me the DataRow is not declared.
So, up above the For statement I declare it. That makes the issue about it not being delcared go away in my code for the messageBox. But the "For Each sqlRSGetProcessing As DataRow In sqlRStbl.Rows" line barks at me saying the DataRow is alread delcared.
How can I make the DataRow in the For statement visible to the code below it?
Thanks,
jimbo99999
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
this should work:
Declare sqlRSGetProcessing As DataRow
For Each sqlRSGetProcessing In sqlRStbl.Rows
Next
The above answer should address your query, however it will contain the last row in the table, whereas the error you want to notify of may indeed be in another row within the table. In which case, stick to your original code and simply handle your messagebox inside a try catch, e.g
For Each sqlRSGetProcessing As DataRow In sqlRStbl.Rows
Try
'here do your processing
Catch ex As Exception
'here put your messagebox
End Try
Next
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place!
Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special.
It's completely agentless, but does let you create an agent, if you desire.
It offers powerful scalability …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month5 days, 15 hours left to enroll
626 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.