必须申报一个机构，因为它不是抽象的？ [英] must declare a body because it is not abstract ?

问题描述

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 ..

推荐答案

在C＃中，您不必在使用它们之前为方法签名声明placemarker：您只需声明实际方法本身，编译器将为您排序。



你的方法都没有方法体，所以它们不能执行任何代码：这只能用于抽象类或接口，它们声明它们以确保任何派生类必须实现一个体。如果你试图这样做，那么你需要添加抽象关键字，如果没有，那么你需要在函数中添加一个主体，即使是作为方法的占位符，你将在以后充实：

In C# you do not have to declare a "placemarker" for your method signatures before you can use them: you just declare the actual method itself, and the compiler will sort it all out for you.

None of your methods have method bodies, so they cannot execute any code: This is only allowed with abstract classes or interfaces, which declare them to ensure that any derived classes must implement a body. If you are trying to do that, then you need to add the abstract keyword, if not, then you need to add a body to the function, even as a placeholder for a method you will "flesh out" later:

public sealed class SqlHelper
{

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

我猜你已经为SqlHelper引用了一个DLL，并且您尝试使用 F12（转到定义）查看定义。那里它只显示这个（定义）..

如果你想看到DLL的源代码，你可以使用反射器 [ ^ ]要查看...

I Guess You have been referencing a DLL for SqlHelper, and you tried to see the Definition using F12 (Go To Definition). there it will show like this ( definition) only..
If you want to see the source code of the DLL you can use reflector[^] to view...

要么将类设置为抽象，要么为类中的所有方法提供主体。

either set the class as abstract or provide body for all the methods in the class.

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...
}
}

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