Click here to Skip to main content
15,897,891 members
Home / Discussions / Database
   

Database

 
Question[SQLite3] handling returned data from PRAGMA table_info("table_name") in C#? Pin
bbranded6-Jan-10 9:36
bbranded6-Jan-10 9:36 
AnswerRe: [SQLite3] handling returned data from PRAGMA table_info("table_name") in C#? Pin
loyal ginger6-Jan-10 9:59
loyal ginger6-Jan-10 9:59 
QuestionRe: [SQLite3] handling returned data from PRAGMA table_info("table_name") in C#? Pin
Dimitri Witkowski6-Jan-10 10:23
Dimitri Witkowski6-Jan-10 10:23 
AnswerRe: [SQLite3] handling returned data from PRAGMA table_info("table_name") in C#? Pin
Dimitri Witkowski6-Jan-10 10:22
Dimitri Witkowski6-Jan-10 10:22 
GeneralRe: [SQLite3] handling returned data from PRAGMA table_info("table_name") in C#? Pin
bbranded7-Jan-10 5:55
bbranded7-Jan-10 5:55 
GeneralRe: [SQLite3] handling returned data from PRAGMA table_info("table_name") in C#? Pin
Dimitri Witkowski7-Jan-10 6:17
Dimitri Witkowski7-Jan-10 6:17 
GeneralRe: [SQLite3] handling returned data from PRAGMA table_info("table_name") in C#? Pin
bbranded7-Jan-10 6:38
bbranded7-Jan-10 6:38 
GeneralRe: [SQLite3] handling returned data from PRAGMA table_info("table_name") in C#? Pin
bbranded7-Jan-10 9:00
bbranded7-Jan-10 9:00 
GeneralRe: [SQLite3] handling returned data from PRAGMA table_info("table_name") in C#? Pin
Dimitri Witkowski7-Jan-10 9:08
Dimitri Witkowski7-Jan-10 9:08 
QuestionT-SQL Query Help Needed Pin
#realJSOP6-Jan-10 9:17
professional#realJSOP6-Jan-10 9:17 
AnswerRe: T-SQL Query Help Needed Pin
Corporal Agarn6-Jan-10 9:50
professionalCorporal Agarn6-Jan-10 9:50 
GeneralRe: T-SQL Query Help Needed Pin
#realJSOP6-Jan-10 12:23
professional#realJSOP6-Jan-10 12:23 
AnswerRe: T-SQL Query Help Needed Pin
Tim Carmichael6-Jan-10 10:44
Tim Carmichael6-Jan-10 10:44 
GeneralRe: T-SQL Query Help Needed Pin
#realJSOP6-Jan-10 12:24
professional#realJSOP6-Jan-10 12:24 
QuestionRun dynamic query Pin
mehrdadc486-Jan-10 4:19
mehrdadc486-Jan-10 4:19 
AnswerRe: Run dynamic query Pin
David Mujica6-Jan-10 4:39
David Mujica6-Jan-10 4:39 
AnswerRe: Run dynamic query Pin
Ashfield6-Jan-10 4:40
Ashfield6-Jan-10 4:40 
AnswerRe: Run dynamic query Pin
loyal ginger6-Jan-10 4:45
loyal ginger6-Jan-10 4:45 
QuestionUpate Multiple Rows using update query in sql Pin
ballameharmurali6-Jan-10 0:27
ballameharmurali6-Jan-10 0:27 
AnswerRe: Upate Multiple Rows using update query in sql Pin
Mycroft Holmes6-Jan-10 2:30
professionalMycroft Holmes6-Jan-10 2:30 
AnswerRe: Upate Multiple Rows using update query in sql Pin
loyal ginger6-Jan-10 3:54
loyal ginger6-Jan-10 3:54 
AnswerRe: Upate Multiple Rows using update query in sql Pin
David Skelly6-Jan-10 5:29
David Skelly6-Jan-10 5:29 
What language are you using for your front end? Some languages will support this.

For example, Java supports batch updates so you can loop through all the entries setting the update parameters for each in turn, then do an executeBatch to do the lot in one go. (OK, before anyone points this out, not all JDBC drivers support this.)

C# has something similar, although I've never used it myself. And if you can do it in C#, you can probably do it in VB.NET as well.
GeneralRe: Upate Multiple Rows using update query in sql Pin
Corporal Agarn6-Jan-10 6:33
professionalCorporal Agarn6-Jan-10 6:33 
AnswerRe: Upate Multiple Rows using update query in sql Pin
Andy_L_J6-Jan-10 10:43
Andy_L_J6-Jan-10 10:43 
QuestionHow to run a software developed in VS2005 with Integrated SQL2005 Express? Pin
Atanu Bera5-Jan-10 6:36
Atanu Bera5-Jan-10 6:36 

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.