你好!我用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();
using System.Data.Odbc;
var con = new OdbcConnection();
if (con != null)
con.Close();
try
{
con.ConnectionString =
"Dsn=sqllocaldb;" +
"Uid=;" +
"Pwd=;";
//连接到数据库
con.Open();
var cmd = con.CreateCommand();
cmd.CommandText = "select SalesId, SalesName,SalesPhone,SalesEmail from SalesTable";
var str = cmd.ExecuteReader();
using System.Data.SqlClient;
SqlConnection conn = new SqlConnection();
conn.ConnectionString =
"Data Source=ServerName;" +
"Initial Catalog=DataBaseName;" +
"User id=UserName;" +
"Password=Secret;";
conn.Open();
其中ServerName、DataBaseName、UserName、Secret根据情况输入具体值
没有用户名和密码的,是Windows集成安全口令的。
odbc建好后,也需要写用户名和密码吗?
用OdbcConnection
https://msdn.microsoft.com/zh-cn/library/system.data.odbc(VS.80).aspx
odbc驱动
https://msdn.microsoft.com/zh-cn/library/system.data.odbc.odbcconnection.connectionstring(v=vs.110).aspx
System.Data.Odbc.OdbcConnection con = new System.Data.Odbc.OdbcConnection("DSN=sqllocaldb");