Output Parameter Resulting In Null Reference Error
Apr 23, 2013
I have article.aspx page that there is some Textboxs and fileupload control and insert when users click on btnInsert their data insert into database below is Behind code
protected void btnInsert_Click1(object sender, ImageClickEventArgs e)
{
string path = Server.MapPath(".") + "../image/House/article/pdf";
string filename = System.IO.Path.GetFileName(fuppdf.PostedFile.FileName);
string[] validext = { ".pdf" };
string ext = System.IO.Path.GetExtension(fuppdf.PostedFile.FileName);
if (Array.IndexOf(validext, ext.ToLower()) < 0)
[code]....
View 1 Replies
Similar Messages:
Feb 24, 2010
I am using dropdownlist in my view page with some values which will display corresponding ID(primary key of other table) in my database.If i leave my dropdownlist blank and save it in database then its showing null parameter error. Can you explain how to use this reference type to overcome this error
View 2 Replies
Jan 26, 2011
How can i check if an output parameter is null before i bind it to a asp literal, and if it is null i want to just make the literal
hname1.Text = cmd.Parameters("@hotel1").Value
hname1.DataBind()
hname2.Text = cmd.Parameters("@hotel2").Value
[code]...
View 1 Replies
Aug 9, 2010
Here is my stored proc
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
Create PROCEDURE [dbo].[sp_GetNextSeq] (
@p_NextSeqNo int = NULL OUTPUT
)
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY
BEGIN TRANSACTION
Generate Next Sequence Number
[code]...
View 7 Replies
Mar 3, 2010
for some reason i get an error saying the following. i have tried to look it up on google but there seems to be nothing about this error.
View 2 Replies
Oct 13, 2010
i have a WebSite project which i published, in the machine where i published the WebSite everything works smooth. when i moving it to the server, i got the Error:
Value cannot be null.Parameter name: type
Description:
An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentNullException: Value cannot be null.Parameter name: type
and the details of it:
[code]...
How can i fix it?
View 1 Replies
Mar 2, 2011
I have a WSDL: [URL] (I have changed address location).
My code is for accessing data from SAP via WSDL; bind that to .NET control as well as sending data from .NET control to SAP via same WSDL.
The code is like below:
[Code]....
On the other way, When I am binding data with .net control at from load event then there is a no problem.
The code is like below:
[Code]....
View 9 Replies
Jan 14, 2010
I have a gridview,when i do it is giving me null object reference error.
I am posting my code for your reference -
[Code]....
My gridview code is -
[Code]....
View 8 Replies
Jan 16, 2010
I downloaded a sample Rolodex from here: [URL] the file to download is at the bottom of the page and it is called 'RolodexDatalist.zip (6.71 kb)' So I changed the HTML to it points to my SQL Server DB. I changed the ConnectionString to this:
<connectionStrings>
<add name="CustomersConnectionString" connectionString="Data Source=EXCEL-4J2W8KYNPSQLEXPRESS;Initial Catalog=Customers;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
Now, everything points to my DB! I thought, ok great, this should be pretty easy. However, when I debug, I get this error message: 'Null reference was unhandled by user code. Object reference not set to instance of an object. Troubleshooting Tips: use the "new" keyword to set an instance of an object.' This line is yellow:
Dim conStr As String = ConfigurationManager _
.ConnectionStrings("conStr").ConnectionString
Here is the code-behind:
Imports System.Data
Imports System.Data.SqlClient
Imports System.Collections.Generic
Partial Class VB
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not IsPostBack Then
ViewState("CurrentAlphabet") = "ALL"
Me.GenerateAlphabets()
Me.BindDataList()
End If
End Sub
Private Sub BindDataList()
Dim conStr As String = ConfigurationManager _
.ConnectionStrings("conStr").ConnectionString
Dim con As New SqlConnection(conStr)
Dim cmd As New SqlCommand("spx_GetContacts")
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.AddWithValue("@Alphabet", ViewState("CurrentAlphabet"))
con.Open()
dlContacts.DataSource = cmd.ExecuteReader()
dlContacts.DataBind()
con.Close()
If ViewState("CurrentAlphabet").ToString().Equals("ALL") Then
lblView.Text = "all Contacts."
Else
lblView.Text = "Contacts whose name starts with " & _
ViewState("CurrentAlphabet").ToString()
End If
End Sub
Private Sub GenerateAlphabets()
Dim alphabets As New List(Of Alphabet)()
Dim alphabet As New Alphabet()
alphabet.Value = "ALL"
alphabet.isNotSelected = Not alphabet.Value _
.Equals(ViewState("CurrentAlphabet"))
alphabets.Add(alphabet)
For i As Integer = 65 To 90
alphabet = New Alphabet()
alphabet.Value = [Char].ConvertFromUtf32(i)
alphabet.isNotSelected = Not alphabet.Value _
.Equals(ViewState("CurrentAlphabet"))
alphabets.Add(alphabet)
Next
rptAlphabets.DataSource = alphabets
rptAlphabets.DataBind()
End Sub
Protected Sub Alphabet_Click(ByVal sender As Object, ByVal e As EventArgs)
Dim lnkAlphabet As LinkButton = DirectCast(sender, LinkButton)
ViewState("CurrentAlphabet") = lnkAlphabet.Text
Me.GenerateAlphabets()
Me.BindDataList()
End Sub
End Class
View 8 Replies
May 27, 2010
i have an application wherein i have incorporate a "Remember Me" feature for the login screen. I do this by creating a cookie when the user logs in for the first time, so next time when the user visits the site i get the cookie and load the user information.
i have written the code for loading user information in a common class in the App_Code folder...and all my pages inherit from this class.
code for loading the user info is as follows:
public static void LoadUserDetails(string emailId)
{
UsersEnt currentUser = UsersBL.LoadUserInfo(emailId);
if (currentUser != null)
HttpContext.Current.Session["CurrentUser"] = currentUser;
}
Now the problem is i get an "Object reference" error when i try to store the currentUser object in the session variable (even though the currentUser object is not null). However the password property in the currentUser object is null.
View 3 Replies
Mar 5, 2010
I've started using Enterprise Library and have the following questions:1)How do I add output parameter to this query and how do I get it back:
public int InsertDoc(HDocument document)
{
Database db = DatabaseFactory.CreateDatabase();
int result;
var reader = db.ExecuteNonQuery("sp_InsertDocument",
document.AddedDate,document.AddedBy, document.Title))
.
.
.
}
The db.AddOutParameter requires paremetrers that I don't have like DbCommand.2)I have a few methods that work with database (I transfer from ADO.net) stored procedures, do I have to declare : Database db = DatabaseFactory.CreateDatabase(); in each one of them or I can reuse it?
View 1 Replies
Jan 10, 2011
instead of returning my output paremeter value in my stored procedure to my label it returns the default value i set my output parameter to. why cant i put my output parameter into my text label
Dim reader As SqlDataReader
cmd.Parameters.AddWithValue("@tour", "2365")
cmd.Parameters.Add("@tourname", SqlDbType.VarChar)
cmd.Parameters("@tourname").Direction = ParameterDirection.Output
[code]...
View 1 Replies
Feb 7, 2011
I am trying to return output parameter from stored procedure.
Here is my code:
protected void Button1_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["myConn"].ConnectionString))
{
SqlCommand cmd = new SqlCommand();........
View 2 Replies
Feb 19, 2010
I am declaring a list in my class, populating the list in page load and using the list in various methods in this class. But, I get this error at every instance where I use this list in the methods. Error: System.NullReferenceException: Object reference not set to an instance of an object.
public partial class ViewBG1 : HealthServicePage
View 3 Replies
Dec 14, 2010
I am using LINQ.I have stored procedure as:
ALTER PROCEDURE [dbo].[usp_ATI_OA_GetCalculatedValue]
@OredrID BIGINT = 0,
@SubTotal MONEY OUTPUT,
@ShippingTotal MONEY OUTPUT,
[code]...
The problem is that, how to return OUTPT value to dTtoal and the remaining. Because now it's show assigned values as 1, 2, 3, 4 resp. I mean the bold values.But, if I execute SP using EXEC then it works fine, shows result correctly.
View 3 Replies
Aug 4, 2010
I have a stored procedure with output parameter. I encapsulate it with Table Adapter and BLL. Call it using ObjectDataSource in conjuction with formview, just like the one in Data Access Tutorial. How do I get the output parameter in event INSERTED of the ObjectDataSource in code behind (VB)?
My stored procedure looks like this:
[Code]....
My BLL code looks like this:
[Code]....
View 2 Replies
Jul 12, 2010
We have a stored procedure which creates and returns as output the next value in line:
[Code]....
Yes, the dullards who created this system not only failed to use an identity for the primary key of this table, they then proceeded to add 1 to a varchar column to create the new value, thus insuring it can never be anything but numeric.
Sigh. I'm told we cannot address that obvious deficiency now, and we have to leave the column as varchar. Double sigh.
If I execute this sproc from SSMS, the hh_num variable is returned as expected:
[Code]....
However, when I run it through the application, the parameter I set up as output does not get its Value attribute changed:
[Code]....
I've verified that the "@hh_num" maintains its direction and name through the ExecuteNonQuery call, but its Value remains an empty string.
View 1 Replies
Feb 24, 2011
I am trying to return a sum total figure from a stored procedure by using the output parameter. When I execute the stored procedure in SQL it returns 0 or a valid number like it should but when I try to use the webmethod listed below I keep getting a 0 even when I should get a valid number back.
ALTER PROCEDURE spGetCustSum
@CustomerCode CHAR(4),
@Sum AS INTEGER OUTPUT
AS
BEGIN......
Am I missing a step or have some wrong code in this method?
View 4 Replies
Jan 4, 2010
How do you evalute a null sql output paramater. I've tied several ways but can find one that works. I always get an error code of Conversion from type 'DBNull' to type 'String' is not valid.
I've tried both IsDbNull and if the value = nothing - both return the same error.
Code:
If IsDBNull(e.Command.Parameters("@JobCount")) Then
Me.lblInternalJobCount.Text = 0
Else
Me.lblInternalJobCount.Text = e.Command.Parameters("@JobCount").Value
End If
'I have also tried checking for nothing and that doesn't work either
View 2 Replies
Oct 7, 2010
how do I add an output parameter to a Stored Procedure that returns a code or string to the calling app
View 1 Replies
Jul 30, 2010
I am having some trouble with the below code snippet. It is a stored procedure which executes on load that has an output parameter which should display in a label. Familiar which Vb however not so much in C#.
View 2 Replies
Oct 11, 2010
m trying to capture an output parameter from an SQL insert.for
CREATE TABLE [dbo].[Test](
[TestID] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
[Test1] [int] NULL,
CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED
INSERT INTO [Test] ([Test1]) OUTPUT inserted.TestID as TestOut VALUES 1))
[code]....
View 3 Replies
Apr 15, 2010
I have a gridview that has the header row modified in order to add new records; the gridview is bound to a sqldatasource control. In my code behind, i handle the insert in the following manner:
[Code]....
I know the insert is occuring because the new record shows up in the grid after the databind, but the output parameter is not picking up the scope_identity() value...what am i doing wrong with the output parameter?
View 2 Replies
May 17, 2010
I'm converting my application from using System.Data.OracleClient to Oracle.DataAccess.Client and I've noticed some weird behavior.
I am calling a stored procedure that sets an output parameter value. Under some circumstances, a null value gets assigned to this value and I need to detect it.
Here's how I'm declaring it using ODP.net:
cmd.Parameters.Add("p_status", OracleDbType.VarChar2, 200, DBNull.Value, ParameterDirection.Output)
The old Microsoft driver for Oracle would read the value as an empty string. However, ODP is returning a value {null} (per Visual Studio's debugger), which is not equivalent to null, DBNull.Value, nor an empty string. As a result, the code doesn't branch correctly now.
View 1 Replies
May 21, 2010
Is there a better way to write the code below? I have quite a few blocks that are similar, and this is making the code in the Viewpage very messy to work with. The data value with the associated label only needs to be output when certain conditions are met, which is almost always if the value is not null. The options I can think is to use a response.write to atleast minimize the usage of the ASP script tags, or to format the webpage is such a way that the label displays with an appropriate n/a type value.
<% if (myData.Balance != null)
{ %>
Balance: <%= String.Format("{0:C}", (myData.Balance))%>
<% } %>
View 2 Replies
