how to retrive data from dataset

[biswa47]

hello frndz. i am using a dataset. and i want to retrivw value from that. for that i am using Textbox1.Text = dsAppData.Tables[0].Columns[0].ToString(); Textbox2..Text = dsAppData.Tables[0].Columns[1].ToString(); where "dsAppData" is the name of my dataset ... well through this i am getting the value. but here the problem is. if there are 20values neeed to be retrived from dataset. the each time when i retrive the value i must use dataset. so here i think it reduces the perfermance of the application as it hits the database each time i populate the data from it. so is ther any other way to retrive data from dataset only using once means for the first time when we use the dataset we will keep all the requiered value from it. plz i need ur suggestion

[Abhijit Jana]

DataSet is logical database. you can use it in connection less envirment. so it does not have any direct connection with database. if you go through the details of ADO.NET , you will see there is connection oriented and connection less mode. and Dataset comes under the connection less mode. So i think there should not be any performance issue if you use this . Using DataSets in ADO.NET [^]

Best Regards ----------------- Abhijit Jana View My CodeProject Articles "Success is Journey it's not a destination"