Click here to Skip to main content
15,920,217 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL Query Pin
Gunvant Patel26-Dec-05 22:58
Gunvant Patel26-Dec-05 22:58 
GeneralRe: SQL Query Pin
Colin Angus Mackay27-Dec-05 0:38
Colin Angus Mackay27-Dec-05 0:38 
AnswerRe: SQL Query Pin
rihdus27-Dec-05 19:44
rihdus27-Dec-05 19:44 
QuestionCreate .Net SQL At Runtime Pin
Steve4523-Dec-05 6:46
Steve4523-Dec-05 6:46 
AnswerRe: Create .Net SQL At Runtime Pin
Colin Angus Mackay23-Dec-05 7:14
Colin Angus Mackay23-Dec-05 7:14 
GeneralRe: Create .Net SQL At Runtime Pin
Steve4523-Dec-05 7:47
Steve4523-Dec-05 7:47 
GeneralRe: Create .Net SQL At Runtime Pin
Colin Angus Mackay23-Dec-05 8:04
Colin Angus Mackay23-Dec-05 8:04 
GeneralRe: Create .Net SQL At Runtime Pin
Steve4523-Dec-05 13:33
Steve4523-Dec-05 13:33 
Thanks Colin

Two possible choices to evaluate for on-the fly SQL statements
http://www.easyobjects.net
http://www.reebsoftware.com

I think that command builder is for stored SQL procedures. Also, if you have VS do a Help search for SQL Pane - I think its for Access.

If I have to I'll reduce my report requirements and have 3 or 4 SQl templates and insert the parameters in the preformed SQL string.

string s = "SELECT " + field.text + "FROM " + "....";

Building dynamic SQL statement is an excellent choice for a Code Project code sample. Hope all this helps someone.

Thanks




Steve
GeneralRe: Create .Net SQL At Runtime Pin
Glenn Dawson28-Dec-05 8:54
Glenn Dawson28-Dec-05 8:54 
QuestionDataset Thread Safety Pin
Tristan Rhodes23-Dec-05 2:25
Tristan Rhodes23-Dec-05 2:25 
QuestionQuery for display row as column Pin
PrakashBhaskar22-Dec-05 23:39
PrakashBhaskar22-Dec-05 23:39 
AnswerRe: Query for display row as column [edited] Pin
toxcct22-Dec-05 23:53
toxcct22-Dec-05 23:53 
GeneralRe: Query for display row as column Pin
PrakashBhaskar22-Dec-05 23:58
PrakashBhaskar22-Dec-05 23:58 
GeneralRe: Query for display row as column Pin
toxcct23-Dec-05 0:05
toxcct23-Dec-05 0:05 
Questionsound Pin
khurramzaidi22-Dec-05 21:32
khurramzaidi22-Dec-05 21:32 
AnswerRe: sound Pin
Colin Angus Mackay22-Dec-05 22:11
Colin Angus Mackay22-Dec-05 22:11 
QuestionTesting on a Null value Pin
gharry22-Dec-05 10:13
gharry22-Dec-05 10:13 
AnswerRe: Testing on a Null value Pin
Colin Angus Mackay22-Dec-05 10:23
Colin Angus Mackay22-Dec-05 10:23 
GeneralRe: Testing on a Null value Pin
gharry22-Dec-05 10:50
gharry22-Dec-05 10:50 
GeneralRe: Testing on a Null value Pin
Colin Angus Mackay22-Dec-05 11:07
Colin Angus Mackay22-Dec-05 11:07 
AnswerRe: Testing on a Null value Pin
gharry22-Dec-05 10:26
gharry22-Dec-05 10:26 
QuestionConnecting to a remote DB from a service Pin
Marc Clifton22-Dec-05 4:12
mvaMarc Clifton22-Dec-05 4:12 
AnswerRe: Connecting to a remote DB from a service Pin
enjoycrack22-Dec-05 22:02
enjoycrack22-Dec-05 22:02 
QuestionSelecting a range of sql query results Pin
Rama Sharma22-Dec-05 0:41
Rama Sharma22-Dec-05 0:41 
AnswerRe: Selecting a range of sql query results Pin
Colin Angus Mackay22-Dec-05 8:39
Colin Angus Mackay22-Dec-05 8:39 

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.