conver.cs

个人作品

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

namespace webjiuye
{
	/// <summary>
	/// conver 的摘要说明。
	/// </summary>
	public class conver
	{
			static string str=System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"];
		SqlConnection con=new SqlConnection(str);
		public conver()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public DataSet dm_mc(string tbname, string dm)
		{
			SqlDataAdapter mydata=new SqlDataAdapter("dm_to_mc", con);
			mydata.SelectCommand.CommandType=CommandType.StoredProcedure;
			SqlParameter para1=new SqlParameter("@table",SqlDbType.NVarChar,15);
			SqlParameter para2=new SqlParameter("@dm",SqlDbType.NVarChar,15);
			para1.Value=tbname;
			para2.Value=dm;
			mydata.SelectCommand.Parameters.Add(para1);
			mydata.SelectCommand.Parameters.Add(para2);
			DataSet ds=new DataSet();
			mydata.Fill(ds,"students");
			return ds;
		}
		public DataSet mc_dm(string tbname, string mc)
		{
			SqlDataAdapter mydata=new SqlDataAdapter("mc_to_dm", con);
			mydata.SelectCommand.CommandType=CommandType.StoredProcedure;
			SqlParameter para1=new SqlParameter("@table",SqlDbType.NVarChar,15);
			SqlParameter para2=new SqlParameter("@mc",SqlDbType.NVarChar,15);
			para1.Value=tbname.Trim();
			para2.Value=mc.Trim();
			mydata.SelectCommand.Parameters.Add(para1);
			mydata.SelectCommand.Parameters.Add(para2);
			DataSet ds=new DataSet();
			mydata.Fill(ds,"students");
			return ds;
		}

	}
}