Advertisement
Guest User

Untitled

a guest
May 27th, 2016
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. [WebMethod]
  2. public ArrayList Read_FarmName(int TitleID)
  3. {
  4. SqlConnection cn = new SqlConnection();//連接資料庫
  5. string comBoxPlace = "";//設定參數
  6. ArrayList alt = new ArrayList();//宣告資料格式
  7. cn.ConnectionString = "server=IP位置;uid=帳號;pwd=密碼;database=資料庫名稱";//伺服器連接資料
  8. cn.Open();//開啟資料庫
  9. SqlCommand cmd = new SqlCommand("SELECT 欄位 FROM 資料表 Where TitleID=@TitleID", cn);//資料庫指令
  10. //輸入條件(SELECT是選擇),設定特定條件
  11. cmd.Parameters.AddWithValue("@TitleID",TitleID);//選擇置入
  12. SqlDataReader reader = cmd.ExecuteReader();//讀取器
  13. while (reader.Read())//將某特地條件資料拿取
  14. {
  15. comBoxPlace += reader["Id"].ToString() + ",";//把讀出值放入
  16. }
  17. reader.Close();//關閉讀取
  18. cmd.Parameters.Clear();//清空紀錄
  19. cn.Close();//資料庫關閉
  20. return alt; //將結果回傳
  21. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement