ASP.NET出错 从索引 0 处开始，初始化字符串的格式不符合规范

[Yami365]

代码片断：

	/// <summary>
	/// 创建并准备基于新连接的Dbcommand对象
	/// </summary>
	/// <returns>Dbcommand</returns>
	public static DbCommand CreateCommand()
	{
		//从配置文件获取数据库连接类型和数据库连接字符串
		string dataProviderName = SiteConfiguration.DbProviderName;
		string connectionString = SiteConfiguration.DbConnectionString;

		// 创建数据库访问工厂
		DbProviderFactory factory = DbProviderFactories.GetFactory(dataProviderName);
		//获取连接对象
		DbConnection conn = factory.CreateConnection();
		//设置连接字符串
		conn.ConnectionString = connectionString; //----------这里出错

		DbCommand comm = conn.CreateCommand();
		comm.CommandType = CommandType.StoredProcedure;

		return comm;
	}

这里的connectionString 是从SiteConfiguration.DbConnectionString获取到的，SiteConfiguration.DbConnectionString代码片断如下：

    static SiteConfiguration()
	{
		dbConnectionString = ConfigurationManager.ConnectionStrings["SiteConnection"].ConnectionString;
		dbProviderName = ConfigurationManager.ConnectionStrings["SiteConnection"].ProviderName;
	}

	// 返回数据库连接字符串
	public static string DbConnectionString
	{
		get
		{
			return dbConnectionString;
		}
	}

webconfig代码片断是：

	<connectionStrings>
		<add name="SiteConnection" connectionString="Server=(local)\SQLEXPRESS;Database=BalloonShop;User:balloonshop;Password:ecommerce" providerName="System.Data.SqlClient"/>
	</connectionStrings>

[IHandler]

User:balloonshop;Password:ecommerce改
uid=balloonshop;pwd=ecommerce
呢

[Yami365]

改了还是一样

[xray2005]

注意你的SiteConnection，后面似乎有多余的空格。

修改为：
<connectionStrings>
<add name= "SiteConnection" connectionString= "Server=(local)\SQLEXPRESS;Database=BalloonShop;user id=balloonshop;password=ecommerce" providerName= "System.Data.SqlClient"/>
</connectionStrings>


dbConnectionString = ConfigurationManager.ConnectionStrings[ "SiteConnection"].ConnectionString;
dbProviderName = ConfigurationManager.ConnectionStrings[ "SiteConnection"].ProviderName;

[皇城龙三]

connectionString= "Server=(local)\SQLEXPRESS;Database=BalloonShop;User:balloonshop;Password:ecommerce "


还是这句话有问题，server改成ip地址

还有测试一下balloonshop用户的连通性，用数据库自带的测试先连接一下

还有就是ecommerce后面那个空格去掉

应该是没有找到你的数据库文件的路径

[Yami365]

谢谢各位，的确是空格的问题，是我太粗心了，我结贴