Click here to Skip to main content
15,907,396 members
Home / Discussions / Database
   

Database

 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar26-Aug-04 7:07
Sanjeev Kumar26-Aug-04 7:07 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Colin Angus Mackay26-Aug-04 8:45
Colin Angus Mackay26-Aug-04 8:45 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar26-Aug-04 13:59
Sanjeev Kumar26-Aug-04 13:59 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Colin Angus Mackay27-Aug-04 6:07
Colin Angus Mackay27-Aug-04 6:07 
GeneralParse sql query without executing Pin
tocheng00525-Aug-04 11:42
susstocheng00525-Aug-04 11:42 
GeneralRe: Parse sql query without executing Pin
S Sansanwal25-Aug-04 16:31
S Sansanwal25-Aug-04 16:31 
GeneralRe: Parse sql query without executing Pin
tocheng00526-Aug-04 12:07
susstocheng00526-Aug-04 12:07 
GeneralDataSet with GUIDs Pin
mikasa25-Aug-04 11:21
mikasa25-Aug-04 11:21 
I have a DataTable with a PKey defined as a GUID. The problem is trying to "lookup" values in the DataTable.Select Method. Since this is a GUID column, I cannot do the normal things like I could in SQL Server (i.e. DataTable.Select("ID = '" & sID & "'")). In SQL, the GUID DataType is treated like a String.

I generated an XSD Schema of my table, and I got this info for the PKey:
xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string"

How can I get my DataTable to treat my PKey like a String at run time without loading aa Schema first? Or, how can I lookup GUID values in a DataTable??? OMG | :OMG: WTF | :WTF:
GeneralRe: DataSet with GUIDs Pin
mikasa27-Aug-04 3:05
mikasa27-Aug-04 3:05 
GeneralDealing with special characters in SQL queries Pin
david@mindplay.com25-Aug-04 10:36
david@mindplay.com25-Aug-04 10:36 
GeneralRe: Dealing with special characters in SQL queries Pin
Colin Angus Mackay25-Aug-04 11:13
Colin Angus Mackay25-Aug-04 11:13 
GeneralRe: Dealing with special characters in SQL queries Pin
david@mindplay.com25-Aug-04 11:28
david@mindplay.com25-Aug-04 11:28 
GeneralRe: Dealing with special characters in SQL queries Pin
Colin Angus Mackay25-Aug-04 12:22
Colin Angus Mackay25-Aug-04 12:22 
GeneralRe: Dealing with special characters in SQL queries Pin
mikasa25-Aug-04 11:24
mikasa25-Aug-04 11:24 
GeneralRe: Dealing with special characters in SQL queries Pin
david@mindplay.com25-Aug-04 11:51
david@mindplay.com25-Aug-04 11:51 
GeneralRe: Dealing with special characters in SQL queries Pin
david@mindplay.com25-Aug-04 12:13
david@mindplay.com25-Aug-04 12:13 
GeneralRe: Dealing with special characters in SQL queries Pin
mikasa26-Aug-04 3:38
mikasa26-Aug-04 3:38 
GeneralRe: Dealing with special characters in SQL queries Pin
Colin Angus Mackay26-Aug-04 12:01
Colin Angus Mackay26-Aug-04 12:01 
GeneralRe: Dealing with special characters in SQL queries Pin
mikasa27-Aug-04 3:05
mikasa27-Aug-04 3:05 
AnswerRe: Dealing with special characters in SQL queries Pin
ToolJoe11-Aug-09 10:50
ToolJoe11-Aug-09 10:50 
QuestionWhat's faster? Pin
Chodici Mrkev24-Aug-04 20:46
Chodici Mrkev24-Aug-04 20:46 
GeneralDELETE table, ignore key constraints Pin
Christian Graus24-Aug-04 12:54
protectorChristian Graus24-Aug-04 12:54 
Questionhow do I write to an access DB using ADO & VisualC++ ? Pin
Eduardo M. Rey24-Aug-04 8:48
Eduardo M. Rey24-Aug-04 8:48 
AnswerRe: how do I write to an access DB using ADO & VisualC++ ? Pin
S Sansanwal24-Aug-04 11:23
S Sansanwal24-Aug-04 11:23 
GeneralUsing ADO with Visual C++ Pin
Eduardo M. Rey24-Aug-04 8:41
Eduardo M. Rey24-Aug-04 8:41 

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.