Illusionist

The joining is not really what im looking for. I'm making an event page, and what i want to do is have users add an event and it will store it into a database. Then if another user replies to that event, it adds the replies in another database, but with the same EventID as the Original Event. So the output i'm really looking for would be something like: FName: John LName: Doe FName: Even LName: Hitchcock If that makes any more sense. Thank you for your reply, and i did try that, but it wasn't what i was looking for, it was cool though! lol <-- I'm a n00b to .net and database programming!

I'm trying to figure out that best way to load two tables from a database where they have certain relationships. I'll explain more: I have 2 tables, 1 with information and stuff, and the other has data that directly corresponds with data in the first table. More in detail: First table: ID Name 1 John 2 Even ...................... Second table: ID LastName: 1 Doe 2 Hitchcock ....................... My question is: I want to get the ID for each column in the first table, and match it with an ID in the second table. Then get the LastName and display it with the first name. Also, if there are more than 1 of that same ID then print all last names with that ID number. I know this probably doesn't make sense, but this isn't my real data, it's just a sample example to see what i can do. Thanks for your time and help!

Yes, Yes it does. Thanks for all your help.

I did some research on that error number and found two possible reasons: 1) I didn't have write permissions, or 2) One of my filed Names was a reserved word I tried the first one first! I check my database to see if i did have write rights, and i did. So crossed that one out, and read about the 2nd possible cause. I didn't know which of my feldnames was a reserved word, i was thinking it was Time, but jsut to be safe i put ([]) brackets around each of them, and it worked!

Ok, i tried that, and now all I'm getting is a syntax error in my INSERT INTO statement. In my Catch I have: ..... Catch OleDB Exception as OleDb.OleDbException MsgBox("Error!" & vbCrLf & Err.Description) MsgBox(OleDbException.ErrorCode.ToString & vbCrLf & OleDbException.Source.ToString) ..... And it returns: Error! Syntax Error in INSERT INTO statement. and -2147217900 Micosoft JET Database Engine If anyone knows what this means, could you please help me out! Thank you!

OK, Ill try that. Thanks

In my Table i have: Name : Text UserID : Text Event : Memo Time : Date/Time : Format = General Date Cost : Currency tStamp : Date/Timer : Format = General Date

Oops, that was a typo. There is supposed to be a comma between them. I'm actually doing this project on my laptop, and right now I'm on my desktop where I have internet at the moment. And I was just typing it on here, and mis-type on the postcode.

I'm working on a WebApplication for my school that will allow Students and Faculty to add events, respond tom, edit, etc.. But right now I'm just working on a standalone VB app to start with. I have a database and can read from it fine. Although when I try to insert into it, itgives me an error: "A unhandled exception of type 'System.NullReferenceException' occured in DataBaseReadWrite.exe" Additional information: Object reference not set to an instance of an object." and it highlights my whole insert statement.... Take a look at it and see what you think: DA.InsertCommand.CommandText = _ "INSERT INTO EventData (Name, " & _ "UserID, Event Time, Cost, tStamp)" & _ "VALUES('" & txtName.Text & "', " & _ "'" & txtUID.Text & "' , " & _ "'" & txtEvent.Text & "' , " & _ "'" & pckDateTime.Text "' , " & _ "'" & txtCost.text "' , " & _ "'" & Now.ToLongTimeString() & "')" At first i was using it with SelectCommand.CommandText, and it worked when i inserted 3 values, and then i tried to add all of them int he SelectCommand and it gave me a syntax error in my INSERT INTO statement. Then i realized there was an InsertCommand (I'm very n00b at .net!) and I switched it , and now nothing works! Any help will be greatly appreciated! Thanks

OK, so it wasn't just because i was getting it off a shared drive or because my laptop was just slow. Well, I got it all working now. I have a few books on vb.net asp.net and c#, and I'm supposed to be learning asp.net so I can finish something up for my school's website, but I really get lost, and read really slow from books... Does anyone know of any good asp.net tutorials out there? I've looked for some but couldn't really find anything that started with the basic of the .net framework and stuff. ego tibi gratias maximas ago.

Thank you Robby for such a quick reply, and a direct answer. It worked perfectly! Now I can get to work, and get some thigns done! Thanks again.

Ya, about 4 hours. But it was probably because I was installing it from a shared DVD-ROM on my network. Either way it is going to take forever to re-install, if i have to. Well, I searched my hard drive for aspnet_regiis.exe and found it, but it still wouldn't let me navigate to the "C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\" to run it, so I just ran it from the run prompt, and i think it worked. I'm about to test it real quick. Thanks.

It says it's not regonized as an internal or external command,operable program, or batch file.

I recently installed Visual Studio .NET on my laptop, which at the time was running XPHE. A few days ago I installed XPPro on my laptop, and have been installing all the updates and stuff. Well, I installed IIS, and my Web Applications don't seem to be working. What should I do? Re-install Visual Studio .NET?? <-- I hope not. It took like a whole day to install it! Any help will be greatly appreciated! Thanks!