Dynamic Dataset

Question

Hi Please help me to genarate dynamic dataset. Example i have asp.net page which contains one selection list if i select one item from the list according to that data need to be retrived from the data set. thanks in advance regards Rajesh.A

Santhosh Veeraraman · Answer

Two ways. Either hit the database in the selected_change event of your list control. (whatever control you are using) or hold all the data (if the data is not huge) in a dataset upfront and filter it based on your requirement. DataSet ds = new DataSet (); DataTable dt = ds.Tables[0]; DataRow [] rows = dt.Select( name like '%Santhosh%' order by id ); - This will save data traffic and increase performance.