[RESOLVED] [2005] Play ASP

[ClaudeX]

Hi,

I'm new to ASP , so trying to play around to discover new thing.
The asp.net is sort of like frontpage to me..except there's diff function...o.O

Anyway trying to seek some help/answer as i am stuck ..keke...
it's about this...

I want to try to display out my newly created database from microsoft access using asp.net, i mean just pure data been displayed out to see.Is there any way to do it?


Does it require the exact location of the access file that it will extract it out...not too sure about this..as mention..i'm new to asp..keke

Thanks...

[Fishcake]

You can find some nice starter tutorails here including one on data access.

[timeshifter]

As long as you saved the DB in its' default directory, it should be easy to find it. I'd start with whatever data object is appropriate for your needs (i.e. GridView, DetailsView, FormView, etc.), and just follow the wizard to set it up. You'll need an Access DataSource, naturally, but it should guide you through all the steps you need to finish to get it running.

[ClaudeX]

Manage to get hold of getting database displayed...keke

Now trying to get hold of certain data out only if selected.
Hmmm... like..i got a monthly calendar and if i select a certain date and the data of that date will displayed out only.

is it possible?...coz i flip my books here and there doesn;t seem to give me any clue at all...lol...

btw thanks for helping out...

[timeshifter]

Configure the data source that should be on your form now... add a WHERE clause to it. That limits the data returned by a field and a value, or more if you need it to.

[mendhak]

Might want to learn SQL while you're at it?

[ClaudeX]

Wah?

Don't know wor...2 more weeks later going overseas for fun perhaps... then might forget what i learn...lol...

ok...timeshifter, i give it a try ...keke...

i try the monthly calendar first...
the monthly calendar date is underlined and it look to me like it can be selected, which is why i decide to test on that ..hehe...

i try the event out. but somehow i don;t know what to put in..

eg.

If
Calendar1.SelectedDate = >> database date << then >>information of that date will be displayed out <<
End if


and also what tools is recommend to display the information out ?
sounds complicated ...-.-lll

ps:i look at some other people post to act as reference and understand more and their post is under visual studio section yet they using asp.net ... wondering am i in the right section?

[ClaudeX]

Cannot believe it... i always thought that i need play with the code in order to get it work until i saw my friend instead of using code ..

He use the datagrid and have the control set to date and link with sqldatasource and it work .. without any code at all...

I was like oh my god...i tried for few days and he just click here and there ..and poof..here comes the result... -.-ll

Feel like digging a hole and hide my head in ..

[Fishcake]

It depends what your long term goals are. You may be able to achieve what you want by dragging a datagrid onto your form but in the end you will come unstuck if you don't know how to code or understand how it works.

[mendhak]

and also what tools is recommend to display the information out ?
sounds complicated ...-.-lll

ps:i look at some other people post to act as reference and understand more and their post is under visual studio section yet they using asp.net ... wondering am i in the right section?

An ADO.NET tutorial
http://www.vbforums.com/showthread.p...uction+ado.net

[mendhak]

Cannot believe it... i always thought that i need play with the code in order to get it work until i saw my friend instead of using code ..

He use the datagrid and have the control set to date and link with sqldatasource and it work .. without any code at all...

I was like oh my god...i tried for few days and he just click here and there ..and poof..here comes the result... -.-ll

Feel like digging a hole and hide my head in ..

With no due respect, your friend is an amateur, because the drag-drop method teaches him absolutely nothing. If you go the handcode way (as also shown in the tutorial) you will at least understand how ADO.NET works and can understand future concepts better. And make it more flexible.