initcomcobox.cs

网上购物中介

using System;
using System.Data;
using System.Data.OleDb;

namespace _3DLib
{
	/// <summary>
	/// InitComcoBox 的摘要说明。
	/// </summary>
	public class InitComcoBox
	{
		public InitComcoBox()
		{
		}
		public static object[] getItem(string table)
		{
			object[] temparr=new object[100];
			object[] ass;
			OleDbConnection con=DataBaseCon.GetCon();
			System.Data.OleDb.OleDbCommand cmd=new System.Data.OleDb.OleDbCommand();
			cmd.Connection=con;
			con.Open();
            string query="select * from "+table;
			cmd.CommandText=query;
			OleDbDataReader odr;
			odr=cmd.ExecuteReader();
			int cnt=0;
			int line=0;
			while(odr.Read())
			{
				line++;
				string temp=odr.GetString(1);
                temparr[cnt]=temp;
				cnt++;
			}
			ass=new object[line];
			for(int i=0;i<line;i++)
			{
                ass[i]=temparr[i];
			}
			return ass;
		}
	}
}