当前文件： ClassTree/DAL/ClassTree.cs[1K，2009-6-12 11:36:01]，打开代码结构图

		            
 1using System;
 2using System.Collections.Generic;
 3using System.Linq;
 4using System.Text;
 5using System.Data;
 6using System.Data.SqlClient;
 7
 8namespace DAL
 9...{
10    public class ClassTree
11    ...{
12        //数据库配置修改并编译才能生效呢 //add by 51aspx.com
13        private string connectionString="Data Source=.;Initial Catalog=classTree;User ID=sa;pwd=sa;";
14        /**//// <summary>
15        /// 根据sql返回DataSet
16        /// </summary>
17        /// <param name="sql"></param>
18        /// <returns></returns>
19        public DataSet getDataSetBySql(string sql)
20        ...{
21            SqlConnection conn = new SqlConnection(connectionString);
22            SqlDataAdapter da = new SqlDataAdapter(sql, conn);
23            DataSet ds = new DataSet();
24            da.Fill(ds);
25            return ds;
26        }
27        /**//// <summary>
28        /// 根据传入的sql语句
29        /// </summary>
30        /// <param name="sql"></param>
31        public void ExecSQl(string sql)
32        ...{
33            SqlConnection conn = new SqlConnection(connectionString);
34            conn.Open();
35            SqlCommand command = new SqlCommand(sql, conn);
36            command.ExecuteNonQuery();
37            conn.Close();
38        }
39    }
40}
41//该源码下载自www.51aspx.com(５1aｓｐｘ．ｃｏｍ)
42