I want to correspond the output of a store procedure to the image onclick event I mean here:
protected void imageLoaded(object sender, EventArgs e) {
Image1.ImageUrl("~/pic/"+Eval(" " )); }
I don't know what I should write in Eval.
i want to put the output of store procedure in ImageUrl
this is behind code, i wrote it on onclick event of asp:image
Pic is the name of a folder in root of site , i want to put the output of store procedure in Eval:
Image1.ImageUrl("~/pic/"+Eval(" " ));
I want to execute a Store Procedure and then get the Output in one table. However I am not getting the query. I want something like this execute 'Stored procedure name' 'param1','param2','param3' and then get the result into some table. Is this possible?
select * into #table from (execute 'Stored procedure name' 'param1','param2','param3')
i have written following code to access public variable of asp.net onclick event on button but its not giving me desired output.. please check it:
<asp:Button runat="server" CssClass="txtdisplay" ID="Button1"
Text="Browse all jobs in area"
OnClientClick="return navigateURL('index.aspx?c=<%=cityid %>')" />
How do I setup a default setting so that if I do not set an OnClick (i.e the asp.net OnClick attribute) explicitly for an asp:LinkButton tag, it will not render an onclick(html attribute for javascript) attribute client side? By default, asp.net adds an onclick='doPostBack....' for the LinkButton.
Case for use:
There is a LinkButton tag on the page. For this page, if the user has one friend, I only want to run client side code if the button is clicked and would not for any reason want to make a post back. If the user has more than one friend I would want a click to trigger a postback.
Using any asp.net Ajaxtoolkit
Dynamically switching the control type (i.e. if friends == 1 use a asp:Hyperlink)
-I want to avoid this because it is not scalable. There might be many cases where I want an asp:Link tag to do a postback or to not do a postback depending on the user context or user attributes Using OnClientClick (I am using jQuery would like to avoid this)
I have two scripts inside my webpage
<script type="text/javascript" src="http://somesite/somefile.js"></script> <script type="text/javascript" >somecode('a','1z4j73');</script>
This script is generating a visitor map on my web page, now I don't want my user to click on the script and get redirect to that website. How can I restrict that? Can I make a div tag and make all element inside the div tag to read only? I have make sure that this restriction doesn't falls under company rules, they just want their logo under the map. Can I catch this through any event and again redirect the user to the default page? Like when user click the image, I check the URL and if the URL contains that site name I again redirect to the default page.
i have n image button with an event:
[Code]....
when i click the button the page refreshs.. is it possible to make the event heppen without refreshign the page?
Basically when a user clicks a button I have a javascript code that runs that displays the hidden DIV, my question is how do I make it so when the users click it executes the SQL code (which is already written to select the data) and then it displays it in the DIV that I want. Would the only way to do this be add a label to the DIV and then use LabelName.Text to populate it or can this be accomplished some other way? I am using Visual Studio 2008 and coding in c#.
View 2 RepliesMy SQL stored procedure returns 3 different datasets as follows:
team_id name
1 Team1
2 Team2
...and more
location_id name
1 Dallas
2 New York
...and more
branch_id name
1 Austin
2 New Jersey
...and more
How do I put this data into one Dataset so that I can loop through the data and manipulate it?
well i have already created the rows and cells dynamically using asp.net table control ...but how to add an onclick event on that ...so that i could retrieve the corresponding cell when a particular row is clicked ...if it was a html control ,i could have used javascript but in this particular case m unable to find any solution..
View 2 RepliesI need to develop image gallery
Image saved in Folder called Images and image Name , Description saved in Database Table Images.
On Deafault.aspx
Thubnail images should display with out any change in Quality i.e by DataList Control
On Click of Thubnail images Fullview of image with width and height same as image width and height
Next, Previous, Close Buttons on Popup window
[Code]....
Above is dynamic sql and when it is executed by sp_executesql then I got output as as xml. If I want to store that XML in a variable. So then what I need to add in my tsql script.
what're the differences between onclick event and oncommand event?
View 2 RepliesI have a stored procedure that works fine for classic asp, but how can I get my output parameters data back from in /MVC 2 / linq/ entities framework model . I have inported the function also, but when i try to code it i dont get results ...i know this is a matter of lack of / knowledge or exmple because i have been scouring the web for it and cannnot find into that accually works.
here is the stored proc.
[Code]....
Here was the one of the few tries I did:
[Code]....
but it executes fine does not give me an error, but also does not return the info i need to the viewmodel
I keep seeing stuff about "ref" on the net but "ref" shows " arbument # should not be passed with the ref keyword.
So i am not sure if there is a problem with the model, or with my understanding this, Now for your info I can do the same step with returning a dataset from a stored procedure fine, but I dont want a data set I just want excatly the data in the output parameters from the stored procedure.
i had a stored proc: How can i get the final select statement in the code behind.
ALTER PROCEDURE [dbo].[tgms_reclass_PO_bip](@po VARCHAR(20), @old_gl VARCHAR(20), @new_gl VARCHAR(20),@output varchar(500) out )
AS
IF (SELECT COUNT(*) FROM mm2po WHERE scode = @po) = 0
BEGIN
SET @output = '1'
SET @output = 'Invalid PO Number'
END
[code]...
From this below stored Procudure, using VB.Net code can i get the Values like "Number of Rows Affected" and "Yes / No" Value from "Select"Stored Procudure:ALTER PROCEDURE [dbo].[lookup] @week_date datetimeAS
DECLARE @currweek datetime, @inweek datetime
IF @week_date = '10/14/2010'
BEGIN
UPDATE dbo.work_status SET ob_flag = 0, ob_update_date = NULL WHERE dbo.work_tatus.week_date ='10/14/2010'
SELECT 'YES'
END
ELSE
SELECT 'NO'
RETURN 0
how do I add an output parameter to a Stored Procedure that returns a code or string to the calling app
View 1 RepliesI 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 RepliesI am calling a stored procedure, that exists in a SQL Server 2005 database, using ADO.NET, in which I instantiate a sql command object.
The stored procedure has an ouput variable like '@packageCode VARCHAR(100) = NULL OUTPUT'.
Can I set it's value when creating the sql command object? Or I can never set a value for an output type variable in a stored procedure?
i hav declare a Variable in stored procedure as@Total numeric(18,2) output..@Total Value is calculated 177.12 in stored procedure but when i return in Class.cs..its output is 177..
View 4 RepliesI have written SP like this to get my required output.create procedure [dbo].[usp_gl_ProjectBudgets] set nocount on begin tran declare @SPError int
declare @y1 varchar(20)
declare @y2 varchar(20)
declare @y3 varchar(20)
declare @y4 varchar(20)
declare @y5 varchar(20)
declare @Glink int
declare @i int
set @y1='Year1'
set @y2='Year2'
set @y3='Year3'
set @y4='Year4'
set @y5='Year5'
set @Glink=1
set @i=1
[code]...
We had a simple Gridview that displayed a column list as Linkbuttons but we now need to display three columns as one, so I wrote a simple stored procedure to do it. However, the output in the Gridview shows duplicates and is not in order even though I specifySELECT DISTINCT in the result select as shown below.
ALTER PROCEDURE [dbo].[GetGeneralAction]
Add the parameters for the stored procedure here
AS
BEGIN
SET NOCOUNT ON;
CREATE TABLE #TempTbl (GeneralAction varchar(300) )
INSERT INTO #TempTbl (GeneralAction)
SELECT [General Action]
FROM [dbo].[Formulary2011]
INSERT INTO #TempTbl (GeneralAction)
SELECT [General Action2]
FROM [dbo].[Formulary2011]
[code]...
I have a question. How do we define date output parameters for a stored procedure?
before you answer,I should mention that I am not referring to the sql syntax definition ,which is @mydate datetime output.
This is ok,what i am asking is HOW DO I SPECIFY IT IN LINQ WHEN I NEED TO CALL THE STORED PROCEDURE IN THE SERVER SIDE CODE. I am repeating that I do I am not referring to the sql definition .
here my code-
using (SqlDataReader sqlDataReader = ExecuteReader(CommandType.StoredProcedure, StoredProcedures.AuthenticateUser, sqlParameter))
{
isAuthenticated = Convert.ToBoolean(sqlParameter[2].Value);
if (isAuthenticated)
{
if (sqlDataReader.Read())
{
User = new UserEntity();
DbHelper.GetEntity(sqlDataReader, User);
}
}
}
I always get isAuthenticated as false because sqlParameter[2].Value is null all the time but when I execute my query with ExecuteNonQuery it gives me the value but in that case I can not fill the entity.
I have stored procedure that increments a number. I am supposed to use the newly generated number and insert it into a table. My question is how do I execute the stored procedure, with a hardcoded value of 3 that it expects as a paramter, receive the number it generates as the output parameter and use it in the insert statement.
Here is the stored procedure code:
CREATE PROCEDURE [dbo].[Generate]
@myid int,
@next_no int output
AS
update mytable
set mynumber=mynumber + 1, @next_no = number
where myid=@myid
RETURN
Here is my insert statement, that I tried and it failed:
EXEC @GetNo = Generate '3'
Insert into customers (custid, name, phone ) values
( @GetNo, 'MSFT', '800-345-5678')
