绑定到DropDownList，设定Text和value显示

最新推荐文章于 2019-04-23 01:28:28 发布

diqian2453

最新推荐文章于 2019-04-23 01:28:28 发布

阅读量310

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/Robert-huge/archive/2012/12/01/2797603.html

版权

public static void BindDropDownList2(string SqlString, DropDownList MyDDL, string TextStr, string ValueStr)
{
SqlDataReader MyReader = GetDataReader(SqlString);

            MyDDL.Items.Clear();
            while (MyReader.Read())
            {
                ListItem MyItem = new ListItem();
                MyItem.Text = MyReader[TextStr].ToString();
                MyItem.Value = MyReader[ValueStr].ToString();
                MyDDL.Items.Add(MyItem);
            }
            MyReader.Close();
        }

public static SqlDataReader GetDataReader(string SqlString)
        {
            try
            {
                Open();
                SqlCommand cmd = new SqlCommand(SqlString, Connection);
                return cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
            }
            catch (System.Data.SqlClient.SqlException ex)
            {
                throw new Exception(ex.Message);
            }
        }

//定义数据库的打开和关闭方法
        protected static void Open()
        {
            if (Connection == null)
            {
                Connection = new SqlConnection(ConnectionString);
            }
            if (Connection.State.Equals(ConnectionState.Closed))
            {
                Connection.Open();
            }
        }

转载于:https://www.cnblogs.com/Robert-huge/archive/2012/12/01/2797603.html