Solved

SqlDataReader Class constructor

Posted on 2013-02-04
4
251 Views
Last Modified: 2013-02-04
What is happening in the 3rd line of code here:
MyReader = command3.ExecuteReader(CommandBehavior.CloseConnection)
If MyReader.Read Then
     FromAddress = MyReader("Email")

Open in new window

It looks like it is calling a constructor of MyReader but I see nothing in the documentation like that.
0
Comment
Question by:allelopath
  • 2
4 Comments
 
LVL 18

Accepted Solution

by:
John (Yiannis) Toutountzoglou earned 100 total points
ID: 38852125
It looks like a variable to me...
it gives me the same results as  FromAddress = MyReader.Item("Email")
0
 
LVL 1

Author Comment

by:allelopath
ID: 38852133
You're right, that's seems to be how it works, but I don't see anything in the documentation saying that MyReader("x") is the same as MyReader.Item("x").
0
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 38852148
If you try i(I've tried it) to write the command and open a "(" you will see the syntax...


John (Yiannis)
0
 
LVL 75

Assisted Solution

by:käµfm³d 👽
käµfm³d   👽 earned 400 total points
ID: 38852170
It's not the constructor. In VB.NET there is the concept of a default property. Such a property allows you to treat the object as it were akin to an array, and you can, in effect, index the object to return some value. In this case, the default property of the SqlDataReader class is the Item property, which gives you access to the columns the SqlDataReader got from the database. In your example, you are simply assigning the value of the "Email" column to the FromAddress variable.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
update textboxes with Streamreader 21 47
Gridview selected row 9 46
Expression Evaluater 3 25
Sql server, import complete table, using vb.net 9 34
Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question