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

How to upload app to macOS

1. Open Terminal Press Cmd (⌘) + Space , type Terminal , and hit Enter . 2. Navigate to Your Build Output Directory Your .app file is likel...