Respuesta: Error al convertir el valor del parámetro de SqlParameter a Int32 Quiero insertar filas a un tabla
estoy usando el sqlhelper:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Xml;
namespace Microsoft.ApplicationBlocks.Data
{
public sealed class SqlHelper
{
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 DataTable ExecuteDataTable(SqlConnection connection, CommandType commandType, string commandText);
public static DataTable ExecuteDataTable(SqlConnection connection, string spName, params object[] parameterValues);
public static DataTable ExecuteDataTable(SqlTransaction transaction, CommandType commandType, string commandText);
public static DataTable ExecuteDataTable(SqlTransaction transaction, string spName, params object[] parameterValues);
public static DataTable ExecuteDataTable(string connectionString, CommandType commandType, string commandText);
public static DataTable ExecuteDataTable(string connectionString, string spName, params object[] parameterValues);
public static DataTable ExecuteDataTable(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
public static DataTable ExecuteDataTable(SqlTransaction transaction, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
public static DataTable ExecuteDataTable(string connectionString, CommandType commandType, string commandText, params SqlParameter[] commandParameters);
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 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 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 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);
}
} |