Search results for query: *

I am working on ADO.NET 2003. So I have such kind of a code: private void Updating() { this.OleDbConnection1.Open(); string strsql = "UPDATE table1 SET name = 'Johnson'"; Oledbcommand cmd = new Oledbcommand(strsql,this.Oledbconnection1); Oledbdatareader rdr1 = cmd.ExecuteReader(); rdr1.Open()...

Dear Ken Reay! I have tried this (i found SELECT @@IDENTITY), BUT it always returns 0. maybe i have to change some property of this auto_increment field? i 've tried to find it out, but didn't manage to. i do need it very much, and would be thankful to everybody who could help me. Best regards...

OK, but what if at one unpleasant moment it won't be the MAX? i think it can be possible . who knows how auto_increment works ?.. Andrew

Hello! I need to know the ID of the last added record into the DB (it is auto_increment). is there some function, like last_id or smth. like that? would be thankful. Andrew

I have 2 problems. I)The problem is the following. I've created a Setup Wizard (in Microsoft ADO.NET 2003) that unpacks the files into the specified folder and does all the needed operations. But when i open Control Panel and click CHANGE button near its name in the program list, I see the...

The problem is that while inserting the sting i need to know 3 more free (not in use yet ID) exaple name ID1 ID2 ID3 1 Bil 2 3 1 2 Bob 0 0 0 3 Michael 0 0 0 5 John 0 0 0 6 Lili 7 9 11 .......................... I'm sending 3 rows...

could you please help me to get the ID of the last inserted row in the table?.. e.g. INSERT INTO table1 (ID,name,surname) values ('null','My_name','My_surname') where ID is AUTO_INCREMENT field. Thank you. Andrew

thanx!!!last 2 examples both work perfect!

NO!Bool is just the name of a field, let it be just 'Answer' so Date | Answer .. | ..

I am afraid i have already tried that - but in the result table it does not contain strings where only 'NO's are... so it's like this: 1.09.05 | 2 2.09.05 | 1 instead of 1.09.05 | 2 2.09.05 | 1 3.09.05 | 0 5.09.05 | 0 ...

Hello! Please help! I need to make a SQL-query in Access DataBase. I have a table with the fields 1.Date 2.Bool e.g.: Date | Bool 1.09.05 | Yes 1.09.05 | Yes 1.09.05 | No 2.09.05 | No 2.09.05 | Yes 3.09.05 | No 3.09.05 | No 5.09.05 | No and i need to generate the following...

I am using ado.net. Have the following problem. in a listbox I display the names taken from a database table,when I select one of them and press the button i'd like to remove this item (the row) from the base. (I do that in the DataSet, and then update the database). The problem is that the...