12 2006 档案
存储过程与触发器Web调用代码
摘要:usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Data;usingSystem.Configuration;usingSystem.Data.SqlClient;namespaceWangKang.DataBase...{publicclassWebDB:DB...{privatestringconnstring=ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;//查询所有
阅读全文
Win调用
摘要:usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Data;usingSystem.Configuration;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWangKang.DataBase...{publicclassWinDB:DB...{privatestringconnstring=@"DataSource=.SQLEXPRESS;IntegratedSecurity=True;UserInstance
阅读全文
触发器、存储过程和事务处理使用
摘要:--创建数据库scrolldynamiccreatedatabaseDatabase1GO--置此数据库为当前数据库useDatabase1GO--创建学生表createtablestudent(SIDvarchar(20)primarykey,--学生编号SNamevarchar(20),--学生姓名SClassvarchar(20),--学生班级SSexvarchar(10),--学生性别SScorefloatdefault(0)check(SScore>=0)--学生平均分)GO--创建课程表createtableclass(EIDvarchar(20)primarykey,--课
阅读全文
GridView鼠标效果001
摘要:protectedvoidGridView1_RowCreated(objectsender,GridViewRowEventArgse)...{if(e.Row.RowType==DataControlRowType.DataRow)...{e.Row.Attributes.Add("onmouseover","c=this.style.backgroundColor;this.style.backgroundColor='#00ffee'");e.Row.Attributes.Add("onmouseout",&q
阅读全文