01.namespace TORServices.TestInterface
02.{
03. public interface iDatabase
04. {
05. System.Data.DataRow Datarow(string sql);
06. System.Data.DataTable Datatable(string sql);
07. }
08. public class DataODBC : iDatabase
09. {
10. public string ConnectionString;
11. public DataODBC(string connStr) { ConnectionString = connStr; }
12. public System.Data.Odbc.OdbcConnection OdbcConnection(string connectionString = "")
13. {
14. System.Data.Odbc.OdbcConnection con = new System.Data.Odbc.OdbcConnection(connectionString);
15. try { con.Open(); return con; }
16. catch (Exception ex) { throw ex; }
17. }
18. public System.Data.DataRow Datarow(string sql, int rowIndax = 0)
19. {
20. System.Data.DataTable dt = Datatable(sql);
21. return (dt != null) ? dt.Rows[0] : null;
22. }
23. public System.Data.DataTable Datatable(string sql)
24. {
25. try
26. {
27. System.Data.DataSet ds = new System.Data.DataSet();
28. System.Data.Odbc.OdbcDataAdapter adapter1 = new System.Data.Odbc.OdbcDataAdapter(sql, OdbcConnection(ConnectionString));
29. adapter1.Fill(ds);
30. return ds.Tables[0];
31. }
32. catch { return null; }
33. }
34. }
35. public class DataOleDb : iDatabase
36. {
37. public string ConnectionString;
38. public DataOleDb(string connStr) { ConnectionString = connStr; }
39. public System.Data.OleDb.OleDbConnection OleDbConnection(string connectionString = "")
40. {
41. System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(connectionString);
42. try { con.Open(); return con; }
43. catch (Exception ex) { throw ex; }
44. }
45. public System.Data.DataRow Datarow(string sql, int rowIndax = 0)
46. {
47. System.Data.DataTable dt = Datatable(sql);
48. return (dt != null) ? dt.Rows[0] : null;
49. }
50. public System.Data.DataTable Datatable(string sql)
51. {
52. try
53. {
54. System.Data.DataSet ds = new System.Data.DataSet();
55. System.Data.OleDb.OleDbDataAdapter adapter1 = new System.Data.OleDb.OleDbDataAdapter(sql, this.OleDbConnection(ConnectionString));
56. adapter1.Fill(ds);
57. return ds.Tables[0];
58. }
59. catch { return null; }
60. }
61. }
62. public class DataSqlClient : iDatabase
63. {
64. public string ConnectionString;
65. public DataSqlClient(string connStr) { ConnectionString = connStr; }
66. public System.Data.SqlClient.SqlConnection SqlConnection(string connectionString = "")
67. {
68. System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(connectionString);
69. try { con.Open(); return con; }
70. catch (Exception ex) { throw ex; }
71. }
72. System.Data.DataRow Datarow(string sql, int rowIndax = 0)
73. {
74. System.Data.DataTable dt = Datatable(sql);
75. return (dt != null) ? dt.Rows[0] : null;
76. }
77. System.Data.DataTable Datatable(string sql)
78. {
79. try
80. {
81. System.Data.DataSet ds = new System.Data.DataSet();
82. System.Data.SqlClient.SqlDataAdapter adapter1 = new System.Data.SqlClient.SqlDataAdapter(sql, SqlConnection(ConnectionString));
83. adapter1.Fill(ds);
84. return ds.Tables[0];
85. }
86. catch { return null; }
87. }
88. }
89.
90.
91.}
ถ้าโปรแกรมมีขนาดไม่เกินแสนบรรทัด ก็ไม่มีประโยชน์อะไร 
