Tengo un problema de insertar unos datos en una base de datos en SQL, estoy trabajando con asp.net.
Hago la conexión y muestra los datos y todo, pero cuando mando a insertar me da un error con EXECUTENONQUERY(), me dice que debo hacer una consulta actulizable y alli se queda.
Por favor si alguien sabe como puedo solucionar este error, se lo agradecería o si tiene el código de ese pedazo donde inserto datos en una BD.
Gracias de antemano,
Codigo...
__________________________________________________ __________________________________________________ ____________
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class Resultado : System.Web.UI.Page
{
DataSet ds = new DataSet();
SqlConnection con;
//Here we declare the parameter which we have to use in our application
SqlCommand cmd = new SqlCommand();
SqlParameter sp1 = new SqlParameter();
SqlParameter sp2 = new SqlParameter();
SqlParameter sp3 = new SqlParameter();
SqlParameter sp4 = new SqlParameter();
SqlParameter sp5 = new SqlParameter();
SqlParameter sp6 = new SqlParameter();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
con = new SqlConnection("Data Source=cscsql1\\cscmsqlvs1; database=FEM_Auditoria;Integrated Security=True");
cmd = new SqlCommand("Resultados", con);
cmd.Parameters.Add("@Nomb_UN", SqlDbType.VarChar).Value = Nomb_UN.SelectedItem.Text;
cmd.Parameters.Add("@Nomb_UO", SqlDbType.VarChar).Value = Nomb_UO.SelectedItem.Text;
cmd.Parameters.Add("@Nomb_Pais", SqlDbType.VarChar).Value = Nomb_Pais.SelectedItem.Text;
cmd.Parameters.Add("@Usuario", SqlDbType.VarChar).Value = Usuario.SelectedItem.Text;
cmd.Parameters.Add("@Fecha", SqlDbType.VarChar).Value = Fecha.SelectedDate.Date;
cmd.Parameters.Add("@Mes", SqlDbType.VarChar).Value = Mes.SelectedItem.Text;
cmd.Parameters.Add("@Hora", SqlDbType.VarChar).Value = Hora.SelectedItem.Text;
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
Server Error in '/Control de Tiempos' Application.
--------------------------------------------------------------------------------
The request for procedure 'Resultados' failed because 'Resultados' is a view object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: The request for procedure 'Resultados' failed because 'Resultados' is a view object.
Source Error:
Line 41: cmd.CommandType = CommandType.StoredProcedure;
Line 42: con.Open();
Line 43: cmd.ExecuteNonQuery();
Line 44: con.Close();
Line 45: }
Source File: d:\My Documents\AI\2009\Control de Tiempos\Miembros\Resultados.aspx.cs Line: 43
Stack Trace:
[SqlException (0x80131904): The request for procedure 'Resultados' failed because 'Resultados' is a view object.]
System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection) +177
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +68
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +199
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2300
System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +147
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1021
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +314
System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +413
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +115
Resultado.Button1_Click(Object sender, EventArgs e) in d:\My Documents\AI\2009\Control de Tiempos\Miembros\Resultados.aspx.cs:43
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +75
System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +97
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4919
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
Respuesta: No inserta Datos en Base de Datos 
