Question

asp.net如何将textbox中的值插入oracle数据库？

当我用asp.net通过textbox向oracle数据库中插入数据的时候总是报不支持关键字: “provider”。请问问题在哪里，我该如何解决？下面是我的cs代码public partial class writepassage : System.Web.UI.Page{ protected void InsertData() { string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlConnection conn = new SqlConnection(connStr); conn.Open(); string sqlStr = string.Format("insert into mypage(name, author, contents) values(\"{0}\", \"{1}\", \"{2}\")", txtMytitle.Text, txtAuthor.Text, txtContent.Text); string sqlStr1 = "commit"; SqlCommand comm = new SqlCommand(sqlStr, conn); SqlCommand comm1 = new SqlCommand(sqlStr1, conn); comm.ExecuteScalar(); comm1.ExecuteScalar(); conn.Close(); }protected void btnCommit_Click(object sender, EventArgs e) //Provider=MSDAORA; { InsertData(); }}我的连接字符串如下：connectionString="Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;Password=oracle;User ID=zhangzhicheng" providerName="System.Data.OleDb"





Answer 1

SqlConnection,SqlCommand之类是针对sqlserver的，oracle的要下载相应的类库，到oracle官网去下载Oracle Data Provider for .NET (ODP.NET)

追问

请问，不用sqlconnection之类的，我该怎么配置呢？

追答

下载库啊