Click here to Skip to main content
15,849,328 members
Home / Discussions / Database
   

Database

 
GeneralAccess to mySQL Pin
Anonymous20-Aug-05 9:19
Anonymous20-Aug-05 9:19 
GeneralRe: Access to mySQL Pin
Santanu Lahiri23-Aug-05 12:28
Santanu Lahiri23-Aug-05 12:28 
GeneralXML Database Pin
surfman1919-Aug-05 12:03
surfman1919-Aug-05 12:03 
GeneralRe: XML Database Pin
Colin Angus Mackay20-Aug-05 7:29
Colin Angus Mackay20-Aug-05 7:29 
GeneralRe: XML Database Pin
surfman1920-Aug-05 13:41
surfman1920-Aug-05 13:41 
GeneralRe: XML Database Pin
Colin Angus Mackay21-Aug-05 0:03
Colin Angus Mackay21-Aug-05 0:03 
GeneralRe: XML Database Pin
Frank Kerrigan23-Aug-05 1:15
Frank Kerrigan23-Aug-05 1:15 
QuestionNewbie: ODBC or OleDb SQL Command Dictionary? Pin
zPaul19-Aug-05 10:49
zPaul19-Aug-05 10:49 
I know sql pretty well but am new to ado.net.

Can anyone suggest a quick reference on SQL commands and syntax that will work with ODBC or OleDb flat-files? Or that will work separately with non-SqlServer datasets in general?

For instance, I'd like to be able to use a t-sql style 'case-when-then' statement but am having no luck using it to pull records from a fixed-width text file I'm connecting to via an ODBC connection (a simple select with a where and order-by clause works fine).

My goal here is to be able to quickly find the syntax for all legal SQL statements within a given context, like any of us would expect with a regular t-sql manual, and know it will apply in a given environment.

I am not finding much help in the vs.net help files or web searches. Maybe I'm not looking in the right place or using the right search expressions? Everything seems to either be rudimentary select statements or assume you are using Sql Server databases.

In case it's helpful: I'm currently working on a console application in vb.net that needs to batch-process data in flat-files we get nightly, massaging the data with conditionals and some string manipulation, and updating other files. It should be possible to handle most of the process with a handful of SQL statements but I'm now looking at writing a bunch of nested vb routines instead. Not happy.

Thanks in advance for any help.

GeneralDataGrid bounded to a DataTable with composite key Pin
miah alom19-Aug-05 8:33
miah alom19-Aug-05 8:33 
Generaldropdownlist in datagrid Pin
sarah_chandran19-Aug-05 2:01
sarah_chandran19-Aug-05 2:01 
GeneralRe: dropdownlist in datagrid Pin
miah alom19-Aug-05 7:24
miah alom19-Aug-05 7:24 
GeneralHELP unable to connect to sql server Pin
christy1819-Aug-05 0:56
christy1819-Aug-05 0:56 
GeneralRe: HELP unable to connect to sql server Pin
Colin Angus Mackay19-Aug-05 1:21
Colin Angus Mackay19-Aug-05 1:21 
GeneralRe: an aside: localhost Pin
Scott Serl19-Aug-05 11:28
Scott Serl19-Aug-05 11:28 
GeneralRe: an aside: localhost Pin
Luis Alonso Ramos19-Aug-05 15:26
Luis Alonso Ramos19-Aug-05 15:26 
GeneralRe: an aside: localhost Pin
Scott Serl20-Aug-05 8:29
Scott Serl20-Aug-05 8:29 
GeneralThank you Pin
christy1819-Aug-05 19:06
christy1819-Aug-05 19:06 
GeneralRe: HELP unable to connect to sql server Pin
Rob Graham20-Aug-05 5:01
Rob Graham20-Aug-05 5:01 
GeneralUsing Check Boxes Pin
Binary011018-Aug-05 9:52
Binary011018-Aug-05 9:52 
GeneralRe: Using Check Boxes Pin
Christian Graus18-Aug-05 18:01
protectorChristian Graus18-Aug-05 18:01 
GeneralRe: Using Check Boxes Pin
Binary011018-Aug-05 21:44
Binary011018-Aug-05 21:44 
GeneralRe: Using Check Boxes Pin
toxcct18-Aug-05 21:37
toxcct18-Aug-05 21:37 
GeneralRe: Using Check Boxes Pin
miah alom19-Aug-05 7:42
miah alom19-Aug-05 7:42 
GeneralAbstraction Layer Factory Tool Pin
Tristan Rhodes18-Aug-05 3:26
Tristan Rhodes18-Aug-05 3:26 
GeneralRe: Abstraction Layer Factory Tool Pin
miah alom19-Aug-05 7:27
miah alom19-Aug-05 7:27 

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.