class1.cs

本系统以ASP.NET为开发平台

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

namespace 学生综合素质测评系统
{
		

		
	/// <summary>
	/// DoDataBase 的摘要说明。
	/// </summary>
	public class Class1
	{
		


		public Class1()
		{
			
			// TODO: 在此处添加构造函数逻辑
			//
	
		}
		public static DataSet GetDataSet(string sql)
		{
			SqlConnection conn=new SqlConnection();
			DataSet ds=new DataSet();
			try
			{

				conn=new SqlConnection("Server=.;database=学生综合素质测评系统;user=sa;password=");
				SqlDataAdapter sda=new SqlDataAdapter(sql,conn);
				sda.Fill(ds);
				return ds;
                
			}
			catch(Exception ex)
			{
				throw(ex);
			}
			finally
			{
				conn.Close();
			}
		}
		public static int ExecuteSQL(string sql)
		{
			SqlConnection conn=new SqlConnection();
			try
			{
				conn=new SqlConnection("Server=.;database=学生综合素质测评系统;user=sa;password=");
				SqlCommand sqlCmd =new SqlCommand(sql,conn);
				conn.Open();
				return sqlCmd.ExecuteNonQuery();
			}
			catch(Exception ex)
			{
				throw ex;
			}
			finally
			{
				conn.Close();
			}


		}


	}


}