ADO.NET小结
ADO.NET是 数据访问技术。
通过程序连接访问数据库。
基础用法:
增:
using system.data.sqlclient;
SqlConnection con=new sqlconnection("server=.;databasw=data0908;user=sa;pwd=1232412213");
sqlcommand com=con.createcommand();
com.commandtext="insert into users values(",'','')";
con.open();
com.executenonquery();
con.close();
console.read();
删:
using system.data.sqlcliment;
Sqlconnection con=new sqlconnection("server=.;database=data0908;user=sa;pwd=23213213");
sqlcommand com=con.createcommand();
com.commandtext="delete from~~~ ";
con.open();
com.executenonquery();
con.close();
console.read();
改:
using system.data.sqlclient;
Sqlconnection con=new sqlconnection();
sqlcommand com=con.createcommand;
com.commandtext=" update users set name=" "where ~~~ ";
con,close();
com.executenonquery();
conclose();
console.read();
查:
using system.data.sqlclient;
Sqlconnection con=new sqlconnection("server=.;database=data0908;user=sa;pwd=123123213");
sqlcommand com=con.createcommand();
com.commandtext="select * from users ";
con.open();
Sqldatareader dr=com.executereader();
if(dr.hasrows){
while(com.read()){
console.write(dr[0]);
~~~
~~}
}
con.close();
console.read();
con.close();