|
|
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
|
|
|
|
|
In SQL server database there is a datatype datetime use that.It wil store date and time.
|
|
|
|
|
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
|
|
|
|
|
Do want to create two fields date & time?
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
ooops..the tags don't show up...basically any kinda tags i can go with
|
|
|
|
|
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.
|
|
|
|
|
thanks for reply...it could be any tags...i can have them hardcode predefined tags
|
|
|
|
|
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 
|
|
|
|
|
Why dont you use
document.getElementById('textbox').focus();
in onload of the page ??
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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  )
Thanks again for your help.
|
|
|
|
|
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
|
|
|
|
|
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. 
|
|
|
|
|
Thanks a lot.
I am grateful.
Tunsten
|
|
|
|
|
Hi all,
How can I point to an HTML file if I am setting the IsHtmlBody = true in my app?
Please help.
Tunsten
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
