|
Hi,
My web application exports a List of objects to an Excel spreadsheet by creating a DataGrid and binding it to the List. The objects that the List contains include columns whose type is DateTime and while the resulting spreadsheet correctly lists all the objects, the date format is US instead of UK (which is what I want) - to be expected really.
I can, of course, create a new object class and copy each object in the List to a second List of these new object types and bind the DataGrid to that but I'll have to do the same for every list of object types I want to export.
Can anyone suggest a simple method to resolve this issue?
Thanks 
Evil cannot be conquered in the world... It can only be resisted within oneself.
modified 11-Jan-12 6:20am.
|
|
|
|
|
Simplest method turned out to be iterating through the list, parsing any DateTime fields with the DateTime.Parse() method specifying "en-GB" CultureInfo as the DateTimeFormat parameter 
Evil cannot be conquered in the world... It can only be resisted within oneself.
|
|
|
|
|
Hi all,
May we compare the two template fields of Gridview with Compare Validator like below
<asp:TemplateField HeaderText="Qty">
<ItemTemplate>
<asp:TextBox ID="txtSendingQty" runat="server" Enabled="False"
Text='<%#Bind("Qty")%>'></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Recive Item">
<ItemTemplate>
<asp:TextBox ID="txtReciveItem" runat="server"
>/asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
I want to validate the Receive Item with Qty using Compare Validator that User can not insert value greater than qty in Receive Item.
Any Idea
Regards,
|
|
|
|
|
Hi,
Try the below code,
<asp:CompareValidator ID="CompareValidator1" runat="server" ControlToValidate="txtReciveItem"
ErrorMessage="CompareValidator" ControlToCompare="txtSendingQty" Operator="GreaterThan" SetFocusOnError="True" Type="Date"></asp:CompareValidator>
Hope this helps.
-Manognya
__________________________________________________
$ God gives what is best.Not what all you wish
|
|
|
|
|
you can use custom validator with client validation function as below..
function compare(source,args)
{
var receive = parseInt(document.getElementById('txtReciveItem').value);
var sending = parseInt(document.getElementById('txtSendingQty').value);
if (receive > sending)
{
args.Isvalid=false;
}
else
{
args.Isvalid=true;
}
}
see more here[^] on custom validators
with regards
Karthik Harve
|
|
|
|
|
I guess you can, or may
I don't see the point of it.
Just put the qty value in the receive textbox, so the user doesn't have to type in the number unless needed. What if more are received than ordered?
Check the value when the form is submitted on the client or server side.
|
|
|
|
|
sir iam using asp.net3.5 with c#
i want the same menu as code project web site as top navigation as well as left navigation in code project website, can you give me example
|
|
|
|
|
developerit wrote: i want the same menu as code project web site as top navigation as well as left navigation in code project website, can you give me example
Hi I do not know why You would want Your menu's to point to Code Project? 
Just Kidding, I would say it was done With a combination of un-ordered-list, Css And Maybe JavaScript. Why don't You just view source in the browser?
Frazzle the name say's it all
|
|
|
|
|
|
hi
i have following line of code
randomNumber = Math.round(100000*Math.random());
url = "sample.aspx?host="+host+"&port="+port+"&targetName="+targetName+"&imageMode="+imageMode+"&randomNumber="+randomNumber;
alert("callbegins:Authentication.aspx");
location.replace(url);
alert("callends:Authentication.aspx");
break;
in the Authentication.aspx page i have the client code which connects a device. when the line of the above code getting executed it is redirecting to the URL server side but my javascript code are not working. when i call alert after replace then the page getting redirected and client code is getting excuted.
i am confused that why when putting alert after replace it is redirecting and calling client code but when the alert commented then the client code not working.
this issue is in fire fox, and in IE9 its not at all redirecting if alert also there.
please clarify me why this happens
thanks
|
|
|
|
|
I didn't take the time to look it up,
but wouldn't it be
window.location(url);
to use javascript to redirect to another page?
If it's the same page, I don't see the purpose of it.
The alert is just a message box, used for diagnosing values, or to tell the client something important.
FYI;
You need to encode the url with utf-8 or something before calling window.location(url)
|
|
|
|
|
thanks for your time & reply...
Encoding also didn't helped me. the page getting opened when i am using
window.open("URL");
but not when using
window.location.replace("URL");
|
|
|
|
|
take the double quotes off url.
I think you misinterpreted encoding. You just want to make sure that the url you create is in the correct format. encodeURI and encodeURIComponent.
But skip that for now.
window.location(url) will redirect the current page to a new page indicated by url
window.open(url) will open a new browser window, or a new tab, with the value url
it always works unless your url value has an error in it. I would have to see the string you created to see if it is a valid format.
|
|
|
|
|
url = "Authentication.aspx?host=" + host + "&port=" + port + "&targetName=" + targetName + "&imageMode=" + imageMode + "&randomNumber=" + randomNumber;
As you suggested i used as below,but that too didnt helped me out.
url=encodeURIComponent(url);
window.location.replace(url);
(Authentication.aspx%3Fhost%3D172.2.542.166%26port%3D5900%26targetName%3D172.2.542.166%26imageMode%3DColor%26randomNumber%3D79148)
this is the url i need to redirect to, i am getting break point in c# but my client side not getting executed.even i placed an alert in body onload,alert is not shown.this is happening in IE9,FF,chrome all this are HTML5 new browsers.
thanks for the reply..
modified 11-Jan-12 0:14am.
|
|
|
|
|
I need to see the url string after construction, just use alert(url);, and copy the result in this window.
Most likely, you string may be corrupt, and the function failed.
|
|
|
|
|
If you can't get construct the url, show me your header code for pointing to the js file, and post the entire javascript function. I'm taking off in 20 minutes to watch big bang theory on tv, so hurry.
|
|
|
|
|
if(xmlhttp.status == 200)
{
switch (xmlhttp.responseText)
{
//If the browser connected to remote MFP (For Anonymous connections).
case "authenticationrequired":
//Generate random number and attach it to the endpoint to avoid caching problems.
randomNumber = Math.round(100000*Math.random());
url = "Authentication.aspx?host=" + host + "&port=" + port + "&targetName=" + targetName + "&imageMode=" + imageMode + "&randomNumber=" + randomNumber;
// url=encodeURIComponent(url);
alert(url);
//
// window.open(url);
window.location(url);
default:
case...
}
}
|
|
|
|
|
It looks good.
I'd have to say in theory, that the . in the ip address are interfering, there being picked up as a special url character, so you have to encode the dots. Even if you encode the dots, there still dots.
I saw the remarked out urlencode, looks like you tried it, but it still didn't work.
I'm watching my bowling videos now, but check the valid url character set, try the encoding again, paste the results directly into the url bar, until you find something that works.
You may have to replace the dots with another char, to get it to work. try I think %20 which is a space, or an underscore _, I can't remember the encoded value for it, but there are charts on the web, url encoding %20 should find a chart.
Be back tommorow, I'm -8 GMT. I have bowling tommorrow night, so it has to be before 18:00 -8 gmt.
Edit:
I thinking that the url is a bad idea. Maybe a hidden textbox to store the ip is better.
|
|
|
|
|
Really thanks for your time & reply....
Your answers are really helped me out very well to debug depth about URL encoding cooncepts.
In the mean time i have gone through some articles about this issue and tried by returning false after a function call. And also where i am using location.replace(url). now it is working fine but yet to test in all scenarios and all browser versions.
i will get back to you on the said time tommorrow.
bye take care.
|
|
|
|
|
Oh,
That was fast.
Browsers pretty much work the same, so since it failed on all browsers means that the problem was not with the browser.
You have to encode everything you transmit, UTF8 is a set of chars from 1 to 127, that is unicode, and decode everything you receive.
asp.net is a high level wrapper, that talks to c++ code underneath, so the principles of character encoding still apply.
They don't tell you that in the books.
Have fun and go forward, your day will be productive.
jkirkerx
Oh, give me a vote, some day I might be a mvp.
|
|
|
|
|
Really thanks for your time & reply....
Your answers are really helped me out very well to debug depth about URL encoding cooncepts.
In the mean time i have gone through some articles about this issue and tried by returning false after a function call. And also where i am using location.replace(url). now it is working fine but yet to test in all scenarios and all browser versions.
i will get back to you on the said time tommorrow.
bye take care.
|
|
|
|
|
Authentication.aspx?host=172.2.542.166&port=5900&targetName=172.2.542.166&imageMode=Color&randomNumber=15563
this is the one i am getting thru alert.
thanks
|
|
|
|
|
i need help for hows to download attachment file from gridview???
|
|
|
|
|
Hi,
Please use the below code
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
onrowcommand="GridView1_RowCommand">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server"
CommandArgument='<%# Eval("url") %>' CommandName="cmd"><strong class="highlight">Download</strong></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
For handling this on code behind, see the link below:
http://www.daniweb.com/web-development/aspnet/threads/282306[^]
-Manognya
__________________________________________________
$ God gives what is best.Not what all you wish 
|
|
|
|
|
It depends on your program design first.
You can issue a postback to the server, and reload the page, while sending the file down to the browser, if the user clicks ok on the download, or you can do it on the client side using javascript, in which the page stays intact, and javascript intializes the download.
I use the javascript method now. I see no reason to issue a postback, even if it's async.
Javascript
window.open(url to file);
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
