sql2000+asp.net

 1.Web.config

<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <appSettings>
         <add key="connectionString" value="server=(local);database=ETMS;uid=sa;pwd=123"/>   
    </appSettings>
  
    <system.web>
        <!--
            设置 compilation debug="true" 将调试符号插入
            已编译的页面中。但由于这会
            影响性能，因此只在开发过程中将此值
            设置为 true。
        -->
        <compilation debug="true" />
        <authentication mode="Windows" />
    </system.web>
</configuration>

2.数据库连接
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Data.Sql;

public class DataControl
{
    SqlConnection myConnection;
    DataSet MyDataSet;
    public string Conn;
    public DataControl()
    {
        MyDataSet = new DataSet();
        Conn = System.Configuration.ConfigurationManager.AppSettings["connectionString"];
    }

    public DataSet GetData(string _sql)
    {
        myConnection = new SqlConnection(Conn);
        myConnection.Open();
        SqlDataAdapter command = new SqlDataAdapter(_sql,myConnection);
        int Dcount = command.Fill(MyDataSet);
        myConnection.Close();
        return MyDataSet;
    }
     public int Execute(string _sql)
    {

        int i = 0;
        try
        {
            myConnection = new SqlConnection(Conn);
            myConnection.Open();
            SqlCommand tranCmd = new SqlCommand(_sql, myConnection);
            i = tranCmd.ExecuteNonQuery();
            myConnection.Close();
        }
        catch (Exception ex)
        {
            i = 0;
        }
 return i;
    }

     
}

3.读取数据库信息
 protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            DataControl dc = new DataControl();
            string _sql = "select name from computer";
            DataSet ds = dc.GetData(_sql);
            DataRow dr = ds.Tables[0].Rows[0];
            string name = dr["name"].ToString().Trim();
            Response.Write(name);
        }
        catch
        {
            Response.Write("Database failed!");
        }
    }

4.建表
切忌用USER做表名，我的一个晚上和一个下午就浪费在这个名字上面了。