ChrisHunter 152 Posting Whiz in Training Featured Poster

Naaahhhhhh scooters and bikes are safe if everyone pays propper attention.

ChrisHunter 152 Posting Whiz in Training Featured Poster

I used to ride a scooter when I was 16. My first was a Piaggio NRG 50cc but a lady pulled out on me, I hit the side of her car at nearly 30mph, flipped over the car, rolled an slid down the road. I did both of my knees and the scooter was a write-off.

Second scooter was a Peugeot Vivacity, a fella pull out on a roundabout on me and I hit the side of his car but I had managed to slow down enough to only leave a dent in his door. I also dropped it going around a corner in the rain because the car in front of me slammed on (pressing the breakes on a corner is never a good idea, never mind in the wet), but I only lay the bike down and carried on running across the road.

You need to be more careful, you're not in a big metal cage. By the sounds of it you already know how it feels to bin it.

Got my full bike lisence now though so can't wait to get bike and get out!

ChrisHunter 152 Posting Whiz in Training Featured Poster

@Mike Askew you've got a Z4 and you're not even 25! that's good going that is!.

I've got an 07 place 1.6 Ford Focus I've had for about 3 years and should be getting myself a motorbike in April-ish. I was supposed to get one last year but I moved in with my partner instead. The things you do ay?

ChrisHunter 152 Posting Whiz in Training Featured Poster

Sorry if this isn't exactly what you're asking for but your English isn't the greatest so I may have miss understood you a little but here goes...

It depends on how simple you want to keep it.

If the client can only purchase one type of item/service at a time (but multiple of that one item/Service) You will need at least 3 tables:

Client Table
- Should have a well named primary key such as ClientID.
- Used to store client information.

Products table (or what ever the client is paying for)
- Should have a well named primary key such as ProductID.
- Used to store product or service information.

Transation Table (or orders table)
- Should have a well named primary key such as ProductID.
- Used to store the ID of both the product purchased and the client (as forgien keys).
- It's also important to have fields such as quantity, price per unit, total price and order date. This is because you can keep a record of what price the item was at the time of order (you might want to change prices at some point).

Then when you want to retireve all transations for a customer you simply select the fields needed using the client ID and the same can be done to see which customers have bought a particular product.

Hope this helps...

ChrisHunter 152 Posting Whiz in Training Featured Poster

In all honesty I hardly do anything. I'm one of those people who rarely feels hungry but can out eat the majority of people and not put any weight, or go a day or so so without realising I haven't eaten.

I haven't got a six-pack and I'm not ripped but I climb a lot and do the odd week of exercise (to try to get ripped) when I'm bored so I don't look like a muffin but don't ask me to run a mile because I probably won't make it half way!.

Like my Bio says I'm distinctly average...

ChrisHunter 152 Posting Whiz in Training Featured Poster

That would mean the more and more jobs there are the more tables you will need. You can limit the size of your DB by just having a Employee table (for the people), a JobTypes table (for the different jobs) and a table named something like EmployeeJobs which references both the Employee table and the JobTypes table.

This way you just add a new record into the JobTypes table for each job (e.g. manager, director etc). Other wise if you keep adding a new table for each your database will become more and more unmanagable.

As for denormalised databases they have their perks and if you're an experienced DBA it's probably as easy to use as a normalised one.

ChrisHunter 152 Posting Whiz in Training Featured Poster

I've got to say I've always been of the opinion that iPhones are over rated, over priced, average smartphones with Apple still riding the on the back of the ground breaking advances of original iPhone (and great marketing) by churning out handsets with little improvements.

After reading specs and reviews though my opinion of the 5s is completely different. I've recently bought the Lumia 520 because I only needed something basic that lets me go on the internet, music, satnav, calls and texts which means I won't be upgrading any time soon...

However my lovely girlfriend is due for an upgrade next month so if I'm nice enough I might be able to convince her to get one and drain the battery on her on a daily basis!

ChrisHunter 152 Posting Whiz in Training Featured Poster

It depends on the layout of you database itself.

