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

Apple iPhone sending SMS automatically 00447786205094

GREYCstoration Oil Paint plugin for Photoshop

Security Token Service is not available (I fixed it)

SharePoint online hub navigation not updating for other users

Service Bus Gateway service stuck at Starting