?????ù?VS2008??VS2010?????????????????????IDE???????????????????????SQL?????????SqlExpress???????????????????????????????????????????????????????Щ???????????????????????????SQL???????????????????????????????????????????????????????????????????????????????????????????????SQL???????????????ζ???????????
???????δ???????????????????????????ú?????????~~
???????????????????C#????????????????????????????????????????????????????????SQL??????…
???????????
???????????
string strconn;
strconn = "Data Source=(local);";
strconn += "Initial Catalog=student;";
strconn += "User ID=sa;";
strconn += "Password=;";
SqlConnection con = new SqlConnection(strconn); //???????????????????????
//SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=library;Integrated Security=True");    //????????????????????
con.Open();
SqlDataAdapter thisadapter = new SqlDataAdapter("select * from reader where ??????='" + txm + "'"?? con);
SqlCommandBuilder thisbuilder = new SqlCommandBuilder(thisadapter);
DataSet thisdataset = new DataSet();
thisadapter.Fill(thisdataset?? "reader");
…… //??????????????????
????????????????????????????????????…
???????????????????????????????????п??????????????????????????…????????????д??????????治??????????????????????????????????????????????μ????????????????????ο??????????????
????????????????????????????????????????Щ?????????????????????????????????????????
????????????
???????????
SqlConnectionStringBuilder connectstringbuilder = new SqlConnectionStringBuilder();
connectstringbuilder.DataSource = @"(local)/sqlexpress";   //???????????
connectstringbuilder.AttachDBFilename = @"|DataDirectory|/data/library.mdf"; //???????????????????????????????????
connectstringbuilder.IntegratedSecurity = true;
connectstringbuilder.UserInstance = true;
SqlConnection thisconnection = new SqlConnection(connectstringbuilder.ConnectionString);
SqlDataAdapter thisadapter = new SqlDataAdapter("select * from reader where ??????='" + txm + "'"?? thisconnection);
DataSet dt = new DataSet();
thisadapter.Fill(dt?? "info");
……  //??????????????????
???????????????е?????????????e??600M??MSSQL2000??????1G??MSSQL2005????????????????????SQL??????????????22M?????????????????????????????…
??????????????????????????????????????????????????е??????????????????????????????????Щ?????????Щ???????????仯?????????????????????????????????α??????????????е???????????????????????????????????????κ????????????????
????????????????????????????????
?????????????????????????????????????????????????????????…
????????????????????VS2008+MSSQL???????…??