Click here to Skip to main content
15,889,216 members
Home / Discussions / ASP.NET
   

ASP.NET

 
Questionasp.net-text editor Pin
luckyve14-Feb-07 8:18
luckyve14-Feb-07 8:18 
AnswerRe: asp.net-text editor Pin
Sylvester george14-Feb-07 19:26
Sylvester george14-Feb-07 19:26 
AnswerRe: asp.net-text editor Pin
M A A Mehedi Hasan14-Feb-07 19:59
M A A Mehedi Hasan14-Feb-07 19:59 
QuestionPage Classes Pin
DanB198314-Feb-07 7:41
DanB198314-Feb-07 7:41 
QuestionASP.NET 2.0 button click to perform 2 actions (client side e-mail then redirect to another page) Pin
bubberz14-Feb-07 6:31
bubberz14-Feb-07 6:31 
AnswerRe: ASP.NET 2.0 button click to perform 2 actions (client side e-mail then redirect to another page) Pin
Jesse Squire14-Feb-07 7:34
Jesse Squire14-Feb-07 7:34 
GeneralRe: ASP.NET 2.0 button click to perform 2 actions (client side e-mail then redirect to another page) Pin
Neeraj Arora14-Feb-07 17:23
Neeraj Arora14-Feb-07 17:23 
QuestionNo data being returned by the stored procedure. Pin
Quecumber25614-Feb-07 3:59
Quecumber25614-Feb-07 3:59 
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
AnswerRe: No data being returned by the stored procedure. Pin
Jesse Squire14-Feb-07 4:10
Jesse Squire14-Feb-07 4:10 
GeneralRe: No data being returned by the stored procedure. Pin
Quecumber25614-Feb-07 4:24
Quecumber25614-Feb-07 4:24 
AnswerRe: Now I getting a different error. Pin
Quecumber25614-Feb-07 5:00
Quecumber25614-Feb-07 5:00 
GeneralRe: Now I getting a different error. Pin
Colin Angus Mackay14-Feb-07 5:13
Colin Angus Mackay14-Feb-07 5:13 
GeneralRe: Now I getting a different error. Pin
Quecumber25614-Feb-07 6:06
Quecumber25614-Feb-07 6:06 
GeneralRe: Now I getting a different error. Pin
Bassam Saoud14-Feb-07 5:17
Bassam Saoud14-Feb-07 5:17 
GeneralRe: Now I getting a different error. Pin
Quecumber25614-Feb-07 6:06
Quecumber25614-Feb-07 6:06 
QuestionAdd new cell in htmltable control Pin
Mohammed Elkholy14-Feb-07 3:41
Mohammed Elkholy14-Feb-07 3:41 
AnswerRe: Add new cell in htmltable control Pin
badgrs14-Feb-07 3:47
badgrs14-Feb-07 3:47 
AnswerRe: Add new cell in htmltable control Pin
tarasp14-Feb-07 4:17
tarasp14-Feb-07 4:17 
GeneralRe: Add new cell in htmltable control Pin
Mohammed Elkholy14-Feb-07 4:22
Mohammed Elkholy14-Feb-07 4:22 
GeneralRe: Add new cell in htmltable control Pin
badgrs14-Feb-07 4:47
badgrs14-Feb-07 4:47 
Questionhow to change the webservice Pin
srinandan..14-Feb-07 3:27
srinandan..14-Feb-07 3:27 
AnswerRe: how to change the webservice Pin
Jesse Squire14-Feb-07 3:54
Jesse Squire14-Feb-07 3:54 
QuestionUpdate Progress Is A Bitch And I want to slay it Pin
Sam Heller14-Feb-07 3:20
Sam Heller14-Feb-07 3:20 
QuestionDisplay a single quote in a GridView's ToolTip Pin
-Dr_X-14-Feb-07 3:11
-Dr_X-14-Feb-07 3:11 
AnswerRe: Display a single quote in a GridView's ToolTip Pin
andyharman14-Feb-07 3:25
professionalandyharman14-Feb-07 3:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.