C# - Error When Executing A Stored Proc

Aug 17, 2010

I am attempting to execute a stored proc in asp.net in the code behind. The parameter I am trying to pass is strErrorMessage that contains a value of "The transport failed to connect to the server.; ". The error message when the query gets executed is: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 ("@errMessage"): Data type 0xE7 has an invalid data length or metadata length. Update with code

try
{
...
...
...
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Email was not sent - " + ex.Message + "');", true);
string strMessage = ex.Message;
string strStackTrace = ex.StackTrace;
strMessage = strMessage.Replace("
", "; ");
strMessage = strMessage.Replace(" ", "");
strStackTrace = strStackTrace.Replace("
", "; ");
strStackTrace = strStackTrace.Replace(" ", "");
AppErrorLog(strMessage, strStackTrace);
return false;
}
protected void AppErrorLog(string strErrorMessage, string strErrorStackTrace)
{
SqlConnection conErrLog = new SqlConnection(strConn);
string sql = "usp_AppErrorLog_AddRecord";
SqlCommand cmdErrLog = new SqlCommand(sql, conErrLog);
conErrLog.Open();
try
{
cmdErrLog.CommandType = CommandType.StoredProcedure;
cmdErrLog.Parameters.Add(new SqlParameter("@errMessage", SqlDbType.NVarChar, 8000));
cmdErrLog.Parameters["@errMessage"].Value = strErrorMessage;
cmdErrLog.Parameters.Add(new SqlParameter("@errStackTrace", SqlDbType.NVarChar, 8000));
cmdErrLog.Parameters["@errStackTrace"].Value = strErrorStackTrace;
cmdErrLog.Parameters.Add(new SqlParameter("@userID", SqlDbType.VarChar, 12));
cmdErrLog.Parameters["@userID"].Value = User.Identity.Name;
SqlDataAdapter ada = new SqlDataAdapter(cmdErrLog);
cmdErrLog.ExecuteNonQuery();
}
catch(Exception e)
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('AppErrorLog - " + e.Message + "');", true);
}
finally
{
conErrLog.Close();
}
}

The column datatype in the table is nvarchar(MAX).

View 4 Replies


Similar Messages:

C# - Work Continuously On Other Pages While Executing Stored Proc?

Jul 28, 2010

I have a stored procedure that I need to execute from asp.net button , It takes more than 30 mins to execute. So here I need to show a message like "In Process" while execution and disable couple of links..Once the execution is done I need to show "Last processed data and time" and enable the disabled links. So in "In Process" stage we have to allow user to access other pages in the site. How it is possible?

View 2 Replies

VS2010: Executing Parameter Less Stored Proc To Update Record

Apr 28, 2010

I would like to execute a stored proc that simply updates a record. At this point I would like to keep it parameter less. But in future, I will be adding parameters to the stored proc. Can I simply do it via SQLDataSource? It will save me writing few lines of code to execute stored proc in a traditional ado.net.

View 1 Replies

SQL Server :: Pass Stored Proc Output To Another Stored Proc?

Jul 28, 2010

i have two stored procs. when th 1st stored proc runs i want to be able to use this value returned from the stored into another stored proc.

my first stored proc is:

[Code]....

which returns [Transfer_stations_Authority_name] = 'Blackpool'

now i want to use this value into my second stored proc@

[Code]....

[Code]....

View 1 Replies

SQL Server :: Raise Error Stored Proc?

Mar 16, 2011

I have written a stored proc for raise error.Whenever a customer checks for a record in the DB that doesn't exist in the DB he has to get an error displayed.I have written a stored proc help me on it i know it is wrong suggest me the correct one.

[Code]....

View 5 Replies

Stop Other Sub Proc From Executing After Error "database Is Not Available"

Jan 31, 2011

I am having a problem with my try catch block runs in the error "dastabase is not available". My problem is the try catch runs and catches the error, but it will not redirect to my error page. The code continues to execute the other subs. I have tried adding: exit, return, response.end. None of them worked.

Imports System.Data
Imports EUC
Imports System.Threading
Imports System.Data.SqlClient
Partial Class mpMain
Inherits System.Web.UI.MasterPage
Dim strSQL As String
Dim objData As clsDataAccess = New clsDataAccess()
Dim ds As New DataSet
Dim t1 As DataTable
Dim intSecurityLevel As String = 0
Dim strUser As String = UCase(Right(HttpContext.Current.User.Identity.Name.ToString(), 4))
Protected Sub ExpandNode(ByVal NodeName As String, ByVal PageName As String)
'More Code
End Sub
Protected Sub ExpandNode2(ByVal NodeNameMain As String, ByVal NodeName As String, ByVal PageName As String)
'More Code
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not (IsPostBack) Then
Try
strSQL = "Select SecurityLevel from tblSecurity where SFID = @SFID order by SecurityLevel"
Dim MyParameters1 As SqlParameter() = { _
New SqlParameter("@SFID", SqlDbType.VarChar) _
}
MyParameters1(0).Value = UCase(Right(HttpContext.Current.User.Identity.Name.ToString(), 4))
ds = objData.SQLExecuteDataset(strSQL, CommandType.Text, MyParameters1)
t1 = ds.Tables(0)
Catch ex As Exception
Dim sendError As New clsExceptionMessage
sendError.sendMessage(ex.Message, Request.Path, strSQL)
Response.Redirect("ErrorMessage.aspx", False)
End Try
End If
End Sub
Protected Sub TreeView1_TreeNodeDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.TreeNodeEventArgs) Handles TreeView1.TreeNodeDataBound
'More Code
End Sub
Protected Sub TreeView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles TreeView1.DataBound
'More Code
End Sub
End Class

