Hi all,
having a DataReader populater with an Excel file, how can add a column with
a fixed value to it?

For example, having DbDataReader dr = cmd.ExecuteReader()

I need to add another column to it.

Thanks a lot.

Luigi

=?Utf-8?B?THVpZ2k=?= <(E-Mail Removed)> wrote in
news:925F1F79-1BF4-41F4-9463-(E-Mail Removed):

> Hi all,
> having a DataReader populater with an Excel file, how can add a column
> with a fixed value to it?
>
> For example, having DbDataReader dr = cmd.ExecuteReader()
>
> I need to add another column to it.

How do you add food coloring to water coming out of a firehose?

Answer: You don't.

A DataReader is a firehose cursor, so much like trying to add food
coloring to water during a fire, you can't add to it.

In short: You cannot add a column to the cursor. You can, however, add
information as you pull records from the cursor.

With a DataSet, you have more options, as you can add a column.

Do you want to know how to add data as you pull from the DataReader?

Peace and Grace,


--
Gregory A. Beamer (MVP)

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************

//How do you add food coloring to water coming out of a firehose?//

Good illustration! , I'll add that one to "the bag o' tricks" (for
explaining it to someone).

.......


"Gregory A. Beamer" <(E-Mail Removed)> wrote in message
news:Xns9CD691F852098gbworld@207.46.248.16...
> =?Utf-8?B?THVpZ2k=?= <(E-Mail Removed)> wrote in
> news:925F1F79-1BF4-41F4-9463-(E-Mail Removed):
>
>> Hi all,
>> having a DataReader populater with an Excel file, how can add a column
>> with a fixed value to it?
>>
>> For example, having DbDataReader dr = cmd.ExecuteReader()
>>
>> I need to add another column to it.
>
> How do you add food coloring to water coming out of a firehose?
>
> Answer: You don't.
>
> A DataReader is a firehose cursor, so much like trying to add food
> coloring to water during a fire, you can't add to it.
>
> In short: You cannot add a column to the cursor. You can, however, add
> information as you pull records from the cursor.
>
> With a DataSet, you have more options, as you can add a column.
>
> Do you want to know how to add data as you pull from the DataReader?
>
> Peace and Grace,
>
>
> --
> Gregory A. Beamer (MVP)
>
> Twitter: @gbworld
> Blog: http://gregorybeamer.spaces.live.com
>
> *******************************************
> | Think outside the box! |
> *******************************************

"sloan" <(E-Mail Removed)> wrote in news:OOH8bzNeKHA.4112
@TK2MSFTNGP06.phx.gbl:

> //How do you add food coloring to water coming out of a firehose?//
>
> Good illustration! , I'll add that one to "the bag o' tricks" (for
> explaining it to someone).

Analogies help us picture things. here is another one you might like.

Years ago, I had someone telling me "FrontPage sucks" because I
suggested he was coding and needed a tool like InterDev. My answer is
"hammers suck when you want to screw in a screw".

Peace and Grace,

--
Gregory A. Beamer (MVP)

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************

Now if we can only teach builders that.


"Gregory A. Beamer" <(E-Mail Removed)> wrote in message
news:Xns9CDC71CF1B68Bgbworld@207.46.248.16...
> "sloan" <(E-Mail Removed)> wrote in news:OOH8bzNeKHA.4112
> @TK2MSFTNGP06.phx.gbl:
>
>> //How do you add food coloring to water coming out of a firehose?//
>>
>> Good illustration! , I'll add that one to "the bag o' tricks" (for
>> explaining it to someone).
>
> Analogies help us picture things. here is another one you might like.
>
> Years ago, I had someone telling me "FrontPage sucks" because I
> suggested he was coding and needed a tool like InterDev. My answer is
> "hammers suck when you want to screw in a screw".
>
> Peace and Grace,
>
> --
> Gregory A. Beamer (MVP)
>
> Twitter: @gbworld
> Blog: http://gregorybeamer.spaces.live.com
>
> *******************************************
> | Think outside the box! |
> *******************************************

"Paul" <(E-Mail Removed)> wrote in news:OfTwjFleKHA.4952
@TK2MSFTNGP06.phx.gbl:

> Now if we can only teach builders that.

The educational aspect of change takes years, unless there is an
overwhelming din from the masses. :-0

Peace and Grace,

--
Gregory A. Beamer (MVP)

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************