logindb.cs

个人作品

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

namespace webjiuye
{
	/// <summary>
	/// loginDB 的摘要说明。
	/// </summary>
	public class loginDB
	{
		public loginDB()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public DataSet GetUser(string userid)
		{
		
			
			string str=System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"];
			SqlConnection myConnection=new SqlConnection(str);
			
			SqlDataAdapter myData = new SqlDataAdapter("userpwd_sel",myConnection);
			myData.SelectCommand.CommandType = CommandType.StoredProcedure;
			SqlParameter para = new SqlParameter("@id",SqlDbType.Char,20);
			para.Value = userid;
			myData.SelectCommand.Parameters.Add(para);
			DataSet myDataSet = new DataSet();
			myData.Fill(myDataSet,"users");
			return myDataSet;
		}

	}
}