Help! Anyone know Ado.net / vb2005 database integration?

[radamanthys]

I've got this MASSIVE project, due tomorrow. It's defeated me. I'm beaten and humbled- you know how code is, when you just can't figure it out. I'm really really fucked. Anyone a pro at this stuff? Hopefully?

If anyone knows anything about it, I can post more details on what I have to do.

I'm desperate.

[Celephais]

Post up more details, I'm a ADO.NET/SQL2k5 developer. Although if it's some massive project due by tomorrow you might just be screwed.

[radamanthys]

I don't think it's that difficult, I think my brain is malfunctioning. I've lost data a number of times, too. Mostly, in my brain it seemed easy... but then I tried to do it. Kinda like playing music, or drawing.

The zip refused to attach, so here's a rapidshare.

http://rapidshare.com/files/73797815/Olive.zip.html

I think everything is there.

[radamanthys]

basically, it's a really really nifty order form.

[radamanthys]

blaaaaaaah

[radamanthys]

Fuck VB.net. Fuck Ado.net. Fuck Access. Fuck Olive Garden. Fuck datatables and everything else in the fucking fucker of a fuck.

Ok, I feel better.

[Insodus]

Fuck VB.net. Fuck Ado.net. Fuck Access. Fuck Olive Garden. Fuck datatables and everything else in the fucking fucker of a fuck.

Ok, I feel better.

Sounds like maybe computer science isn't the field for you...

[radamanthys]

Luckily, I'm not a CS major. I'm MIS.

Of course, I was saying the same things about Sarbanes Oxley yesterday, when writing a paper on it. I think I just need to graduate.

[Daniel]

I think I just need to graduate.

Know the feeling.

[Stanley Burrell]

I think I just need to graduate.


Know the feeling.

Try graduating after your graduation ceremonies because your stupid "B." ends in an "A." instead of a damn "S." Apply poorness due in part to your stamped piece of toilet paper from the "A." section.

Here, here/Word the fuck up.

[radamanthys]

This sucks, man.

[Celephais]

Sorry about not responding all day, got dragged into some shit and then well... my friend called me over to play Halo so... I'm taking a look at the solution right now.

What is the issue you're having? I am getting the forms to open up and then I'm seeing some issues like failing to enable constraints, but that shit can just be turned off... just rather not start fixing issues that aren't really the meat and potatoes of what you're having trouble with.

[radamanthys]

Yea, I'm just having problems implementing all the things that I had to- having it update the database and everything.

I've got it running DataGrids with buttoncolumns, which seems the best solution so far. Having it update stuff correctly is proving a challenge... things don't work in this program like I'm expecting them to... especially considering that I've done a goodly amount of VBA and vb6 in the past.

The big things that are stumping me are:
How to set up the Management UI- the combobox method wasn't working.
Manipulation of the party table by the hostessUI.
The entire customer order process.

There's no way I'll be able to do the serverUI or the KitchenUI, I don't think.

[radamanthys]

By the way, did you at least kick their asses in Halo?

[radamanthys]

Oh, here's the newest version.

[Celephais]

Yeah I'm certainly not going to be able to help you in time for tomorrow... if you're looking to filter on the ManagementUI you're going to need to add a where clause to your adapter.

I'm not a big fan of the built in drag/drop data access, as it's really easy to do basic stuff, but gets way too convuluted quickly.

It also doesn't look like you've got your Hostess form saving back to the database, you created a save function but it's not currently linked to any event (like a button click event), so it's not going to save.

[radamanthys]

Thanks for looking at it, I'll see what I can do from here. I still have alot to do, heh.

Yea, 9:40am is gonna come up REALLY quick-like.