Click here to Skip to main content
15,845,196 members
Home / Discussions / Database
   

Database

 
GeneralRe: Is this possible, using an old foxpro database files and oledb for DBase Pin
jkirkerx31-Jul-15 7:25
professionaljkirkerx31-Jul-15 7:25 
Questionrestore database Pin
millerwilliam3529-Jul-15 3:51
millerwilliam3529-Jul-15 3:51 
AnswerRe: restore database Pin
CHill6029-Jul-15 4:56
mveCHill6029-Jul-15 4:56 
QuestionRe: restore database Pin
Eddy Vluggen29-Jul-15 6:31
professionalEddy Vluggen29-Jul-15 6:31 
AnswerRe: restore database Pin
Mycroft Holmes29-Jul-15 15:30
professionalMycroft Holmes29-Jul-15 15:30 
AnswerRe: restore database Pin
Nitzan Levi22-Aug-15 21:20
Nitzan Levi22-Aug-15 21:20 
QuestionUpdate SQL Server Table with a Spreadsheet Worksheet DataTable using CommandBuilder Pin
LHendren27-Jul-15 2:37
LHendren27-Jul-15 2:37 
AnswerRe: Update SQL Server Table with a Spreadsheet Worksheet DataTable using CommandBuilder Pin
Mycroft Holmes27-Jul-15 15:33
professionalMycroft Holmes27-Jul-15 15:33 
You can get an empty datatable from SQL with Select * from Tablename where 1-1. This will give you the SQL data type, they may differ from the Excel data type.

An update statement will look like
SQL
Update TableName set field1 = ValueFromExcelCell, field2 = ... where PrimareyKeyField = PrimaryKeyValueFromExcel

The update needs to be execute for each row in the ExcelTable where the data has changed
Never underestimate the power of human stupidity
RAH

QuestionSQL Linq, Joins, returns 1st record over and over Pin
jkirkerx23-Jul-15 10:11
professionaljkirkerx23-Jul-15 10:11 
Answer[Solved] Pin
jkirkerx23-Jul-15 12:30
professionaljkirkerx23-Jul-15 12:30 
QuestionEntity Framework Book. Pin
Kevin Marois23-Jul-15 6:29
professionalKevin Marois23-Jul-15 6:29 
QuestionRe: Entity Framework Book. Pin
Richard MacCutchan23-Jul-15 7:36
mveRichard MacCutchan23-Jul-15 7:36 
AnswerRe: Entity Framework Book. Pin
Kevin Marois23-Jul-15 8:31
professionalKevin Marois23-Jul-15 8:31 
AnswerRe: Entity Framework Book. Pin
Mycroft Holmes23-Jul-15 15:10
professionalMycroft Holmes23-Jul-15 15:10 
QuestionSQL Linq, select from select and join Pin
jkirkerx21-Jul-15 14:27
professionaljkirkerx21-Jul-15 14:27 
SuggestionRe: SQL Linq, select from select and join Pin
Richard Deeming22-Jul-15 2:50
mveRichard Deeming22-Jul-15 2:50 
GeneralRe: SQL Linq, select from select and join Pin
jkirkerx22-Jul-15 7:02
professionaljkirkerx22-Jul-15 7:02 
GeneralRe: SQL Linq, select from select and join Pin
Richard Deeming22-Jul-15 9:00
mveRichard Deeming22-Jul-15 9:00 
GeneralRe: SQL Linq, select from select and join Pin
jkirkerx22-Jul-15 10:04
professionaljkirkerx22-Jul-15 10:04 
QuestionTrouble working with dates again and union and sum Pin
jkirkerx20-Jul-15 14:08
professionaljkirkerx20-Jul-15 14:08 
AnswerRe: Trouble working with dates again and union and sum Pin
jkirkerx20-Jul-15 14:34
professionaljkirkerx20-Jul-15 14:34 
Generalmake nullable type Pin
jkirkerx20-Jul-15 14:59
professionaljkirkerx20-Jul-15 14:59 
General[Got It] Pin
jkirkerx21-Jul-15 10:58
professionaljkirkerx21-Jul-15 10:58 
GeneralThe above post is incorrect - SQL Linq, Date Range, Union in VB Pin
jkirkerx22-Jul-15 9:54
professionaljkirkerx22-Jul-15 9:54 
GeneralRe: The above post is incorrect - SQL Linq, Date Range, Union in VB Pin
Mycroft Holmes22-Jul-15 15:15
professionalMycroft Holmes22-Jul-15 15:15 

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.