寻求C# 的ado.net访问数据库的实例

[sys0i]

谢谢
我刚学，还不会

[F15Eagle]

SqlConnection conn = new SqlConnection("server=192.168.1.26;uid=sa;pwd=;database=pubs;");
conn.Open();
SqlDataAdapter da = new SqlDataAdapter("select au_id, au_lname, au_fname from authors order by au_id", conn);
DataSet ds = new DataSet();
da.Fill(ds);
this.ListBox1.DataSource = ds.Tables[0].DefaultView;
this.ListBox1.DataTextField="au_lname";
this.ListBox1.DataValueField="au_id";
this.ListBox1.DataBind();

[F15Eagle]

别忘了这个
using System.Data.SqlClient;

[tepc2000]

你在csdn的搜索 中搜索ado.net 已经有很多类似的帖子了。

[F15Eagle]

Web.config文件中
<add key="CONNECTIONSTRING" value="user id=SYS;data source=XXGL;password=SYS"></add>

aspx.cs文件中
using System.Data.OracleClient;

OracleConnection MyConnection=new OracleConnection();
DataSet ds=new DataSet();
MyConnection.ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"].ToString();
MyConnection.Open();
OracleDataAdapter dr=new OracleDataAdapter("select * from XXJCB",MyConnection);
dr.Fill(ds);
MyConnection.Close();

以上代码针对oracle

[F15Eagle]

对，多搜点电子书看，或者去买本入门书，最好带光盘的，哈哈

[sunzhong2003]

sqlhelper

[wanwenpeng]

关注

[SassyBoy]

baidu.com

[sqllong]

using System.Data.SqlClient;
连接字符串最好写在Config文件中；
<configuration>
<appSettings>
<add key="SQLCONNECTIONSTRING" value="data source=.;uid=sa;pwd=sa;database=NorthWind"></add>
</appSettings>
</configuration>

取连接串的时候记得
using System.Configuration;

[sqllong]

SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"].ToString());