本文介绍了必须申报一个机构,因为它不是抽象的?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
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...
}
}
这篇关于必须申报一个机构,因为它不是抽象的?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!