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] ....
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]....
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?
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?
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?
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].....
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]....
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] ....
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....
Problem with ExecuteNonquery
View 15 Repliesa) 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?
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();........
[Code]....
[Code]....
what is the use of this...?
View 4 RepliesI'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]....
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]....
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
[Code]....
is used for update, insert and delete operations.Besides the fact
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]...
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]....
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??
how to Declare scalar variable
[Code]....
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
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
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]....