给一个在asp.net中用C#连接数据库的例子(100分)

我有不少这样的例子,在网上也能找到不少,但均不能用
谁有测试无误的例子,给我一个!感激不尽.

gz

先行者能不能进来帮一忙

up

http://www.aspxcn.com/dotnetdown/default.aspx?classid=1
那上面有不少

private string connstring = "Provider=msdaora;Data Source=db;Password=x;User ID=dba;";
OleDbConnection objConnection = new OleDbConnection(connstring);
OleDbCommand objCommand = new OleDbCommand("Select * From Table",objConnection);
objConnection.Open();
OleDbDataReader result = objCommand.ExecuteReader(CommandBehavior.CloseConnection);

private void ConnectionDataBase() //连接数据库。
{
// 创建ole连接,其中使用web.config作数据连接配置。
ConStr = ConfigurationSettings.AppSettings["ConnectionString"];
con = new OleDbConnection(ConStr);
//登录验证
public bool Longin(string UserAccount,string UserPassWord)
{

string QryStr;
object Count;
QryStr = "SELECT COUNT(*) FROM XTGL001 ";
QryStr = QryStr +" WHERE XTGL001001='"+UserAccount+"' ";
QryStr = QryStr +" AND XTGL001002 = '"+UserPassWord+"' ";
ConnectionDataBase();
OleDbCommand myCommand = new OleDbCommand(QryStr,con);
// Mark the Command as a Text
myCommand.CommandType = CommandType.Text;
con.Open();
Count= myCommand.ExecuteScalar();
...}

up

多人接受答案了。