ADO.Net,数据库直连式

connection创建和数据库的连接：1,服务器2，身份验证3，指定数据库

"."代表本机或（local），Database是指数据库名字，如果用Windows验证用Integrated security = true;

Sqlconnection conn = <span style="color: #0000ff">new</span><span style="color: #000000"> Sqlconnection();
conn.ConnectionString </span>= <span style="color: #800000">"</span><span style="color: #800000">server = .;Database = stu;uid = sa; pwd = 123</span><span style="color: #800000">"</span>;<br>conn.Open();

command

<span style="color: #008000">//</span><span style="color: #008000">构造命令对象</span>
 Sqlcommand com = <span style="color: #0000ff">new</span><span style="color: #000000"> Sqlcommand();
cmd.commandText </span>= <span style="color: #800000">"</span><span style="color: #800000">select * from student</span><span style="color: #800000">"</span><span style="color: #000000">;
cmd.connection </span>= con;

datareade

<span style="color: #008000">//</span><span style="color: #008000">声明结果集</span>
SqlDataReader dr =<span style="color: #000000"> com.ExecuteReader();
</span><span style="color: #008000">//</span><span style="color: #008000">遍历dr数据</span>
<span style="color: #0000ff">if</span><span style="color: #000000">(dr.HasRows)
{ 
     whlie(dr.Read)
{
  ListBox1.Item.Add(dr[</span><span style="color: #800080">1</span><span style="color: #000000">].Tostring());
}
}<br>con.Close();</span>

全程手打的有错见谅

ADO.Net,数据库直连式

标签：.exe   uid   command   listbox   using   security   color   技术分享   UI