在dropdownlist绑定时,使用SqlConnection conn = UtilitySqlClass.OperateDataBase.ReturnConn();
string strSQL = "select * from tb_score";
SqlDataAdapter ada = new SqlDataAdapter(strSQL, conn);
DataSet ds = new DataSet();
ada.Fill(ds, "tb_score");
ddlcx.DataSource = ds.Tables["tb_score"].DefaultView;
ddlcx.DataValueField = ds.Tables["tb_score"].Columns[i].ColumnName;
ddlcx.DataTextField = ds.Tables["tb_score"].Columns[i].ColumnName;
ddlcx.DataBind();
ds.Dispose();但是总是提示上下文不存在UtilitySqlClass;
网上值给出了这句话:
UtilitySqlClass.OperateDataBase.ReturnConn();返回的是一个打开的conn对象。数据库操作类在命名空间UtilitySqlClass中定义那位高手帮忙一下数据库操作类命名空间UtilitySqlClass怎么样才能引用?
string strSQL = "select * from tb_score";
SqlDataAdapter ada = new SqlDataAdapter(strSQL, conn);
DataSet ds = new DataSet();
ada.Fill(ds, "tb_score");
ddlcx.DataSource = ds.Tables["tb_score"].DefaultView;
ddlcx.DataValueField = ds.Tables["tb_score"].Columns[i].ColumnName;
ddlcx.DataTextField = ds.Tables["tb_score"].Columns[i].ColumnName;
ddlcx.DataBind();
ds.Dispose();但是总是提示上下文不存在UtilitySqlClass;
网上值给出了这句话:
UtilitySqlClass.OperateDataBase.ReturnConn();返回的是一个打开的conn对象。数据库操作类在命名空间UtilitySqlClass中定义那位高手帮忙一下数据库操作类命名空间UtilitySqlClass怎么样才能引用?
解决方案 »
- msnd library2010怎么用啊?查MVC方面的类怎么查不到啊?
- asp中20110109如何轉換為日期型
- 为什么.net发送邮件都不用填写用户密码的
- 关于web.sitemap的问题
- 大家看看,验证码系统,ASP.NET (VB),为什么在有的机子上可以看到,有的机子上看不到图片哦,立刻给分!!!我的信用,大家看着办
- 用XmlTextWriter如何添加、修改xml节点,并使文本内容加上<![CDATA[ 文本内容 ]]>
- getRef引用一个带参数得动态函数?
- 请问如何读取.net生成的dll文件的内容,并修改,有没有软件?
- 用ASP。NET如何实现文件夹上传
- 如何将数据库"序列值"显示出来:
- 在页面点Button按钮,页面进行重新加载进入,如何确定页面中Button按钮已被执行?
- ASP.NET 操作
利用DropDownList.Items.Add方法。protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){SqlConnection conn = UtilitySqlClass.OperateDataBase.ReturnConn();try{conn.Open();this.DropDownList1.Items.Add("");string strSQL = "select CompanyType from CompanyType";SqlCommand com = new SqlCommand(strSQL, conn);SqlDataReader dr = com.ExecuteReader();while (dr.Read()){this.DropDownList1.Items.Add(dr["CompanyType"].ToString());}}catch (Exception ex){Response.Write("alert(’" + ex.Message.ToString() + "’)");}finally{conn.Close();}}}
应该下面的方法或者是把SqlConnection conn = UtilitySqlClass.OperateDataBase.ReturnConn();
改成SqlConnection con=new SqlConnection("server=.;uid=sa;pwd=sa;database=数据库名称");
第一种方法:
string ConnString = ConfigurationSettings.AppSettings["ConnectionString"];
//创建一个SqlConnection
SqlConnection Conn = new SqlConnection( ConnString ); string SQL_Select = "select id, ItemName from DDLItem order by id desc"; //构造一个SqlDataAdapter SqlDataAdapter myAdapter = new SqlDataAdapter( SQL_Select, Conn); //开始读取数据 Conn.Open(); DataSet dataSet = new DataSet(); myAdapter.Fill( dataSet,"Table1" ); Conn.Close(); //开始绑定DropDownList //指定DropDownList使用的数据源 DropDownList1.DataSource = dataSet.Tables["Table1"].DefaultView; //指定DropDownList使用的表里的那些字段 DropDownList1.DataTextField = "ItemName"; //dropdownlist的Text的字段 DropDownList1.DataValueField = "id";//dropdownlist的Value的字段 DropDownList1.DataBind();
第二种方法:
con.Open();
SqlCommand cmd = new SqlCommand(strSql,con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DropDownList1.Items.Add(new ListItem(dr["status"].ToString(), dr["status_Id"].ToString()));
}
http://blog.csdn.net/archer_klx/article/details/975742
http://topic.csdn.net/t/20020402/19/617836.html
string ConnString = ConfigurationSettings.AppSettings["ConnectionString"];
//创建一个SqlConnection
SqlConnection Conn = new SqlConnection( ConnString ); string SQL_Select = "select id, ItemName from DDLItem order by id desc"; //构造一个SqlDataAdapter SqlDataAdapter myAdapter = new SqlDataAdapter( SQL_Select, Conn); //开始读取数据 Conn.Open(); DataSet dataSet = new DataSet(); myAdapter.Fill( dataSet,"Table1" ); Conn.Close(); //开始绑定DropDownList //指定DropDownList使用的数据源 DropDownList1.DataSource = dataSet.Tables["Table1"].DefaultView; //指定DropDownList使用的表里的那些字段 DropDownList1.DataTextField = "ItemName"; //dropdownlist的Text的字段 DropDownList1.DataValueField = "id";//dropdownlist的Value的字段 DropDownList1.DataBind();
第二种方法:
con.Open();
SqlCommand cmd = new SqlCommand(strSql,con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DropDownList1.Items.Add(new ListItem(dr["status"].ToString(), dr["status_Id"].ToString()));
}
string ConnString = ConfigurationSettings.AppSettings["ConnectionString"];
//创建一个SqlConnection
SqlConnection Conn = new SqlConnection( ConnString ); string SQL_Select = "select id, ItemName from DDLItem order by id desc"; //构造一个SqlDataAdapter SqlDataAdapter myAdapter = new SqlDataAdapter( SQL_Select, Conn); //开始读取数据 Conn.Open(); DataSet dataSet = new DataSet(); myAdapter.Fill( dataSet,"Table1" ); Conn.Close(); //开始绑定DropDownList //指定DropDownList使用的数据源 DropDownList1.DataSource = dataSet.Tables["Table1"].DefaultView; //指定DropDownList使用的表里的那些字段 DropDownList1.DataTextField = "ItemName"; //dropdownlist的Text的字段 DropDownList1.DataValueField = "id";//dropdownlist的Value的字段 DropDownList1.DataBind();
第二种方法:
con.Open();
SqlCommand cmd = new SqlCommand(strSql,con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DropDownList1.Items.Add(new ListItem(dr["status"].ToString(), dr["status_Id"].ToString()));
}
SqlCommand cmd = new SqlCommand(strSql,con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DropDownList1.Items.Add(new ListItem(dr["status"].ToString(), dr["status_Id"].ToString()));
}