当前文件路径：OfficeOnline/App_Code/WebService.cs

		            
 1using System;
 2using System.Web;
 3using System.Collections;
 4using System.Web.Services;
 5using System.Data;
 6using System.Data.Common;
 7using System.Web.Services.Protocols;
 8
 9
10/**//// <summary>
11/// WebService 的摘要说明
12/// </summary>
13[WebService(Namespace = "http://tempuri.org/")]
14[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
15public class WebService : System.Web.Services.WebService ...{
16
17    public WebService () ...{
18
19        //如果使用设计的组件，请取消注释以下行 
20        //InitializeComponent(); 
21
22    }
23    string strConn = System.Configuration.ConfigurationManager.AppSettings["51aspxConn"];
24
25    [WebMethod]
26    public bool HasName(string strSql)
27    ...{
28       // string strConn = "Data Source=(local);Initial Catalog=OfficeOnline;User ID=sa;Password=sa";
29        DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactory("System.Data.SqlClient");
30        DbConnection dbConn = dbProviderFactory.CreateConnection();
31        dbConn.ConnectionString = strConn;
32        dbConn.Open();
33        DbCommand dbComm = dbProviderFactory.CreateCommand();
34        dbComm.Connection = dbConn;
35        dbComm.CommandText = strSql;
36        DbDataReader reader = dbComm.ExecuteReader();
37        return reader.Read();
38    }
39    public void ExcuteSql(string strSql)
40    ...{
41        //string strConn = "Data Source=(local);Initial Catalog=OfficeOnline;User ID=sa;Password=sa";
42        DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactory("System.Data.SqlClient");
43        DbConnection dbConn = dbProviderFactory.CreateConnection();
44        dbConn.ConnectionString = strConn;
45        dbConn.Open();
46        DbCommand dbComm = dbProviderFactory.CreateCommand();
47        dbComm.Connection = dbConn;
48        dbComm.CommandText = strSql;
49        dbComm.ExecuteNonQuery();
50        dbConn.Close();
51        dbConn.Dispose();
52    }
53    public DataTable ExcuteSelect(string strSql)
54    ...{
55        //string strConn = "Data Source=(local);Initial Catalog=OfficeOnline;User ID=sa;Password=sa";
56        DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactory("System.Data.SqlClient");
57        DbConnection dbConn = dbProviderFactory.CreateConnection();
58        dbConn.ConnectionString = strConn;
59        dbConn.Open();
60        DbCommand dbComm = dbProviderFactory.CreateCommand();
61        dbComm.Connection = dbConn;
62        dbComm.CommandText = strSql;
63        DbDataAdapter adapter = dbProviderFactory.CreateDataAdapter();
64        adapter.SelectCommand = dbComm;
65        DataSet dsDataSet = new DataSet();
66        adapter.Fill(dsDataSet, "table");
67        return dsDataSet.Tables["table"];
68    }
69    
70}
71
72