dataclass.cs

来自「本程序只要配置好IIS就可以直接使用,是一个在线网上考试系统」· CS 代码 · 共 80 行

using System;
using System.Data.SqlClient;
using System.Xml;
using System.Data;
using System.Collections;
using System.ComponentModel;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;


namespace DBClass
{
	public class DataClass : System.Web.UI.Page
	{
		public DataClass()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		SqlConnection con=new SqlConnection();
		SqlCommand com=new SqlCommand();
		SqlDataAdapter da=new SqlDataAdapter();
		DataSet ds=new DataSet();
		public string conn()
		{
			XmlDocument xmldoc=new XmlDocument();
			xmldoc.Load(Server.MapPath("XMLFile1.xml"));
			XmlElement root=xmldoc.DocumentElement;
			string server,database;
			server=root.ChildNodes[0].ChildNodes[0].InnerText;
			database=root.ChildNodes[0].ChildNodes[1].InnerText;
			string strcon;
			strcon="server="+ server +";database="+ database +";user id=sa;pwd=";
			return strcon;
		}
		public DataSet SelectData(string strsql)
		{
			con.ConnectionString=conn();
			com.CommandText=strsql;
			com.Connection=con;
			da.SelectCommand=com;
			try
			{
				ds.Clear();
				con.Open();
				da.Fill(ds);
				con.Close();
				return ds;
			}
			catch(Exception)
			{
				con.Close();
				return ds;
			}
		}
		public bool updateData(string strsql)
		{
			con.ConnectionString=conn();
			com.CommandText=strsql;
			com.Connection=con;
			try
			{
				con.Open();
				com.ExecuteNonQuery();
				con.Close();
				return true;
			}
			catch(Exception)
			{
				con.Close();
				return false;
			}
		}
	}
}