Click here to Skip to main content
15,844,903 members
Home / Discussions / C#
   

C#

 
GeneralRe: Guid in DataTable Pin
Heath Stewart30-Dec-03 20:39
protectorHeath Stewart30-Dec-03 20:39 
GeneralRe: Guid in DataTable Pin
Mazdak30-Dec-03 20:57
Mazdak30-Dec-03 20:57 
GeneralForm flashes beneath an OpenFileDialog or 2nd Form Pin
flipdoubt30-Dec-03 5:15
flipdoubt30-Dec-03 5:15 
GeneralRe: Form flashes beneath an OpenFileDialog or 2nd Form Pin
Heath Stewart30-Dec-03 6:58
protectorHeath Stewart30-Dec-03 6:58 
GeneralValue in Database Pin
Mazdak30-Dec-03 2:17
Mazdak30-Dec-03 2:17 
GeneralRe: Value in Database Pin
Heath Stewart30-Dec-03 6:51
protectorHeath Stewart30-Dec-03 6:51 
GeneralRe: Value in Database Pin
Mazdak30-Dec-03 7:32
Mazdak30-Dec-03 7:32 
GeneralRe: Value in Database Pin
Heath Stewart30-Dec-03 8:36
protectorHeath Stewart30-Dec-03 8:36 
Sorry, your question didn't quite make sense. "Record" instead of "item" would've been the optimal word. I didn't quite follow what you meant.

The way you're doing it (or using the COUNT aggregate and checking for a result value of 1) is fine, but you can create a multi-field index that is unique, thus making a UNIQUE index as you could in MSDE/SQL Server. I know you said you didn't want to do this, but I don't know if you were aware that multi-field indexes are possible.

Just open the Indexes Window for your table. On a new line, type an index name (like "Name"), and select the first field you want. Below that, select the second field you want but do not type an index name. You can do this for up to 10 rows. Finally, go back to the first row and set Unique to Yes. This is documented in the MS Access help. This should also cause an OleDbException to be thrown, which you can catch in a try-catch block and handle gracefully. We do this with SQL Server on our web site quite a bit and just show friendly errors when they occur while logging more information to the trace log (or other event target).

 

-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
GeneralRe: Value in Database Pin
Mazdak30-Dec-03 10:30
Mazdak30-Dec-03 10:30 
GeneralCreating an XML File Pin
deanoA29-Dec-03 23:08
deanoA29-Dec-03 23:08 
GeneralRe: Creating an XML File Pin
Colin Angus Mackay29-Dec-03 23:36
Colin Angus Mackay29-Dec-03 23:36 
GeneralRe: Creating an XML File Pin
Manster31-Dec-03 4:31
Manster31-Dec-03 4:31 
QuestionHow should I call an exe file using C# Pin
Saqib Razzaq29-Dec-03 21:25
Saqib Razzaq29-Dec-03 21:25 
AnswerRe: How should I call an exe file using C# Pin
Yaron K.29-Dec-03 21:38
Yaron K.29-Dec-03 21:38 
GeneralRe: How should I call an exe file using C# Pin
Saqib Razzaq29-Dec-03 21:49
Saqib Razzaq29-Dec-03 21:49 
GeneralRe: How should I call an exe file using C# Pin
Juergen Posny29-Dec-03 23:09
Juergen Posny29-Dec-03 23:09 
GeneralRe: How should I call an exe file using C# Pin
Saqib Razzaq29-Dec-03 23:30
Saqib Razzaq29-Dec-03 23:30 
GeneralExpand/Collapse feature in c# Pin
pc_2k1129-Dec-03 20:35
pc_2k1129-Dec-03 20:35 
GeneralRe: Expand/Collapse feature in c# Pin
Heath Stewart30-Dec-03 6:40
protectorHeath Stewart30-Dec-03 6:40 
GeneralChanging the paper size at run time Pin
Yaron K.29-Dec-03 20:32
Yaron K.29-Dec-03 20:32 
GeneralRe: Changing the paper size at run time Pin
Mazdak30-Dec-03 0:42
Mazdak30-Dec-03 0:42 
GeneralRe: Changing the paper size at run time Pin
Mehdi Moshtaghi30-Dec-03 1:27
Mehdi Moshtaghi30-Dec-03 1:27 
GeneralRe: Changing the paper size at run time Pin
Yaron K.30-Dec-03 3:25
Yaron K.30-Dec-03 3:25 
GeneralRe: Changing the paper size at run time Pin
Heath Stewart30-Dec-03 6:35
protectorHeath Stewart30-Dec-03 6:35 
GeneralRe: Changing the paper size at run time Pin
IntegraSoft31-Dec-03 10:37
IntegraSoft31-Dec-03 10:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.