|
I have a button click and what I need to do is too things:
1. Send an email to the value of what was selected from a required dropdown list of people
2. Then send the user to another page.
I wanted to do both of these in the code behind, and it's been decided the application owner (person who's funding the application) would like to use the client's email application (ie. Eudora, Outlook, etc.) when sending this email.
I'm not sure how to replicate the href='mailto:person@person.com' that's possible with the anchor tag.
|
|
|
|
|
What you may consider doing is adding a client-side click handler that opens the mailto link in a new window. So long as you don't return false from the client event, then your server-side Click event will still fire so that you can call your redirect there. For example:
<asp:Button ID = "test" OnClick = "Button_Click" OnClientClick = "window.open('mailto:user@server.ext'); return true;" Text = "Click Me" runat = "server"/>
Hope that helps. 
--Jesse
|
|
|
|
|
|
Here is the subroutine I’m using to recover the employee’s information from the database.
Protected Sub Load_EmployeeInfo_To_Edit(ByVal intEmployeeID As Integer)
'Purpose: Loads the selected employee's information for editting
'Parameters: intEmployeeID as Integer; The Employee's ID number
'Returns: Nothing - populates the textboxes in the Employees.aspx page
Dim cn As SqlConnection = New SqlConnection(MRMFunctions.WebConfigConnString)
cn.Open()
Try
Dim cd As SqlCommand = New SqlCommand("mrmsp_RetrieveEmployeeForEditting", cn)
cd.CommandType = Data.CommandType.StoredProcedure
'Load the parameters from the stored procedure into the web form
'cd.Parameters.Add("@varEmployeeID", Data.SqlDbType.Int)
'cd.Parameters("@varEmployeeID").Direction = Data.ParameterDirection.InputOutput
cd.Parameters.Add("@varTitleID", Data.SqlDbType.Int)
cd.Parameters("@varTitleID").Direction = Data.ParameterDirection.Output
cd.Parameters.Add("@varDeptID", Data.SqlDbType.Int)
cd.Parameters("@varDeptID").Direction = Data.ParameterDirection.Output
cd.Parameters.Add("@varLName", Data.SqlDbType.NVarChar)
cd.Parameters("@varLName").Direction = Data.ParameterDirection.Output
cd.Parameters.Add("@varFName", Data.SqlDbType.NVarChar)
cd.Parameters("@varFName").Direction = Data.ParameterDirection.Output
cd.Parameters.Add("@varMI", Data.SqlDbType.NVarChar)
cd.Parameters("@varMI").Direction = Data.ParameterDirection.Output
cd.Parameters.Add("@varAddrTypeID", Data.SqlDbType.Int)
cd.Parameters("@varAddrTypeID").Direction = Data.ParameterDirection.Output
cd.Parameters.Add("@varAddress1", Data.SqlDbType.NVarChar)
cd.Parameters("@varAddress1").Direction = Data.ParameterDirection.Output
cd.Parameters.Add("@varAddress2", Data.SqlDbType.NVarChar)
cd.Parameters("@varAddress2").Direction = Data.ParameterDirection.Output
cd.Parameters.Add("@varCity", Data.SqlDbType.NVarChar)
cd.Parameters("@varCity").Direction = Data.ParameterDirection.Output
cd.Parameters.Add("@varStateID", Data.SqlDbType.Int)
cd.Parameters("@varStateID").Direction = Data.ParameterDirection.Output
cd.Parameters.Add("@varZip", Data.SqlDbType.NVarChar)
cd.Parameters("@varZip").Direction = Data.ParameterDirection.Output
txtID.Text = CStr(intEmployeeID)
intTitleID = cd.Parameters("@varTitleID").Value
intDeptID = cd.Parameters("@varDeptID").Value
strLName = cd.Parameters("@varLName").Value
strFName = cd.Parameters("@varFName").Value
strMI = cd.Parameters("@varMI").Value
intAddrTypeID = cd.Parameters("@varAddrTypeID").Value
strAddr1 = cd.Parameters("@varAddress1").Value
strAddr2 = cd.Parameters("@varAddress2").Value
strCity = cd.Parameters("@varCity").Value
intStateID = cd.Parameters("@varStateID").Value
strZip = cd.Parameters("@varZip").Value
Catch ex As Exception
Msg = ex.Message
lblErr.Visible = True
lblErr.ForeColor = Drawing.Color.Red
lblErr.Font.Bold = True
lblErr.Text = Msg
Finally
cn.Close()
End Try
End Sub
For those who need to see the Stored Procedure it is:
USE databasename;
GO
IF OBJECT_ID('mrmsp_RetrieveEmployeeForEditting','P') IS NOT NULL
DROP PROCEDURE mrmsp_RetrieveEmployeeForEditting;
GO
CREATE PROCEDURE mrmsp_RetrieveEmployeeForEditting
@varEmployeeID INT,
@varTitleID INT OUTPUT,
@varDeptID INT OUTPUT,
@varLName VARCHAR(25) OUTPUT,
@varFName VARCHAR(15) OUTPUT,
@varMI VARCHAR(1) OUTPUT,
@varAddrTypeID INT OUTPUT,
@varAddress1 VARCHAR(40) OUTPUT,
@varAddress2 VARCHAR(40) OUTPUT,
@varCity VARCHAR(40) OUTPUT,
@varStateID INT OUTPUT,
@varZip VARCHAR(10) OUTPUT
AS
SELECT @varTitleID = tblEmployees.[TitleID],
@varDeptID = tblEmployees.[DeptID], @varLName = tblEmployees.[LName],
@varFName = tblEmployees.[FName], @varMI = tblEmployees.[MI],
@varAddrTypeID = tblAddresses.[AddressTypeID],
@varAddress1 = tblAddresses.[Address1],
@varAddress2 = tblAddresses.[Address2],
@varCity = tblAddresses.[City],
@varStateID = tblAddresses.[StateID],
@varZip = tblAddresses.[ZipCode]
FROM databasename.dbo.tblEmployees
INNER JOIN databasename.dbo.tblAddresses
ON databasename.dbo.tblEmployees.EmployeeID =
databasename.dbo.tblAddresses.EmployeeID
WHERE databasename.dbo.tblEmployees.EmployeeID = @varEmployeeID
AND databasename.dbo.tblEmployees.Deleted = 0
The intEmployeeID parameter is the only parameter that is showing up. The ones below the txtID.Text are empty. When I ran the Stored procedure within SQL Server the information was there. Does anyone have any idea why this is not working?
Thanks
Quecumber256
|
|
|
|
|
You don't seem to ever execute the stored procedure after setting up all of the parameters. As you, for some reason, are returning all of your data through OUT parameters, you should add the call cd.ExecuteNonQuery() after you finish adding your parameters. Also, don't forget to call the Dispose method on both the command and connection to free up the unmanaged resources.
Hope that helps. 
--Jesse
|
|
|
|
|
Thank you. I completely overlooked that.
Quecumber256
|
|
|
|
|
I put in the ExecuteNonQuery command and now I'm getting this:
String[3]: the Size property has an invalid size of 0.
What's causing this?
Thanks,
Quecumber256
|
|
|
|
|
I'm guessing you haven't told the parameters the expected size of the result, and it has defaulted to zero. In your stored proc you declare the various parameters with a size (e.g. @myParam VARCHAR(25)) add that information to the parameter definition.
Or better yet, ditch this and use ExecuteDataReader and get the data out that way (i.e. remove all but the input parameters). Using output parameters is okay for one or two values, but this is a wee bit much.
|
|
|
|
|
Could you use the code snippet I sent and give me an example of this method? I'm still wet behind the ears where VB.NET and ASP.NET are concerned.
Thanks,
Quecumber256
|
|
|
|
|
probably because you didnt supply a size, for example:
cd.Parameters.Add("@varLName", Data.SqlDbType.NVarChar,50)<code><br />
where 50 should match the size of your column in DB
|
|
|
|
|
Thank you, I'll put it in and see how it goes.
Quecumber256
|
|
|
|
|
i have a web page that displays data from dataset in HtmlTable
i add linkbutton in specific cell
i want whaen i click this linkbutton add new table cell in the specific cell
i hope my question clear
thanks for help
MD_NADA
|
|
|
|
|
You want to add a new cell within the one containing the link button? A nested cell? HTML tables don't work like that....
|
|
|
|
|
If you create the table like this:
<asp:Table ID="MyTable" runat="server"></asp:Table>
then you can add rows and/or cells like this:
TableRow tr = new TableRow();
TableCell td = new TableCell();
tr.Controls.Add(td);
MyTable.Controls.Add(tr);
Tara
|
|
|
|
|
this is right thank you
but if i did this code the row will be the last row
i want to add the new row after the current row
if i am clicking in rowindex 2 the new row will be rowindex 3
thanks
MD_NADA
|
|
|
|
|
Use Table.Rows.AddAt(index, row)
|
|
|
|
|
Hi all
i am using a web service in my asp.net 2.0 project
wstest.WebservicePvr.com/ABCClass.asmx
there are folder created like
App_WebReferences
-wstest
-WebservicePvr
-com
-ABCClass.disco
-ABCClass.discomap
-ABCClass.wsdl
then i have created the object like follow in all the code behind file.
using wstest.WebservicePvr.com;
ABCClass _objABCClass=new ABCClass();
using this code accessing the all the web method and i have done my project and it working properly.
Now the problem i have to change the live webservice
Is it possible to handle this problem from the web.config.
Please help.
Many many thanks in advance
Regards,
Srinandan
|
|
|
|
|
The url of the webservice can be specified in your .config file rather then hardcoded in the proxy. To do so, right-click the web reference and set its connection property to dynamic. Also, the proxy has a url property that you can set. For programatic manipulation, see examples here[^] and here.[^]
Hope that helps.
--Jesse
|
|
|
|
|
Good day my fellow people.
How are you.
I was wondering along my route through Atlas and such. If you have a single UpdateProgress in your master page then it will show the progress panel on any inner pages asych call. Is this correct and also can this be prevented at certain times for certain UpdatePanels?
Thanks for reading and keep it real. Ciao
|
|
|
|
|
The following code works:
<<asp:TemplateField ItemStyle-Width="1px">
<<ItemTemplate>
<<asp:ImageButton ID="imbView" runat="server" ImageUrl="~/Images/ViewSearch.gif"
CommandName="View" CommandArgument='<%# Eval("UID") %>'
ToolTip='<%# "View employee information for " & Eval("FullName") & "." %>' />
<</ItemTemplate>
<</asp:TemplateField>As I said, all works well here. However, I would prefer to have the following display for the ToolTip instead:
ToolTip='<%# "View " & Eval("FullName") & "' employee information." %>' However it does not like the single quote ('). I have tried placing 2 and 3 single quotes in a row and it still fails.
Any ideas?
Thanks,
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
Try replacing with '
|
|
|
|
|
Thanks for the reply however it literally show up the "'". I even tried the following:
ToolTip='<%# System.Web.HttpUtility.HtmlDecode("View " & Eval("FullName") & "' employee information.") %>'It failed as well.
Any other ideas?
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
Escape it with a backslash?
|
|
|
|
|
Thanks but I have already tried that as well. I get the usual 'server tag not well formed' error and the page does not render.
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
Try ToolTip='<%# MyCodebehindFormatingMethod(Eval("FullName")) %>'
"Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
