How to get data in DataSet or DataTable from DataReader using SQL Perameters

The C# Part

string connStr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
 SqlConnection mySqlConnection = new SqlConnection(connStr);
        mySqlConnection.Open();
        SqlCommand mySqlCommand = new SqlCommand("GetPersonByID", mySqlConnection);
        //Use this if you want to use a store procedure
        mySqlCommand.CommandType = CommandType.StoredProcedure;
        mySqlCommand.Parameters.AddWithValue("@id", ID);
        SqlDataReader dr = mySqlCommand.ExecuteReader();
        dt.Load(dr);
        GridView1.DataSource = dt;
        GridView1.DataBind();

Comments

Popular Posts

GREYCstoration Oil Paint plugin for Photoshop

Apple iPhone sending SMS automatically 00447786205094

SharePoint online hub navigation not updating for other users

Service Bus Gateway service stuck at Starting

RangeError: Maximum call stack size exceeded | Node JS | SPFX React