service1.asmx.cs

C#示例代码,刚刚注册随便找了一个东西测试一下好不好用

		[WebMethod]
		public bool check(string name,string mima)
		{
			string name1;
			string mima1;
			//string check=null;
			string sele="SELECT * FROM 表1";
			
			oleDbConnection1.Open();
			oleDbSelectCommand1=new OleDbCommand(sele, oleDbConnection1);
			OleDbDataReader reader=oleDbSelectCommand1.ExecuteReader();
			while(reader.Read())
			{
					
				name1=reader.GetString(0);
				mima1=reader.GetString(1);
				
				if(name1==name&&mima1==mima)
				{
					return true;
				}
				
			}
			
			reader.Close();
			
			oleDbConnection1.Close();
			//下行的意思是：如果数据库中不存在用户输入的登录名，返回“false”
			return false;

		
		
		}

		//**************************************************************

		[WebMethod]
		public  DataSet  sele(string xingming,string xuehao,string kecheng,string fenshu,string xuefen,string check )
		{
			
			string add=null;
			string query1="SELECT * FROM TABLE1 WHERE ";
			if(check=="10000")
			{
				add="姓名="+"'"+xingming+"'";
			}
			if(check=="01000")
			{
				add="学号="+"'"+xuehao+"'";
			}
			if(check=="00100")
			{
				add="课程="+"'"+kecheng+"'";
			}
			if(check=="00010")
			{
				add="分数="+"'"+fenshu+"'";
			}
			if(check=="00001")
			{
				add="学分="+"'"+xuefen+"'";
			}
			if(check=="11000")
			{
				add="("+"姓名="+"'"+xingming+"'"+")"+"AND"+"("+"学号="+"'"+xuehao+"'"+")";	
			}
			if(check=="10100")
			{
				add="("+"姓名="+"'"+xingming+"'"+")"+"AND"+"("+"课程="+"'"+kecheng+"'"+")";		
			}
			if(check=="10010")
			{
				add="("+"姓名"+"'"+xingming+"'"+")"+"AND"+"("+"分数="+"'"+fenshu+"'"+")";		
			}
			if(check=="10001")
			{
				add="("+"姓名="+"'"+xingming+"'"+")"+"AND"+"("+"学分="+"'"+xuefen+"'"+")";	
			}
			if(check=="01100")
			{
				add="("+"学号="+"'"+xuehao+"'"+")"+"AND"+"("+"课程="+"'"+kecheng+"'"+")";		
			}
			if(check=="01010")
			{
				add="("+"学号="+"'"+xuehao+"'"+")"+"AND"+"("+"分数="+"'"+fenshu+"'"+")";		
			}
			if(check=="01001")
			{
				add="("+"学号="+"'"+xuehao+"'"+")"+"AND"+"("+"学分="+"'"+xuefen+"'"+")";		
			}
			if(check=="00110")
			{
				add="("+"课程="+"'"+kecheng+"'"+")"+"AND"+"("+"分数="+"'"+fenshu+"'"+")";	
			}
			if(check=="00101")
			{
				add="("+"课程="+"'"+kecheng+"'"+")"+"AND"+"("+"学分="+"'"+xuefen+"'"+")";		
			}
			if(check=="00011")
			{
				add="("+"分数="+"'"+fenshu+"'"+")"+"AND"+"("+"学分="+"'"+xuefen+"'"+")";		
			}
			if(check=="11100")
			{
				add="("+"姓名="+"'"+xingming+"'"+")"+"AND"+"("+"学号="+"'"+xuehao+"'"+")"+"AND"+"("+"课程="+"'"+kecheng+"'"+")";	
			}
			//
			if(check=="11010")
			{
				add="("+"姓名="+"'"+xingming+"'"+")"+"AND"+"("+"学号="+"'"+xuehao+"'"+")"+"AND"+"("+"分数="+"'"+fenshu+"'"+")";	
			}
			if(check=="11001")
			{
				add="("+"姓名="+"'"+xingming+"'"+")"+"AND"+"("+"学号="+"'"+xuehao+"'"+")"+"AND"+"("+"学分="+"'"+xuefen+"'"+")";	
			}
			if(check=="10110")
			{
				add="("+"姓名="+"'"+xingming+"'"+")"+"AND"+"("+"课程="+"'"+kecheng+"'"+")"+"AND"+"("+"分数="+"'"+fenshu+"'"+")";	
			}
			if(check=="10101")
			{
				add="("+"姓名="+"'"+xingming+"'"+")"+"AND"+"("+"课程="+"'"+kecheng+"'"+")"+"AND"+"("+"学分="+"'"+xuefen+"'"+")";	
			}
			
			
			//
			if(check=="01110")
			{
				add="("+"学号="+"'"+xuehao+"'"+")"+"AND"+"("+"课程="+"'"+kecheng+"'"+")"+"AND"+"("+"分数="+"'"+fenshu+"'"+")";		
			}
			if(check=="01101")
			{
				add="("+"学号="+"'"+xuehao+"'"+")"+"AND"+"("+"课程="+"'"+kecheng+"'"+")"+"AND"+"("+"学分="+"'"+xuefen+"'"+")";		
			}

			if(check=="00111")
			{
				add="("+"学分="+"'"+xuefen+"'"+")"+"AND"+"("+"课程="+"'"+kecheng+"'"+")"+"AND"+"("+"分数="+"'"+fenshu+"'"+")";			
			}
			if(check=="11110")
			{
				add="("+"姓名="+"'"+xingming+"'"+")"+"AND"+"("+"学号="+"'"+xuehao+"'"+")"+"AND"+"("+"课程="+"'"+kecheng+"'"+")"+"AND"+"("+"分数="+"'"+fenshu+"'"+")";		
			}
			if(check=="11101")
			{
				add="("+"姓名="+"'"+xingming+"'"+")"+"AND"+"("+"学号="+"'"+xuehao+"'"+")"+"AND"+"("+"课程="+"'"+kecheng+"'"+")"+"AND"+"("+"学分="+"'"+xuefen+"'"+")";		
			}

			if(check=="01111")
			{
				add="("+"学分="+"'"+xuefen+"'"+")"+"AND"+"("+"学号="+"'"+xuehao+"'"+")"+"AND"+"("+"课程="+"'"+kecheng+"'"+")"+"AND"+"("+"分数="+"'"+fenshu+"'"+")";			
			}
			if(check=="11111")
			{
				add="("+"姓名="+"'"+xingming+"'"+")"+"AND"+"("+"学分="+"'"+xuefen+"'"+")"+"AND"+"("+"学号="+"'"+xuehao+"'"+")"+"AND"+"("+"课程="+"'"+kecheng+"'"+")"+"AND"+"("+"分数="+"'"+fenshu+"'"+")";	
			}

			string query =query1+add;
			
			try
			{
				sqlDataAdapter1.SelectCommand.CommandText=query;
				sqlDataAdapter1.Fill(stud1);
				return stud1;
			    
			}
			catch
			{
				return null;
			}

		
		
		}
		//************************************************************

		[WebMethod]
		public void insert(string xingming,string xuehao,string kecheng,string fenshu,string xuefen,string bianhao)
		{
			
			string name =xingming;
			string number=xuehao;
			string course=kecheng;
			string mark=fenshu;
			string credit=xuefen;
			string sial=bianhao;
			string name1="'"+name+"'";
			string number1="'"+number+"'";
			string course1="'"+course+"'";
			string mark1="'"+mark+"'";
			string credit1="'"+credit+"'";
			string sial1="'"+sial+"'";
			string insertText="("+sial1+","+name1+","+number1+","+course1+","+mark1+","+credit1+")";
			stud1.AcceptChanges();
			string insert="INSERT INTO TABLE1(编号,姓名,学号,课程,分数,学分)VALUES"+insertText;
			//"+insertText;
			
		
			sqlConnection1.Open();
			sqlInsertCommand1=new SqlCommand(insert, sqlConnection1);
			sqlInsertCommand1.ExecuteNonQuery();
			stud1.Clear();
			sqlConnection1.Close();

			
		}
		//********************************************************

		[WebMethod]
		public void dele(string xingming,string xuehao,string kecheng,string fenshu,string xuefen,string check)
		{
			
			string add=null;
			string delete1="DELETE FROM TABLE1 WHERE ";
			if(check=="10000")
			{
				add="姓名="+"'"+xingming+"'";
			}
			if(check=="01000")
			{
				add="学号="+"'"+xuehao+"'";
			}
			if(check=="00100")
			{
				add="课程="+"'"+kecheng+"'";
			}
			if(check=="00010")
			{
				add="分数="+"'"+fenshu+"'";
			}
			if(check=="00001")
			{
				add="学分="+"'"+xuefen+"'";
			}
			if(check=="11000")
			{
				add="("+"姓名="+"'"+xingming+"'"+")"+"AND"+"("+"学号="+"'"+xuehao+"'"+")";	
			}
			if(check=="10100")
			{
				add="("+"姓名="+"'"+xingming+"'"+")"+"AND"+"("+"课程="+"'"+kecheng+"'"+")";		
			}
			if(check=="10010")
			{
				add="("+"姓名"+"'"+xingming+"'"+")"+"AND"+"("+"分数="+"'"+fenshu+"'"+")";