Web Forms :: Return Scalar Value Using ExecuteNonQuery

Apr 27, 2016

I used this code it’s worked. But I want when Id exist then output any parameter equal 1 else 0. because I have two button Add and Continue.  

CREATE PROCEDURE InsertName
@Id INT = NULL
@Name VARCHAR(50)= ''
as
BEGIN
IF NOT EXISTS(SELECT Count(Id) FROM ParsonTable WHERE Id = @Id) OR @Id IS NULL

[Code] ....

View 1 Replies


Similar Messages:

Must Declare The Scalar Variable "@EmailAddress" On 'command'.ExecuteNonQuery()

May 18, 2010

I keep getting:

Must declare the scalar variable "@EmailAddress" when I'm debugging and my values aren't being submitted to the DB. Can the eyes of the forum see my error?

[Code]....

[Code]....

View 2 Replies

Web Forms :: Difference Between Return Value Of ExecuteNonQuery And ExecuteScalar

Oct 6, 2012

I use below code for my button event

int Result = _cmd.ExecuteNonQuery();
if (Result > 0)
{
Session["Login"] = true;
Response.Redirect("~/Managers.aspx?BehCode=" + Server.UrlEncode(TextBox1.Text));
}

But it didn't work it didn't go to managers.aspx page but when I replace code with below code it worked correctly it go to managers.aspx

int count = Convert.ToInt32(_cmd.ExecuteScalar());
if (count > 0)
{
Session["Login"] = true;
Response.Redirect("Managers.aspx?BehCode=" + Server.UrlEncode(Txtbeh.Text));
}

Why this happen whats exact different between two code?

View 1 Replies

DataSource Controls :: Why Does Cmd.ExecuteNonQuery() Return -1

Mar 3, 2010

I have created a stored procedure that reset my tables' identity value. The store procedure works fine when I didrectly run it in my ms sql server 2008. It reset my table Identity value However, when I call it from my function reset, it returns -1, and does not reset my table identitity value. The function to restet my identity value is:

[Code]....

My stored procedure is

[Code]....

To call the the function:

Dim result
As
Integer = util.resetTableIdentity("myTable", "id", 60)
util.print(result)

I got result is -1, and it does ot reset my table identity. Why? How to resove it?

View 4 Replies

ADO.NET :: ExecuteNonQuery Trimming Return Parameter Value?

Sep 6, 2010

I am observing a rather strange behavior. I have a procedure which selects a field from a matching record and returns it. The procedure works as expected returning proper values, when I execute the procedure from Visual Studio Server Explorer tab. The procedure is

[Code]....

This is being called from the DAL as follows:

[Code]....

The problem is if @ReturnValue is EAE then cmd.Parameter[outputParameterKey].Value is giving the value "E". If @ReturnValue is "Sassyboy" it is giving "S". why this behavior?

View 1 Replies

Web Forms :: Must Declare The Scalar Variable?

Mar 24, 2014

I Am getting error as Must declare the scalar variable "@Imageid" for the following code,while executing,

exec spGetPager  ' ' , ' ', ' 3 ', ' '

In my coding I pass querystring value like 1,2,3 etc

CREATE PROCEDURE spGetPager
@PageNo int = 1,
@ItemsPerPage int = 1,
@Imageid int,

[Code].....

View 1 Replies

Web Forms :: Error - Must Declare Scalar Variable

Dec 11, 2012

when I am executing an above code and click on button to insert data is shows an error message

as: System.Data.SqlClient.SqlException: Must declare the scalar variable "@imagefile"

Protected Sub button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles button1.Click
Try
If fileupload1.HasFile Then
'getting length of uploaded file

[Code]....

View 1 Replies

Web Forms :: ExecuteNonQuery - Conversion Failed When Converting DateTime From Character String

Jun 2, 2012

I'm trying to submit my form into the database but I'm getting this error on the cmd.ExecuteNonQuery() section:

Conversion failed when converting datetime from character string.

