Thursday, July 14, 2011

Convert DataReader to DataSet in C#

Following sample explains how to Convert DataReader to DataSet
DataSet objDataSet = new DataSet();
SqlCommand objCommand = new SqlCommand("Your Stored Proc listed here");

objCommand.Connection = new SqlConnection("Your conection string here");
SqlDataAdapter objDataAdapter = new SqlDataAdapter(objCommand);

objCommand.Connection.Open();

objDataAdapter.Fill(objDataSet);

No comments:

Post a Comment

If you’re using Visual Studio to build your .NET MAUI app on a Mac, locating the IPA (iOS App Package) file can be a bit tricky

  If you’re using   Visual Studio   to build your   .NET MAUI   app on a   Mac , locating the   IPA (iOS App Package)   file can be a bit tr...