Click here to Skip to main content
15,883,603 members
Home / Discussions / Database
   

Database

 
AnswerRe: Append data within XML file using form Pin
Mycroft Holmes9-Apr-12 12:42
professionalMycroft Holmes9-Apr-12 12:42 
QuestionDatabase Pin
Ngobi Arthur8-Apr-12 5:57
Ngobi Arthur8-Apr-12 5:57 
AnswerRe: Database Pin
PIEBALDconsult8-Apr-12 6:03
mvePIEBALDconsult8-Apr-12 6:03 
GeneralRe: Database Pin
gdmoland9-Apr-12 9:13
gdmoland9-Apr-12 9:13 
GeneralRe: Database Pin
PIEBALDconsult9-Apr-12 9:25
mvePIEBALDconsult9-Apr-12 9:25 
AnswerRe: Database Pin
Eddy Vluggen9-Apr-12 10:36
professionalEddy Vluggen9-Apr-12 10:36 
AnswerCant see database in SSE after importing with SSMA[solved] Pin
Richard.Berry1006-Apr-12 19:34
Richard.Berry1006-Apr-12 19:34 
QuestionGet a datarow with a query OLEDB - VB.net Pin
Richard.Berry1006-Apr-12 4:26
Richard.Berry1006-Apr-12 4:26 
Is there a better way to get one row from a database. I have been using the Fill Method of the DataAdapter to fill a datatable, and then returning the first row of the table

VB
Dim dr As DataRow
Using cn As New OleDb.OleDbConnection(cnStr)
            Dim cmd As New OleDb.OleDbCommand(strSelect, cn)
            Dim da As New OleDb.OleDbDataAdapter(cmd)
            
            Try
                cn.Open()
                da.Fill(dt)
                If dt.Rows.Count >= 1 Then
                    dr = dt.Rows(0)
                End If
            Catch ex As Exception
                'Err handling
            Finally
                cn.Close()
                dt = Nothing
            End Try
        End Using
        Return dr

AnswerRe: Get a datarow with a query OLEDB - VB.net Pin
PIEBALDconsult6-Apr-12 4:33
mvePIEBALDconsult6-Apr-12 4:33 
GeneralRe: Get a datarow with a query OLEDB - VB.net Pin
Richard.Berry1006-Apr-12 5:04
Richard.Berry1006-Apr-12 5:04 
GeneralRe: Get a datarow with a query OLEDB - VB.net Pin
PIEBALDconsult6-Apr-12 5:11
mvePIEBALDconsult6-Apr-12 5:11 
AnswerRe: Get a datarow with a query OLEDB - VB.net Pin
Eddy Vluggen6-Apr-12 6:02
professionalEddy Vluggen6-Apr-12 6:02 
Questionsql server Pin
hamakhoshi5-Apr-12 23:01
hamakhoshi5-Apr-12 23:01 
AnswerRe: sql server Pin
Mycroft Holmes5-Apr-12 23:14
professionalMycroft Holmes5-Apr-12 23:14 
AnswerRe: sql server Pin
PIEBALDconsult6-Apr-12 3:28
mvePIEBALDconsult6-Apr-12 3:28 
QuestionMerget Replication Issue Pin
Ahmed Barradah5-Apr-12 9:37
Ahmed Barradah5-Apr-12 9:37 
AnswerRe: Merget Replication Issue Pin
Mycroft Holmes5-Apr-12 12:58
professionalMycroft Holmes5-Apr-12 12:58 
QuestionSSIS Development Workflow Pin
cjb1105-Apr-12 0:26
cjb1105-Apr-12 0:26 
AnswerRe: SSIS Development Workflow Pin
PIEBALDconsult5-Apr-12 5:03
mvePIEBALDconsult5-Apr-12 5:03 
AnswerRe: SSIS Development Workflow Pin
Mycroft Holmes5-Apr-12 12:55
professionalMycroft Holmes5-Apr-12 12:55 
GeneralRe: SSIS Development Workflow Pin
cjb11013-Apr-12 0:21
cjb11013-Apr-12 0:21 
QuestionCan Not Resolve The collation Conflict Pin
yousefshokati1-Apr-12 19:02
yousefshokati1-Apr-12 19:02 
AnswerRe: Can Not Resolve The collation Conflict Pin
Bernhard Hiller1-Apr-12 21:26
Bernhard Hiller1-Apr-12 21:26 
QuestionHow do you lock records in Access 2007 Pin
Richard.Berry1001-Apr-12 9:14
Richard.Berry1001-Apr-12 9:14 
AnswerRe: How do you lock records in Access 2007 Pin
Eddy Vluggen1-Apr-12 22:43
professionalEddy Vluggen1-Apr-12 22:43 

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.