studentsdb.cs

个人作品

using System;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Text.RegularExpressions;
using System.Configuration.Assemblies;
using System.Messaging;
namespace webjiuye
{
	/// <summary>
	/// studentsDB 的摘要说明。
	/// </summary>
	public class studentsDB
	{
		static string str=System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"];
		SqlConnection myConnection = new SqlConnection(str);
		public studentsDB()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public void UpdateStudents(string Studentid ,string Studentname , string Examineid , string Xbdm ,string  Yxdm ,string Yxszddm , string Mzdm , string zzmmdm , string xldm , string pyfsdm , string zxwyyzdm ,string syszddm ,  string borndate , string matriculationdate  , string graduatedate , string lengthofschooling ,string byqxdm , string Directional ,string zydm  ,string Languagelevel , string xy)
		{
			//SqlDataAdapter myAdapter = new SqlDataAdapter("ins_stu",myConnection);
			SqlDataAdapter myAdapter=new SqlDataAdapter();　
			myAdapter.InsertCommand=new SqlCommand("ins_stu",myConnection);
			myAdapter.InsertCommand.CommandType = CommandType.StoredProcedure;
		　
           
			SqlParameter para1 = new SqlParameter("@Studentid",SqlDbType.Char,10);
			SqlParameter para2 = new SqlParameter("@Studentname",SqlDbType.NVarChar,50);
			SqlParameter para3 = new SqlParameter("@Examineid",SqlDbType.Char,13);
			SqlParameter para4 = new SqlParameter("@Xbdm",SqlDbType.NVarChar,1);
			SqlParameter para5 = new SqlParameter("@Yxdm",SqlDbType.NVarChar,5);
			SqlParameter para6 = new SqlParameter("@Yxszddm",SqlDbType.NVarChar,6);
			SqlParameter para7 = new SqlParameter("@Mzdm",SqlDbType.NVarChar,2);
			SqlParameter para8 = new SqlParameter("@zzmmdm",SqlDbType.NVarChar,2);
			SqlParameter para9 = new SqlParameter("@xldm",SqlDbType.NVarChar,2);
			SqlParameter para10 = new SqlParameter("@pyfsdm",SqlDbType.NVarChar,1);
			SqlParameter para11 = new SqlParameter("@zxwyyzdm",SqlDbType.NVarChar,2);
			SqlParameter para12 = new SqlParameter("@syszddm",SqlDbType.NVarChar,6);
			SqlParameter para13 = new SqlParameter("@borndate",SqlDbType.DateTime,8);
			SqlParameter para14 = new SqlParameter("@matriculationdate",SqlDbType.DateTime,8);
			SqlParameter para15 = new SqlParameter("@graduatedate",SqlDbType.DateTime,8);
			SqlParameter para16 = new SqlParameter("@lengthofschooling",SqlDbType.NVarChar,10);
			SqlParameter para17 = new SqlParameter("@byqxdm",SqlDbType.NVarChar,1);
			SqlParameter para18 = new SqlParameter("@Directional",SqlDbType.NVarChar,50);
			SqlParameter para19 = new SqlParameter("@zydm",SqlDbType.NVarChar,8);
			SqlParameter para20 = new SqlParameter("@Languagelevel",SqlDbType.NVarChar,50);
			//SqlParameter para21 = new SqlParameter("@dwdm",SqlDbType.NVarChar,15);
			SqlParameter para22 = new SqlParameter("@xy",SqlDbType.NVarChar,50);
			para1.Value = Studentid;
			para2.Value = Studentname;
			para3.Value = Examineid;
			para4.Value = Xbdm;
			para5.Value = Yxdm;
			para6.Value = Yxszddm;
			para7.Value = Mzdm;
			para8.Value = zzmmdm;
			para9.Value = xldm;
			para10.Value = pyfsdm;
			para11.Value = zxwyyzdm;
			para12.Value = syszddm;
			para13.Value = borndate;
			para14.Value = matriculationdate;
			para15.Value = graduatedate;
			para16.Value = lengthofschooling;
			para17.Value = byqxdm;
			para18.Value = Directional;
			para19.Value = zydm;
			para20.Value = Languagelevel;
			//	para21.Value = dwdm;
			para22.Value = xy;
			myAdapter.InsertCommand.Parameters.Add(para1);
			myAdapter.InsertCommand.Parameters.Add(para2);
			myAdapter.InsertCommand.Parameters.Add(para3);
			myAdapter.InsertCommand.Parameters.Add(para4);
			myAdapter.InsertCommand.Parameters.Add(para5);
			myAdapter.InsertCommand.Parameters.Add(para6);
			myAdapter.InsertCommand.Parameters.Add(para7);
			myAdapter.InsertCommand.Parameters.Add(para8);
			myAdapter.InsertCommand.Parameters.Add(para9);
			myAdapter.InsertCommand.Parameters.Add(para10);
			myAdapter.InsertCommand.Parameters.Add(para11);
			myAdapter.InsertCommand.Parameters.Add(para12);
			myAdapter.InsertCommand.Parameters.Add(para13);
			myAdapter.InsertCommand.Parameters.Add(para14);
			myAdapter.InsertCommand.Parameters.Add(para15);
			myAdapter.InsertCommand.Parameters.Add(para16);
			myAdapter.InsertCommand.Parameters.Add(para17);
			myAdapter.InsertCommand.Parameters.Add(para18);
			myAdapter.InsertCommand.Parameters.Add(para19);
			myAdapter.InsertCommand.Parameters.Add(para20);
			//myAdapter.InsertCommand.Parameters.Add(para21); 
			myAdapter.InsertCommand.Parameters.Add(para22);
			myConnection.Open();
		
		
			
			try 
			{
				myAdapter.InsertCommand.ExecuteNonQuery();
			}
			catch(Exception e)
			{
				
			}
			finally
			{
				myConnection.Close();
					
			}

		}
		public DataSet stuid_check(string id)
		{
			
		
			SqlDataAdapter mydata=new SqlDataAdapter("stuid_check",myConnection);
			mydata.SelectCommand.CommandType=CommandType.StoredProcedure;
			SqlParameter para=new SqlParameter("@id",SqlDbType.Char,10);
			para.Value=id;
			mydata.SelectCommand.Parameters.Add(para);
			DataSet ds=new DataSet();
			mydata.Fill(ds,"students");
			return ds;
		}
		public DataSet displaystudents(string xymc)
		{
			string sql="select * from students where xy='xymc'";
			SqlDataAdapter myAdapter=new SqlDataAdapter(sql,myConnection);
			//myAdapter.SelectCommand.CommandType=CommandType.StoredProcedure;
		
			DataSet ds=new DataSet();
			myAdapter.Fill(ds,"students");
			return ds;
		}
	}
}