ASP.NET

Return Value from Stored Procedure

16-Mar-10 11:16

Thanks for your answer.
So in order to use the ups tracking code webservice I will need to contact UPS or...?

ahayw0116-Mar-10 8:06

ahayw01

16-Mar-10 8:06

Hello,

I have a asp.net website and a C# web page and I am calling a stored procedure to return the email address of the user that is logged in.

I have debugged my code and am presented with the following error message.

Cannot implicitly convert type 'System.Data.SqlClient.SqlParameter' to 'string'

Any assistance you can provide would be much appreciated.

My code for the web page class and my code for the stored procedure are below.

Thank you,

Allison

EmailTo Class

<br />
public class EmailTo<br />
{<br />
	public string getEmailTo() <br />
	{<br />
     <br />
                // Command - specify as StoredProcedure<br />
                using (System.Data.SqlClient.SqlConnection myConnection = new<br />
                   System.Data.SqlClient.SqlConnection(ConfigurationManager.<br />
                   ConnectionStrings["ConnectionString2"].ConnectionString))<br />
                {<br />
                    System.Data.SqlClient.SqlCommand myCommand2 = new System.Data.SqlClient.SqlCommand();<br />
                    myCommand2.CommandText = "usp_get_email_to";<br />
                    myCommand2.CommandType = CommandType.StoredProcedure;<br />
                    myCommand2.Connection = myConnection;<br />
<br />
                    // Return value as parameter<br />
                    SqlParameter returnEmail = new SqlParameter("Email", SqlDbType.NVarChar);<br />
                    returnEmail.Direction = ParameterDirection.ReturnValue;<br />
                    myCommand2.Parameters.Add(returnEmail);<br />
<br />
<br />
                    // Execute the stored procedure<br />
                    myConnection.Open();<br />
                    myCommand2.ExecuteNonQuery();<br />
                    myConnection.Close();<br />
<br />
                    return returnEmail;<br />
<br />
                                 <br />
            }<br />
        }<br />
}<br />
<br />

Stored Procedure

<br />
CREATE PROCEDURE dbo.usp_get_email_to<br />
<br />
	@Email nvarchar(256),<br />
	@UserId uniqueidentifier<br />
	<br />
AS<br />
<br />
SET @Email  = (SELECT Email FROM aspnet_Membership<br />
	WHERE UserId=@UserId)<br />
<br />
<br />
RETURN @Email<br />
GO<br />
<br />
<br />

Sandeep Mewara16-Mar-10 9:14

16-Mar-10 9:14

ahayw01 wrote:
SqlParameter returnEmail = new SqlParameter("Email", SqlDbType.NVarChar);
returnEmail.Direction = ParameterDirection.ReturnValue;
myCommand2.Parameters.Add(returnEmail);

1. parameter should start with '@'

SqlParameter returnEmail = new SqlParameter("@Email", SqlDbType.NVarChar);

2. parameter value is missing - add this below line before adding the parameter to myCommand2

returnEmail.Value = "abc@codeproject.com"

ahayw0116-Mar-10 9:23

ahayw01

16-Mar-10 9:23

Sandeep,

Thank you so much for your quick response.

I am a little confused about step 2. I think that I may not have been clear in my initial post.

The returnEmail.Value should be pulling from the value that is stored in the sql table.

However, I had thought that the existing code will account for that

<br />
returnEmail.Direction = ParameterDirection.ReturnValue;<br />
                    myCommand2.Parameters.Add(returnEmail);<br />

Any additional suggestions would be appreciated. My apologies for any confusion.

Allison

Sandeep Mewara16-Mar-10 9:27

16-Mar-10 9:27

Did you tried adding '@' before the parameter Email?

Sandeep Mewara16-Mar-10 9:34

16-Mar-10 9:34

Furtherm, Where from your @UserID parameter is supplied? Shouldn't that too be added in the Command Parameters?

ahayw0116-Mar-10 9:34

ahayw01

16-Mar-10 9:34

Hello,

Thanks yes, I did apply step 1. And was still receiving the same error message.

However, just tried and tested the following and now it works

return returnEmail.Value as String;

Thanks again for your help,

Allison

Sandeep Mewara16-Mar-10 9:38

Defaulting a DataView control with paging to the last page.

16-Mar-10 9:38

Steven J Jowett16-Mar-10 7:00

Steven J Jowett

16-Mar-10 7:00

I have DataView control with paging on an asp.net webpage. I have been asked if it is possible to default the DataView to the last page, rather than page 1.

So I tried this :-

Protected Sub telemetryGridView_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles telemetryGridView.PreRender
        If Not IsPostBack Then
            telemetryGridView.PageIndex = telemetryGridView.PageCount - 1
            telemetryGridView.DataBind()
        End If
    End Sub

I read somewhere that after setting the PageIndex I would need to call the DataBind method of the GridView.

The result is that the GridView still defaults to page 1.

Can anyone enlighten me as to where I am going wrong?

Thanks

Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.

Re: Defaulting a DataView control with paging to the last page.

Sandeep Mewara16-Mar-10 7:15

Re: Defaulting a DataView control with paging to the last page.

16-Mar-10 7:15

This code looks ok. Now are you rebinding the grid again after this? Try VS debugger and see if your grid is getting re-bind somewhere else after this?

Also, try using the above code in Page Prerender instead of controls pre-render.

ASHISH GHADI18-Mar-10 22:02

ASHISH GHADI

18-Mar-10 22:02

- Solution (same i am doing on page load it works)

