//引用命名空间
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("失败");
}
}
企业库一全套增删改
最新推荐文章于 2024-04-18 11:33:23 发布