need help in solving the code

Question

0.00/5 (No votes)

See more:

Hi all

VB

var = ds.Tables(0).Rows(0)(12)

i m getting error in the above line..the application getting closed automatically..i am trying to fetch the 12th column of the table and save it in the variable 'var'

Posted 3-Oct-12 20:04pm

Code-Hunt

Updated 4-Oct-12 3:38am

Kenneth Haugland

v3

Add a Solution

Comments

Venkatesh Mookkan 4-Oct-12 8:55am

I have updated the answer!

fjdiewornncalwe 4-Oct-12 9:20am

As a comment, you should avoid using a variable name like "var" because it simply isn't descriptive of what you are getting back. If you make a habit of naming your variables in a very generic way your code will quickly become unreadable. In development, clarity is of the utmost importance. Cheers.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Venkatesh Mookkan · Answer 1 · 2012-10-03T20:19:00

Solution 1

To fetch the value of 12th column, you should use 11 as the index always starts from 0.

The only possible reason that the application is crashing could be, you are accessing column which does not exists.

Posted 3-Oct-12 20:19pm

Venkatesh Mookkan

Updated 4-Oct-12 2:55am

v2

Comments

Joan M 4-Oct-12 3:06am

What I find amusing is that the compiler has not imploded after reading that...
Can it be used for anything?

Kenneth Haugland 4-Oct-12 9:39am

This might be my fault, I tageed the code C#, it should have been VB. Var is not a designated method or expression in VB, but it is in C#...

Venkatesh Mookkan 4-Oct-12 8:53am

Hey Joan. I checked in VB.NET, its allowing var as variable name. Its seems like the index issue.

Think On · Answer 2 · 2012-10-04T03:01:00

Solution 2

Put the Proper Try Catch block to see the actual error.
put the section of code into the Try catch for catching the exception and preventing application to close directly.

The column/row index is always start from the 0 in the DataSet table

Posted 4-Oct-12 3:01am

Think On

Updated 4-Oct-12 3:02am

v2

Sunil Kumar Pandab · Answer 3 · 2012-10-04T03:18:00

Solution 3

Hi,
Try this one for retrieving 12th column value

Dim d = ds.Tables(0).Rows(0).Item(11)

(or)

Dim d As String = ds.Tables(0).Rows(0)(11)

Posted 4-Oct-12 3:18am

Sunil Kumar Pandab

Updated 4-Oct-12 3:27am

v3