ASP.NETÔõÑùconnectÊý¾Ý¿â£¬µ«ÊÇÊý¾Ý¿âÊÇ2000

ÏÖÔÚÊý¾Ý¿âÊÇ2000,connect to databaseµÄʱºò·¢ÏÖÌáʾThis server version is not supported¡£you must have Microsoft SQL server 2005 or later£¿

ÎÊÌâ1£ºÔõÑù²ÅÄܽ«ASP.NET²éѯµ½SQL2000Êý¾Ý¿âµÄÊý¾Ý

ÎÊÌâ2£ºÔõÑùÓÃDataGridView°ó¶¨Êý¾Ý¿â²éѯµÄ½á¹û¡£
²éѯÓï¾äÔõÑùд~£¿serverÊÇMIS£¬databaseÊÇstudent£¬tableÊÇinformation£¬Óû§ÃûÊÇsa£¬ÃÜÂëÊÇ123

---

Server=MIS;Database=student;UID=sa;PWD=123


DataGridView1.DataSounse=DataSet1;
DataGridView1.DataBind();

---

<add key="DBConnectionSql" value="server=(local);User ID=sa;Password=sa;database=TEST"/>
µ½connectionstrings.com¿´Á¬½Ó×Ö·û´®
DataTable dt=new DataTable();

DataGridView1.DataSounse=dt;

---

http://www.connectionstrings.com/sql-server
²»´í

---

ÒýÓÃ

http://www.connectionstrings.com/sql-server

Server=MIS;Database=student;User ID=sa;Password=123;

UP

---

<add key="DBConnectionSql" value="server=(local);User ID=sa;Password=sa;database=TEST"/>

---

ÒýÓÃ

<add key="DBConnectionSql" value="server=(local);User ID=sa;Password=sa;database=TEST"/>
µ½connectionstrings.com¿´Á¬½Ó×Ö·û´®
DataTable dt=new DataTable();

DataGridView1.DataSounse=dt;

°ÑÎÊÌâÈ«¸ø½â¾öÁË°¡

LZ³öÏÖµÄÎÊÌâÓ¦¸ÃÊÇWeb.Configµ÷ÓÃ×ÅĬÈϵÄ