DataTable dt = new DataTable();
dt.Columns.Add("col1");
dt.Columns.Add("col2");
foreach( ******){
DataRow dtRow = dtTable.NewRow();
dtRow["col1"] = datalist.***;
dtRow["col2"] = datalist.***;
dtTable.Rows.Add(dtRow);
}
dt.Columns.Add("col1");
dt.Columns.Add("col2");
foreach( ******){
DataRow dtRow = dtTable.NewRow();
dtRow["col1"] = datalist.***;
dtRow["col2"] = datalist.***;
dtTable.Rows.Add(dtRow);
}
using (SqlConnection conn = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString))
{
SqlCommand cmd = new SqlCommand("select ProductID, ProductName, UnitPrice from Products", conn);
DataTable dt = new DataTable();
conn.Open();
dt.Load(cmd.ExecuteReader(CommandBehavior.CloseConnection));
DataList1.DataSource = dt;
DataList1.DataBind();
}
这种方式绑定的,那么可以
DataTable dt = (DataTable)DataList1.DataSource;但如果是通过SqlDataSource控件绑定的时候,怎么取得那个数据集?
使用这种方法对另一个Datalist做数据源,又如何绑定数据呢?