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

Database

 
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 
I have created a DataTable from a spreadsheet worksheet and want to UPDATE my SQL table, but am struggling. I cannot update the single table having a Primary Key with the changed column information. Should be easy and straight forward. The ShowResult(dataTable) depicts the correct DataTable information. (Using some DevExpress expressions)

' Create a data table with column names obtained from the first row in a range if it has headers.
' Column data types are obtained from cell value types of cells in the first data row of the worksheet range.

Dim dtpHExportDataTable As DataTable = worksheet.CreateDataTable(range, rangeHasHeaders)

' Create the exporter that obtains data from the specified range, ' 'skips header row if required and populates the specified data ' table.

Dim exporter As DataTableExporter = worksheet.CreateDataTableExporter(range,dtpHExportDataTable, rangeHasHeaders)

AddHandler exporter.CellValueConversionError, AddressOf exporter_CellValueConversionError

' Specify exporter options.

exporter.Options.ConvertEmptyCells = True
exporter.Options.DefaultCellValueToColumnTypeConverter.EmptyCellValue = 0

'Perform the export.
exporter.Export()

'A custom method that displays the resulting data table.
ShowResult(dtpHExportDataTable) 'Looks good!

'Now, my code to Update the "Result" column in my sql table with the datatable information

Dim cnSQL As SqlConnection = dbLIMS.GetLIMSConnection

Using adapter = New SqlDataAdapter("SELECT * FROM Analytical_Sample_Log_ResultsInfo", cnSQL)
Using New SqlCommandBuilder(adapter)
adapter.Fill(dtpHExportDataTable)
cnSQL.Open()
adapter.Update(dtpHExportDataTable)
End Using
End Using
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 
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 
GeneralRe: The above post is incorrect - SQL Linq, Date Range, Union in VB Pin
jkirkerx23-Jul-15 7:38
professionaljkirkerx23-Jul-15 7:38 
GeneralRe: The above post is incorrect - SQL Linq, Date Range, Union in VB Pin
Brisingr Aerowing23-Jul-15 8:37
professionalBrisingr Aerowing23-Jul-15 8:37 
GeneralRe: The above post is incorrect - SQL Linq, Date Range, Union in VB Pin
jkirkerx23-Jul-15 9:21
professionaljkirkerx23-Jul-15 9:21 

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.