C#与数据库sql的连接
1.点击工具,找到数据库连接
2.设置参数PC(window) 数据源为:Microsoft SQL Server (SqlClient) 服务名为:.或者local 选择数据库,已创建的才可选 最后确定。(当然也可以创建属于自己的个人用户,用账号和密码认证也可)
3. 找到服务器资源管理,点击相对应的数据库,接着点击属性,复制连接字符串
4. 创建一个类,获取数据库连接字符串,并做增删查该操作
5. 关闭连接 ConnectString.conn.Close();增删改关闭,查需要加上sdr.Close();查询关闭
数据库连接操作
- 创建一个类ConnectString
class ConnectString
{
public static string ConnectHelp = "Data Source=.;Initial Catalog=PlCMassage;Integrated Security=True";//获取连接字符串
public static SqlConnection conn;//创建连接对象
//打开连接
public static void InitConn()
{
if(conn == null)
{
conn = new SqlConnection(ConnectHelp);//获取到连接
}
if(conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
if(conn.State == System.Data.ConnectionState.Broken)
{
conn.Close();
conn.Open();
}
}
//查询
public static SqlDataReader GetReader(string sqlStr, string num)
{
InitConn();
SqlCommand cmd = new SqlCommand(sqlStr, conn);
cmd.Parameters.Add(new SqlParameter("@Number", SqlDbType.VarChar, 50));
cmd.Parameters["@Number"].Value = num;
return cmd.ExecuteReader();
}
//查询
public static SqlDataReader get_reader(string sqlStr)
{
InitConn();
SqlCommand cmd = new SqlCommand(sqlStr, conn);
return cmd.ExecuteReader();
}
//查询
public static SqlDataReader get_Type_reader(string sqlStr, string t)
{
InitConn();
SqlCommand cmd = new SqlCommand(sqlStr, conn);
cmd.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar, 50));
cmd.Parameters["@Type"].Value = t;
return cmd.ExecuteReader();
}
}
修改:
string sql = "select *from UserInof where Type = '管理员'";
查询:
string sql = "select *from UserInof";
SqlDataReader sdr = null;
sdr = ConnectString.get_reader(sql);
int i = 0;
while (sdr.Read())
{
获取数据库单元格数据:sdr["Name"].ToString().Trim();
}删除:
string sql = "delete from UserInof where Number = '2002'";
增加:
string sqluser = string.Format("insert UserInof(Number,Password,Name,Type,CreateTime) values('{0}','{1}','{2}','{3}','{4}')", n_num, n_password, n_name, type, DateTime.Now);
string sql = "insert UserInof values('1002','123456','lisi','管理员','" + DateTime.Now + "')";string sql = "insert UserInof values('1002','123456','lisi','管理员','" + DateTime.Now + "')";
进阶版的数据库与C#(增删改查):
https://blog.csdn.net/m0_61870489/article/details/123658296
希望能对你有所帮助!!!