源代码: using system;using system.collections.generic;using system.data;using system.data.sqlclient;using system.linq;using system.text;using system.threading.tasks;namespace sqltest{ class program { static void main(string[] args) { //连
源代码:
using system;using system.collections.generic;using system.data;using system.data.sqlclient;using system.linq;using system.text;using system.threading.tasks;namespace sqltest{ class program { static void main(string[] args) { //连接数据库 string connection = server=潘尚\\sqlexpress;database=db_test;trusted_connection=true; sqlconnection sc = new sqlconnection(); sc.connectionstring = connection; try { sc.open(); //打开数据库连接 console.writeline(已经打开数据库连接!); sqlcommand cmd = new sqlcommand();//创建sqlcommand对象 cmd.commandtype = commandtype.text; //设置执行文本命令 cmd.connection = sc; //设置对象属性 cmd.commandtext = insert into db_student(student_name,student_age,student_address,student_grade)values(@name,@age,@address,@grade); //添加参数并为参数赋值 cmd.parameters.add(@name, sqldbtype.varchar, 10).value = 潘; cmd.parameters.add(@age, sqldbtype.int).value = 19; cmd.parameters.add(@address, sqldbtype.varchar).value = 武汉; cmd.parameters.add(@grade, sqldbtype.int).value = 100; int i = cmd.executenonquery(); //执行数据库添加记录命令 if (i > 0) console.writeline(添加记录成功); //控制台输出添加记录 } catch (exception ex) { console.writeline(打开数据库错误:{0}, ex.message); } finally { sc.close(); console.writeline(数据库连接已关闭!); } system.console.readline(); } }}
数据库设计:
运行:
运行之后的数据库状态: