Insert Date and time in sql server 2008 - ASP.NET Discussion Boards

How to Pass value between pages using JavaScript?

adkalavadia20-Nov-09 17:51

20-Nov-09 17:51

I want to pass my array in javascript from Page1.aspx to page2.aspx.

Actually on my Page1, there is a one JavaScript function which get status of my JavaScript Panel(hidden/Shown) and i have to set the same status of that JavaScript Panel on Page2. Also this javascript panel is in Datalist control on both page. How can i pass the status of my panel on Page2?

Smile | :)

!- F - R - I - E - N - D - S -!

Ankur Kalavadia

Re: How to Pass value between pages using JavaScript?

PunkIsNotDead20-Nov-09 18:57

PunkIsNotDead

20-Nov-09 18:57

why don't you send the value in a QueryString? like Page2.aspx?VisiblePanel=false and recive it in javascript

var visiblePnl = Request.QueryString("VisiblePanel");

Problem while using master page

sarang_k20-Nov-09 9:29

sarang_k

20-Nov-09 9:29

Hi all,

I have created a masterpage and in that i am not getting the content place holder,so i tried to use drag and drop from the toolbox but,i am getting error as Invalid FORMATETC structure.can any one tell me solution for it.

Thanks in advance.

Re: Problem while using master page

Abhishek Sur20-Nov-09 10:56

Abhishek Sur

20-Nov-09 10:56

This is a patent exception for VS IDE. If you have created any Custom control, you might have come accross with this.

Dont rely on designer, rather write <asp:Content to the page.

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

Disable Copy/Paste option in Firefox

sarang_k20-Nov-09 7:00

sarang_k

20-Nov-09 7:00

Hi all,

Can anyone tell me how can i block the copy/paste in firefox.

Using javascript i have blocked in IE but how to do in firefox ???

Thanks in advance.

Re: Disable Copy/Paste option in Firefox

Abhijit Jana20-Nov-09 7:04

Abhijit Jana

20-Nov-09 7:04

Try This :
A Javascript Code to Disable Right Click for Both Firefox and Internet Explorer[^]

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

Re: Disable Copy/Paste option in Firefox

Abhishek Sur20-Nov-09 10:53

Abhishek Sur

20-Nov-09 10:53

Use this trick to disable righ click and selection to anything in the page:
http://www.codeproject.com/tips/42554/Javascript-hack-to-disable-Right-Click-and-Text-Se.aspx[^]

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

Insert Date and time in sql server 2008

Salman Farrukh20-Nov-09 6:55

Salman Farrukh

20-Nov-09 6:55

Hi,I am salman.
I have 2 separate fields in sql server 2008 for date and time.
one field is of type date and the other is time.
In .net we have DateTime object but no separate objects for date and time so how to insert date and time in sql server 2008 through c#.net code?
remember i can not insert string of date and time coz the data types in database are date,time not string.

Best Regards,
Salman Farrukh

Re: Insert Date and time in sql server 2008

sarang_k20-Nov-09 12:51

sarang_k

20-Nov-09 12:51

In SQL server database there is a datatype datetime use that.It wil store date and time.

Re: Insert Date and time in sql server 2008

PunkIsNotDead20-Nov-09 18:49

PunkIsNotDead

20-Nov-09 18:49

yes like sarang_k says!!! you only have to concat both values of date and time like a string and after

Convert.ToDateTime(yourConcatString);

and save it

Re: Insert Date and time in sql server 2008

Richa_Soni20-Nov-09 19:51

Richa_Soni

20-Nov-09 19:51

Do want to create two fields date & time?

Re: Insert Date and time in sql server 2008

Salman Farrukh20-Nov-09 20:14

Salman Farrukh

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

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