01.using System;
02.using System.Data;
03.using System.Configuration;
04.using System.Collections;
05.using System.Web;
06.using System.IO;
07.using System.Data.SqlClient;
08.
09.namespace MyApp
10.{
11.
12. class DB
13. {
14. private SqlConnection objConn;
15. private SqlCommand objCmd;
16. private String strConnString;
17.
18. public DB()
19. {
20. strConnString = System.Configuration.ConfigurationSettings.AppSettings["SqlConnectionString"];
21. }
22.
23.
24. public DataSet dsDataSet(String strSQL)
25. {
26. DataSet ds = new DataSet();
27. SqlDataAdapter dtAdapter = new SqlDataAdapter();
28. objConn = new SqlConnection();
29. objConn.ConnectionString = strConnString;
30. objConn.Open();
31.
32. objCmd = new SqlCommand();
33. objCmd.Connection = objConn;
34. objCmd.CommandText = strSQL;
35. objCmd.CommandType = CommandType.Text;
36.
37. dtAdapter.SelectCommand = objCmd;
38. dtAdapter.Fill(ds);
39. return ds;
40. }
41.
42. public DataTable dtDataTable(String strSQL)
43. {
44. SqlDataAdapter dtAdapter;
45. DataTable dt = new DataTable();
46. objConn = new SqlConnection();
47. objConn.ConnectionString = strConnString;
48. objConn.Open();
49.
50. dtAdapter = new SqlDataAdapter(strSQL, objConn);
51. dtAdapter.Fill(dt);
52. return dt;
53. }
54.
55. public Boolean exExecuteNonQuery(String strSQL)
56. {
57. objConn = new SqlConnection();
58. objConn.ConnectionString = strConnString;
59. objConn.Open();
60.
61. try
62. {
63. objCmd = new SqlCommand();
64. objCmd.Connection = objConn;
65. objCmd.CommandType = CommandType.Text;
66. objCmd.CommandText = strSQL;
67.
68. objCmd.ExecuteNonQuery();
69. return true;
70. }
71. catch (Exception)
72. {
73. return false;
74. }
75. }
76.}
