使用DataSet将DataList绑定为

Use DataSet to bind DataList as

SqlConnection cnn = new SqlConnection(ConfigurationSettings.AppSettings["con"]);
            string selectSQL = "select SId,DId,SCUName,DCUName,Quantity,OrderStatus,Email from Exchange where ExchangeId=@ExchangeId)";           
            SqlCommand cmd = new SqlCommand(selectSQL, cnn);
             cmd.Parameters.AddWithValue("@ExchangeId",TextBox1.Text);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds, "Exchange");
            DataList1.DataSource = ds;
            DataList1.DataBind();