ASP.NET Discussion Boards

Re: Insert Date and time in sql server 2008

Salman Farrukh20-Nov-09 20:14

20-Nov-09 20:14

look in sql server 2008 we have three data types datetime,date,time.
I want to store date in date field and time in time field.but not in datatime field.

Re: Insert Date and time in sql server 2008

Richa_Soni20-Nov-09 22:21

Richa_Soni

20-Nov-09 22:21

i think this code helps you.....

SELECT
CAST('2007-05-08 12:35:29. 1234567 +12:15' AS time(7)) AS 'time'
,CAST('2007-05-08 12:35:29. 1234567 +12:15' AS date) AS 'date';

the output of this code is-

Time
12:35:29. 1234567

Date
2007-05-08

Dialog Closed event in ASP.NET

ljuchem20-Nov-09 5:59

ljuchem

20-Nov-09 5:59

Hi
I have a button that calls a function but at the same time it calls the event DialogClosed should be called after I push the button to another screen that closes it. After that he needs to call a function.

Could you help me?

I thank
Att
Luciano Juchem

Re: Dialog Closed event in ASP.NET

Abhijit Jana20-Nov-09 6:08

Abhijit Jana

20-Nov-09 6:08

ljuchem wrote:
I have a button that calls a function but at the same time it calls the event DialogClosed should be called after I push the button to another screen that closes it.

I didn't get your point. Can you please explain it clearly. Confused | :confused:

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: Dialog Closed event in ASP.NET

ljuchem20-Nov-09 6:22

ljuchem

20-Nov-09 6:22

Thank Abhijit Jana

Well I have a button on a screen that calls another screen that should behave like Dialog and dialog screen has a button that calls a function that closes the dialog.
After the main screen I have the DialogClosed function that works if I press the button of the dialog screen if I close the screen will not work.
The problem is that the main screen when I press the button that calls the dialog he calls the event DialogCosed what should not happen.
This event should only be called after I press on any button or close the screen. The main problem is that when I close the dialog does not call the event.

Thanks

How to Add Google Ads in asp.net site

angle5720-Nov-09 5:24

angle57

20-Nov-09 5:24

hello friends

i have requirement for add Google Ads in site but how can i add it is not known. so please help me for write me code or add it in my site.

Re: How to Add Google Ads in asp.net site

Abhijit Jana20-Nov-09 6:02

Abhijit Jana

20-Nov-09 6:02

Here you go
Google AdSense [^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

user controls

samir8020-Nov-09 5:10

samir80

20-Nov-09 5:10

Hi-

i am wondering if there is any way to do the following:

i want the other developers to just create an aspx page...and put some defined tags...lets say something like...
<uca>
<ucf>
<ucy>

if they put the above tags in their aspx page...and also the container user control (that i created) on the same page....the container user control will retrive the above tags and load appropriate user controls dynamically in the container user control..hope it makes sense

thanks

Re: user controls

samir8020-Nov-09 5:10

samir80

20-Nov-09 5:10

ooops..the tags don't show up...basically any kinda tags i can go with

Re: user controls

Abhijit Jana20-Nov-09 6:11

Abhijit Jana

20-Nov-09 6:11

samir80 wrote:
i want the other developers to just create an aspx page...and put some defined tags...lets say something like...

I think your post is incomplete. Where is the tag ?

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: user controls

samir8020-Nov-09 6:27

samir80

20-Nov-09 6:27

thanks for reply...it could be any tags...i can have them hardcode predefined tags

Setting the focus on control jumps page to the top

Jay Royall20-Nov-09 4:17

Jay Royall

20-Nov-09 4:17

Hi,

My senario: I have a sign-up form which, amoungst others, has a username textbox. The username textbox has autopostback set to true which, when posted back, checks to see if the entered username already exists in the DB and displays a message if so.

This works fine. But the problem I have is that in the code behind I am setting the focus to a control after doing the username check ( using txtUsername.Focus() ). But doing this causes the page to jump back to the top. This doesn't happen if I don't give a control the focus.

Any ideas how I can solve this?

A little more info about my form just in case it's relevant. The form is in an AJAX Accodion control which is in an AJAX Update Panel.

Thanks Smile | :)

Re: Setting the focus on control jumps page to the top

Abhishek Sur20-Nov-09 4:22

Abhishek Sur

20-Nov-09 4:22

Why dont you use

document.getElementById('textbox').focus();

in onload of the page ?? Confused | :confused:

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: Setting the focus on control jumps page to the top

Jay Royall20-Nov-09 4:27

Jay Royall

20-Nov-09 4:27

