本文介绍了必须申报一个机构,因为它不是抽象的?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

using System;
using System.Data;
using System.Data.SqlClient;
using System.Xml;

namespace DataAccessLayer
{
    public sealed class SqlHelper
    {

        public static SqlCommand CreateCommand(SqlConnection connection, string spName, params string[] sourceColumns);
        public static DataSet ExecuteDataset(SqlConnection connection, CommandType commandType, string commandText);
        public static DataSet ExecuteDataset(SqlConnection connection, string spName, params object[] parameterValues);
        public static DataSet ExecuteDataset(SqlTransaction transaction, CommandType commandType, string commandText);
        public static DataSet ExecuteDataset(SqlTransaction transaction, string spName, params object[] parameterValues);
        public static DataSet ExecuteDataset(string connectionString, CommandType commandType, string commandText);
        public static DataSet ExecuteDataset(string connectionString, string spName, params object[] parameterValues);
        public static DataSet ExecuteDataset(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
        public static DataSet ExecuteDataset(SqlTransaction transaction, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
        public static DataSet ExecuteDataset(string connectionString, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
        public static DataSet ExecuteDatasetTypedParams(SqlConnection connection, string spName, DataRow dataRow);
        public static DataSet ExecuteDatasetTypedParams(SqlTransaction transaction, string spName, DataRow dataRow);
        public static DataSet ExecuteDatasetTypedParams(string connectionString, string spName, DataRow dataRow);
        public static int ExecuteNonQuery(SqlConnection connection, CommandType commandType, string commandText);
        public static int ExecuteNonQuery(SqlConnection connection, string spName, params object[] parameterValues);
        public static int ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, string commandText);
        public static int ExecuteNonQuery(SqlTransaction transaction, string spName, params object[] parameterValues);
        public static int ExecuteNonQuery(string connectionString, CommandType commandType, string commandText);
        public static int ExecuteNonQuery(string connectionString, string spName, params object[] parameterValues);
        public static int ExecuteNonQuery(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
        public static int ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
        public static int ExecuteNonQuery(string connectionString, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
        public static int ExecuteNonQueryTypedParams(SqlConnection connection, string spName, DataRow dataRow);
        public static int ExecuteNonQueryTypedParams(SqlTransaction transaction, string spName, DataRow dataRow);
        public static int ExecuteNonQueryTypedParams(string connectionString, string spName, DataRow dataRow);
        public static SqlDataReader ExecuteReader(SqlConnection connection, CommandType commandType, string commandText);
        public static SqlDataReader ExecuteReader(SqlConnection connection, string spName, params object[] parameterValues);
        public static SqlDataReader ExecuteReader(SqlTransaction transaction, CommandType commandType, string commandText);
        public static SqlDataReader ExecuteReader(SqlTransaction transaction, string spName, params object[] parameterValues);
        public static SqlDataReader ExecuteReader(string connectionString, CommandType commandType, string commandText);
        public static SqlDataReader ExecuteReader(string connectionString, string spName, params object[] parameterValues);
        public static SqlDataReader ExecuteReader(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
        public static SqlDataReader ExecuteReader(SqlTransaction transaction, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
        public static SqlDataReader ExecuteReader(string connectionString, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
        public static SqlDataReader ExecuteReaderTypedParams(SqlConnection connection, string spName, DataRow dataRow);
        public static SqlDataReader ExecuteReaderTypedParams(SqlTransaction transaction, string spName, DataRow dataRow);
        public static SqlDataReader ExecuteReaderTypedParams(string connectionString, string spName, DataRow dataRow);
        public static object ExecuteScalar(SqlConnection connection, CommandType commandType, string commandText);
        public static object ExecuteScalar(SqlConnection connection, string spName, params object[] parameterValues);
        public static object ExecuteScalar(SqlTransaction transaction, CommandType commandType, string commandText);
        public static object ExecuteScalar(SqlTransaction transaction, string spName, params object[] parameterValues);
        public static object ExecuteScalar(string connectionString, CommandType commandType, string commandText);
        public static object ExecuteScalar(string connectionString, string spName, params object[] parameterValues);
        public static object ExecuteScalar(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
        public static object ExecuteScalar(SqlTransaction transaction, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
        public static object ExecuteScalar(string connectionString, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
        public static object ExecuteScalarTypedParams(SqlConnection connection, string spName, DataRow dataRow);
        public static object ExecuteScalarTypedParams(SqlTransaction transaction, string spName, DataRow dataRow);
        public static object ExecuteScalarTypedParams(string connectionString, string spName, DataRow dataRow);
        public static XmlReader ExecuteXmlReader(SqlConnection connection, CommandType commandType, string commandText);
        public static XmlReader ExecuteXmlReader(SqlConnection connection, string spName, params object[] parameterValues);
        public static XmlReader ExecuteXmlReader(SqlTransaction transaction, CommandType commandType, string commandText);
        public static XmlReader ExecuteXmlReader(SqlTransaction transaction, string spName, params object[] parameterValues);
        public static XmlReader ExecuteXmlReader(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
        public static XmlReader ExecuteXmlReader(SqlTransaction transaction, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
        public static XmlReader ExecuteXmlReaderTypedParams(SqlConnection connection, string spName, DataRow dataRow);
        public static XmlReader ExecuteXmlReaderTypedParams(SqlTransaction transaction, string spName, DataRow dataRow);
        public static void FillDataset(SqlConnection connection, CommandType commandType, string commandText, DataSet dataSet, string[] tableNames);
        public static void FillDataset(SqlConnection connection, string spName, DataSet dataSet, string[] tableNames, params object[] parameterValues);
        public static void FillDataset(SqlTransaction transaction, CommandType commandType, string commandText, DataSet dataSet, string[] tableNames);
        public static void FillDataset(SqlTransaction transaction, string spName, DataSet dataSet, string[] tableNames, params object[] parameterValues);
        public static void FillDataset(string connectionString, CommandType commandType, string commandText, DataSet dataSet, string[] tableNames);
        public static void FillDataset(string connectionString, string spName, DataSet dataSet, string[] tableNames, params object[] parameterValues);
        public static void FillDataset(SqlConnection connection, CommandType commandType, string commandText, DataSet dataSet, string[] tableNames, params SqlParameter[] commandParameters);
        public static void FillDataset(SqlTransaction transaction, CommandType commandType, string commandText, DataSet dataSet, string[] tableNames, params SqlParameter[] commandParameters);
        public static void FillDataset(string connectionString, CommandType commandType, string commandText, DataSet dataSet, string[] tableNames, params SqlParameter[] commandParameters);
        public static void UpdateDataset(SqlCommand insertCommand, SqlCommand deleteCommand, SqlCommand updateCommand, DataSet dataSet, string tableName);
    }

}







i我收到此错误请帮帮我如何避免这个错误..



必须声明一个正文,因为它不是抽象的..




i am getting this error "please help me" how to avoid this error..

must declare a body because it is not abstract ..

推荐答案

public sealed class SqlHelper
{

    public static SqlCommand CreateCommand(SqlConnection connection, string spName, params string[] sourceColumns) {}
    ...



public abstract class SqlHelper
{

        public static SqlCommand CreateCommand(SqlConnection connection, string spName, params string[] sourceColumns);
}

or

public sealed class SqlHelper
{

        public static SqlCommand CreateCommand(SqlConnection connection, string spName, params string[] sourceColumns)
{
//method body goes here...
}
}


这篇关于必须申报一个机构,因为它不是抽象的?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-22 19:14
查看更多