问题一:
我在Web.config文件里加了
<appSettings>
<add key="connectionString" value="server=localhost;database=hotop100;User ID=sa;Password="/>
</appSettings>
在Global.asax.cs文件的
protected void Application_Start(Object sender, EventArgs e)
{
}
里加入
StrDBConn=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
系统运行后提示如下错误:名称“StrDBConn”在类或命名空间“skcl.Global”中不存在
请问该怎么改?
问题二:
在配置文件里写好数据库连接文件后,我要在test.aspx页面里执行下面几个SQL语句,请问该怎么写?
sqlstring1="select * from clgl";
sqlstring2="insert into clgl(id,syr) values('1','2')";
sqlstring3="update clgl set id='2' where id='1'";
sqlstring4="delete clgl where id='1'";
我在Web.config文件里加了
<appSettings>
<add key="connectionString" value="server=localhost;database=hotop100;User ID=sa;Password="/>
</appSettings>
在Global.asax.cs文件的
protected void Application_Start(Object sender, EventArgs e)
{
}
里加入
StrDBConn=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
系统运行后提示如下错误:名称“StrDBConn”在类或命名空间“skcl.Global”中不存在
请问该怎么改?
问题二:
在配置文件里写好数据库连接文件后,我要在test.aspx页面里执行下面几个SQL语句,请问该怎么写?
sqlstring1="select * from clgl";
sqlstring2="insert into clgl(id,syr) values('1','2')";
sqlstring3="update clgl set id='2' where id='1'";
sqlstring4="delete clgl where id='1'";
Public SqlComm As new SqlCommand
SqlConn = New SqlConnection
SqlConn.ConnectionString = ConfigurationSettings.AppSettings("ConnectionString")
SqlComm.Connection = SqlConn
StrSQL="insert into clgl(id,syr) values('1','2')"
SqlComm.CommandText = StrSQL
SqlComm.ExecuteNonQuery()
Using System.Configuration
string StrDBConn=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
2.
SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
if(myConnection.State != ConnectionState.Open)
myConnection.Open();
SqlCommand cmd = new SqlCommand(query,myConnection);
cmd.ExecuteNonQuery();
myConnection.Close();记得加引用using System.Data.SqlClient;
===========改成
SqlConnection StrDBConn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
sqlstring1="select * from clgl";
SqlDataAdapter da = new SqlDataAdapter(sqlstring1,conn);
DataSet ds = new DataSet();
da.Fill(ds);2、
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
conn.Open();
sqlstring2="insert into clgl(id,syr) values('1','2')";
//sqlstring3="update clgl set id='2' where id='1'";
//sqlstring4="delete clgl where id='1'";
//第三句,第四句同
SqlCommand cmd = new SqlCommand(sqlstring2,conn);
cmd.ExecuteNonQuery();
conn.Close();
我在clsq.aspx.cs里加入using System.Data.SqlClient;然在其Page_Load里加入如下代码
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
if(myConnection.State != ConnectionState.Open)
myConnection.Open();
SqlCommand cmd = new SqlCommand("select * from clgl_clsq",myConnection);
cmd.ExecuteNonQuery();
myConnection.Close();
}
系统运行后提示如下:
异常详细信息: System.ArgumentException: 不支持关键字: “provider”。源错误:
行 51: {
行 52: // 在此处放置用户代码以初始化页面
行 53: SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
行 54: if(myConnection.State != ConnectionState.Open)
行 55: myConnection.Open();
源文件: d:\电厂\电厂系统\skcl\cldd\clsq.aspx.cs 行: 53 请问我这样写错在那里?
你写的那些语句是放在test.aspx里还是放在test.aspx.cs里?
SqlCommand cmd = new SqlCommand("insert into clgl(id,syr) values('1','2')",myConnection);要返回数据的话用
SqlDataAdapter da = new SqlDataAdapter("select * from clgl_clsq",myConnection);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
if(myConnection.State != ConnectionState.Open)
myConnection.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from clgl_clsq",myConnection);
DataSet ds = new DataSet();
da.Fill(ds);
系统运行后报错如下:
异常详细信息: System.ArgumentException: 不支持关键字: “provider”。源错误:
行 51: {
行 52: // 在此处放置用户代码以初始化页面
行 53: SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
行 54: if(myConnection.State != ConnectionState.Open)
行 55: myConnection.Open();
源文件: d:\电厂\电厂系统\skcl\cldd\clsq.aspx.cs 行: 53
报错的地方好象和后面的语句没关系,就在SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);这句出错,说是不支持关键字: “provider”。
Standard Security:"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
- or -
"Server=Aron1;Database=pubs;User ID=sa;Password=asdasd;Trusted_Connection=False"
(both connection strings produces the same result)
Trusted Connection:"Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
- or -
"Server=Aron1;Database=pubs;Trusted_Connection=True;"
(both connection strings produces the same result)(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
Connect via an IP address:"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
一、首先,在Web.config里加入了如下语句:
<appSettings>
<add key="ConnectionString" value="Provider=OraOLEDB.Oracle;Data Source=clgl;user=skcl;password=skcl;"></add>
</appSettings>
二、其次,在Global.aspx.cs和clsq.aspx.cs里加了using System.Data.SqlClient;
三、第三,在Global.aspx.cs的Application_Start里加了如下语句:
string myConnection=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
四、第四,在clsq.aspx.cs的Page_Load里加了如下语句:
SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
if(myConnection.State != ConnectionState.Open)
myConnection.Open();
SqlCommand cmd = new SqlCommand("select * from clgl_clsq",myConnection);
cmd.ExecuteNonQuery();
myConnection.Close();
五、系统运行后报错如下:
异常详细信息: System.ArgumentException: 不支持关键字: “provider”。源错误:
行 52: // 在此处放置用户代码以初始化页面
行 53:
行 54: SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
行 55: if(myConnection.State != ConnectionState.Open)
行 56: myConnection.Open();
源文件: d:\电厂\skcl\cldd\clsq.aspx.cs 行: 54
六、说明:我的数据库是Oracle805的。这里提示不支持关键字: “provider”。
SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);出错。请问到底哪里错了?不知道和Oracle版本有没有关系?