View 1 Replies

Databases :: Error While Getting Record Set From The Stored Proc Of The Oracle

Jan 27, 2011

i am getting this error while fetching select statement in oracle pl/sql proc... ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SP_CLASS' ORA-06550: line 1, column 7: PL/SQL: Statement ignored My proc is like..PROCEDURE "SP_CLASS" ( iDec IN NUMBER := null, p_ICID in number := null, p_DATA OUT SYS_REFCURSOR) IS BEGIN if(iDec = 1) then open p_DATA for SELECT ICID AS ID, SNAME AS NAME FROM SETUP_CLASS; else if(iDec = 2) then open p_DATA for SELECT ICID AS ID, SNAME AS NAME FROM SETUP_CLASS where ICID = p_ICID ; end if; end if; END;

View 1 Replies

DataSource Controls :: Stored Proc Giving Error?

Feb 2, 2010

This is the sproc

ALTER Procedure [dbo].[spGetGroupDetails]
(
@inUserID Varchar(15),
@inGroupID numeric=0,
@inGroupName varchar(100) = null
)
As

[Code]....

View 2 Replies

DataSource Controls :: DBNull Error Trying To Call Stored Proc?

Jan 7, 2011

I have a recordset in a gridview that comes from an outer joint that creates null values in the recordsetWhen I write to the database using stored proc defined in datasource I get dbnull error.I'm trying to process the onDeleting event in the code behind but don't know what to write or if that's the best wayI need to call a stored proc and if the last parameters value is null then the stored proc does one thing, if it's no null it does something else.However DBNull doesn't ssem to be working.

View 1 Replies

Crystal Reports :: Add Parameter To Stored Proc - SQL State 42000 Native Error

Jan 30, 2011

i hve crystal report which is wrking perfectly fine.. now i want to add paramter to my stored proc... but i am not able to add the same parameter on crystal report..i tried to add parameter in the parameter fields the crystal reports field explorer.. but when i verfiy database it still gives msg stored proc expects parameter which was not supplied..SQL State 42000 native error..

View 2 Replies

WCF / ASMX :: Error While Executing Stored Procedure On Wcf?

Apr 8, 2010

I use a wcf service to fetch data to a silverlight application, but when I try to execute a stored procedure from the wcf, I get this error..

"Data at the root level is invalid. Line 1, position 1.", this happends here..

Dim MyList = From p In db.StatisticByInvoicingAdressAndDateAndCustID(FromDate, ToDate, CustID)

But when I run the stored procedure on the sql server it works fine and return records, I just don't get it... What is wrong and causing this error?

View 1 Replies

ADO.NET :: Finding Error While Executing Stored Procedure

Oct 1, 2010