Public Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not IsPostBack Then
telemetryGridView.DataBind()
telemetryGridView.PageIndex = telemetryGridView.PageCount
End If
End Sub

In short you have to set max index after binding the datagrid, in your case pre render

GridName.DataBind()
GridName.PageIndex = GridName.PageCount

Re: Defaulting a DataView control with paging to the last page.

ASHISH GHADI18-Mar-10 22:08

ASHISH GHADI

18-Mar-10 22:08

if statement in the html code in aspx page

laziale16-Mar-10 5:39

16-Mar-10 5:39

Hello,
I want to create if statement in the html part of my site. Can someone help me with that and give me some example.
I have a label and depending from the text, the forecolor to be different.
Here is what I have:

<asp:Label ID="lblFirstName" runat="server" Text='<%#Server.HtmlEncode(Eval("FirstName").ToString())%>'></asp:Label>

So depending on the text, for example if the text contains 'John' text will be in red, if the text contains 'Jim' text will be in blue.

Thanks for any advice,
Laziale

JHizzle16-Mar-10 5:41

JHizzle

16-Mar-10 5:41

May I ask why particularly it needs to be in the html code for the page? Are you prevented from altering code behind?

laziale16-Mar-10 5:43

16-Mar-10 5:43

I am trying to solve this issue in the code behind file, but I am trying almost two days now without any success.
The thing is that the label is in templatefield within gridview and I am having hard time to solve how I can get to the label in the gridview, check the text and set the forecolor depending on the text.
If you have good example how I can solve this in code behind file I will be more then pleased to accept that.
Thanks, Laziale

JHizzle16-Mar-10 5:50

JHizzle

16-Mar-10 5:50

Ahhh ok. So, from my experience, you're probably going to want to hook into the databind event on a row, find your label control using fincontrol on the row being passed and then change the colour there. Example:

protected  void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{

Label myLabel = (Label)e.Row.FindControl("yourlabel");

if (myLabel.Text == "Jack")
{
    'change the colour here
}

}

There might be an easier way but that's just off the top of my head.

Sandeep Mewara16-Mar-10 5:44

16-Mar-10 5:44

Looks like you are setting the Label text at runtime and server side. Why using a Eval container?
Directly in the server side, use a switch statment, based on various case, set the back/fore color of the label and also set the text!

laziale16-Mar-10 5:50

16-Mar-10 5:50

I am trying this on button event:

for (int i = 0; i < gvPpl.Rows.Count; i++)
           {
               Label lblL = (Label)gvPpl.Rows[i].Cells[2].FindControl("lblFirstName");
           }

but nothing comes up.
Can you give me some example how I can do that, and how I can set the forecolor afterwards. Eval container was there before I started working on this code.
Please advice if I can/need to use something else and still get the same data.
Thx, Laziale

Sandeep Mewara16-Mar-10 5:51

16-Mar-10 5:51

Based on what now you say, that this is not an independant label and is in the GridView template field...
Here you go:

void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{    
    if (e.Row.RowType == DataControlRowType.DataRow)    
    {           
         Label lblFirstName= (Label)e.Item.FindControl("lblFirstName");       
         if(lblFirstName.Text == "John")             
            lblFirstName.ForeColor=Color.Red;      
         else if(lblFirstName.Text == "Jim")
            lblFirstName.ForeColor= Color.Blue;
    }
}

Lastly, i would suggest to pick a book and read before mocing ahead with development. This is because 2-3 threads below you had been given almost 80% of the code and yet you are unable to get it.

laziale16-Mar-10 6:03

16-Mar-10 6:03

First, thanks for your reply. I tried that thing too, but I am getting no value for the label. Here is what I have:

in the html part:

<div style="padding-left: 10px; padding-right: 10px; text-align: left; width:45%">
                                             <asp:Label ID="lblFirstName" runat="server" Text='<%#Server.HtmlEncode(Eval("FirstName").ToString())%>'></asp:Label>
                                            </div>

in the code behind:

protected void gvPpl_DataBound(object sender, GridViewRowEventArgs e)
       {


           for (int i = 0; i < gvPpl.Rows.Count; i++)
           {
               Label lblL = (Label)gvPpl.Rows[i].Cells[2].FindControl("lblFirstName");
               Label lblL1 = (Label)gvPpl.Rows[i].Cells[1].FindControl("lblFirstName");
               Label lblL2 = (Label)gvPpl.Rows[i].Cells[0].FindControl("lblFirstName");
               Label lblL3 = (Label)gvPpl.Rows[i].Cells[3].FindControl("lblFirstName");
           }
       }

I am trying with different cells, just in case I have the wrong cell, but that is not helping, all the labels have no text.

Any advice?
Thx, Laziale

carlecomm16-Mar-10 17:30

carlecomm

16-Mar-10 17:30

Hi,

If you just want to change the forecolor, you can try this:
string test1 = "John";
string test2 = "Jim";
string testStr = Label1.Text;//source string

if (testStr.IndexOf(test1) > 0)
Label1.ForeColor = System.Drawing.Color.Red;
else if (testStr.IndexOf(test2) > 0)
Label1.ForeColor = System.Drawing.Color.Blue;

Hope it helps Smile | :)

modified 27-May-14 4:49am.

Response.End()

pss.srinivasan16-Mar-10 5:20

pss.srinivasan

16-Mar-10 5:20

HI
Response.End () giving This Error

Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack

Please How to solve?

Re: Response.End()

Sandeep Mewara16-Mar-10 5:38