public void FillDDL(bool addAll,string allTitle, string strSql, string ddlValue,string ddlText,System.Web.UI.WebControls.DropDownList ddl)
{
using (SqlDataAdapter iAdapter = new SqlDataAdapter(strSql, ConnManager.NewSqlConnection () ))
{
using (DataSet ds =new DataSet())
{
DataRow dr;
if (addAll)
{
DataTable dt =new DataTable("ddl");
dt.Columns.Add(new DataColumn(ddlValue));
dt.Columns.Add(new DataColumn(ddlText));
ds.Tables.Add(dt);
dr=ds.Tables["ddl"].NewRow();
dr[0]="";
dr[1]=allTitle;
ds.Tables["ddl"].Rows.Add(dr);
}
try
{
iAdapter.Fill(ds,"ddl");
ddl.DataTextField=ddlText;
ddl.DataValueField=ddlValue;
ddl.DataSource = ds.Tables["ddl"];
ddl.DataBind(); }
catch {}
}
}
}
{
using (SqlDataAdapter iAdapter = new SqlDataAdapter(strSql, ConnManager.NewSqlConnection () ))
{
using (DataSet ds =new DataSet())
{
DataRow dr;
if (addAll)
{
DataTable dt =new DataTable("ddl");
dt.Columns.Add(new DataColumn(ddlValue));
dt.Columns.Add(new DataColumn(ddlText));
ds.Tables.Add(dt);
dr=ds.Tables["ddl"].NewRow();
dr[0]="";
dr[1]=allTitle;
ds.Tables["ddl"].Rows.Add(dr);
}
try
{
iAdapter.Fill(ds,"ddl");
ddl.DataTextField=ddlText;
ddl.DataValueField=ddlValue;
ddl.DataSource = ds.Tables["ddl"];
ddl.DataBind(); }
catch {}
}
}
}
解决方案 »
- 急求C#解答。。
- 紧急求助!关于windows窗体的问题
- 给出解决方案,不仅给分,还可以给Money!!
- 大家快救救我啊,要不我就崩溃了!!!!!!!这问题困扰了我两天了!!!!!
- 我希望datagridview表头如问题所示
- datagrid的模板字段的问题。
- winform datagrid问题,关于弹出新窗口问题。
- System.Threading.Timer的计时器,怎么只执行一次呢??
- socket异步和多线程(在线等)
- 微软的开发工具太烂了!!!!!!!!!!
- CrystalReport的问题:生成CrystalReport预览的时候出现“Invalid Report Source”应该怎样解决呢?
- WinForm中可以让textBox中显示多种颜色的文字吗?
{
DataTable dt = new DataTable();
dt = ProductMngObj.GetShippingClassList(); DataRow tempRow = dt.NewRow();
tempRow["ShippingClass"] = "(Please Select One)";
tempRow["ShippingClassID"] = "0";
dt.Rows.InsertAt(tempRow,0); ShippingClassList.DataSource = dt;
ShippingClassList.DataTextField = "ShippingClass";
ShippingClassList.DataValueField = "ShippingClassID";
ShippingClassList.DataBind();
//bind the hide ClassList
ClassList.DataSource = dt;
ClassList.DataTextField = "ShippingClass";
ClassList.DataValueField = "ShippingClassID";
ClassList.DataBind();
}
OracleDataAdapter da = new OracleDataAdapter(sql,con);
DataSet ds=new DataSet();
da.Fill(ds,"表名");
DropDownList .DataTextField="字段名";
DropDownList .DataValueField = "字段名";
DropDownList .DataSource=ds.Tables["表名"].DefaultView;
DropDownList .DataBind();
DropDownList .Items.Insert(0,""); ///////////第一个选项为空;
DropDownList .Items.Insert(0,"");