I have created stored procedure in sql server 2005 and connected that database to asp.net application when i submit a data from application form corresponding stored procedure stored procedure(sp1) giving following error Could not find stored procedure 'sp1'. I have written following code on buttonclick event provide me a solution and point out the error in code if exists

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class _Default : 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 sp12 = new SqlParameter();
SqlParameter sp2 = new SqlParameter();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{...............................................................

View 1 Replies

SQL Server :: Error While Executing Stored Procedure In 2005 / Invalid Object Name 'TEMPP'

Mar 11, 2011

Below is my sample stored procedure. When I am executing stored procedure by passing DATE it is showing below error.

Invalid object name 'TEMPP'

[code]....

View 2 Replies

C# - Stored Proc In Sql That Does Not Return The Value

Sep 9, 2010

My function isn't returning anything - strReturn is empty:

[Code]....

When I execute this stored proc using 'exec GetMerchantLocationZip (3333, 373773)' I get the correct zipcode in SQL. Why don't I get it in Visual Studio?

[Code]....

I am learning, so apologies if it's a obvious error.

View 7 Replies

SQL Server :: Stored Proc And Scope_identity

Aug 3, 2010

i have the following stored proc that inserts data into a database based on a stauts field. the first stored proc inserts into the first table and i am trying to get the identity field out as i need this value for the next stored proc. the first stored proc works fine and inserts the data but the secnd one doesnt, even though there is data there.

[Code]....

View 3 Replies

MVC :: Calling Stored Proc From A Controller?

Jan 21, 2011

I am trying to pass stored procedure from a controller to view. In my Home controller, in Index method, I have this. CustOrderHist is my stored procedure from northwind database.

public ActionResult Index()
{
DataClasses1DataContext dc = new DataClasses1DataContext();
var products = dc.CustOrderHist("ALFKI").GetEnumerator();
return View(products);

[Code]....

View 3 Replies

ADO.NET ::stored Proc That Takes A Bit Long To Run?

Aug 13, 2010

I have a stored proc that takes a bit long to run. I tried to do this command.CommandTimeout = 200;still gets time out within 200 secs.How is this done?

View 1 Replies

Databases :: How To Execute An Oracle Stored Proc

Oct 14, 2010

DECLARE
CUR_EMP_BIR REF CURSOR;
BEGIN
dbname.EMPLOYEE_P.EMPLOYEEBIRTHDAYSEL ( CUR_EMP_BIR );
END;
ORA-06550: line 2, column 19:
PLS-00201: identifier 'CURSOR' must be declared
ORA-06550: line 2, column 15:
PL/SQL: Item ignored
ORA-06550: line 5, column 45:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored
[code]...

View 4 Replies

DataSource Controls :: Stored Proc Is Not Working?

Mar 18, 2010

I have made a simple stored proc which include Transaction through which I have to delete records from two tables EmpDetail and EmpDept . EmployeeId is PK in EmpDetail and FK in EmpDept. Procedure has been executed but on doing exec DelEmployee @EmployeeID='e07' showing 0 rows affected..

[Code]....

View 6 Replies

DataSource Controls :: Getting @@Identity Value From Stored Proc?

Jul 2, 2010

I've been self teaching SQL and asp.net and i'm a little stuck. I have a stored proc for the insert and then in my Insert inside my class it's not returning the ID after the insert as I am receiving an error message that NULL value has cannot be inserted. I want to add default values to a seperate table after the insert. I will provide my code below, if anyone can help me why the value is not going across?

[Code]....

View 7 Replies

SQL Server :: Stored Proc Insert Into One Table From Another?

Jul 27, 2010

i am trying to write a stored proc that takes data from one table based on a field in that tabke and writes that data out to another table with the eventual idea that this data is deleted from the original table it was read from. my stored proc is as follows:

[Code]....

but i keep getting an error: incorrect syntax near 'BACKUP_TWS_Waste_Colection_Request'.

View 8 Replies

SQL Server :: Updating All Records Using Stored Proc?

Mar 9, 2011

I hope to one day figure this looping records from a table to update it, but i cannot get this to complie, I guess cause I am not

versed in looping in sql yet :(

[Code]....

I just want to get data from a table per record run the stored procedure(i have nesting on) and update the record's fields with the values that were returned from the Store procedure. The Stored procedure is working fine.

View 6 Replies

SQL Server :: XML / Creating An XML File From Stored Proc?

Dec 16, 2010

I'm converting Active X code in DTS to Script Task for SSIS and I'm having trouble creating an XML file from my stored proc. Here's the code:

[Code]....

It throws an error on the dataAdapter fill saying:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '<'.
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near '<'.
Msg 132, Level 15, State 1, Line 5
The label 'sql' has already been declared. Label names must be unique within a query batch or stored procedure.

View 6 Replies

Databases :: Stored Proc Which Accepts Datatable?

Dec 15, 2010

I want to have a stored procedure which will accept a Datatable from .NET application and the tablename and will loop thru' each record in the Datatable and insert it into the table. It will insert the bad records into a bad file. Also how to send the datatable to the proc,what kind of parameter to use.
Pls post the code for this proc.

View 3 Replies

ADO.NET :: Using Stored Proc In CTP5 Having Multiple Parameters

Mar 4, 2011

I am having a strange problem with using stored proc in CTP5.I am calling a stored proc in my function like this:

private List<Test> GetDatat(Test pTest)
{
using(var staticDB=new StaticDB()) [code]...

But I am getting error that parameters not found. Looking at the sql trace I can see that CTP5 is sending "default" value if any of my parameters is null instead of the null value.

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved