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;//查询所有 阅读全文
posted @ 2006-12-12 21:58 wkjs 阅读(173) 评论(0) 推荐(0)
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 阅读全文
posted @ 2006-12-10 10:59 wkjs 阅读(162) 评论(0) 推荐(0)
触发器、存储过程和事务处理使用
摘要:--创建数据库scrolldynamiccreatedatabaseDatabase1GO--置此数据库为当前数据库useDatabase1GO--创建学生表createtablestudent(SIDvarchar(20)primarykey,--学生编号SNamevarchar(20),--学生姓名SClassvarchar(20),--学生班级SSexvarchar(10),--学生性别SScorefloatdefault(0)check(SScore>=0)--学生平均分)GO--创建课程表createtableclass(EIDvarchar(20)primarykey,--课 阅读全文
posted @ 2006-12-10 09:34 wkjs 阅读(226) 评论(0) 推荐(0)
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 阅读全文
posted @ 2006-12-06 21:10 wkjs 阅读(160) 评论(0) 推荐(0)