下拉框显示从数据库中检索的记录问题 请问各位,我在ASP。NET程序中有个下拉框,与数据库表中的一个字段绑定后能实现下拉框内容从数据库中生成,我想从数据库中检索出整条记录时,包括这个下拉框也能显示出在录入时选择的数据,请问该怎么实现啊? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 string strConn="你的连接字符串"; SqlConnection Conn = new SqlConnection(strConn); DataSet objDataSet = new DataSet(); string strSql ; strSql = "select * from province"; SqlDataAdapter objAdapter = new SqlDataAdapter(strSql,Conn); objAdapter.Fill(objDataSet,"province"); DataView objDataView = new DataView(objDataSet.Tables["province"]); DropDownList2.DataSource = objDataSet; DropDownList2.DataTextField = "province"; DropDownList2.DataValueField = "provinceid"; DropDownList2.DataBind(); Conn.Close(); public static void BindVT(string stringconnection,string BindTableName,string BindTypeTxt,string BindValue,System.Web.UI.WebControls.DropDownList BindControl ) { SqlConnection myconn=new SqlConnection(stringconnection); try { myconn.Open(); string DropDownStr1="select * from "+ BindTableName; SqlCommand mycmd=new SqlCommand(DropDownStr1,myconn); SqlDataReader myReader; myReader=mycmd.ExecuteReader(); BindControl.DataSource=myReader; BindControl.DataTextField=BindTypeTxt; BindControl.DataValueField=BindValue; BindControl.DataBind(); myReader.Close(); } catch { throw new Exception("数据帮定错误!"); } finally { if(myconn.State==ConnectionState.Open) { myconn.Close(); myconn.Dispose(); } } } 呵呵楼上的代码都可实现数据单列绑定到DropDownList的功能 /// <summary>/// 邦定DroDownList /// </summary>/// <param name="DroDList"></param>//控件名/// <param name="TableName"></param>//表名/// <param name="DataTextFd"></param>提供文本内容的数据源字段/// <param name="DataValueFd"></param>为列表项提供值的数据源字段public void DroList(DropDownList DroDList,string TableName,string DataTextFd,string DataValueFd){ string CnnString ="Provider= Microsoft.Jet.OLEDB.4.0;Data Source= "+Server.MapPath("web.mdb"); cnn= new OleDbConnection(CnnString); cnn.Open(); string sql = "select * from "+TableName+" "; OleDbDataAdapter myDa =new OleDbDataAdapter(sql,cnn); myDa.SelectCommand.CommandType = CommandType.Text; DataSet myDs =new DataSet(); try { myDa.Fill(myDs,TableName); DroDList.DataSource = myDs.Tables[TableName]; DroDList.DataTextField = DataTextFd; DroDList.DataValueField = DataValueFd; DroDList.DataBind(); } catch(Exception e) { Response.Write(e.Message); } finally { cnn.Close(); }} string cSql="SELECT * FROM [Z_Enum] WHERE Z_GroupID = " + _groupid.ToString(); DataView dvEnum; dvEnum=SqlHelper.ExecuteDataView(cSql); _objdropdownlist.Items.Clear(); foreach(DataRowView drvEnum in dvEnum) { _objdropdownlist.Items.Add(new System.Web.UI.WebControls.ListItem(drvEnum["Z_EnumTitle"].ToString(),drvEnum["Z_EnumID"].ToString())); } 用listbox代码可以从这里改改<%@ Page Language="C#" AutoEventWireup="True" %><html><head> <script language="C#" runat="server"> void Page_Load(Object sender, EventArgs e) { if (!IsPostBack) { ArrayList values = new ArrayList(); values.Add ("Item 1"); values.Add ("Item 2"); values.Add ("Item 3"); values.Add ("Item 4"); values.Add ("Item 5"); values.Add ("Item 6"); ListBox1.DataSource = values; ListBox1.DataBind(); } } void SubmitBtn_Click(Object sender, EventArgs e) { if ( ListBox1.SelectedIndex > -1 ) Label1.Text = "You chose: " + ListBox1.SelectedItem.Text; } </script></head><body> <form runat=server> <h3>Data Binding ListBox</h3> <asp:ListBox id="ListBox1" Width="100px" runat="server"/> <asp:button id="Button1" Text="Submit" OnClick="SubmitBtn_Click" runat="server" /> <asp:Label id="Label1" font-name="Verdana" font-size="10pt" runat="server"/> </form></body></html> C# 关于IOS的推送 APNS 如何将unicode转换utf8,急啊 谁有C/S结构的事例 发布后连接不到数据库 fckeditor设置问题 写这样一段程序:鼠标一点FormView或者DetailsView的Textbox框。。。。。。 SQL语句问题,各位大虾帮帮忙,谢谢 asp.net 服务器 503 Service Unavailable 请问一个.net的目录问题! 我装PWS运行APS时,文本框输入后,为何要等很长时间?而以前都不要等时间. ntfs 英文全称是什么? 请大家帮一下,救人一命呀!(用SQL SERVER 可是取出ID然后再显示,可为什么不成功呀50分)
SqlConnection Conn = new SqlConnection(strConn);
DataSet objDataSet = new DataSet();
string strSql ;
strSql = "select * from province";
SqlDataAdapter objAdapter = new SqlDataAdapter(strSql,Conn);
objAdapter.Fill(objDataSet,"province");
DataView objDataView = new DataView(objDataSet.Tables["province"]); DropDownList2.DataSource = objDataSet;
DropDownList2.DataTextField = "province";
DropDownList2.DataValueField = "provinceid";
DropDownList2.DataBind();
Conn.Close();
{
SqlConnection myconn=new SqlConnection(stringconnection);
try
{
myconn.Open();
string DropDownStr1="select * from "+ BindTableName;
SqlCommand mycmd=new SqlCommand(DropDownStr1,myconn);
SqlDataReader myReader;
myReader=mycmd.ExecuteReader();
BindControl.DataSource=myReader;
BindControl.DataTextField=BindTypeTxt;
BindControl.DataValueField=BindValue;
BindControl.DataBind();
myReader.Close();
}
catch
{
throw new Exception("数据帮定错误!");
}
finally
{
if(myconn.State==ConnectionState.Open)
{
myconn.Close();
myconn.Dispose();
}
}
}
楼上的代码都可实现数据单列绑定到DropDownList的功能
/// 邦定DroDownList
/// </summary>
/// <param name="DroDList"></param>//控件名
/// <param name="TableName"></param>//表名
/// <param name="DataTextFd"></param>提供文本内容的数据源字段
/// <param name="DataValueFd"></param>为列表项提供值的数据源字段
public void DroList(DropDownList DroDList,string TableName,string DataTextFd,string DataValueFd)
{
string CnnString ="Provider= Microsoft.Jet.OLEDB.4.0;Data Source= "+Server.MapPath("web.mdb");
cnn= new OleDbConnection(CnnString);
cnn.Open();
string sql = "select * from "+TableName+" ";
OleDbDataAdapter myDa =new OleDbDataAdapter(sql,cnn);
myDa.SelectCommand.CommandType = CommandType.Text;
DataSet myDs =new DataSet();
try
{
myDa.Fill(myDs,TableName);
DroDList.DataSource = myDs.Tables[TableName];
DroDList.DataTextField = DataTextFd;
DroDList.DataValueField = DataValueFd;
DroDList.DataBind();
}
catch(Exception e)
{
Response.Write(e.Message);
}
finally
{
cnn.Close();
}
}
DataView dvEnum;
dvEnum=SqlHelper.ExecuteDataView(cSql);
_objdropdownlist.Items.Clear();
foreach(DataRowView drvEnum in dvEnum)
{
_objdropdownlist.Items.Add(new System.Web.UI.WebControls.ListItem(drvEnum["Z_EnumTitle"].ToString(),drvEnum["Z_EnumID"].ToString()));
}
代码可以从这里改改
<%@ Page Language="C#" AutoEventWireup="True" %><html>
<head> <script language="C#" runat="server"> void Page_Load(Object sender, EventArgs e)
{ if (!IsPostBack)
{ ArrayList values = new ArrayList(); values.Add ("Item 1");
values.Add ("Item 2");
values.Add ("Item 3");
values.Add ("Item 4");
values.Add ("Item 5");
values.Add ("Item 6"); ListBox1.DataSource = values;
ListBox1.DataBind(); } } void SubmitBtn_Click(Object sender, EventArgs e)
{
if ( ListBox1.SelectedIndex > -1 )
Label1.Text = "You chose: " + ListBox1.SelectedItem.Text;
} </script></head>
<body> <form runat=server> <h3>Data Binding ListBox</h3>
<asp:ListBox id="ListBox1"
Width="100px"
runat="server"/> <asp:button id="Button1"
Text="Submit"
OnClick="SubmitBtn_Click"
runat="server" />
<asp:Label id="Label1"
font-name="Verdana"
font-size="10pt"
runat="server"/> </form></body>
</html>