Loading

Dynamic Dataset

rajesharra

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Santhosh Veeraraman18y ago
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.