ASP.NET

Export to Excel Date Format for UK

13-Jan-12 10:22

You have to capture the last url and store the value in the confirmation page.

thowra11-Jan-12 0:09

thowra

11-Jan-12 0:09

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 Smile | :)

Evil cannot be conquered in the world... It can only be resisted within oneself.

modified 11-Jan-12 6:20am.

Re: Export to Excel Date Format for UK

thowra11-Jan-12 2:28

thowra

11-Jan-12 2:28

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 Cool | :cool:

Evil cannot be conquered in the world... It can only be resisted within oneself.

Compare two Template Fields of Gridview

Rameez Raja9-Jan-12 21:36

Rameez Raja

9-Jan-12 21:36

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,

Re: Compare two Template Fields of Gridview

manognya kota9-Jan-12 22:40

manognya kota

9-Jan-12 22:40

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 Smile | :)

Re: Compare two Template Fields of Gridview

Karthik Harve9-Jan-12 22:43

Karthik Harve

9-Jan-12 22:43

you can use custom validator with client validation function as below..

JavaScript

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

Re: Compare two Template Fields of Gridview

jkirkerx13-Jan-12 10:46

how to display menu control like code project top navigation and left panel menu

13-Jan-12 10:46

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.

developerit9-Jan-12 20:47

developerit

9-Jan-12 20:47

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

Re: how to display menu control like code project top navigation and left panel menu

David C# Hobbyist.10-Jan-12 3:07

David C# Hobbyist.

10-Jan-12 3:07

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? Laugh | :laugh:

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

Re: how to display menu control like code project top navigation and left panel menu

anishkannan10-Jan-12 20:16

anishkannan

10-Jan-12 20:16

You can search on google.

for reference:
ASP.NET Horizontal Menu Control[^]

window.location.replace

Satish_S9-Jan-12 0:09

9-Jan-12 0:09

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

jkirkerx9-Jan-12 9:24

9-Jan-12 9:24

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)

Satish_S9-Jan-12 23:45

9-Jan-12 23:45

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");

jkirkerx10-Jan-12 6:33

10-Jan-12 6:33

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.

Satish_S10-Jan-12 18:05

10-Jan-12 18:05

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.

jkirkerx10-Jan-12 18:10

10-Jan-12 18:10

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.

jkirkerx10-Jan-12 18:16

10-Jan-12 18:16

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.

Satish_S10-Jan-12 18:20

10-Jan-12 18:20

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...

}
}

jkirkerx10-Jan-12 18:33

10-Jan-12 18:33

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.

Satish_S10-Jan-12 18:56

10-Jan-12 18:56

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.

jkirkerx10-Jan-12 19:03

10-Jan-12 19:03

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.

Satish_S12-Jan-12 1:11

12-Jan-12 1:11

Satish_S10-Jan-12 18:17