企业库一全套增删改

最新推荐文章于 2023-12-17 00:42:05 发布

我是成果啊

最新推荐文章于 2023-12-17 00:42:05 发布

阅读量337

点赞数 1

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/xiongchengguo/article/details/46319007

//引用命名空间
using  Microsoft.Practices.EnterpriseLibrary.Data;

//数据库连接字符串
Database db = DatabaseFactory.CreateDatabase();

//添加
private void Add()
{
    if(textbox.text == null)
    {
        response.write("内容不能为空");
    }
    else
    {
        string sql = string.Format("insert into 表名 values('{0}'",textbox.Text.Replace("'","''"));
        int  i = db.ExecteNonQuery(CommandType.Text,sql);
        if(i>0)
        {
            response.write("成功");
        }
        else
        {
            response.write("失败");
        }
    }
}

//修改
private void Edit()
{
    if(textbox.text == null)
    {
        response.write("内容不能为空");
    }
    else
    {
        string sql = string.Format(“update 表名 set 字段名  = ‘{0}’ where id='{1}'”,textbox.Text.Replace("'","''"),1);
        int  i = db.ExecteNonQuery(CommandType.Text,sql);
        if(i>0)
        {
            response.write("成功");
        }
        else
        {
            response.write("失败");
        }
    }
}

//查询
private void select ()
{
    string sql = "select * from 表名";
    DataSet ds = db.ExecuteDataSet(CommandType.Text, sql);
    if(ds.Tables[0].Rows.Count > 0)
    {
        response.write("成功");
    }
    else
    {
        response.write("失败");
    }
}