C#的WebService
[WebMethod]
    public DataSet GetDataSetA()
    {
        SqlConnection mConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        SqlDataAdapter mAdapter = new SqlDataAdapter("Select * From Table1", mConn);
        DataSet mDataSet = new DataSet();
        try
        {
            mAdapter.Fill(mDataSet);
        }
        catch { }
        finally
        {
            mConn.Close();
            mConn.Dispose();
            mAdapter.Dispose();
        }
        return mDataSet;
    }