bind_drpdownlist.cs

一个很好的商品销售系统,能广泛应用于大学生毕业论文设计,用java开发出来的

using System;
using System.Data.SqlClient;
using System.Data;

namespace Super_Market
{
	/// <summary>
	/// bind_DrpDownList 的摘要说明。
	/// </summary>
	public class bind_DrpDownList
	{
		public bind_DrpDownList(string sql,System.Web.UI.WebControls.DropDownList DropDownList)
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
			SqlConnection Conn;
			Conn=new SqlConnection("server=localhost;database=MyTest;uid=sa;pwd=''");
			String strSQL = sql;
			SqlCommand Comm = new SqlCommand(strSQL,Conn);
			SqlDataAdapter da = new SqlDataAdapter();
			Conn.Open();
			da.SelectCommand = Comm;
			DataSet ds = new DataSet();
			da.Fill(ds,"grade");
			DropDownList.DataSource = ds.Tables["grade"].DefaultView;
			DropDownList.DataTextField="TYPE_NAME"; 
			DropDownList.DataBind();
			Conn.Close();
		}
	}
}