I have three date fields (in bold below) and in the database they are set up as datetime (8).

What am I missing:

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim conn As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection("Data Source=cmssolutions.db.9373013.hostedresource.com; Initial Catalog=cmssolutions; User ID=CMSSolutions; Password=CMSMedical1")
If BMItxt.Text = "" Then
BMItxt.Text = "01/01/1900"

[Code] ....

View 1 Replies

Forms Data Controls :: Binding Scalar Values - Get Value In OnItemDataBound?

Jan 21, 2010

I have a question on Scott's article about binding scalar values to data controls: [URL]

On the seconde example (the one using templates), how would I access the scalar value in the controls OnItemDataBound event? e.Item.DataItem seems to be null....

View 2 Replies

Databases :: ExecuteNonquery?

Jul 12, 2010

Problem with ExecuteNonquery

View 15 Replies

Benefits Of Using SqlCommand.ExecuteNonQuery?

Mar 29, 2010

a) SqlCommand.ExecuteNonQuery is used for update, insert and delete operations.

Besides the fact that by using ExecuteNonQuery instead of ExecuteReader we automatically know there won't be any query results returned, are there some other benefits/reasons why ExecuteNonQuery should be used?

b) Similarly, if we want a database operation to return a single value, we should use ExecuteScalar instead of ExecuteNonquery ,where with the latter result would be returned via SqlParameter. Is there any particular reason why we should prefer ExecuteScalar over ExecuteNonQuery?

View 2 Replies

ADO.NET :: ExecuteNonQuery With Output Parameter?

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

SQL Server :: C# Error SQL ExecuteNonQuery?

Feb 1, 2011

[Code]....

[Code]....

View 6 Replies

SQL Server :: SqlHelper.ExecuteNonQuery?

Aug 17, 2010

what is the use of this...?

View 4 Replies

ADO.NET :: .ExecuteNonQuery Not Performing Update?

Aug 4, 2010

I've got a routine that's supposed to be capturing data from an XML to a DataTable (which works fine), and then using that data to insert into MS SQL. I have no problems with the Inserting of records (via a different routine) but am struggling to update existing records - I'm not even getting any errors, and I can verify that the data is being assigned to the parameters.

Here's what I've got.

Shared Sub Sold(ByVal FullPath As String)
Dim SQLSold As String
Dim SC As New SqlConnection(CS)
SQLSold = "Update Properties SET Status = @Status, Price = @Price WHERE UniqueID = @UniqueID"
Dim DT As New DataTable

[Code]....

View 12 Replies

AJAX :: UpdateProgress Control With ExecuteNonQuery?

May 18, 2010

I need to write a single web page that checks the status of an SQL job, and allows the user to execute a new job if the job has a specific status.

I have the job status checking code working but have a problem when it comes to the execution of the next job. The problem is because as soon as ExecutNonQuery is run my code goes straight to the next line leaving SQL to do its own thing - therefore my UpdateProgress never shows. How do I get the UpdateProgress control is be aware that my Job is still running??

I also have a method called ReturnJobDetailStatus which I imagine I could use by continually checking it with a combination of the UpdateProgress control and a timer control? If so I cannot visualise how to achieve this?

Here is a snippet of the code:

Page:

[Code]....

Code-behind:

[Code]....

View 2 Replies

Declaring Scalar Variable

Jan 23, 2013

I have a really simple web interface which has been created in visual studio 2010 and is connected to an SQL server running MS SQL Server 2008. I essentially want the user to be able to enter values into the two text boxes provided and when the button is clicked, these values are inserted into the relevant table in the database.

When I run the code, I get an error back saying that the 'scalar variable for @clientName is not defined.' I have altered the insert statement to fixed values rather than entering from the text boxes and this works fine (ie, replace @clientName and @serverName in the insert statement with 'xx' and 'yy' respectively). How I can define these scalar variables. I'm not to sure what i'm missing. Code below.

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">

[Code] .....

The code that the button executes is below

