ASP.NET mssql server串連資料庫

asp教程.net mssql server串連資料庫教程
*/
public partial class _default : system.web.ui.page
{
  protected void page_load(object sender, eventargs e)
  {

  }
  protected void btn_sendmessage_click(object sender, eventargs e)
  {

  sqlconnection conn = new sqlconnection(@"sever = .sqlexpress;database=guestbook; trusted_connection=true");
  string sql = "insert into tbguestbook (username,posttime,message,isreplied,reply) values ('test','2006-11-1 12:00','www.111cn.net',0,'ac')";
  sqlcommand cmd = new sqlcommand (sql, conn);
  conn.open();
  cmd.executenonquery();
  conn.close();

  }
 
  //串連資料庫後再查詢資料
 
  private   void   page_load(object   sender,   system.eventargs   e)
{
 if(!ispostback)
 {
  string   myconnectstring   =   "server=localhost;uid=sa;database=manager ";
  sqlconnection   myconnection   =new   sqlconnection(myconnectstring);
  string   comstring   =   "select   *   from   newstudent ";
  sqlcommand   mycommand   =   new   sqlcommand(comstring,myconnection);
  mycommand.connection=myconnection;
  myconnection.open();
  dataset   ds=new   dataset();
  sqldataadapter   mydataadepter   =new   sqldataadapter(comstring,myconnection);
  mydataadepter.fill(ds, "newstudent ");
  
  datagrid1.datasource=ds.tables[ "newstudent "].defaultview;
  datagrid1.databind();
  datalist.datasource=ds.tables[ "newstudent "].defaultview;
  datalist.databind();
   }
}

//方法三

在vs中的web.config檔案裡面可以設定的，
<connectionstrings>
<add name="sqlconnectionstring" connectionstring="data source=pc-200909160824; initial catalog=shopping; integrated security=true"></add>
</connectionstrings>
data source是串連的資料來源，initial catalog是你要串連的資料庫名，integrated security說明你串連資料庫的方式為windows身分識別驗證
 %>