是不是这个的错
<add name="POCConnectionStringExp"
connectionString="Data Source=.;AttachDbFilename=|DataDirectory|\Data\POC.mdf;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
AttachDbFilename这个地方错了嘛?如果是的话,怎么解决呢?谢谢!
哦,对了
代码里没有附加的语句
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;namespace CallApp
{
public class RunDataSet
{
// Static constants
private const string SQL_SELECT = "SELECT * FROM Activity_History WHERE ActivityType = 11"; /// <summary>
/// Get all requests
/// </summary>
/// <returns></returns>
public static DataSet GetRunList()
{
SqlCommand cmd = new SqlCommand(); //Open a connection
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
{ StringBuilder strSQL = new StringBuilder(); strSQL.Append(SQL_SELECT); // Open the connection
conn.Open(); //Set up the command
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = strSQL.ToString(); //Execute the query
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet(); adapter.Fill(ds, "ACTIVITY_HISTORY"); return ds;
}
}
}
}
<add name="POCConnectionStringExp"
connectionString="Data Source=.;AttachDbFilename=|DataDirectory|\Data\POC.mdf;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
AttachDbFilename这个地方错了嘛?如果是的话,怎么解决呢?谢谢!
哦,对了
代码里没有附加的语句
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;namespace CallApp
{
public class RunDataSet
{
// Static constants
private const string SQL_SELECT = "SELECT * FROM Activity_History WHERE ActivityType = 11"; /// <summary>
/// Get all requests
/// </summary>
/// <returns></returns>
public static DataSet GetRunList()
{
SqlCommand cmd = new SqlCommand(); //Open a connection
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
{ StringBuilder strSQL = new StringBuilder(); strSQL.Append(SQL_SELECT); // Open the connection
conn.Open(); //Set up the command
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = strSQL.ToString(); //Execute the query
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet(); adapter.Fill(ds, "ACTIVITY_HISTORY"); return ds;
}
}
}
}
connectionString= "Data Source=.;uid=xxx;password=xxx;database=xx " providerName= "System.Data.SqlClient "/> 之类这种方式
<add name="POCConnectionStringExp"
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=H:\Work\Projects\POC\Code\Call_Project\CallApp\CallApp\POC.mdf;;Initial Catalog=POC;Integrated Security=True"
providerName="System.Data.SqlClient" />
所以一定是要附加的,但是只要指定了数据库名的话,如果这个库已经存储在了,那么就不会附加了
同时再指定Data Source=.\SQLEXPRESS就只会在sqlexpress下附加了