通过本文主要向大家介绍了c#数据库操作类,c#操作access数据库,c#操作数据库,c#数据库操作语句,c#操作mysql数据库等相关知识,希望对您有所帮助,也希望大家支持linkedu.com www.linkedu.com
1、常用的T-Sql语句
查询：SELECT * FROM tb_test WHERE ID='1' AND name='xia'
SELECT * FROM tb_test
插入：INSERT INTO tb_test VALUES('xia','123')
INSERT INTO tb_test(name) VALUES('xia')
更新：UPDATE tb_test SET password='234' WHERE ID='1'
删除：DELETE FROM tb_test WHERE ID='1'
DELETE tb_test WHERE ID='1'
2、在vs2010中获取数据库连接字符串
string connectionString = Properties.Settings.Default.DatabaseTestConnectionString;
3、SqlCommand类型
查询：
&nbs
查询：SELECT * FROM tb_test WHERE ID='1' AND name='xia'
SELECT * FROM tb_test
插入：INSERT INTO tb_test VALUES('xia','123')
INSERT INTO tb_test(name) VALUES('xia')
更新：UPDATE tb_test SET password='234' WHERE ID='1'
删除：DELETE FROM tb_test WHERE ID='1'
DELETE tb_test WHERE ID='1'
2、在vs2010中获取数据库连接字符串
string connectionString = Properties.Settings.Default.DatabaseTestConnectionString;
3、SqlCommand类型
查询：
&nbs