如何将数据库绑定到数据列表 [英] how to bind database to datalist

问题描述

我正在使用此代码将数据库列绑定到数据列表，而没有像
这样的数据源

hi i am using this code to bind database columns to datalist without datasource like

SqlConnection con= new SqlConnection(connection);
            con.Open();
            SqlCommand cmd = con.CreateCommand();
          cmd.CommandText="select SId,DId,SCUName,DCUName,Quantity,OrderStatus,Email from Exchange where ExchangeId=@ExchangeId";
            cmd.Parameters.AddWithValue("@ExchangeId",TextBox1.Text);
            SqlDataReader dr = cmd.ExecuteReader();
            if (dr.HasRows)
            {
                DataList1.DataSource = dr;
                  DataList1.DataBind();
            }
            dr.Read();
            if (dr != null) dr.Close();

            con.Close();

但正在读取但未显示

but it is reading but it is not displaying

推荐答案

使用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();

这篇关于如何将数据库绑定到数据列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！