查看mysql 表 被人删除_SQL 数据库被人删掉了,肿么可以查出是谁删

我这个是C#，ASp.net的：

查询后显示在Gridview控件里：

SqlConnection Conn = BaseClass.DBCon();

Conn.Open();

string mystr = "select * from tb_AddBook where textbox.text";

DataSet mydt = new DataSet();

SqlDataAdapter mysda = new SqlDataAdapter(mystr, Conn);

mysda.Fill(mydt);

GvNavol.DataSource = mydt;

GvNavol.DataBind();

删除代码：

protected void btnDelete_Click(object sender, EventArgs e)

{

SqlConnection conn = BaseClass.DBCon();

conn.Open();

string str = "delete tb_AddBook where BookName='"+ddlBookName.SelectedValue+"' and BookAuthor='"+ddlBookAuthor.SelectedValue+"'";

BaseClass.OperateData(str);

Response.Write("");

}

取消

评论