你好!我用vs2012开发mvc4程序,其中用到了aspx页面,后台数据库就是sqllocaldb
现在我在系统的odbc也配好了,名字就叫sqllocaldb,请问在aspx里怎么写connectionstring?
string ConnectString = "Data Source=sqllocaldb";
SqlConnection con = null;
SqlCommand cmd = null;
SqlDataReader str = null;
try
{
con = new SqlConnection(ConnectString);
//连接到数据库
cmd = con.CreateCommand();
cmd.CommandText = "select SalesId, SalesName,SalesPhone,SalesEmail from SalesTable";
//T-SQL语句
con.Open();
//创建连接后需要用Open打开连接,结束后要关闭连接,及时释放资源
str = cmd.ExecuteReader();