Re: Help - ASP.NET Discussion Boards

Re: webpages flickers/Blinks during post backs....

dhulipudi14-Jun-07 3:21

dhulipudi

14-Jun-07 3:21

It's working now... Big Grin | :-D

in IE 6.0, 7.0. Problem remains in Firefox. D'Oh! | :doh:

I kept it in web.config

<system.web>
<pages smartNavigation="true"/>
</system.web>

Thanks U Sylvester,

Regards,
JJ

query problem (with date format) in dot net

deep714-Jun-07 1:25

deep7

14-Jun-07 1:25

this query when exceuted on oracle client does show the data:

select sum(locked_items) as locked_items ,sum(total_item_count) as total_item_count , sum(failed_item_count)as failed_item_count from ita_job_audit where to_date(job_created_on,'dd/MM/yyyy') = to_date('13/06/2007', 'dd/MM/yyyy') group by worker_process_oid

but when exceuted from my asp.net application...donn get any data in the dataset..here the code:
OracleConnection conn = new OracleConnection();
DataSet ds = new DataSet();
OracleDataAdapter adapter= new OracleDataAdapter();

adapter.SelectCommand = new OracleCommand(@"select sum(locked_items) as locked_items ,sum(total_item_count) as total_item_count, sum(failed_item_count)as failed_item_count from ita_job_audit where to_date(job_created_on,'dd/MM/yyyy') = to_date('13/06/2007', 'dd/MM/yyyy') group by worker_process_oid", conn);

adapter.Fill(ds,"Jobs");

My problem is with the date format in the query...if i put some other where condition (which has no date) then it gets the data...but with this particular where condition..it donn wrk...

its something to do with how dot net send data to the oracle client...
could anyone help me out here plz..

Thanks,
Dee

Re: query problem (with date format) in dot net

andyharman14-Jun-07 3:33

andyharman

14-Jun-07 3:33

Try:

select sum(locked_items) as locked_items,
  sum(total_item_count) as total_item_count,
  sum(failed_item_count)as failed_item_count
from ita_job_audit
where to_char(job_created_on, 'dd/MM/yyyy') = '13/06/2007'
group by worker_process_oid

I think your "to_date(job_created_on,'dd/MM/yyyy')" is causing the job_created_on column to be implicitely cast to a string (using the default date format) - before you convert it back into a date.

Note that I have not been able to test this because I don't have access to Oracle at the moment.

Regards
Andy

Re: query problem (with date format) in dot net

deep714-Jun-07 18:47

deep7

14-Jun-07 18:47

Thank you Andy...it worked!
i had tried so many ways but not this way...thanks again Smile | :)

Chat coding

Sathiya Narayanan14-Jun-07 1:22

Sathiya Narayanan

14-Jun-07 1:22

i want one individual chat coding... in Dot Net... may with database or with out database..... like Google....

Sathiya

Re: Chat coding

Sathesh Sakthivel14-Jun-07 1:30

Sathesh Sakthivel

14-Jun-07 1:30

Get it[^]

Regards,

Satips. Rose | [Rose]

Help

Kartik Rathi14-Jun-07 1:16

Kartik Rathi

14-Jun-07 1:16

Can anybody tell me some site that should be converted in asp.net like some shopping site etc.
I want to make shopping site in asp.net.
Can anybody suggest me about this.

Kartik Rathi

Re: Help

Sathesh Sakthivel14-Jun-07 1:19

Sathesh Sakthivel

14-Jun-07 1:19

Hey please name your subject with Suitable topic.

For more details about the Shopping cart Petshoppee[^] download this project and it will clearly give the explanation about all your needs.

Regards,

Satips. Rose | [Rose]

Crystal Reports

teddddddddddd14-Jun-07 1:06

teddddddddddd

14-Jun-07 1:06

Hello,

How can I show picture on crystal reports? Picture insert in table.

Thank you

Re: Crystal Reports

Sathesh Sakthivel14-Jun-07 1:22

Sathesh Sakthivel

14-Jun-07 1:22

Get it[^]

Regards,

Satips. Rose | [Rose]

Data grid Problem :- Very Urgent

Devkranth Kishore Vanja14-Jun-07 0:58

Devkranth Kishore Vanja

14-Jun-07 0:58

hi...

i have a problem in datagrid.... as follows

