Question

我想与我的伙伴关系中的服务器契约4.0联系起来。 NET应用软件。

守则的例子如下:

protected void Page_Load(object sender, EventArgs e)
{
    string connStr = "Data Source=D:\MyDB.sdf;";
    string sqlStr = "select * from tblMyTable";

    var sqlDataSrc = new SqlDataSource(connStr, sqlStr);

    GridWithUrls.DataSource = sqlDataSrc;
    GridWithUrls.DataBind();
}

But I have the next error: "A network-related or instance-specific error occurred while establishing a connection to SQL Server.The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"

The SqlDataSource has constructor with three parameters, one of them is providerName so, how to specify that I want definitely use Sql Server Compact provider ? Also I have added System.Data.SqlServerCe reference..

Answer 1

Try:

providerName = "System.Data.SqlServerCe.4.0"

Answer 2

将单一数据库文档(例如MySite.sdf)列入App_Data。

增加<条码>连接<条码>进入<条码>。

web.config:

<configuration>
   <connectionStrings>
      <add name="db" 
           connectionString="Data Source=|DataDirectory|MySite.sdf"
           providerName="System.Data.SqlServerCe.4.0" />
   </connectionStrings>
   ...
</configuration>

之后,你可以通过显示<条码>的链接(<><>>>><>条码>查询<>db>/strong>:

public static DbConnection CreateConnection()
{
   //Get connection string named "db"
   String csName = "db";
   ConnectionStringSettings cs = ConfigurationManager.ConnectionStrings[csName];
   if (cs == null)
      throw new ConfigurationErrorsException("Could not find connection string "" + csName + """);

   //Get a factory based on the "ProviderName" in the connection string
   DbProviderFactory factory = DbProviderFactories.GetFactory(cs.ProviderName);
   if (factory == null)
      throw new Exception("Unable to locate factory for " + cs.ProviderName);

   //Have the factory create us a connection object
   DbConnection conn = factory.CreateConnection();

   //Open the connection with the connection string from web.config
   conn.ConnectionString = cs.ConnectionString;
   conn.Open();

   //Give the ready connection to the user
   return conn;
}

<>:任何法规均公布于公共领域。不需要归属。

Answer 3

举一个例子:

http://linkionstrings.com/sql-server-2005-ce”rel=“nofollow> http://linkionstrings.com/sql-server-2005-ce。

如果你想明确指明地点:

Data Source=" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\MyDB.sdf;Persist Security Info=False;

Answer 4

您可以首先将数据输入数据表:

        using (SqlCeConnection c = new SqlCeConnection(
            Properties.Settings.Default.DataConnectionString))
        {
            c.Open();

            // Create new DataAdapter
            using (SqlCeDataAdapter a = new SqlCeDataAdapter(
                "SELECT * FROM tblMyTable", c))
            {

                // Use DataAdapter to fill DataTable
                DataTable t = new DataTable();
                a.Fill(t);

                // Render data onto the screen
                dataGridView1.DataSource = t;
            }
        }

友情链接