Loading

convert datatable to dataset?

convert datatable to dataset?

Reylin Mathew

Reylin Mathew

7y3.7k.NET

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

7 Replies

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

Mageshwaran R6y ago
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 Powar7y ago
What is the return type of function?
Amit Kumar7y ago
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", "[email protected]");
dtresults.Rows.Add("1", "Devid", "[email protected]");

//Creating another DataTable to copy
DataTable dtdatas = dtresults.Copy();
ds.Tables.Add(dtdatas).

return ds;
    }
Amit Gupta7y ago
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);
Gajendra Jangid7y ago
1. DataTable employees = new DataTable();
2. DataTable payCheckes = new DataTable();
3. DataSet ds = new DataSet();
4. ds.Tables.Add(employees);
5. ds.Tables.Add(payCheckes);

Reylin Mathew

Reylin Mathew7y ago

Rajanikant Hawaldar

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

Rajanikant Hawaldar

Rajanikant Hawaldar7y ago

Hi, What error it is?