传递dropdownlist和表参数
private void BindDropDown(DropDownList ddl,string tableName)
{
// DataSet dataSet = null;
if (Session[tableName]==null)
{
string sqlQuery = "Select * from "+ tableName;
sqlConnection1.Open();
SqlDataAdapter sqldpt = new SqlDataAdapter (sqlQuery,sqlConnection1);
sqldpt.Fill (dataSet1,tableName);
Session[tableName]=dataSet1;
}
else
{
dataSet1 = (DataSet)Session[tableName];
}
ddl.DataSource = dataSet1.Tables [tableName].DefaultView ;
ddl.DataValueField =dataSet1.Tables[tableName].Columns[0].Caption ;
ddl.DataTextField =dataSet1.Tables [tableName].Columns[1].Caption ;
ddl.DataBind();
sqlConnection1.Close ();
}
2004年5月12日
