从索引 0 处开始,初始化字符串的格式不符合规范
以下为代码:运行时,在OracleConnection cn = new OracleConnection("Common.Class1.ConnectString");出现异常:从索引 0 处开始,初始化字符串的格式不符合规范。using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OracleClient;
namespace DataAccess
{
public class Class1
{
OracleConnection cn = new OracleConnection("Common.Class1.ConnectString");
OracleDataAdapter da;
DataSet ds = new DataSet();
public DataSet getUsers( )
{
OracleCommand cmd = new OracleCommand(Common.Class1.Oracle_getUser, cn);
da = new OracleDataAdapter(cmd);
da.Fill(ds,Common .Class1.table_Users );
return ds;
}
}
}
请高手帮忙解答,谢谢。我用的数据库是oracle. --------------------编程问答-------------------- OracleConnection cn = new OracleConnection(Common.Class1.ConnectString);
Common.Class1.ConnectString不要加引号
--------------------编程问答-------------------- "Common.Class1.ConnectString"
错误 --------------------编程问答--------------------
--------------------编程问答--------------------
ConnectString本来就是个字符串吧 不用加"" --------------------编程问答-------------------- 把引号去掉了,再次运行时又出现:不支持关键字: “database”。
是指common层里的代码吗?
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace Common
{
public class Class1
{
//cn
public const String ConnectString = "server=localhost;database=xBlog;uid=adotest;password=adotest";
//Oracle
public const String Oracle_getUser = "select *from Users";
//table
public const String table_Users = "Users";
//storedprocedure
}
} --------------------编程问答-------------------- Oracle的连接字符串好象是用Data Source而不是Database吧 --------------------编程问答-------------------- Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;
Data Source=myOracle;User Id=myUsername;Password=myPassword;Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;Incr Pool Size=5;Decr Pool Size=2; --------------------编程问答-------------------- 谢谢,我已经解决了。
补充:.NET技术 , C#