?using System;
using System.Data;
using System.Data.SqlClient;
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;

/// <summary>
/// db 的摘要說明
/// </summary>
public class db
{
	public db()
	{
		//
		// TODO: 在此處添加構造函數邏輯
		//
	}
    public static SqlConnection createconn()
    {
        SqlConnection conn = new SqlConnection("server=.;database=nt;uid=sa;pwd=5706512;");
        return conn;
    }
    public static void insert(string sub, string name, string tel, string fax, string email, string url, string content)
    {
        SqlConnection conn = db.createconn();
        conn.Open();
        string str = "insert into liuyan(subject,name,tel,fax,email,url,content,date1) values(@sub,@name,@tel,@fax,@email,@url,@content,@date)";
        SqlCommand cmd = new SqlCommand(str,conn);
        cmd.Parameters.Add("@sub", SqlDbType.VarChar).Value = sub;
        cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = name;
        cmd.Parameters.Add("@tel", SqlDbType.VarChar).Value = tel;
        cmd.Parameters.Add("@fax", SqlDbType.VarChar).Value = fax;
        cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = email;
        cmd.Parameters.Add("@url", SqlDbType.VarChar).Value = url;
        cmd.Parameters.Add("@content", SqlDbType.VarChar).Value = content;
        cmd.Parameters.Add("@date", SqlDbType.DateTime).Value = DateTime.Now.ToString();
        try
        {
            cmd.ExecuteNonQuery();
        }
        catch (Exception e)
        {
            throw e;
        }
        finally
        {
           conn.Close();
        }

    }
    public static DataSet sel()
    {
        SqlConnection conn = db.createconn();
        string str = "select * from liuyan order by date1 desc";
        SqlDataAdapter myAdapter = new SqlDataAdapter(str,conn);
        DataSet ds = new DataSet();
        try
        {
            myAdapter.Fill(ds, "liuyan");
        }
        catch (Exception e)
        {
            throw e;
        }
        return ds;
    }
  
}