03 2015 档案

return命令
摘要：CREATE PROCEDURE MultipleTwoValue @Number1 int,@Number2 int,@Number3 int ASRETURN @Number1 * @Number2 * @Number3======================================... 阅读全文

posted @ 2015-03-27 09:03 飞哥Penfield 阅读(325) 评论(0) 推荐(0)

SQL里的case函数
摘要：--------------------------------------------------------------------------------SELECT 姓名,--此处显示列名不能使用as性别 = CASE 性别 WHEN 0 THEN '女' ... 阅读全文

posted @ 2015-03-27 08:54 飞哥Penfield 阅读(142) 评论(0) 推荐(0)

一个游标的简单操作（use transaction）
摘要：注意：将游标封装在事务中可以防止操作不完整性======+脏读begin trybegin transactionDECLARE @Name varchar(10), @Sex bit, @Married bit, @Phone char(10), @ChineseSex char(2), @Chi... 阅读全文

posted @ 2015-03-27 08:41 飞哥Penfield 阅读(1058) 评论(0) 推荐(0)

listview+contentMenuStrip
摘要：namespace WindowsFormsApp{ public partial class listview : Form { private void func() { listView1.Items.Clear(); ... 阅读全文

posted @ 2015-03-19 13:59 飞哥Penfield 阅读(188) 评论(0) 推荐(0)

listview控件
摘要：private void listview_Load(object sender, EventArgs e) { string sql = string.Format("select LoginId,StudentName,UserStateId,Sex fro... 阅读全文

posted @ 2015-03-19 10:22 飞哥Penfield 阅读(144) 评论(1) 推荐(0)

控制台实现数据库的增删改查
摘要：using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data.SqlClient;using Syste... 阅读全文

posted @ 2015-03-18 15:05 飞哥Penfield 阅读(266) 评论(0) 推荐(0)

Winform连接数据库
摘要：using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;u... 阅读全文

posted @ 2015-03-18 11:40 飞哥Penfield 阅读(421) 评论(2) 推荐(0)

导航