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 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 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]....
How do you declare global variables in ASP.NET MVC?
View 6 Repliesit's possible to declear global variable in asp.net C#.
View 1 RepliesI´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.
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 have the following code:
[Code]....
As you can see, I have two variables @total and @euclidDist, and I have declaring them and defining them using DECLARE and SET respectively. This query works in VB and MSSQL and returns the required results, however when I try to great a Gridview, and I paste the above query in the query builder, it asks me to input the values to @total and @euclidDist, ie it ignores the fact that I already defined them in the statement itself...how do I get around this?
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]....
am trying to provide users with a number of options, among which, I would like them to see a sum of trips that they have talked about. I have therefore the Trips Table and the Users table. The UserId is the PK of User Table and FK of Trips Table. Trip_Id is PK of Trips Table.In order to see a sum of the number of trips that a user has post, this is the query I have wrote into SQLDATASOURCE:
[Code]....
Everything seems really simple and cannot figure out why when I try to login to test the application , the error I get is: Must declare the scalar variable "@UserId".
I will declarate a attribute, but it gives me an error
This query works fine and returns 1 record from type int:
SELECT TOP 1 DataObjectVersionID
FROM tblDataObjectVersionPropertyValueText
WHERE PropValue like CAST('00010281' AS ntext)
ORDER BY DataObjectVersionID DESC
And when I will declarate a attribute/parameter it gives me an error:
DECLARE @dataObjectVersionId INT
SET @dataObjectVersionId = SELECT TOP 1 DataObjectVersionID
FROM tblDataObjectVersionPropertyValueText
WHERE PropValue like CAST('00010281' AS ntext)
ORDER BY DataObjectVersionID DESC
Error message:
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'SELECT'.
I have a problem with my SQL statement with the WHERE statement and I also need to return the declared variable. and I have a function which also needs to return the returned value but it's not passed in as parameter it passed back with a variable declared in the sql statement using the Return keyword I can't use OUPUT for declared variables so if there here's my code.
[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 have a stored procedure which returns a value to state if the userlogin is valid. but i want to return the data and store it in a data session as i will require the user details in the checkout page.
is it best to get individual parameters out of the stored procedure then assign the variables to a datatable which is then assigned to session Or how can i get all the details returned from the stored procedure for the table? not sure which would be the most effective solution?
I got variables to send as parameters to Stored Procedure,
How to send it using SqlParameter[] arrParam?
How to write those variables to the arrParam?
im developing a silverlight project using silverlight 3, vs2008 and linq2sql. when projects starts, im storing all the data from database into some static list variables. so when ever i need data, im reading it from those static list variables. all i want to know is, is it good to store data in static list variables and use it when ever necessary or is it good to get data directly from DataClassesDataContext object like db.mytable. which is the rite and fastest way or retrieving data. i mean which will use less connections to database?
View 2 RepliesI'm trying to combine a date and time from separate variables in my asp.net insert sql. pointers? I'm getting the following error
Conversion failed when converting date and/or time from character string.
[Code]....
I 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 Replies