Last post Oct 13, 2008 11:27 PM by Bobby-Z
Oct 05, 2008 03:46 PM|Bobby-Z|LINK
I posted this in the beginners forum, but I guess it has more to do with databases, and since no-one is answering me there, I will see if anyone can help me
I am using Expression web, along with visual Web Developer. I am confused about the wizard control.
I am making input forms for my site but if someone can take the time to answer a few questions for me.
1. I am trying to make a simple input form that accepts personal information into a database for a free monthly drawing. Someone helped me to connect to a database using a form control in the insert default mode - it works but I cannot change the edit button
to site default button scheme like you can in the wizard, and I had to do a page postback url redirect script so that the user didn't keep hitting submit and enter a thousand entries.
a. is this the best way to do this? and if so what is the use of the wizard to collect information? What I really want to do is make a wizard form that when you hit submit collects the information into a dbase that I can then view in a grid detail or other
view, and I would also like something that if the users email address has already been entered it says 'That Email address is already entered.' Am I being clear in my question? Why have a wizard that collects input if you cannot insert that data into a database?
(I am sure you can just everyone I have asked cannot or does not explain it to me or knows what I am talking about)
2. I also have created my website roles, but in the CreateUser wizard I have added textboxes for Company, Contact Name, Address, and Phone Info. These items are only for our contact list and not really needed to log-in, but I would like to collect this info
for marketing purposes. I also know the dbase that the createuser wiazard connects to does not store this info, How do I manage this?
a. I would also like to create a role that is for users (basic website customers) and for applicants (career section) how do you edit the create user wizard to (hiddenly) assign a role as applicant if they are using the creatuser wizrd in the career section
of our site rather than the register section.
3. Next, I also have an email newsletter signup for 5 different services (each newsletter is separate), how would I set up checkboxes on a 1 textbox (email address) so the information is stored in either one or separate databases for the newsletter registration
( like entrepreneur.com)
The signup form would have 5 checkboxes that 1,2, or all 5 can be selected (these are the newsletters), with an email textbox, and how is the checkbox data sent to the dbase, do you create the fields and the checkbox enters a true/false or y/n in that field?
4. Are forms that hard, or am I just missing something? Input items like textboxes, and a submit button that connects to a database that stores the info, right? Since this is the most common use for input items why do I not see any training videos on how
to do this, just videos on adding the numbers from 2 textboxes and getting a value after you hit the submit button - valuable for online estimate forms which I will use, but I want to collect info and use it for marketing, is there a link to a simple description
to do this, or a video, or is that like pre-school web programming and no-one teaches it anymore?
5. Last question about forms (wizard) I will be creating an on-line employment application - many steps - same question about storing the info?
and a little question about adrotators - Is it possible instead of jpg files to use silverlight or swf instead?
Please help since I am near to publishing my site and I need to add these forms - Thank You
Oct 12, 2008 04:00 AM|Mikesdotnetting|LINK
I suggest you spend some time on this site:
http://www.maconstateit.net/tutorials/ASPNET20/default.htm, which looks at using Access with ASP.NET 2.0. Break your requirements down into their constituent parts and put together basic pages to achieve the functionality you want one at a time, testing
as you go, and avoiding shoving a whole lot of unnecessary formatting etc into the page. That way, if you have a problem with a specific aspect, and come back here and ask a question, you can post just the relevant lines of code. There's nothing worse than
when someone posts 900 lines of aspx markup when only one line is causing an error.
You will also find some help with common Access-related problems here: http://www.mikesdotnetting.com/Category.aspx?Category=10.
What you want to do is pretty basic - if you spend a small amount of time getting to grips with the fundamentals.
Oct 13, 2008 11:31 AM|Bobby-Z|LINK
Thanks for taking the time to answer and the information is very helpful, also thanks for the great tutorial website. I think what is so confusing to me is micsrosofts visual studio and expression web, even with all of the features they have (not consistent)
You still need both programs and still need to learn VB or C#!
Oct 13, 2008 03:27 PM|Mikesdotnetting|LINK
You need to learn a lot more than that. Personally, I wouldn't bother with Expression Web. There's nothing you can do with that that you can't with Visual Studio. You should also spend some time learning (x)HTML, CSS and SQL. I chose C#, because I thought
Oct 13, 2008 03:58 PM|Bobby-Z|LINK
I know CSS, XML,
I know most XHTML, XSL
but need to learn VB, SQL, C#.
I only bought expression web cuz i was a newbie and didn't know much else, don't know why they didn't put Visual Studios features in Expression Web. I was really confused for a long time with the ASP wizards and in expr web especially login and management,
but you cannot control site security in expr web! :(
I also cannot figure out the new browsers, I spent months designing the layout and background images in CSS and now with chrome, safari, and IE8 the background images that are supposed to repeat-y don't. You are supposed to have the height / width settings
declared, but what about when all of your pages are different heights? check it out @
www.mycustomservicesolutions.com (just a parking page for now!)
Oct 13, 2008 04:07 PM|Mikesdotnetting|LINK
I wouldn't worry too much about IE8 or Google Chrome, as both are in beta and likely to change. Stick with either C# or VB. Once you have learned one, the other one is pretty easy (if you ever need it).
Oct 13, 2008 11:27 PM|Bobby-Z|LINK
Maybe you can help me with another related concern. How would I relate an input form to the users database?
example: I have a free drawing form with personal information, but instead of users entering their personal information again, I just make them log-in and enter their username and password or email to enter the drawing, but be able to tie that information
in somehow to the rest that is in the users dbase? and still have the drawing entry as a separate database, but also check for duplicate email addresses!
In other words, users who are logged in do not have to enter personal information gathered when they first created a user, and then have the entry info save to a separate database freeDrawing.mdb but also check the email address to avoid duplicate entries.
I would just restrict access to the entry form to those who are registered. Right now I have a spearate form with all the personal information needed and saved to the database, with form-fill it is no problem, but could be tedious for people without form-fill
Is this clear?