简单数据库操作代码(添加删除修改读取)

 

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;

 

public partial class _Default : System.Web.UI.Page

{

    private SqlConnection con = new SqlConnection("server=localhost;uid=sa;pwd=sa;database=bld");

    protected void Page_Load(object sender, EventArgs e)

    {

        if(!IsPostBack)

        {

            bindgrid();

        }

    }

    // 创建函数

    private void bindgrid()

    {

        SqlDataAdapter sql = new SqlDataAdapter("select title,inputdate from article",con);

        DataSet rs = new DataSet();

        sql.Fill(rs, "article");

        GridView1.DataSource = rs.Tables[0].DefaultView;

        GridView1.DataBind();

 

       

    }

 

    protected void btnAdd_Click(object sender, EventArgs e)

    {

        SqlCommand sql = con.CreateCommand();

        sql.CommandText = "insert article (id,title,inputdate)values('123456',' 新增加的标题','2007-3-15')" ;

        try

        {

            con.Open();

            sql.ExecuteNonQuery();

        }

        catch

        { }

        bindgrid();

    }

    private string getmax()

    {

        string qm = "";

        SqlCommand sql = new SqlCommand("select top 1 id from article", con);

        try

        {

            con.Open();

            //sql.ExecuteNonQuery();

            //qm = (int)sql.ExecuteScalar();

            SqlDataReader rs = sql.ExecuteReader();

            if (rs.Read())

            {

                qm = rs["id"].ToString();

            }

        }

        catch

        { }

        finally

        {

            con.Close();

        }

        return qm;

    }

    protected void btnDelete_Click(object sender, EventArgs e)

    {

        //Response.Write(getmax());

        //string q = getmax();

        //Response.Write(q);

        SqlCommand sql = con.CreateCommand();

        sql.CommandText = "delete from article where id='" + getmax() + "'";

        try

        {

            con.Open();

            sql.ExecuteNonQuery();

        }

        catch

        { }

        bindgrid();

    }

    protected void btnUpdate_Click(object sender, EventArgs e)

    {

        //Response.Write(getmax());

        SqlCommand sql = con.CreateCommand();

        sql.CommandText = "update article set title='111111111' where id ='" + getmax() + "'";

        try

        {

            con.Open();

            sql.ExecuteNonQuery();

        }

        catch

        { }

        finally

        { con.Close(); }

        bindgrid();

    }

}