how we can create dataset of existing table in sqlserver2000 using c# n asp.net

Question

hello; how we can create dataset of existing table in sqlserver2000 using c# n asp.net. because my application is based on crystal reporting. regards sumaira

Sam Hobbs · Answer

Did Krishna answer your question? If so then you can mark it as the answer. If not then please calrify your question.

Krishna Garad · Answer

you can create dataset of existing table by using select command like bellow. Private DataSet CreateDS() { //connection object SqlConnection cn=new SqlConnection(U r ConnectionString); //command object SqlCommand cmd=new SqlCommand(Select * from TableNamecn); //create dataset DataSet ds=new DataSet(); //call adapter SqlDataAdapter da=new SqlDataAdapter(cmd); //fill the dataset da.Fill(ds); return ds; } I hope this will help you.