Time converting - ASP.NET Discussion Boards

Amit Agarrwal29-Jun-06 0:52

29-Jun-06 0:52

hi i m using Asp.net with Mysql as a Database. I have store date in Mysql with my webpage now the Problem is that i want to Show the data whose is Greater than Current date But i m now able to do that..pls. help me tell me what the query shuld i wrote that compare the current date with database date...

thanx

byee

Aavesh

Re: Compare Date In Mysql

varshavmane29-Jun-06 1:59

varshavmane

29-Jun-06 1:59

hi,

Try this I hope it will help u:

System.Globalization.DateTimeFormatInfo dtf = new System.Globalization.DateTimeFormatInfo();<br />
dtf.ShortDatePattern = "dd/MM/yyyy";<br />
DateTime todate = DateTime.Parse(txtTrainingedt.Text, dtf);<br />
DateTime fdate  = DateTime.Parse(txtTrainingfdt.Text, dtf);<br />
                        <br />
if(DateTime.Compare(todate,fdate) >= 0)<br />
{<br />
}

Date.Compare retruns >0 if todate is greater than from date and return 0 if it is equal.

Re: Compare Date In Mysql

Amit Agarrwal29-Jun-06 2:29

Amit Agarrwal

29-Jun-06 2:29

hello

thanx

actually i'm writing a query for getting the the filtered record on the basic of

current date like this: -

select * from GarageSales where siteid ='" & sid & "' and Gar_Date <" & Date.Today.

and its not working..i'm using my sql as a database.

Re: Compare Date In Mysql

varshavmane29-Jun-06 3:12

varshavmane

29-Jun-06 3:12

Try to store todays date in a variable and the assign.I really dont know how to handle this.Sorry Frown | :(

Re: Compare Date In Mysql

Guffa29-Jun-06 3:46

Guffa

29-Jun-06 3:46

You need apostrophes around the date in the query. Also you should convert the date to a string instead on using automatic conversion, so that you can specify the format. I suggest ISO 8601 date format: "yyyy-MM-dd".

---
b { font-weight: normal; }

Re: Compare Date In Mysql

Amit Agarrwal29-Jun-06 18:59

Amit Agarrwal

29-Jun-06 18:59

hello

thanx for the such a nice answer..

could u tell me plz how to make mouse over event on datalist control.

i have thumb image in datalist & and image control just above it..

i want to show a large image in a image control when a user move a mouse on the corresponding thumb image.

could u send me some relevant code..

thanx

Re: Compare Date In Mysql

Guffa29-Jun-06 19:13

Guffa

29-Jun-06 19:13

No, I don't use datalists.

If you show some code I might be able to help you with it.

---
b { font-weight: normal; }

Time converting

varshavmane29-Jun-06 0:32

varshavmane

29-Jun-06 0:32

Hi all,

I want datetime datatype column in database(SQL Server).In SQL it is stores in the format MM/dd/yyyy hr:mm:ss AM/PM.
My problem is that I need to display this time in 24hrs.
For ex: 6/20/2005 3:30:00 PM
They I want to display 20/6/2005 in date column of datagrid and and the time 3:30 PM should be display as 15:30 and it is AM then I dont have to do any thing.

For Date I have use the following code:

System.Globalization.DateTimeFormatInfo dtf = new System.Globalization.DateTimeFormatInfo();
dtf.ShortTimePattern = "dd/MM/yyyy";
DateTime fdate = DateTime.Parse(txtTrainingfdt.Text, dtf);

Can any one tell me how should I do the same thing for time.

Thanks in advance.

Re: Time converting

Sushant Duggal29-Jun-06 1:00

Sushant Duggal

29-Jun-06 1:00

Hi,

this is what you want

http://idunno.org/displayBlog.aspx/2004071401[^]

Sushant Duggal.

Re: Time converting

varshavmane29-Jun-06 1:46

varshavmane

29-Jun-06 1:46

Hi,

how do I Parse it.Following code I have used:

string datefrom = htxtFromTime.Value.Substring(index+1);
string dateto = htxtToTime.Value.Substring(index+1);
System.Globalization.DateTimeFormatInfo dtf = new System.Globalization.DateTimeFormatInfo();
dtf.ShortTimePattern = "HH:mm";

Now I need to store the time in any variable in the format HH:mm (24hrs)

Please help me in this.Thanks.

how to pass more than 1 parameter in crystal report 10

arunlala29-Jun-06 0:20

arunlala

29-Jun-06 0:20

In the given code iam trying to pass 1 parameter ..its working fine ... how can i pass more than 1 parameter ???

CrystalDecisions.Shared.TableLogOnInfo objConInfo;
ReportDocument objRDoc;
--------------------------
--------------------------
objRDoc.SetParameterValue("USERID", 1);
--------------------------
--------------------------
objobjExpOptspts.ExportDestinationType=exportDestinationType.DiskFile;
objobjExpOptspts.ExportFormatType = ExportFormatType.PortableDocFormat;
objobjExpOptspts.DestinationOptions = objDiskFileOpts;
objRDoc.SetDatabaseLogon("userid", "password");
objRDoc.Export();

thanks
Arunlal

How To Embed images in Mail

Sushant Duggal29-Jun-06 0:04

Sushant Duggal

29-Jun-06 0:04

Hi,

Can anyone tell me how to send images in the mail. Not as a attachment, I want to embed images in the mail.

Thanks,

Sushant Duggal.

Re: How To Embed images in Mail

Maksi29-Jun-06 0:10

Maksi

29-Jun-06 0:10

send email body type as html not text, and in the body write , or link of your image on the net.

Re: How To Embed images in Mail

Sushant Duggal29-Jun-06 0:54

Sushant Duggal

29-Jun-06 0:54

Hi,

Thanks for the reply.

But i can't use the server address as i am developing windows Application.
I need to send the images along with the mail.
If you have any other Idea, please let me know.

Thanks,

Sushant Duggal.

Re: How To Embed images in Mail

Jesse Squire30-Jun-06 0:54

Jesse Squire

30-Jun-06 0:54

Always remember: Google is your friend. A quick search[^] produced plenty of hits. A couple to get you started:

mwdiablo's article[^] here on CodeProject
A tutorial[^] at DotNetBlips
The commercial component AspNetMail[^]

Hope that helps a bit. Smile | :)

