dropdownlist.txt

C语言操作ADO数据库 这些操作是对一个微软Access 2000数据库进行的,但是SQL或是其它 ADO数据源可以通过简单的改变连接字符串来使用.

string strConn,strCmd;
			strConn="DATABASE=Northwind;SERVER=localhost;UID=sa;PWD=;";
			strCmd="SELECT employeeid,firstName,lastName FROM Employees";
			SqlDataAdapter oCMD=new SqlDataAdapter(strCmd,strConn);
			DataSet oDS=new DataSet();
			oCMD.Fill(oDS,"EmployeesList");
			DataTable dt=oDS.Tables["EmployeesList"];
			dt.Columns.Add("EmployeeName",typeof(string),"lastName+','+firstname");
			EmpList.DataSource=oDS.Tables["EmployeesList"].DefaultView;
			EmpList.DataTextField="EmployeeName";
			EmpList.DataValueField="employeeid";
			EmpList.DataBind();
//SQL Server开销大，应避免使用
strCmd="SELECT lastname+','+firstName AS 'EmployeeName' FROM Employees";