I need to declare a variable xyz, then, using a select statement, pass a variable into it so I can then insert it into a table.
Dim @xyz As
Integer
set @xyz = (select xyz
from systable)
1. I get a squiggly line below the @.
2. I get informed that set and let are no longer supported.
3. When I remove the @ I get the squiggly below select.
I´m having a SQL query statement in management studio that runs prefect. I can´t have it set in a gridview.In SQL management studio I´m declaring some variables. It seems like I´m not able to declare inside the query statement in a gridview. Do I have to do the declaring outside the gridview?Here is my code in management studio
[Code]....
i am still stcuk with my project and unabale to perform calculation on my edited gridview..
here is my problem :
i have fields (f1,f2,f3, f4...) pulled from my sql data base table. into a gridview.
the "f4" field value is based on some calculation done on f1, f2 & f3 field values..
1- i need to have the same calculation done when i edit and update f1, f2 & f3 on my gridview...
more complicated..
2 -my calculation are based on a javascript function ...
a- how can i pass the fields values to the JavaScript variables...perform the calculation....then reassign back the result varibale to the f4 field ?? ..then update my gridview with the new calculation..
[code]....
I am looking to cache a dataset and then filter the results as they will be used repeatedly. However, I don't know how to assign values in the filtered dataset to variables in C#. I have looked on the internet for the past few hours but all I can get in binding the dataset to a control.
View 4 RepliesI am looking to retrieve data from a database and assign those values to class objects which in turn will be turned into session variables. I am using an object datasource to retrieve the data from the database but I cannot find anywhere that shows how to assign these values to variables. The data is returned in a dataset. There is the added problem that there will be mulitple items returned which will have to be assigned to different arraylists of objects based on the a primary key in the database.
View 4 RepliesHow do you declare global variables in ASP.NET MVC?
View 6 RepliesI've changed the definition on one of my tables by removing a field from my data key. However, I still want to pass this field to my stored procedure that inserts fields into this table from another table. The field in question is called ignum. I was using the code
[Code]....
How do I pass the ID and SelectedDate values in to the stored procedure as parameters??
[Code]....
it's possible to declear global variable in asp.net C#.
View 1 Repliesbasically i have two dropdown boxes to filter data and textbox with stored procedure bound to gridview.i want to be able to query data depending on the selected value passed,either using one or more parameter values.
i would like seperate sqlcommands to chose from depending on which controls i select to pass parameters.
i have included a parameter Select(control id) as this is declared by the wizard for stored procedure.
but i am not sure how it is defined on the page and passed to procedure.
[Code]....
I´m in need to export datagrids to excel. I found a good solution in C#. I´m a newbie at VB.net. I have got it to work but I´m not familar to set the SQL connection and bind data in C#.
I need to declare my query with a calendar parameter but I have no idea how this should be done in this code.
Either, how do I set parameters into the C# code or how can I set a SQLDATASOURCE in the ASPX file and still run all code.
ASPX CODE
[Code]....
And CS
[Code]....
I am rather confused as how or where to declare this variable in asp.net.
[Code]....
Whenever i put this in my sqldatasource for it is asking me to Define Parameters:
The wizard has detected one or more parameters in your SELECT statement. For each parameter in the Select Statement, choose a source for the parameter's value.
I have a requirement where I need to declare a Sql Statement dynamically in a cusror. When I declare dynamic Sql Statement and execute the SP, it throws an error message. The Cursor is not recognizing the dynamic Sql command.
As per the requirement, the sql statement will change according to the input parameter and it can't be declared as a static sql as shown below. Can anyone tell me, how this can be achieved any other alternative to do?
I can't figure out whats wrong with my contact page. I am getting this error when executing. It complied fine, I see the page as it suppose to. Then I enter all my contact information and click submit I am getting this error. Can someone guide me. Here is the error msg
must declare the scalar variable @txtSubject Here is the part of relevant code
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
Dim ContactDataSource As New SqlDataSource()
ContactDataSource.ConnectionString = ConfigurationManager.ConnectionStrings("ASPNETDBConnectionString1").ToString()
ContactDataSource.InsertCommandType = SqlDataSourceCommandType.Text
ContactDataSource.InsertCommand = "INSERT INTO Enquery (EnqSubject,EnqFirstname, EnqLastname,EnqContactNumber,EnqEmail,EnqMsg,EnqDateTimeStamp,EnqIPAddress) values (@txtSubject, @txtFirstname, @txtLastname,@txtPhone,@txtEmail,@txtMsg, @txtDateTimeStamp,@txtIpAddress)"
[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'm getting "Must declare the scalar variable "@ShowTypes"." when I try to run the code below.
[Code]....
How do I define @UserName in my function:
[Code]....
I believe "UserName" = Me.User.Identity.Name
but I don't know the proper way to add it to the function.
In my example below I am trying to Bind 2 different size GoogleAds to the 2 first rows in the GridView. One Ad on each row. The ads that are inside.......
(i2 == 0) and(i2 == 1).
I need to use <%if (Counts < 2) %> in HTML to restrict it to just 2 Rows, so this variable needs to be passed correctly also. As it is now, Counts is not passed correctly so <%if (Counts < 5) %> needs to be set in order to see any ads at all. I beleive this is because Page.DataBind() is binding the last ad in memory from the loop.
So when running this code, the same ad (i2== 2) is set to 3 rows in the GridView. This is my problem!
[Code]....
I have an sp that I would like to us the data from one column to use as a parameter for the following Select Statement
[Code]....
need to set the @customerID parameter = customer_data.CustomerID from the first Select Statement
i would like to insert a picture on a gridview, but i allways get the error:
Must declare the scalar variable "@IMAGEM"
somme one can on tihs code ? here is my code:
[code]....
As what other member said in this community, the data assign a public variable may be shared among users, therefore, how am be able to declare a property that will accept an array of values using List<string>? The variable will be use in about fifteen pages...if I am going to declare this on each of the page, this will result to difficulty in maintaining the code of my program.
View 1 RepliesI have two user controls both have a repeater and a button. They are both on a .aspx page. I need to capture the values from those two buttons on the user controls in variables on the .aspx page. Right now, I have two labels on the page that I am outputting the values of the buttons to, but they don't have a value right now, which is my problem.
View 5 RepliesI want pass the current page variables to next page and further also.
How to do this?
I was able to handle this to next page by previous page variable property but not further.
I am getting these errors when compiling => Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'AS' Msg 156, Level 15, State 1, Line 6 Incorrect syntax near the keyword 'DECLARE'.
SET ANSI_NULLS
ON
SET QUOTED_IDENTIFIER
ON
GO
AS
ALTER PROCEDURE [dbo].[Z_DQA_LOAD_RECIPE]
DECLARE @instbl
varchar(50)
SET @instbl
=
'Z_DQA_'
DECLARE @instbl_def
varchar(50)
SET @instbl_def
=
'Z_DQA_'
DECLARE @updttbl
varchar(20)
DECLARE @Run
int
DECLARE @Defect
int
DECLARE @Test_Num
int
DECLARE @Test_Desc
varchar(50).............................
I am working on this for couple of days but still getting this error message.
SqlCommand sqlInsert;
SqlDataAdapter MySqlAdapter_insert;
SqlCommandBuilder MyBuilder_insert;
[Code]....