100分求一个常用的对数据库操作的类 微软的Data Access Application Blockhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/entlib.asp 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 http://spaces.msn.com/members/cobrastudio/偶在WEB设计中的一个IAdoNetBuilder接口的实际和实现。 http://dev.csdn.net/article/61/61208.shtm http://dev.csdn.net/develop/article/61/61208.shtm this's the chinese document of SqlHelperhttp://www.hidotnet.com/documents/sqlhelper/ 微软的Data Access Application Blockhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/entlib.asp 对呀 微软的SQLHelper就很好!!! 微软的SQLHelper这个怎么样啊??? 微软的SQLHelper怎么用呀,怎么加载?????????????????????? Data Access Application Block,数据访问模块http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.asp private void OpenOracleDataBase() { string strConn="ORACLE_CONNECTIONSTRING" value="Data Source=dlq;User Id=scott;Password=tiger;Max Pool Size = 512"; OracleConn=new OracleConnection(strConn); OracleConn.Open(); } private void CloseOracleDataBase() { OracleConn.Close(); } private void DisplayEmp() { OpenOracleDataBase(); string strSql="select empno as 员工编号,ename as 姓名,job as 工作 from emp"; OracleCommand ocomm=new OracleCommand(strSql,OracleConn); DataGrid1.DataSource=ocomm.ExecuteReader(); DataGrid1.DataBind(); CloseOracleDataBase(); } private void OracleData(string strSql) { OpenOracleDataBase(); OracleCommand OracleCmd=new OracleCommand("",OracleConn); OracleCmd.CommandText=strSql; OracleCmd.ExecuteNonQuery(); CloseOracleDataBase(); } private void btnAdd_Click(object sender, System.EventArgs e) { string strInset="insert into emp values(7777,'张三','PG',7789,'23-1月 -82',3500,12,10)"; OracleData(strInset); } private void btnNew_Click(object sender, System.EventArgs e) { DisplayEmp(); } private void btnDelete_Click(object sender, System.EventArgs e) { string strDelete="delete emp where empno=7777"; OracleData(strDelete); } private void btnUpDate_Click(object sender, System.EventArgs e) { string strUpDate="update emp set ename='张三' where empno=7777"; OracleData(strUpDate); } private void btnQuery_Click(object sender, System.EventArgs e) { OracleDataReader odrTemp; OpenOracleDataBase(); OracleCommand ocmdTemp=new OracleCommand("select ename from emp where empno="+Convert.ToInt32(txtID.Text.Trim())+"",OracleConn); odrTemp=ocmdTemp.ExecuteReader(); while(odrTemp.Read()) { txtName.Text=odrTemp.GetString(0); } CloseOracleDataBase(); } 我也想要 [email protected] 权限管理的实现 请教关于“写狗程序”的一些问题 前辈们 都来瞧瞧咯 vs.net2005的故障原因请教 100分求网站数据经上级管理员审核的问题, 有关计算器算法的问题?? System.Management名称空间为什么找不到?我用的是VS2003,.net Framework1.1 如何学C# 今天发傻,有个问题实在不明白,看这个 Encoding ASCII = Encoding.ASCII; 编程中遇到的几个难题,300分求救(问题解决后另外加分) MySQL.OleDb Provider 出现的问题 ,是不是它的bug。 如何根据数据库读取的值定位 ComboBox绑定的项?
http://www.hidotnet.com/documents/sqlhelper/
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/entlib.asp
微软的SQLHelper就很好!!!
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.asp
{
string strConn="ORACLE_CONNECTIONSTRING" value="Data Source=dlq;User Id=scott;Password=tiger;Max Pool Size = 512";
OracleConn=new OracleConnection(strConn);
OracleConn.Open();
}
private void CloseOracleDataBase()
{
OracleConn.Close();
}
private void DisplayEmp()
{
OpenOracleDataBase();
string strSql="select empno as 员工编号,ename as 姓名,job as 工作 from emp";
OracleCommand ocomm=new OracleCommand(strSql,OracleConn);
DataGrid1.DataSource=ocomm.ExecuteReader();
DataGrid1.DataBind();
CloseOracleDataBase();
} private void OracleData(string strSql)
{
OpenOracleDataBase();
OracleCommand OracleCmd=new OracleCommand("",OracleConn);
OracleCmd.CommandText=strSql;
OracleCmd.ExecuteNonQuery();
CloseOracleDataBase();
} private void btnAdd_Click(object sender, System.EventArgs e)
{
string strInset="insert into emp values(7777,'张三','PG',7789,'23-1月 -82',3500,12,10)";
OracleData(strInset);
} private void btnNew_Click(object sender, System.EventArgs e)
{
DisplayEmp();
} private void btnDelete_Click(object sender, System.EventArgs e)
{
string strDelete="delete emp where empno=7777";
OracleData(strDelete);
} private void btnUpDate_Click(object sender, System.EventArgs e)
{
string strUpDate="update emp set ename='张三' where empno=7777";
OracleData(strUpDate);
} private void btnQuery_Click(object sender, System.EventArgs e)
{
OracleDataReader odrTemp;
OpenOracleDataBase();
OracleCommand ocmdTemp=new OracleCommand("select ename from emp where empno="+Convert.ToInt32(txtID.Text.Trim())+"",OracleConn);
odrTemp=ocmdTemp.ExecuteReader();
while(odrTemp.Read())
{
txtName.Text=odrTemp.GetString(0);
}
CloseOracleDataBase();
}