ASP.NET

Re: Return Value from Stored Procedure

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

Re: Return Value from Stored Procedure

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

Re: Web User Controls(ascx)

16-Mar-10 5:38

This is becasue, the Response.End method ends the page execution and shifts the execution to the Application_EndRequest event in the application's event pipeline. The line of code that follows Response.End is not executed.

Resolution:
For Response.End, call the HttpContext.Current.ApplicationInstance.CompleteRequest method instead of Response.End to bypass the code execution to the Application_EndRequest event.

Find the full detail here:
ThreadAbortException [^]

Re: Response.End()

carlecomm17-Mar-10 15:17

carlecomm

17-Mar-10 15:17

Hi,

If you use
1. Response.End，you should try ApplicationInstance.CompleteRequest
2. Response.Redirect，please change it to Response.Redirect(String url, bool endResponse)，set endResponse as false. For example,
Response.Redirect ("nextpage.aspx", false);
3. Server.Transfer，please change it to Server.Execute.

Hope this helps Smile | :)

modified 27-May-14 4:41am.

Web User Controls(ascx)

jonhbt16-Mar-10 4:47

jonhbt

16-Mar-10 4:47

I divided my application into 2 different web apps. I have created a control in the first web app and i need to reference it in the second application. Is it possible to do so? I am trying to drag and drop the control but when debugging i am getting problems.

Thanks for your help.

Sandeep Mewara16-Mar-10 4:58

Re: Web User Controls(ascx)

16-Mar-10 4:58

First of all, whether it's a Custom control or a User control? Heading of your query says a usercontrol.
Had it been a custom control, you can include that as a reference and drag-drop it on your designer.

If it's a user control that too in another project, it would be difficult for you to refer. Either include that user control in your project where you need it or design a similar one.

jonhbt16-Mar-10 5:11

jonhbt

16-Mar-10 5:11

Thanks for your reply. its a user control. The use of itis to have one control which could be used on both apps. Is there any solution for that please?

Re: Web User Controls(ascx)

Sandeep Mewara16-Mar-10 5:40

procedure or function expects parameter which was not supplied

16-Mar-10 5:40

It's a file that can be found in your folders. Since you don't want to create a copy, design the directory of this file such that you can include it in both of your applications!

ishwarya mahadevan16-Mar-10 4:42

ishwarya mahadevan

16-Mar-10 4:42

what kind of exception is this? how to rectify it?

Re: procedure or function expects parameter which was not supplied

Sandeep Mewara16-Mar-10 4:55