•19:38
public void BindList(DropDownList dl,string datestr,string textfield,string valuefield,string dtfield)
{
//打开数据库联接
objConn.Open();
try
{
myCommand = new OleDbDataAdapter(datestr,objConn); //myCommand 为基类中定义的
myCommand.Fill(ds,dtfield);
dl.DataSource = ds.Tables[dtfield].DefaultView;
dl.DataTextField = textfield;
dl.DataValueField = valuefield;
dl.DataBind();
}
catch
{
//报告错误
HttpContext.Current.Response.Write("<script>alert('绑定下拉菜单无法通过!')script>");
}
//关闭数据库连接
objConn.Close();
}
{
//打开数据库联接
objConn.Open();
try
{
myCommand = new OleDbDataAdapter(datestr,objConn); //myCommand 为基类中定义的
myCommand.Fill(ds,dtfield);
dl.DataSource = ds.Tables[dtfield].DefaultView;
dl.DataTextField = textfield;
dl.DataValueField = valuefield;
dl.DataBind();
}
catch
{
//报告错误
HttpContext.Current.Response.Write("<script>alert('绑定下拉菜单无法通过!')script>");
}
//关闭数据库连接
objConn.Close();
}
.Net
|

1 评论:
呵呵,可以作为临时查询用