Hi in our webserver oftenly we get an error ORA-03113: end-of-file on communication channel, whenever our website tries to connect an Oracle database.This error disappears when we restart the IIS.
Can anyone give a permanent solution to this problem?
To request a friend, I think it is done as follows
When the user selects the person by his/her name and click send request
The system does 2 things:
1- Sends an email message to that person including the name of the sender
2- Insert a new request record in the requests table of that person to enable him/her see it within the site
Change your TextBox to a DropDownList
Create a StoredProcedure that will return you a listing of Categories from your Category reference table
Transform the raw data into a List of KeyValuePairs with your category DisplayNames and your Database Values,
Set the DataSource of your DropDownList to the List<KeyValuePair<string,string>> where each KeyValuePair represents an individual category,
Trigger a postback on Category Selection,
Send the category down to your Stored Procedure as a parameter,
Pull back data,
set the DataSource of your GridView to a List of your Business Objects
Quick and dirty, typed in-line off top of head:
public List<KeyValuePair<string, string>> GetCategories()
//Pseudo-Code//Open Database Connection//Create a command of type StoredProcedure//Tell the command which stored procedure to execute (preferrably, your "GetCategories() SP)
List<KeyValuePair<string,string>> categories = new List<KeyValuePair<string,string>>();
public List<BusinessObject> GetData(int category)
//Pseudo-Code//Open Database Connection//Create a command of type StoredProcedure//Tell the command which stored proc to execute (preferrably, the one that "Gets Data")//Send category down to Stored Proc as a parameter
List<BusinessObject> list = new List<BusinessObject>();
protectedvoid Page_Load(object sender, EventArgs e)
grdData.DataSource = GetData();
ddlCategories.DataSource = GetCategories();
ddlCategories.DataTextField = "Key";
ddlCategories.DataValueField = "Value";
Well...to pass data from one page to another, you are going to have to have some way of persisting the relevant information between pages because web development is inherently stateless.
The most common methods for passing data from form to form would be:
I suggest you begin by investigating these three mechanisms.
Then, figure out how to bind a GridView to data that you pull out of your chosen variable. Then, figure out how to put data from the original GridView into the variable. If you can combine these three tasks, you will be able to pass data from GridView to GridView.
I'm running into some very weird (to me) behavior when I try to chain the OnClick event of a Label to an Anchor. If that isn't self-explanatory, what I'm doing is showing a Label and hiding an Anchor. When I click on the Label, the Label clicks the Anchor.
My debugging process:
-> If I hide the Label, Show the anchor and set the function directly in the OnClick event in the a tag, executes as expected
-> If I show the Label, Hide the anchor and set the function directly in the OnClick event in the asp:label tag, executes as expected
Clicking the Label is triggering a PostBack, but it is not executing the client-side onclick event before doing so.
I've included the relevant code below. Does anyone have enough experience in this area to know why the Anchor's onclick event is not chained to the Label?
I am trying to code a procedure in VB.Net where a user clicks on a link and the page detects the email of the person. This way I will be able to validate that it is a new user who has accessed the activation aspx page.
Currently, I have the follwing:
IF Request.QueryString("uid") > 0 THEN<br />
'activate user<br />
'display error message<br />
I can also query the DB to see if the userID is > 0 AND if the activation status is false, but it is still not specific enough. If I can include his EMAIL ADDRESS in the query, I will have solved the issue.
Well because your user might have a browser but not an email client or multiple registered emails, there's no linkage between machine and email address or browser and email address so you're basically going to have to add another variable to your querysting to include their registered email (I'm assuming your link is sent out via mail a la a forum registration message).
My only extension would be to encrypt the value on the way out and then decode it in your page's code when they come back. Just because someone might mess around with the URL, randomly entering IDs and email combinations.
It's unlikely I'll admit but it's just one of those things I end up doing just for peace of mind.