listdb.cs

个人作品

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

namespace webjiuye
{
	/// <summary>
	/// listDB 的摘要说明。
	/// </summary>
	public class listDB
	{
		static string str=System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"];
		SqlConnection conn=new SqlConnection(str);

		public listDB()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public DataSet listall(string tbname)
		{
			SqlDataAdapter mydata=new SqlDataAdapter("list_all",conn);
			mydata.SelectCommand.CommandType=CommandType.StoredProcedure;
			SqlParameter para=new SqlParameter("@table",SqlDbType.NVarChar,15);
			para.Value=tbname;
			mydata.SelectCommand.Parameters.Add(para);
			DataSet ds=new DataSet();
			mydata.Fill(ds);
			return ds;
		}
		public DataSet Selectxy(string dm)
		{
			SqlDataAdapter mydata=new SqlDataAdapter("select_xymc",conn);
			mydata.SelectCommand.CommandType=CommandType.StoredProcedure;
			SqlParameter para=new SqlParameter("@dm",SqlDbType.NVarChar,15);
			para.Value=dm;
			mydata.SelectCommand.Parameters.Add(para);
			DataSet ds=new DataSet();
			mydata.Fill(ds);
			return ds;
		}
		public DataSet listxy()
		{
			SqlDataAdapter mydata=new SqlDataAdapter("list_xy",conn);
			mydata.SelectCommand.CommandType=CommandType.StoredProcedure;
			
			DataSet ds=new DataSet();
			mydata.Fill(ds);
			return ds;
		}
		public DataSet listzy(string xymc)
		{
			SqlDataAdapter mydata=new SqlDataAdapter("list_zy",conn);
			mydata.SelectCommand.CommandType=CommandType.StoredProcedure;
			SqlParameter para=new SqlParameter("@xy",SqlDbType.NVarChar,50);
			para.Value=xymc;
			mydata.SelectCommand.Parameters.Add(para);
			DataSet ds=new DataSet();
			mydata.Fill(ds);
			return ds;
		}
	}
}