--Jesse

Authentication not being transferred

WillemM28-Jun-06 23:53

WillemM

28-Jun-06 23:53

I am trying to use the CRM webservice from a sharepoint webpart, but I get "The request failed with HTTP status 401: Unauthorized" when enabling callstack on the sharepoint website. It comes from the webpart that I use to display some data from the CRM webservice.

CRM and Sharepoint both use windows integrated authentication and both have impersonation set to 'true'.

I'm quite puzzled how this can happen. Anyone have a clue what's going on here?

WM.

What about weapons of mass-construction?

Re: Authentication not being transferred

Paddy Boyd29-Jun-06 0:25

Paddy Boyd

29-Jun-06 0:25

The default (at least this was with 1.1) was for webservice calls to run under the NetworkServices account. In your code for the webservice what you can do is:

localhost.Service1 myProxy = new localhost.Service1();
myProxy.Credentials = System.Net.CredentialCache.DefaultCredentials;

See this[^] for a bit of further info.

Re: Authentication not being transferred

WillemM29-Jun-06 1:25

WillemM

29-Jun-06 1:25

I forgot to tell that part, I did that and it didn't do much for the authentication. As far as I know now it has something to do with KeepAlive.

In .NET 1.1 there was a setting for this, but it is no longer available in .NET 2.0, at least I can't find it...

WM.

What about weapons of mass-construction?

Re: Authentication not being transferred

WillemM29-Jun-06 1:49

WillemM

29-Jun-06 1:49

Just posting a follow-up on the problem: I just discovered in the documentation of the CRM list webpart from microsoft, that I need to setup kerberos authentication on the sharepoint webserver and trust delegation for the sharepoint server and crm server, so that it can delegate the user information.

I'm off to find an administrator to help me setup the active directory for this change Big Grin | :-D

WM.

What about weapons of mass-construction?

XML Paging, Datalist

Maksi28-Jun-06 23:45

Maksi

28-Jun-06 23:45

How can I achieve paging Datalist with datasource is XML file.
The XML file includes many records thats why i dont want to get all records to Dataset. Have anybody did that?
Thank you in advance.

Makusato

Re: XML Paging, Datalist

Maksi29-Jun-06 5:41

Maksi

29-Jun-06 5:41

Thank you, i did that, with help of Igor Gribanov's article.
http://www.codeproject.com/soap/xsltpaging.asp

DateFormat problem

Commickey28-Jun-06 23:16

Commickey

28-Jun-06 23:16

Hello, I am using Sql server, I want to display a date on a datagrid with the following details:

_ Only the date and not the time
_ The format of the date should be dd/mm/dddd

I am getting this column from the database and would like to display on a datagrid.... can someone help with the sql statement that will help me in doing this conversion?

Thanks alot,

Commickey

Re: DateFormat problem [modified]

mehnazash28-Jun-06 23:45

mehnazash

28-Jun-06 23:45

//Check the third field , this is how u need to write
103 represents some code given by .net

string query = "select build_desc,baseline,folder,convert(varchar(10),build_date,103),comment,developed_by,convert(varchar(10),modified_on,103),approval_flag from build_master order by build_date";

Hope this helps
Jiny

-- modified at 5:59 Thursday 29th June, 2006

Re: DateFormat problem

Commickey29-Jun-06 0:37

Commickey

29-Jun-06 0:37

Yes... thanks... it solved my problem....

Re: DateFormat problem [modified]

Sushant Duggal28-Jun-06 23:47

Sushant Duggal

28-Jun-06 23:47

Hi,
Use

string.Format("{o:dd/MM/yyyy}",yourdate);

check whether mm or MM

Thanks,

Sushant Duggal.

-- modified at 5:49 Thursday 29th June, 2006

Last Visit: 31-Dec-99 18:00 Last Update: 28-May-24 6:12

Refresh

ᐊ Prev 1...6126 6127 6128 612961306131 6132 6133 6134 6135 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.