|
output type parameter int in the sql server 2000 helps in returning the value.Can i extract the string from the stored procedure .I wrote the following syntax
@error varchar(100) output
but this is not working.
I wanted to get the string in the code behind .
Please Help.
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
Hard to know what 'it's not working' means. If you add a variable to the code that calls your proc, and you set it to be an output variable, once you close the connection, you should be able to use that variable to access the value.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
You have to set the parameter direction to output. Then access the value of that particular parameter after calling stored procedure.
|
|
|
|
|
Sonia Gupta wrote: this is not working
It doesn't really help when you aren't clear as to what is not working.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
I am creating this page where I am reading from the database using a SqlDataReader and Loading the info into an ArrayList. The ArrayList is a class member and the ArrayList object has been created in the class constructor, therefore, this object should be visible to all other members of the class.
However, if I add some objects to the ArrayList in a MenuItem_Click and then try to read those added objects from a Button_Click, it shows the ArrayList is empty - which seems quite surprising. Obviously I am missing something.
Any help?
Thanks.
Ekjon
|
|
|
|
|
The two clicks happen on different postbacks, so there's a new list each time.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi Christian,
Thanks for the reply. I worked mostly with non-web-based apps, so I thought if I create the ArrayList in the costructor, its always the same List unless the page is disposed.
So, what would be the solution? How do I get the same Even if I use a DataSet, is it gonna behave the same way? Please help.
Thanks.
Ekjon
|
|
|
|
|
Everything is going to work the same way, your options are:
1 - store it in viewstate ( this means it goes down to the client every time, making it insecure, and also making your pages huge )
2 - store it in the session ( I don't like this if I can avoid it )
3 - don't store it at all, redirect so some value is on your URL that allows you to rebuild the data from the database.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Thanks so much Christian. It was really helpful. I thought there could be a better way that I don't know, but looks like there isn't. Off course I'll not use ViewState, probably, I'll use the Session.
|
|
|
|
|
I am trying to create a table for layout. Simple header, content and footer sections (rows).
I want the header to sit flush against the top of the page and the footer to sit at the bottom of the page. The content section should fill the available space. I thought setting the height of the table to 100% would accomplish this but there appears to be problems. Is there a neat solution to this problem? What is the workaround?
Code shown below:
<br />
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><br />
<br />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><br />
<br />
<html xmlns="http://www.w3.org/1999/xhtml"><br />
<head runat="server"><br />
<title>Untitled Page</title><br />
</head><br />
<body><br />
<br />
<asp:Table Width="100%" Height="100%" BackColor="Azure" runat="server"><br />
<asp:TableRow><br />
<asp:TableCell Height="50px">top</asp:TableCell><br />
</asp:TableRow><br />
<br />
<asp:TableRow><br />
<asp:TableCell BackColor="Beige"><br />
<form id="form1" runat="server"><br />
<div><br />
mid<br />
</div><br />
</form><br />
<br />
</asp:TableCell><br />
</asp:TableRow><br />
<br />
<br />
<asp:TableRow><br />
<asp:TableCell Height="50px" BackColor="BlanchedAlmond">bottom</asp:TableCell><br />
</asp:TableRow><br />
<br />
<br />
</asp:Table><br />
</body><br />
</html><br />
<br />
<br />
<br />
|
|
|
|
|
Try to use with CSS. Because there is some issues in using Width of table directly.
|
|
|
|
|
hi there,
I have a gridview connected to a SQLDataSource and a formview connected to the same data source, and I am enabling selection to the grid view in oreder to show the details of the selected row from the gridview in the formview ,
I had this script code :
Protected Sub GridView1_SelectedIndexChanged(ByVal obj As Object)
FormView1.PageIndex = GridView1.SelectedIndex
End Sub
But it is not working for me , it just do it for the first one and when I select another row it does nothing
does anyone knows what is the problem 
I am ready to do any thing to solve it
urgent help is needed
There is always something to learn
|
|
|
|
|
Knowledgestudent wrote: urgent help is needed
No. That is very rude.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Thanks for help by the way , I had solved it
thanks again 
There is always something to learn
|
|
|
|
|
Knowledgestudent wrote: I had solved it
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
I have an ASP.Net web application in C# that needs to generate a text file automatically every hour. Is there a way for me to automatically generate the text file without any user interaction on the server or through a client? Is there a timer function that I can called? Thanks.
|
|
|
|
|
You would need to write a web windows service that uses a timer to run some code to generate a file at hourly intervals.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
modified on Friday, December 21, 2007 3:17:10 PM
|
|
|
|
|
The Webcontrols.Login control has a RememberMe checkbox that when checked will write a cookie to the client machine with their identity info. When the client re-visits the site their Page.User.Identity info is read from the cookie.
Anyone know what data this cookie actually stores? Does this cookie store the UserName and Password? Is it storing the UserName and a flag that says this user did successfully log in?
I guess I'm basically wondering how useful this cookie is VS how secure it is.
|
|
|
|
|
If the user successfully logs in and the RememberMe checkbox is ticked, the authentication ticket generated by the Forms Authentication system is stored in a persistent cookie. This ticket is an encrypted string that, when decrypted, uniquely identifies a particular user account. No plaintext information is stored in the cookie for obvious security reasons.
For more information, see this article[^].
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
i am confused in paypal as i am a newbie in handling the payment transaction. I want to know that in dodirectpayment api when i use these api with my apiusername,password,signature and all the other details which this api requires , but i know that money is deducted from buyers a/c through the use of dodirectpayment api but how is it debited to our account,means to seller a/c, how paypal knows which a/c to be debit.
actually want a complete information on this section regarding money transfer and recieve. what actually is the background process.
|
|
|
|
|
Don't know. Have you tried getting help from paypal?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
iam using gridview where iam assing datatable to the grid view datasource .now i want the particular column cells color should in given color
|
|
|
|
|
I think you can set the color of specific columns in RowDataBound event of gridview,and also you can implement this by javascript alternatively
|
|
|
|
|
hi ,Guys
I have master page containing the contentplceholder .
I added the user control dynamically in contentplceholder. Control is added but when I click on button of my user control , the control is vanish , any one know how to handle event of user control that added dynamincally in contenplceholder ?
Yogesh M
|
|
|
|
|
I think the dynamic control will be lost while postback. You will have to keep on adding on every pageload.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
