retreiving a value from a dataset

View: New views
3 Messages — Rating Filter:   Alert me  

retreiving a value from a dataset

by Don-73 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I have a specific requirement to retreive a value from a dataset that has been created.

example: keyword.Text = myDataSet.Tables[0].Rows[0].item["keyword"];

basically trying to access the column name 'keyword' and get its value.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:44:1827
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/44
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:44
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.44
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: retreiving a value from a dataset

by Kwang Suh :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Try myDataSet.Tables[0].Rows[0]["keyword"];

>I have a specific requirement to retreive a value from a dataset that has been created.
>
>example: keyword.Text = myDataSet.Tables[0].Rows[0].item["keyword"];
>
>basically trying to access the column name 'keyword' and get its value.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:44:1828
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/44
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:44
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.44
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Parent Message unknown Re: Re: retreiving a value from a dataset

by satya chhikara :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

 ?
if you are using vb.net
then syntax is

keyword.Text = myDataSet.Tables[0].Rows[0].item["keyword"];

if you are using c# then syntax is

keyword.Text = myDataSet.Tables[0].Rows[0]["keyword"].ToString();


On Fri, 09 Sep 2005 Kwang Suh wrote :
>Try myDataSet.Tables[0].Rows[0]["keyword"];
>
> >I have a specific requirement to retreive a value from a dataset that has been created.
> >
> >example: keyword.Text = myDataSet.Tables[0].Rows[0].item["keyword"];
> >
> >basically trying to access the column name 'keyword' and get its value.
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:44:1829
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/44
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:44
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.44
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54