Partial Class Default2
Inherits System.Web.UI.Page
Protected Sub Button1_Click(sender As Object, e As System.EventArgs) Handles Button1.Click
SqlDataSource1.Insert()
End Sub
End Class

View 3 Replies

DataSource Controls :: Benefits Of Using SqlCommand.ExecuteNonQuery Instead Of â€

Mar 29, 2010

[Code]....

is used for update, insert and delete operations.Besides the fact

View 3 Replies

SQL Server :: Syntax Error Near StrStatusUS... ExecuteNonQuery?

Jul 17, 2010

i have been having an error which readsIncorrect syntax near 'strStatusUS'.

Line 86: objCmd.CommandText = cmdStrLine 87: objCn.Open()Line 88: intNoOfRecordUpdated = objCmd.ExecuteNonQuery()Line 89: objCn.Close()Line 90:

the sql statement i used are as follow... when i type it out in sql server management, everything works fine

UPDATE tblUser
SET strStatusUS ='Suspended'
WHERE intUserIdUS = 8

however when i type out this code in visual studio. The error message will pop out..

Public Function updateUser(ByVal pintUSerId As Integer) As Integer
Dim objCn As New SqlConnection
Dim objCmd As New SqlCommand
Dim intNoOfRecordUpdated As Integer

[code]...

View 1 Replies

DataSource Controls :: Table Isn't Updating Using Executenonquery?

Jan 20, 2010

I have stepped through this code to test it and I am puzzled as to why the update isn't going through to the DB. When I run the SQL statement in SQL editor it updates fine. All variables are getting the proper values when I step through.

[Code]....

View 5 Replies

DataSource Controls :: ExecuteNonQuery And Stored Procedure?

Jun 28, 2010

Im using above to makes sure that record is inserted to the SQL database before executing another function, but for some reason even if the record is NOT inserted other function has been called.(Other function is t update a Flag)

look at my code below and see where it goes wrong??

Part of the .Net Code
=============================================================
Private Sub GetAndInsert()[code]....

I have a feeling it could be that Rolling back is done in both .NET and SP??

View 2 Replies

SQL Server :: How To Declare Scalar Variable

Aug 5, 2010

how to Declare scalar variable

[Code]....

View 6 Replies

DataSource Controls :: ExecuteNonQuery - Declare And Execute All On One Line?

Apr 14, 2010

I'm looking for a way of being able to declare and execute a SqlCommand all on one line. At the moment I do something like:

Dim Cmd as New SqlCommand("....", Conn)
Cmd.ExecuteNonQuery

How can I do something like:

(New SqlCommand("....", Conn)).ExecuteNonQuery

View 3 Replies

Databases :: Error In ExecuteNonQuery() - OracleHelper.cs While Passing Parameters

Sep 7, 2010

I get an error while passing Parameters, This is my code, OracleHelper

public static int ExecuteNonQuery(OracleConnection connection, CommandType commandType, string commandText, params OracleParameter[] commandParameters)
{
OracleCommand cmd = new OracleCommand();
PrepareCommand(cmd, connection, (OracleTransaction)null, commandType, commandText, commandParameters);
return cmd.ExecuteNonQuery();
}

My Code

DataWrapper.ExecuteNonQuery(connection, CommandType.Text, "Insert into sample values(@id,@name)",new OracleParameter("@id",OracleType.Int32,Int32.Parse(TextBox1.Text)),new OracleParameter("@name",TextBox2.Text.ToString()));

while executing i get this error ! ORA-01036: illegal variable name/number

View 2 Replies

DataSource Controls :: ExecuteNonQuery Requires An Open And Available Connection?

Feb 4, 2010

I've a web form named contest, where users are to register for it. When the register is clicked on, details entered by the user will be saved into the database, but before it will check if the user has already participated in the contest (using AJAX). If the user has already participated, the button will be disabled. The problem is there is an error when I click on the register button.

The error:

ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

Here's the codes I use:

[Code]....

View 7 Replies







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