2.サーバの接続（ADO.CSを新規する）

1. using System;
2. using System.Data;
3. using System.Configuration;
4. using System.Web;
5. using System.Web.Security;
6. using System.Web.UI;
7. using System.Web.UI.WebControls;
8. using System.Web.UI.WebControls.WebParts;
9. using System.Web.UI.HtmlControls;
10. using System.Data.SqlClient;
13. /// <summary>
14. /// サーバを連結する
15. /// </summary>
16. public class ADO
17. {
18.     public ADO()
19.     {
20.         //
21.         // TODO: コンストラクタ ロジックをここに追加します
22.         //
23.     }
25.     public SqlConnection connect = null;
26.     public SqlCommand command = null;
27.     public SqlDataAdapter adapter = null;
28.     /// <summary>
29.     /// OPEN() 開ける 
30.     /// </summary>
31.     public void open()
32.     {
33.         string connectstring = ConfigurationManager.ConnectionStrings["LINConnectionString"].ConnectionString;
34.         connect = new SqlConnection(connectstring);
35.         //if(connect.State == ConnectionState.Closed)
36.         connect.Open();
37.     }
40.     /// <summary>
41.     /// CLOSE()閉じる
42.     /// </summary>
43.     public void close()
44.     {
45.         //if(connect.State == ConnectionState.Open)
46.         connect.Close();
47.     }
51.     /// <summary>
52.     /// 検索select
53.     /// </summary>
54.     /// <param name="SqlText"></param>
55.     /// <param name="parmeters"></param>
56.     /// <returns></returns>
57.     public DataSet GetDataSet(string SqlText, params SqlParameter[] parameters)
58.     {
59.         DataSet ds = new DataSet();
60.         open();
61.         command = new SqlCommand(SqlText, connect);
62.         foreach (SqlParameter par in parameters)
63.         {
64.             command.Parameters.AddWithValue(par.ToString(), par.Value);
66.         }
67.         adapter = new SqlDataAdapter(command);
68.         adapter.Fill(ds);
69.         close();
70.         return ds;
71.     }
72.     /// <summary>
73.     /// 挿入(インサート)insert, 更新updata,削除delete
74.     /// </summary>
75.     /// <param name="SqlText"></param>
76.     /// <param name="parmeters"></param>
77.     /// <returns></returns>
79.     public int ExecuteNonQuery(string sqlText, params SqlParameter[] parameters)
80.     {
81.         int num = 0;
82.         command = new SqlCommand(sqlText);
83.         open();
84.         command.Connection = connect;
85.         SqlTransaction trans = connect.BeginTransaction();
86.         command.Transaction = trans;
87.         try
88.         {
89.             foreach (SqlParameter parameter in parameters)
90.             {
91.                 command.Parameters.AddWithValue(parameter.ToString(), parameter.Value);
92.             }
93.             num = command.ExecuteNonQuery();
94.         // コミット
95.             trans.Commit();
96.         }
97.         catch (SqlException ex)
98.         {
99.         //ロールバック
100.             trans.Rollback();
101.             //throw new Exception("GetListId(3)にて例外が発生しました" + ex.Message, ex);
102.             
103.         }
104.         finally
105.         {
106.             close();
107.         }
109.         return num;
110.     }
111. }
113.