BowenXu11的博客

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.W...

设计理念1.所有数据存储比对和存储过程全部交给服务器端2.前端只做数据提交和判断结果后端SQL数据库存储过程create table bank( userId int identity primary key not null, userName nvarchar(32) not null, userMoney int null, check(userMoney ...

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.W...

//思路，通过创建两个集合，一个用于存储拼接字符串，一个用于存储pms对象的值 //通过多个if判断，对集合进行复制 //最后，通过一个字符串拼接，完成整个sql字符串和对应的pms对象的创建 // StringBuilder sbSql = new StringBuild...

//拿到分组对应的gorupid string gorupid = comboBoxGroup.SelectedValue.ToString(); //模糊查询符号%，不能写在SQL语句中，要写在C#中，用拼接字符串的方式传给SQL参数 string sql = "select contactId, c...

string sql = "select groupid,groupname from tblcontactgroup";DataTable dt = _07城市列表和递归Treeview.SqlHelper.SqlDataAdapter(sql);comboBoxGroup.DataSource = dt;comboBoxGroup.DisplayMember = "groupn...

先来看一下数据和结果两个表的数据再来看一下内联查询后的结果select contactId, contactName, cellPhone, gp.groupid,gp.groupName from[dbo].[TblContact] as co inner join[dbo].[TblContactGroup] as gp on co.groupid = gp.groupid...

//插入数据注意事项 //1.获取数据时，要判断空值，并给空值赋值null //2.int,bool等值类型无法赋值null，要改成int?， bool? //3.c# 的null值!= DBNull,使用SQLcommand属性传值是，要手动设置DBNull.value //获取数据 string name = this.textBoxName....

//1.设置sqlHelper为静态类 public static class SqlHelper//2.设置连接字符串的app.config配置文件<?xml version="1.0" encoding="utf-8" ?><configuration> <connectionStrings> <add name ="mssql...

//sql初始化参数 //创建sqlParameter集合，SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@loginId", SqlDbType.NVarChar, 32) { Value = id },//参数初始化器{ Value = id }new SqlParameter("@newPwd", SqlDbT...

//1.获取数据 string name = txtName.Text; string pwd = txtPwd.Text; string pwdMd5 = GetMD5(pwd); //2.比较用户名，用户名正确，返回密码 string constr = "data so...

string conStr = "data source=.;initial catalog=sqldemos;user id=sa;password=123456;"; //使用cmd参数方式防止sql注入 string cmdStr = string.Format("select count(*) from login where logini...