matale

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 all of them in this diagram

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 from Vb.net etc

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. "microsofts OS is not good enough to be seen as any …

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. [URL="http://i43.tinypic.com/2qs7707.jpg""]http://i43.tinypic.com/2qs7707.jpg"[/URL] Now the problem comes when I try to use an ObjectDataSource, it sees …

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, how do I check if a category has Products in it, before attempting to delete …

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 idea how to proceed.

[CODE=asp.net] GridView1.Datasource= Whatevever the datasource is GridView1.Databind() [/CODE]

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

[url]http://www.sitepoint.com/article/net-shopping-cart-datatables[/url] [url]http://www.codeproject.com/KB/user-controls/shopcart.aspx[/url]

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

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 everything. They are opening branches in other countries like the US and Eastern Europe. …

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

[quote=Day Brown;339505]Part of the problem Microsoft has, is that programmers are not fools. Back in the 80's M$ stole software sure that they had enough lawyers to keep a programmer in court forever. SO- programmers began inserting "back doors" into their code, strings of assy bytes, that if called could …

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 might want to look at some train or airline websites to what you need …

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 true if the movieTitleBox is empty. Then you put other Ifs to check which of …

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 [url]www.joomla.org[/url] go to the forums.

[quote=GLT;427885]Thanks but, how would I make the connection between the database and Outlook? :S I'm beginning to think, I'm thinking about this problem is more complicated than it is.[/quote] The best thing to do is to ask for clarification, if they want you to integrate it into Outlook or their …

Try doing it in hard code and see what happens.

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 grant the user apropriate access based on their security level. If they …

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 could also put the customer details in here or even beter in a different customers table.

why do you want to do that? seems strange

option A for sure

[quote=claptrap;348783]I am trying to learn about databases and at the moment starting to read general stuff about multidimensional database design. The trouble is, I don't even know the basics about databases, like what is natural key (same as primary key made of single components?) or surrogate key... Could anyone explain …

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.

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. So I stumbled into this forum when looking for Database Design stuff.

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?

I currently have something like this in my code [code=vb.net] For intIndex = 1 To 1000 objWriter.Write("a") Next intIndex [/code] Is there a faster way to write to a file? Especially for higher values of intIndex, doesnt matter if Im writing characters or whatever. Im just trying to fill a …

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 over. for as long as you want …

[quote=aerosmith;356104]The section for radiobutton2 does not work properly Usually it returns either nothing or it wil display the msgbox insuficient funds, and wont debi if its proper [code] [COLOR=#0000ff]ElseIf[/COLOR] TextBox1.Text.[B][COLOR=red]ToString[/COLOR][/B] > Label3.Text [COLOR=#0000ff]Then[/COLOR] [/code] [/quote] 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.

[quote=DangerM0use;349394]Hey all, I'm really struggling with the first part of my database design assignment for uni and I don't know why as I am repeating the year and did well in the subject last year and also did it at college. But enough of the background, let me explain my …