程序博客网 > mac miscrosoft

Sql连接操作

来源：互联网发布：mac miscrosoft 编辑：程序博客网时间：2024/04/30 04:20

判断连接数据库状态：

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

<%@ 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>

更新数据库语句：

<%@ 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>

删除数据库记录

<%@ 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>

异常的捕捉及处理

<%@ Import Namespace= "System.Data.SqlClient" %><mce:script runat = "server"></mce:script>

捕捉sql执行异常

<%@ 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" %><script runat="server"> 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"; var cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandText = "insert Student (StudentID,StudentName) values (8,'wss')"; try { 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连接关闭");*/ var records = cmd.ExecuteNonQuery(); cn.Close(); Response.Write("新增了" + records.ToString() + "条数据"); } catch (SqlException ex) { Response.Write(ex.Number + ":" + ex.Message + " <br/>"); } finally { if (cn.State == System.Data.ConnectionState.Open) { cn.Close(); } } }

mac miscrosoft

mac miscrosoft

原创粉丝点击

热门问题 老师的惩罚人脸识别我在镇武司摸鱼那些年重生之率土为王我在大康的咸鱼生活盘龙之生命进化天生仙种凡人之先天五行春回大明朝姑娘不必设防，我是瞎子汉武御酒价格表及图片汉武大帝在线播放秦皇汉武并称的原因汉武大帝多少集汉江渡汉江汉江师范汉江临泛渡汉江古诗汉江怪物2 汉江大学金陵望汉江汉江流域汉江水海伦堡汉江汉江集团汉江奇迹汉江大桥汉江三峡汉江绿谷韩国汉江汉江路度汉江渡汉江拼音汉江水位汉江奇石渡汉江鉴赏襄阳汉江网汉江是哪里汉江在哪里汉江在哪汉江发源地汉江源头汉江源汉江局汉江师范学院渡汉江宋之问渡汉江古诗带拼音湖北省汉江河道管理局谷城汉江社区招聘信息渡汉江古诗朗诵