Wouldn't that set the focus to that particular textbox every time the page was loaded? I need to be able to set the focus to a different textbox depending on the result of the username check, i.e. if the check fails then set focus to txtUsername but if it passes then set focus to txtPassword.

But also, when the page is loaded for the first time then the focus needs to be set to yet a different control. So using Javascript how would I determine which control to give the focus to?

Thanks for help by the way Smile | :)

Re: Setting the focus on control jumps page to the top

Abhishek Sur20-Nov-09 4:47

Abhishek Sur

20-Nov-09 4:47

Well, if the page is actually posted back, you might consider adding a script block using RegisterScriptBlock to the client page to have the proper textbox focus.

It is not usually great to do focus in server side in case of ASP.NET.

use txtBox.ClientId to get the id on the control to be focus.

But If I was in your situation, I would have invoked an AJAX call to the server, and get if it is available or not. It is really unnecessary to fully postback the page for this.
Wink | ;)

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: Setting the focus on control jumps page to the top

Jay Royall20-Nov-09 5:33

Jay Royall

20-Nov-09 5:33

Abhishek Sur wrote:
But If I was in your situation, I would have invoked an AJAX call to the server, and get if it is available or not.

Ah, didn't realise that I could do this (I am a newbie to ASP.NET Big Grin | :-D

)

Thanks again for your help.

Static page height! How do I resize it dynamically?

tunsten20-Nov-09 4:08

tunsten

20-Nov-09 4:08

Hi developers,

I am having a great challenge in my .aspx pages. I have a .css file for my site layout, but each time I add a page and add a lenghtly contents (i.e a long content), it does stay static and not resized automatically. This does not give me flexibility of page layout that I want (page height resizing dynamically). Although, the #content height was specified in pixels. But if I had not specified the #content height in my css file, the page can be resized dynamically.

Please help.

Tunsten

Re: Static page height! How do I resize it dynamically?

Abhishek Sur20-Nov-09 4:19

Abhishek Sur

20-Nov-09 4:19

If you specify height in Pixels, it will not automatically resize according to content length. One thing you can do, is you can make overflow:auto to have scrollbar when content length goes greater than the height.

If you remove the setting of height of the element, it will automatically spread itself. Thumbs Up | :thumbsup:

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: Static page height! How do I resize it dynamically?

tunsten20-Nov-09 4:43

tunsten

20-Nov-09 4:43

Thanks a lot.

I am grateful.

Tunsten

Problem with SmtpClient - IsHtmlBody?

tunsten20-Nov-09 3:54

tunsten

20-Nov-09 3:54

Hi all,

How can I point to an HTML file if I am setting the IsHtmlBody = true in my app?

Please help.

Tunsten

Re: Problem with SmtpClient - IsHtmlBody?

Abhishek Sur20-Nov-09 4:08

Abhishek Sur

20-Nov-09 4:08

You need to create an AlternateView.

See this How I did this :
How to Send Mails from your GMAIL Account through VB.NET or C#. Windows Programming, with a Bit of Customization[^]

It is actually a sending program from Gmail account, but basics remains the same. Smile | :)

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: Problem with SmtpClient - IsHtmlBody?

tunsten20-Nov-09 4:44

tunsten

20-Nov-09 4:44

A lots of thanks. I appreciate that.

Tunsten

FireFox Issue!! [modified]

Sr...Frank20-Nov-09 2:49

Sr...Frank

20-Nov-09 2:49

Hi,

Below line of code is not working with FireFox.
Please let me know where I am wrong.

document.getElementById('txtAdd').innerText = valuefinal.toFixed(5);

Frank
Software Developer
www.mindstick.com

modified on Friday, November 20, 2009 10:44 AM

Re: FireFox Issue!!

J a a n s20-Nov-09 3:44

J a a n s

20-Nov-09 3:44

Please check the following article.
http://blog.coderlab.us/2005/09/22/using-the-innertext-property-with-firefox/[^]

"Never put off until run time what you can do at compile time."
- David Gries, in "Compiler Construction for Digital Computers", circa 1969.

Re: FireFox Issue!!

Abhishek Sur20-Nov-09 4:13

Abhishek Sur

20-Nov-09 4:13

innerText will not work in Firefox I guess.

You can use innerHTML.

Also there might be sometimes the control may have child elements so it is better to remove those elements first.
To Clear a container use

var element = document.getElementById('txtCommissionBalance');
while(element.firstChild)
   element.removeChild(element.firstChild);

After it removes all the element, do set the innerHTML.
Thumbs Up | :thumbsup:

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

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