table1
slno monthlypremium amount recovery type
2090 239908 0 abc
2 0 87534 23434 sfsdfsd
3 0 343 3434 fsdfsd

now the problem is when i diplay in datagrid it displays as follows...
but what i need is in monthlypremium the rows having 0 should have the value of recovery..

please help its very urgent Cry | :((

Re: Data grid Problem :- Very Urgent

nareshss14-Jun-07 1:08

nareshss

14-Jun-07 1:08

Hi
i didnt get ur question...

could u plz make ur question clear

wat do u mean of "value of recovery" ?

bye
naresh.s.s

Re: Data grid Problem :- Very Urgent

Devkranth Kishore Vanja14-Jun-07 3:07

Devkranth Kishore Vanja

14-Jun-07 3:07

value of recovery is nothing but the amount .... in table

Re: Data grid Problem :- Very Urgent

marky77714-Jun-07 1:37

marky777

14-Jun-07 1:37

show us your SQL

Re: Data grid Problem :- Very Urgent

pradeep kumarappagari14-Jun-07 1:43

pradeep kumarappagari

14-Jun-07 1:43

once u verify the bounded colums Data Field, i think u could have interchanged the Data Field text... Blush | :O

Pradeep Reddy

Configure SSL [modified]

Blue_Boy14-Jun-07 0:54

Blue_Boy

14-Jun-07 0:54

Hi , I am trying to configure my SSL connection bazed on
this link [^]
but when I browse my page I only get message "Page can not be displayed".
can anyone tell me how can I configure SSL connection on IIS to be able browsing website sucessfully.

Regards.

I Love SQL

How to play video using asp.net?

Ptiwari314-Jun-07 0:31

Ptiwari3

14-Jun-07 0:31

Hi Friends,

What are the different ways to play any video file (.wmv, .mpg , .dat etc) using asp.net?

Pointers please...

Reg,
Prema

Re: How to play video using asp.net?

Sylvester george14-Jun-07 1:19

Sylvester george

14-Jun-07 1:19

http://www.codeproject.com/cs/media/directshowmediaplayer.asp[^]

http://www.codeproject.com/audio/vmr9.asp[^]

Regards,
Sylvester G
sylvester_g_m@yahoo.com

Re: How to play video using asp.net?

Ptiwari314-Jun-07 1:59

Ptiwari3

14-Jun-07 1:59

Hi sylvester,

Thank you for reply,

But do you think, this solution would help on a web page?

Reg,
Prema

Re: How to play video using asp.net?

Sylvester george14-Jun-07 2:13

Sylvester george

14-Jun-07 2:13

Yes. Why dont you try from this basic concept?

Regards,
Sylvester G
sylvester_g_m@yahoo.com

Re: How to play video using asp.net?

Prasanta_Prince25-May-11 19:18

Prasanta_Prince

25-May-11 19:18

http://www.codeproject.com/Tips/201516/Play-video-in-your-webpage.aspx[^]

Have a look on this link.

reload the page

saravanan0514-Jun-07 0:18

saravanan05

14-Jun-07 0:18

I have a registration form with a captach image.
Below the picture, I have included a javascript link to reload the page if the image is not clear. Nonetheless, when clicking on reload, all datas filled in the forms are lost.
What should I do to reload the page (and reload a new captcha picture) without loosing data in the forms?

I know it can't be done in javascript because it is a client-side script (and the captcha is a server-side script) but I though it could be possible to store data in javascript when the user click reload().

regards
saravanan

Re: reload the page

Devkranth Kishore Vanja14-Jun-07 1:04

Devkranth Kishore Vanja

14-Jun-07 1:04

hi sarvanan

u can use the postback property...
like this

if not ispostback
displing ur data...
endif

happy programming

Re: reload the page

saravanan0514-Jun-07 1:36

saravanan05

14-Jun-07 1:36

hi
it is not working

regards
saravanan

Problem getting the selected date from a calendar?

chand1014-Jun-07 0:01

chand10

14-Jun-07 0:01

Hi
I have a problem in getting the value of selected date from a calendar.

My logic is something like this.....

I have a TextBox and a Button in the page.
When the Button is clicked a calendar object is created and calender is displayed on the page.
After that when I select a date from the Calendar it should display on the TextBox.

I am successful in getting the Calendar on the page but I am unable to get the SelectedDate on the TextBox.

Help me out.....

Thank u
Chandu

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