using System;
using System.Data ;
using System.Data.SqlClient ;
using System.Timers;
using System.Collections;
using System.Collections.Specialized;
using System.IO;
using System.Web;
using System.Web.UI;
using System.Web.Caching;
using System.Configuration;
using System.Text;
using System.Text.RegularExpressions;
using System.Web.UI.WebControls;
namespace c1
{
/// <summary>
/// mydb 的摘要说明。
/// </summary>
public class mydb
{
public mydb()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
//得到表
public static DataTable gettable(string sqlstring)
{
//在WEB.CONFIG文件中的内容如下
// <appSettings>
// <!-- 此处显示用户应用程序和配置的属性设置。-->
// <!-- 示例:<add key="settingName" value="settingValue"/> -->
// <add key="ConnectionString" value="server=(local);uid=sa;pwd=;database=mycount" />
//</appSettings>
//</configuration>
SqlConnection db =new SqlConnection(mydb.ConnectionString);
SqlDataAdapter dp =new SqlDataAdapter("select * from subject", db);
DataSet ds=new DataSet();
dp.Fill(ds, "table0");
return ds.Tables[0];
}
//数据连接
public static string ConnectionString
{
get
{
return ConfigurationSettings.AppSettings ["ConnectionString"];
}
}
}
}