更新时间:2023-11-28 20:40:46
DataTable dt = ConnectionClass.ReturnTable("select * from tbl_Product ORDER BY ProductID");//obj.ReturnTable("select * from tbl_Sparte");
DataRow dr = dt.NewRow();
dr["Product"] = "..SELECT..";
dr["ProductID"] = "0";
dt.Rows.InsertAt(dr, 0);
ddlProduct.DataSource = dt;
ddlProduct.DataTextField = "Product";
ddlProduct.DataValueField = "ProductID";
ddlProducte.DataBind();
使用你的连接类返回DataTable
Just use your connection class to return DataTable
参考
如何对绑定数据从 - 一个数据库到一个-列表框 [ ^ ]