第?3?章?ASP.NET

安装Visual Studio 2010

官网下载并安装Visual Studio 2010。

新建Webuxdb网站

点击文件-->新建网站-->ASP.NET空网站（自定义路径和项目名称，eg:D:\vs2010\WebSite1）。点击确定。

添加库类

添加UXDB.cs接口类

UXDB.cs的代码如下：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
//using System.Windows.Forms;
using System.Data;
using Nuxsql;
public class UXDB
{
    DataSet DS;
    bool ECode;
    string ErrString;
    NuxsqlConnection Conn = new NuxsqlConnection();
    public UXDB(string ServerName, string ServerPort, string DBName, string UserName, string Pwd)
    {
        ECode = false;
        Conn.ConnectionString = "Server=" + ServerName + ";Port=" + ServerPort + ";User Id=" + UserName + ";Password=" + Pwd + ";Database=" + DBName;
        try
        {
            Conn.Open();
        }
        catch (Exception e)
        {
            ECode = true;
            ErrString = e.Message;
        }
    }
    public DataSet GetRecordSet(string sql)
    {
        NuxsqlCommand sqlCmd = new NuxsqlCommand();
        sqlCmd.Connection = Conn;
        sqlCmd.CommandText = sql;
        try
        {
            NuxsqlDataAdapter adp = new NuxsqlDataAdapter(sqlCmd);
            DS = new DataSet();
            adp.Fill(DS);
        }
        catch (Exception e)
        {
            ErrString = e.Message;
            ECode = true;
            return null;
        }
        return DS;
    }
    public int ExecuteSQLScalar(string Sqls)
    {
        string s;
        NuxsqlCommand sqlCmd = new NuxsqlCommand();
        sqlCmd.Connection = Conn;
        sqlCmd.CommandText = Sqls;
        sqlCmd.CommandType = CommandType.Text;
        try
        {
            s = sqlCmd.ExecuteScalar().ToString();
        }
        catch (Exception e)
        {
            ErrString = e.Message;
            ECode = true;
            return -1;
        }
        return (int.Parse(s));
    }
    public string ExecuteSQLScalarTOstring(string Sqls)
    {
        string s;
        NuxsqlCommand sqlCmd = new NuxsqlCommand();
        sqlCmd.Connection = Conn;
        sqlCmd.CommandText = Sqls;
        sqlCmd.CommandType = CommandType.Text;
        try
        {
            s = sqlCmd.ExecuteScalar().ToString();
        }
        catch (Exception e)
        {
            ErrString = e.Message;
            ECode = true;
            return "-1";
        }
        return s;
    }
    public string ExecuteSQLWithTrans(string Sqls)
    {
        string s;
        NuxsqlTransaction myTrans;
        myTrans = Conn.BeginTransaction();
        NuxsqlCommand sqlCmd = new NuxsqlCommand();
        sqlCmd.Connection = Conn;
        sqlCmd.CommandText = Sqls;
        sqlCmd.CommandType = CommandType.Text;
        sqlCmd.Transaction = myTrans;
        sqlCmd.ExecuteNonQuery();
        //Sqls="SELECT @@IDENTITY AS ID";  
        sqlCmd.CommandText = Sqls;
        try
        {
            s = sqlCmd.ExecuteScalar().ToString();
        }
        catch (Exception e)
        {
            ErrString = e.Message;
            ECode = true;
            myTrans.Commit();
            return "";
        }
        myTrans.Commit();
        return (s);
    }
    public void ExecuteSQL(string Sqls)
    {
        NuxsqlCommand sqlCmd = new NuxsqlCommand();
        sqlCmd.Connection = Conn;
        sqlCmd.CommandText = Sqls;
        sqlCmd.CommandType = CommandType.Text;
        try
        {
            sqlCmd.ExecuteNonQuery();
        }
        catch (Exception e)
        {
            ErrString = e.Message;
            ECode = true;
        }
    }
    public NuxsqlDataReader DBDataReader(string Sqls)
    {
        NuxsqlCommand sqlCmd = new NuxsqlCommand();
        sqlCmd.Connection = Conn;
        sqlCmd.CommandText = Sqls;
        sqlCmd.CommandType = CommandType.Text;
        try
        {
            return sqlCmd.ExecuteReader(CommandBehavior.CloseConnection);
        }
        catch (Exception e)
        {
            ErrString = e.Message;
            ECode = true;
            return null;
        }
    }
    public void DBClose()
    {
        try
        {
            Conn.Close();
        }
        catch (Exception e)
        {
            ErrString = e.Message;
            ECode = true;
        }
    }
    public bool ErrorCode()
    {
        return ECode;
    }
    public string ErrMessage()
    {
        return ErrString;
    }
    ~UXDB()
    {
    }
}

创建测试窗体

右键项目名称，添加新项-->Visual C#->Web窗体，点击添加。

Default.aspx.cs代码如下：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Nuxsql;
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //added by qinglong.ou
        //NuxDB myDb = new NuxDB("localhost", "5432", "postgres", "postgres", "123456");
        UXDB myDb = new UXDB("192.168.1.82", "5432", "test", "uxdb", "123456");
        string retStr = "";
        string testSql = "select * from student";
        NuxsqlDataReader reader = myDb.DBDataReader(testSql);
        // 判断数据是否读到尾. 
        while (reader.Read())
        {
            //控制台输入 
            //string temp = String.Format("{0},{1},{2},{3},{4}", reader[0], reader[1], reader[2], reader[3], reader[4]);
            string temp = String.Format("{0},{1},{2},{3}", reader[0], reader[1], reader[2], reader[3]);
            //retStr += temp + "<----->";
            retStr += temp + "\n";
        }
        System.Diagnostics.Debug.WriteLine("student\n" + retStr);
        Console.WriteLine(retStr);
        // 一定要关闭 reader 对象. 
        reader.Close();
    }
}

运行结果

右键项目名称-->生成网站，启动调试（F5），查看即时窗口输出。

运行结果如下显示时asp.net连接使用uxdb成功，显示student表的数据与uxdb数据库中查看结果一致。

使用分析说明