So I solved the issue, apparently you cant use the "Select which returns a single value" option when creating the Query. Oops!

I created a dataset in the Dataset Designer by draging a database table into it, then I added a new select SQL query to the DataTable.
Check the pics I think it helps explain it better....

Hello,
I have a Categories Table and a Products Table each product has a CategoryID which joins it to the Categories Table.
I have a gridView in which I want to enable adding deleting Catagories,...

Hi,
I want to put a function (Button maybe) that will enable the site Admin to backup the website database, I have 2 SQLEXPRESS databases, the Default ASPNETDB.mdf and my own WebDB.mdf .
I have no...

GridView1.Datasource= Whatevever the datasource is
GridView1.Databind()

Ok I think I found it. The CreatedUser event is raised everytime a new user registers, so i can stick the code in there.
thanx

Maybe I didnt explain correctly. The question is how do I trigger the sending of the email when a user registers on my site, using the UserRegistration Wizard? Meaning how do I detect the successul...

http://www.sitepoint.com/article/net-shopping-cart-datatables

http://www.codeproject.com/KB/user-controls/shopcart.aspx

Hi,
Im using ASP.net Login controls to allow users to Register on my website. I want an Email to be sent to the site Administrator everytime a new user registers, how do I achieve this?
Thanx

What is the technical name of those flash panels you see on sites such as http://www.sohh.com?
The one with the numbers 1,2,3 in the top left. I am looking for a tutorial on how to create those but...

Thats not the impression I got when I read the article in Time magazine, India is still solidly ahead of the pack, they are just changing their aproach because customerz realise that low cost is not...

:icon_rolleyes:

Very complex problem, probably some sort of tcp/ip programming to send messages from server to client.

Google is you friend here. break the problem up into smaller part, like shutting down a pc...

First design a database to store all the necessary information about the booking like seat number etc. Then you write the program that will plug this data into the database in a user friendly way....

You could have a boolean inside the first If (boolFormat) which is set to true if the radio buttons are not checked,
and then inside the second If another boolean (boolMovieTitle) which is set to...

Try doing it in hard code and see what happens.

PHP sites are usually run on Apache servers, make sure that your host actually supports PHP and MySql. Also u will find the most help at www.joomla.org go to the forums.

I dont understand the question but, the user enters the username and password, you check that they are both in the database and belong to the same user, if they are you look at the security level and...

What database software are you using? and how are people accesing this database?

The best thing to do is to ask for clarification, if they want you to integrate it into Outlook or their e-mail server I think thats a bit beyond just Database design.

An Inventory table with the item_id,item_description

A loans table which will contain the item_id of items that have been loaned out, the date out, the return date, and any other info u need, you...

why do you want to do that? seems strange

I think the error is because you are using different data types for the vehicleLicence on different tables, they are supposed to be the same.

Im not sure about the other stuff.

Well if you delete the link then there wont be anything for that message.

Why are you deleting the link? Also why not put the link in the message table as another Column?

Why not leave the UserId field alone and just update the name?
Then you can have another table, say History which will store all the edits a user has made.

I think you are reading the wrong stuff, star schemas and serrogate keys are used in Data Warehousing which is different from database design.
For your purposes I don't think that will be...

Im not sure but i think what they do is store the location of the file e.g URL instead of the file itself. Or is it?

Cool.
I was thinking the score would be calculated from the Goals Table, but it might be simpler to include it your right.
The own goal thing seriously never crossed my mind:-O

Mhh whats with all the MS hate, if they are forced to pay millions of dollars for patents, such as the recent MP3 case. Then so should everyone else, so I have to agree with Balmer on this one.
...

I though about that(New diagram attached), but this means that my SQL queries are going to be much more complex, becasue I cant for example look for total goals scored by a player using just the...

When drawing DB relationship diagrams, do you usually show all the relationships? Because I seem to have lots of them and my diagram is geting very messy.
Sample Pic attached, I didnt even fill in...

I currently have something like this in my code

For intIndex = 1 To 1000
objWriter.Write("a")
Next intIndex



Is there a faster way to write to a file? Especially for higher...

For the second one I think u have 3 variables f1=1, f0=1 and temp, u store f1 in the temp, add f1 and f0 together, print the result and store it in f1, then store the temp value in f0. and u start...

Is that ToString supposed to be there?

As I understand it ur not supposed to be inserting anything in the auto number field, Access should take care of that automaticaly.

Hi everyone, I am an IS student at The University of Cape Town, after completing my Course projects for the semester I have decided to do a small project just for fun and to teach myself new things. ...

option A for sure

I think it would bve something like this
DB Schema image attached!!