Search results for query: *

I have an application wriiten vb .net that has a reporting function using crystal. At present all reports are working fine but I would like to be able to let the user select the database to report on, so when the report button is pressed the path to the database is passed to the crystal reports...

Thanks for the reply, Sorting through the SQL is not a problem as is sorting the data grid but because I used the double click in the data grid to obtain the row number and then updated a new form by using the row number as a reference source. I had trouble as double clicking could give me row...

Well i could not fix it so changed the form to include a search box rather than choosing from the datagrid. (looks better) I would be interested in knowing why this happens. It seems that the primary key groups next to a foreign key in the next collumn. For example PK 6,7,8,56,9,10 FK 2,3,7, 7...

I have a form written in vb.net that updates an access db This works fine and I check the table and the record is sitting atthe bottom with the primary key (bookingid) 1 number more that the last record. The problem i have is when I fill a datagrid with the data in the table the last record I...

Thank you for your reply, I do try to not use quick tools as I like to (try to) understand what is happening but I think your right that its the best way to go. Thats got it!!!!! I put data adapter in and used the query to build the code. It should just be a SELECT * FROM studenttable so...

I dont think so. Is that when you drag the conection,adapter etc to the area under the form designer? If so no i didn't do this I just coded all the connections etc. Sorry If im on the wrong track here but im trying to move from VB6 to .net and its not going to well so far. Regards Scott

Thanks for the responce, This is the error message i get from the message box. Syntax error (missing operator) in query expression '((studentID=? AND ((?=1 AND First Name is NILL) OR (First Name = ?)) AND((?=1 AND Last Name IS NULL) OR (Last Name = ?)) AND((?=1 AND Title is Null...

Hi, Im moving over from VB6 to .net 2003 but things are not going to well I have an access db and have designed a VB form with about 16 text boxes to fill from the db. My connection is ok and I can fill the textboxes ok and move through the db rows ok. My problem happens when I try and...