|
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"
|
|
|
|
|
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
|
|
|
|
|
Did you tried adding '@' before the parameter Email?
|
|
|
|
|
Furtherm, Where from your @UserID parameter is supplied? Shouldn't that too be added in the Command Parameters?
|
|
|
|
|
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
|
|
|
|
|
|
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?
ThanksSteve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
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.
|
|
|
|
|
- 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
|
|
|
|
|
- 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
|
|
|
|
|
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
|
|
|
|
|
May I ask why particularly it needs to be in the html code for the page? Are you prevented from altering code behind?
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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!
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
modified 27-May-14 4:49am.
|
|
|
|
|
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?
|
|
|
|
|
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 [^]
|
|
|
|
|
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
modified 27-May-14 4:41am.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
