sql

来源：互联网发布：软件验收报告编辑：程序博客网时间：2024/06/05 18:50

连接数据库状态： --------------------------------------------------------------------------------

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><%@ Import Namespace = "System.Data.SqlClient" %><mce:script runat="server"></mce:script>

判断Sql是否连接

protected void Page_Load(object sender, EventArgs e) { var cn = new SqlConnection(); cn.ConnectionString=@"Data Source=./SQLEXPRESS;AttachDbFilename=|DataDirectory|Student.Mdf;Integrated Security=True;User Instance=True"; cn.Open(); if (cn.State == System.Data.ConnectionState.Open) { Response.Write("SQL is open Now"); cn.Close(); } if (cn.State == System.Data.ConnectionState.Closed) { Response.Write("SQL is close"); } Response.Write("SQL连接开启"); cn.Close(); Response.Write("SQL连接关闭"); }

执行插入Sql语句，代码如下：

更新数据库语句： --------------------------------------------------------------------------------

删除数据库记录 --------------------------------------------------------------------------------

异常的捕捉及处理 --------------------------------------------------------------------------------