摘要: BEGIN TRY BEGIN TRANSACTION INSERT INTO Stuinfo VALUES ('aa','22','11') UPDATE stuinfo SET stu='888' WHERE ID =0 COMMIT TRANSACTIONEND TRYBEGIN CATCH 阅读全文
posted @ 2017-11-19 19:11 嗯哼,还好 阅读(97) 评论(1) 推荐(0)
摘要: Uri uri = new Uri("http://localhost:54534/"); HttpClient client = new HttpClient(); client.BaseAddress = uri; client.DefaultRequestHeaders.Accept.Add( 阅读全文
posted @ 2017-11-19 19:04 嗯哼,还好 阅读(239) 评论(0) 推荐(0)
摘要: CREATE TRIGGER tr_ChufaqiON Student FOR INSERT AS DECLARE @sid INT SELECT @sid =ID FROM insertedINSERT INTO Score VALUES (@sid,90)Go 阅读全文
posted @ 2017-11-19 18:59 嗯哼,还好 阅读(90) 评论(0) 推荐(0)
摘要: //获取数据库数据 var list = new BLL.Wbll().Show().ToList(); //创建Excel文件的对象 HSSFWorkbook book = new HSSFWorkbook(); //添加一个文件薄 ISheet sheet = book.CreateSheet( 阅读全文
posted @ 2017-11-16 16:52 嗯哼,还好 阅读(302) 评论(0) 推荐(0)
摘要: string savapath = Server.MapPath("/haha/" + path); //创建文件流并打开文件 FileStream fs = new FileStream(savapath,FileMode.Open); //创建字节数组 byte[] bt = new byte[ 阅读全文
posted @ 2017-11-15 19:12 嗯哼,还好 阅读(98) 评论(0) 推荐(0)
摘要: Image mia = Image.FromFile(path); //创建位图 Graphics g = Graphics.FromImage(mia); //赋值水印文字 string sy = name; //图片格式 Font ft = new Font("宋体", 32); //创建画笔 阅读全文
posted @ 2017-11-15 19:10 嗯哼,还好 阅读(438) 评论(0) 推荐(0)