ASP.NET

Inserting Only time into SQL db

1-Nov-09 22:47

How does this relate to ASP.NET ?

You do what you're talking about by using maths to calculate the point based on the two image sizes.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

deepseeindeepsy1-Nov-09 22:29

deepseeindeepsy

1-Nov-09 22:29

Hello,
I want to insert only time into SQL. I have datetime field in database & also have taken datetime picker (ew) on the page.
How it can be done?
Please help me..
Thanx..

Smile | :)

Christian Graus1-Nov-09 22:36

1-Nov-09 22:36

I'm not sure if there's a time field in SQL. If there's not, just set the date to always be the same, and ignore it and only use the time portion.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

deepseeindeepsy1-Nov-09 22:56

deepseeindeepsy

1-Nov-09 22:56

Sir,
I used the timepicker from EW & have written the statement as
objData.AddParameter("InTime", tpInTime.SelectedTime);
Here, tpInTime.SelectedTime has datetime as return value which is same in db.
Even its not fare.

Thanx Sir.
Smile | :)

N a v a n e e t h1-Nov-09 22:39

N a v a n e e t h

1-Nov-09 22:39

deepseeindeepsy wrote:
I want to insert only time into SQL

You don't have to do that. Use datetime only and when you read, use the functions provided by SQL server to get only time.

Best wishes,
Navaneeth

deepseeindeepsy1-Nov-09 22:53

deepseeindeepsy

1-Nov-09 22:53

Sir,
Which functions to use ? If I inserted it using nvarchar field in db, then its OK & done bt Will it affect when working on report making?
Thanx.. Smile | :)

Christian Graus1-Nov-09 22:56

1-Nov-09 22:56

deepseeindeepsy wrote:
If I inserted it using nvarchar field in db

That would be utterly retarded, because you'd lose the ability to work with it as a time.

This was my first google hit[^]. Was that so hard ? You can return just the time portion as a string from a datetime in the database, which is what was being suggested, use the functions in SQL Server to get back just the time, even if you store a datetime.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

How to show content while waiting for google map?

Nisha Agrawal2-Nov-09 2:41

Nisha Agrawal

2-Nov-09 2:41

In SQL Server 2008, there is Time Data Type so that you can insert only time value there.

fmlove1-Nov-09 22:11

fmlove

1-Nov-09 22:11

hi!

i'm working on google maps api. i send hundreds of Geocode requests to google map api therefore its take to much time to load the page. Is there any way to show header and left menu while waiting for google maps. please share some ideas with code help... thanks in advance Smile | :)

Re: How to show content while waiting for google map?

N a v a n e e t h1-Nov-09 22:40

N a v a n e e t h

1-Nov-09 22:40

Show the map on a iframe[^]. So other parts of your page will load while you wait for map to load.

Best wishes,
Navaneeth

Re: How to show content while waiting for google map?

fmlove1-Nov-09 22:51

fmlove

1-Nov-09 22:51

iframe needs src="" to a page, but i have just one div where i'm showing the map.. how can i use iframe with my map?

Re: How to show content while waiting for google map?

Christian Graus1-Nov-09 22:52

1-Nov-09 22:52

putting it in a div and then hiding the div with javascript will work just fine.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Approprate Controls

hrishiS1-Nov-09 22:04

hrishiS

1-Nov-09 22:04

Hi to All,

Could anyone please help me finding a proper control, or may be an plugin to display a sets of images with some description with it....I have 100 of images like that...the user should be able to see say 1 15-20 at a time...first he sud see without details...on some user interection on the page user can see the details of it...My main intension is to make UI very attractive too
I am new to asp.net and ajax...please help me out..

thanks in advance

-----------------------------
I am a beginner

Christian Graus1-Nov-09 22:06

1-Nov-09 22:06

hrishiS wrote:
I am new to asp.net and ajax...please help me out..

If you're new, why are you working on a project like this ? Why are you using AJAX if you're new to ASP.NET ?

Is this for work, for for yourself ? If there's nothing in the ASP.NET AJAX library that you can use, you'd have to search the web, I assume writing something is not an option.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

hrishiS1-Nov-09 23:15

hrishiS

1-Nov-09 23:15

Hi Christian,

Thanks for your reply...
I like to learn new staff...And i believe, best way is to do some project. Hence, I am making an project, which if its comes up good i will deploy it. Thats it. And this work is not for any one but for myself as i have told you...I was just looking for some hints so that i can move forward.

Anyway,thanks for your advices, i will keep those in mind..

-----------------------------
I am a beginner

N a v a n e e t h1-Nov-09 22:43

N a v a n e e t h

1-Nov-09 22:43

Read about Repeater control[^]. It allows you to take more control over the rendered HTML.

hrishiS wrote:
I am new to asp.net and ajax...please help me out..

You don't need AJAX here AFAIK.

Best wishes,
Navaneeth

Christian Graus1-Nov-09 22:46

1-Nov-09 22:46

I will bet any amount you like that he has no idea what AJAX actually is, and he's really asking for some client side script to make his thumbnails jump out and to make the whole thing as cool as it can be.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Folder select dialog

bhavna43211-Nov-09 21:58

bhavna4321

1-Nov-09 21:58

how to get folder select dialog box .

Christian Graus1-Nov-09 22:00

1-Nov-09 22:00

Why would you want to select a folder in a website ? What would you do with the folder path ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

bhavna43211-Nov-09 22:17

bhavna4321

1-Nov-09 22:17

yes i want it on my site.

i had used FolderBrowserDialog . But it gives error like

System.Windows.Forms.FolderBrowserDialog m_obBrowser = new System.Windows.Forms.FolderBrowserDialog();
m_obBrowser.ShowDialog();
urrent thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it. This exception is only raised if a debugger is attached to the process.

Christian Graus1-Nov-09 22:20

1-Nov-09 22:20

bhavna4321 wrote:
yes i want it on my site.

But, why ?

bhavna4321 wrote:
System.Windows.Forms.FolderBrowserDialog m_obBrowser

What does this tell you ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Christian Graus1-Nov-09 22:39