aspx页面写数据库连接connectionstring怎么写?

你好!我用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");