If you have a the following tables it's not possible (or isn't ideal):

Person_tbl
* PersonID (PK)
* Name
* JobID (FK)

Job_tbl
* JobID (PK)
* JobTitle

However if you have a the following tables it is probably the best way to go about it:

Person_tbl
* PersonID (PK)
* Name

Job_tbl
* JobID (PK)
* JobTitle

PersonRoles_tbl
* RoleIF (PK)
* PersonID (FK)
* JobID (FK)

This way you can assign multiple people to multiple jobs.

Hope this helps, let me know if you need any clarification.

ChrisHunter 152 Posting Whiz in Training Featured Poster

What language is it in? you might have posted it in the C# form but in the other thread you created for this very question you mentioned a HTML file and never mentioned anything about any C#.NET controls.

You need to be a LOT more descriptive with your questions because that is unbelievably vauge and you need to show evidence that you have at least attempted it yourself.

ChrisHunter 152 Posting Whiz in Training Featured Poster

Don't forget the % wild card simbol if you're using like

ChrisHunter 152 Posting Whiz in Training Featured Poster

You really need to read these two threads that are posted at the top of the C# form

New Programmers - What resources are available to…

Getting Started With C# - The List

How ever for now add a textBox and a button to you form. Next double click the button so that it adds the button_Clicked method in for you and add MyMethod(textBox.Text1); inside the curly braces of the button_Clicked method. Next copy and paste the method I gave you in one of my earlier.

Unfortunatly the DaniWeb rules state that you have to show what you've done before I can help you so next time you will have to show that you have attempted to solve the problem yourself before anyone, especially myself, will help you.

I hope this helps and Google C#.Net programming for beginners. I'd rather help you acheive something through guidence than doing it for you.

ChrisHunter 152 Posting Whiz in Training Featured Poster

Do you know how to retreive a value from a textBox or call a method?

ChrisHunter 152 Posting Whiz in Training Featured Poster

Using webBrowser1.Url.Equals is simply comparing the current value of the Url with http//www.yahoo.com to see if they are the same. this would be good if you wanted to use it as a condition in an if statement but isn't used for setting it's value.

According to the link I sent you earlier you have to do something like the following:

// Pass in the website Url
public void MyMethod(string address)
{
    if (!address.StartsWith("http://"))
    {
        address = "http://" + address;
    }

    try
    {
        webBrowser1.Navigate(new Uri(address));
    }
    catch (System.UriFormatException)
    {
        // put messageBox here if required
    }
}

Once you've done the above you can then get the current Url from the webBrowser by accessing the Url property (which will help solve one of your other threads on here).

Hope this helps.

pardeepkhatri commented: very much cooperative +0
ChrisHunter 152 Posting Whiz in Training Featured Poster

What code do you have already?

This should be a bit easier for you to solve than the URL one in your other thread, you might just be missing a datatype conversion.

ChrisHunter 152 Posting Whiz in Training Featured Poster

Theres a build in DATEADD() function in SQL Server (2005 at least), which lets you add or subtract seconds, minutes, hours, days, months or years to a datetime value.

Have a look at this link and it will tell you everything you need to know.

ChrisHunter 152 Posting Whiz in Training Featured Poster

Have a look at this instead I think original reply was way off, my apologies.

ChrisHunter 152 Posting Whiz in Training Featured Poster

According to MSDN which is the first search result when you Google "System.Uri", it "Provides an object representation of a uniform resource identifier (URI) and easy access to the parts of the URI."

ChrisHunter 152 Posting Whiz in Training Featured Poster

Yeah just like anyother property I would assume you can use it just like the properties of anyother control.

Just do:

myWebBrowser.Url."The Rest Goes Here" = "What ever you want it too"

Have a look at this link it should help you with everything you need to know about the methods and properties for the WebBrowser control.

ChrisHunter 152 Posting Whiz in Training Featured Poster

What is value is it a varchar type of int?

"SELECT * FROM Tablename WHERE value = '" + x + "' AND datefield >= CONVERT(DATETIME, '" + date1 + "', 103) AND datefield <= CONVERT(DATETIME, '" + date2 + "', 103)"

