convert datatable to dataset?

Question

this is my code DataTable dtdatas = results.CopyToDataTable(); ds.Tables.Add(dtdatas) return ds; //but error is come. my function using retrive. plz me hlp

Amit Gupta · Answer

DataSet is nothing but a collection of datatable. If you don't have to work more than 1 table then make the return type of the function as DataTable. In your case you can try new DataSet().Add(dtdatas);

Mageshwaran R · Answer

Hi, Please refer the below link, it might helps you http://getcodesnippet.com/2013/06/20/how-to-add-datatable-to-dataset-in-c/

Ranjit Powar · Answer

What is the return type of function?

Amit Kumar · Answer

Hi, Use the below code it is working properly. public DataSet getDataSet() { //Create a new Dataset for return DataSet ds = new DataSet(); DataTable dtresults = new DataTable(); dtresults .Columns.Add( "Id" ); dtresults .Columns.Add( "Name" ); dtresults .Columns.Add( "Email" ); //Insert record in this table dtresults.Rows.Add( "1" , "John" , "John@gmail.com" ); dtresults.Rows.Add( "1" , "Devid" , "devid@gmail.com" ); //Creating another DataTable to copy DataTable dtdatas = dtresults.Copy(); ds.Tables.Add(dtdatas). return ds; }

Gajendra Jangid · Answer

DataTable employees = new DataTable(); DataTable payCheckes = new DataTable(); DataSet ds = new DataSet(); ds.Tables.Add(employees); ds.Tables.Add(payCheckes);

Reylin Mathew · Answer

Rajanikant Hawaldar Cannot implicitly convert type 'System.Data.DataSet' to 'Data.Patterns.Retrievable'

Rajanikant Hawaldar · Answer

Hi, What error it is?

convert datatable to dataset?

Answers (7)