To change the format of the date time you need to change the 103 value use above to which ever format code you need.

If X is an int and not a varChar then take the single quotation marks from around the X (').

I hope this helps, let me know how you get on.

ChrisHunter 152 Posting Whiz in Training Featured Poster

Yes but you'll need to clarify your question for us if you need help doing so.

What tool is it?
What property is it?
What code have you got so far?

ChrisHunter 152 Posting Whiz in Training Featured Poster

Also it looks like you're asking for an ATM application without having shown any evidance that you've attempted it yoursel.

The rules also say you have to show you've attempted it yourself first.

There's also a lot of help at hand if you use Google, there are examples of the code needed everywhere

ChrisHunter 152 Posting Whiz in Training Featured Poster

The more people that buy a Windows phone the more developers will developers will develop for it. There are more apps out for the Wondows 8 phones than there was for the 7. how about the Galaxy S4?

ChrisHunter 152 Posting Whiz in Training Featured Poster

What have you done so far?

If you're table has a date column in it do SELECT field1, field2 FROM MyTable WHERE dateField >= date1 AND dateField <= date2

ChrisHunter 152 Posting Whiz in Training Featured Poster

I've just bought the Nokia Lumia 520 which I should hopfully get my hands on today. It's a Windows 8 phone and it's only £120 to buy with no sim car or contract.

It's the Lumia 925's little brother (or sister) so it's not a hight end hand-set. On the other hand it's not a piece of crap either. It has a camera, It's Windows 8 OS, because it's part of the lumia series it has the built in GPS that lets you download maps and use them offline so using the GPS doesn't eat into your data usage. It's also got the free Nokia music app that lets to listen to as much music as you want for free (as long as you have WiFi or data) because it's a lumia.

I know you're from OZ but have a look at this review of it.

ChrisHunter 152 Posting Whiz in Training Featured Poster

What is it you want from a phone? most smart phones come with a built in GPS or at least an app that you can download, if it comes built in why not have it? it saves handing over more money for a seperate GPS...

ChrisHunter 152 Posting Whiz in Training Featured Poster

Young Guns.

ChrisHunter 152 Posting Whiz in Training Featured Poster

How are the two tables related, is there a parent ID in the child trable or a child ID in the parent table?

ChrisHunter 152 Posting Whiz in Training Featured Poster

Granted: but only for 10 seconds...

I wish I was a little bit taller...

ChrisHunter 152 Posting Whiz in Training Featured Poster

Yeah that can be done, you could use a DataGridView or a TableLayoutPanel with simple text boxes or buttons that change colour when they're clicked.

ChrisHunter 152 Posting Whiz in Training Featured Poster

Sorry rubberman it was a sarcastic comment because it was such a vague homework like question.

Sorry for the sarcasum Micheal.

rubberman commented: NP. Understood that. Precisely why I up-voted your comment... :-) +0
ChrisHunter 152 Posting Whiz in Training Featured Poster

software...

bradly.spicer commented: You beautiful man +2
rubberman commented: Actually, software is the output of software engineering... :-) +12
ChrisHunter 152 Posting Whiz in Training Featured Poster

I studied in the UK and have never looked into studying in the U.S so I can't help you with that one.

ChrisHunter 152 Posting Whiz in Training Featured Poster

I Googled it and came up with these two webistes that might be helpful.

I don't know anything about the process or fees though because I'm British so I had a different application process.

ChrisHunter 152 Posting Whiz in Training Featured Poster

The price might be different for you guys as you would be classed as foregin students and the application process will be a lot different.

You could alway ask to see how much the fees might be and what the application process would be.

ChrisHunter 152 Posting Whiz in Training Featured Poster

Can you repost the code with the changes so I can see if you misunderstood or not please?

ChrisHunter 152 Posting Whiz in Training Featured Poster

Try making the CloseForm method private static void. Next at the top of the Close form method put Form frm = sender as Form(); and where you have this. in the CloseForm method swop it for frm.... see if it works.

ChrisHunter 152 Posting Whiz in Training Featured Poster

I couldn't tell you to be honest. It was £3,500(GBP) per year for my course when I was studying but I left just before the rise in fees. Now I think it's around £8,500 per year which is insane!.

ChrisHunter 152 Posting Whiz in Training Featured Poster

There's a good university in liverpool called Liverpool University ironically and there's also the University of Manchester.

Heres a the university 2014 leaderboards according to the Guardian news paper

This info is purly UK universities.

ChrisHunter 152 Posting Whiz in Training Featured Poster

What countries do you mean by abroad?

ChrisHunter 152 Posting Whiz in Training Featured Poster

default avatars are generated based on the username

I didn't know that, that's pretty cool.

ChrisHunter 152 Posting Whiz in Training Featured Poster

The default images are similar to the ones used on quite a lot of other forums that are like DaniWeb (i.e. MSDN form), I think they're used to avoid confusion if new user's have used other forums before.

ChrisHunter 152 Posting Whiz in Training Featured Poster

I think I'd probably sit in my living room trying to figure out how to fly the thing for an hour or two before getting frustrated, putting it back in it's box and realising it was a waste of money and that I p****d my girlfriend off for no reason...

I have a broken remote controle helecopter in cupboard, I know how this one plays out.

almostbob commented: than ks, my wife is loooking at me like Im insane, laughing at the screen +0
ChrisHunter 152 Posting Whiz in Training Featured Poster

If you simply want to show and hide the DataGridView (DGV) when a particular label is clicked you only need check if the DGV is visible or not and then do DataGridView.Visible = true; (or = false if you want to hide the DGV), within the predefined clicked method for the label.

If the DGV and the label are both on the same form this can all be done in the one class behind that form.

ChrisHunter 152 Posting Whiz in Training Featured Poster

If you want to delete the recipe from the favourites all together you could do the following

You need 3 tables:

  • UserTable

    • UserID (primary key)
  • RecipeTable

    • RecipeID (primary key)
  • FavouritesTable

    • FavouritesID (primary key)
    • UserID (foreign key)
    • RecipeID (foreign key)

You'll also need 2 stored procedures:

  • Insert
    stored procedure that is executed when the favourite box is and INSERTs a new record with the user's ID and the recipe ID

  • Delete
    stored procedure that is executed when the favourite box is unticked and DELETES a SINGLE record with that user's ID and the ID for that recipe.

ChrisHunter 152 Posting Whiz in Training Featured Poster

You could create a class like the one below and bind that to the DataGridView.

public class Calculate
{    
    public Calculate()
    {
       this.Clear();
    }

    public float Number1 { Get; Set; }

    public flost Number2 { Get; Set; }

    public float Sum 
    {
        get
        {
            return (Number1 + Number2);
        }
    }
}
ChrisHunter 152 Posting Whiz in Training Featured Poster

Saw Chasing Mavericks on the flight home from America on Monday and loved it. although some of the acting isn't the best but it's inspiring, so much so that I watched it twice!

ChrisHunter 152 Posting Whiz in Training Featured Poster

Good to hear you have found the solution and sorry I was much help to you.

Don't forget to mark the thread as solved and don't hesitate to ask if you have any other questions.

ChrisHunter 152 Posting Whiz in Training Featured Poster

I know exactly what you mean London-G, some stuff does stick but I do have to keep looking over previous code for help.

Practise makes perfect I guess...

ChrisHunter 152 Posting Whiz in Training Featured Poster

Can you print screen what your screen looks like when it messes up please?

When I went to Uni we had to work in groups to create and modify a space invaders game in Java. If you're facing the same problem we did when we were trying to display the monsters for Space Invaders I might be able to help.

ChrisHunter 152 Posting Whiz in Training Featured Poster

Hi ss125 are you still looking for a solution to this problem?

If so can you tell me what type of DB you're using as I only know how to use MS SQL server 2005 onwards.

Can you also show me what code you have done so far please? (I can't just give you the code but I can help you where ever possible).