Click here to Skip to main content
15,886,362 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Need system clock advice. Pin
nlarson1119-Apr-11 13:52
nlarson1119-Apr-11 13:52 
AnswerRe: Need system clock advice. Pin
Luc Pattyn19-Apr-11 14:32
sitebuilderLuc Pattyn19-Apr-11 14:32 
AnswerRe: Need system clock advice. Pin
Bernhard Hiller25-Apr-11 22:05
Bernhard Hiller25-Apr-11 22:05 
QuestionVisual Basic 2010 printing on a Zebra via serial port Pin
EdMee19-Apr-11 8:11
EdMee19-Apr-11 8:11 
AnswerRe: Visual Basic 2010 printing on a Zebra via serial port Pin
Dave Kreskowiak19-Apr-11 13:38
mveDave Kreskowiak19-Apr-11 13:38 
GeneralRe: Visual Basic 2010 printing on a Zebra via serial port Pin
EdMee21-Apr-11 11:40
EdMee21-Apr-11 11:40 
GeneralRe: Visual Basic 2010 printing on a Zebra via serial port Pin
Dave Kreskowiak21-Apr-11 12:05
mveDave Kreskowiak21-Apr-11 12:05 
QuestionConvert From Vb.Net 2008 To Vb.Net2010 [DMO Problem] Pin
Paramu197318-Apr-11 5:23
Paramu197318-Apr-11 5:23 
Hi,
Actually i converted my Vb.Net2008 project to 2010. But after to the convertion everything goes fine except SQLDMO.
I used the below code to create a backup & rename & restore in in the same server... And this can be useful at yearend backup like
database name "My_Procurement_Db" can be restored as "My_Procurement_Db_2010".....

The codes I used

Dim backup As Microsoft.SqlServer.SQLDMO.Backup = New SQLDMO.BackupClass()
                Dim oServer As SQLDMO.SQLServer = New SQLDMO.SQLServerClass()
                oServer.LoginSecure = True
                oServer.Connect("198.198.3.90", "sa", "123")
                backup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database
                backup.Database = "My_Procurement_Db"
                backup.Files = PurDbName
                backup.BackupSetName = "Procurement_Analysis"
                backup.BackupSetDescription = "Database Backup Description"
                backup.Initialize = True
                backup.SQLBackup(oServer)

                'RESTORE PROCESS STARTED

                Dim oRestore As SQLDMO.Restore
                Dim qRest As SQLDMO.QueryResults
                Dim LDNames(1) As String

                oRestore = New SQLDMO.Restore
                With oRestore
                    .Database = "My_Procurement_db_2010"
                    .Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database
                    .ReplaceDatabase = True
                    .Files = PurDbName
                    qRest = .ReadFileList(oServer)
                    LDNames(0) = qRest.GetColumnString(1, 1)
                    LDNames(1) = qRest.GetColumnString(2, 1)
                    .RelocateFiles = "[" & LDNames(0) & "],[D:\test.mdf]" _
                    + ",[" & LDNames(1) & "],[D:\testlog.ldf]"
                    .SQLRestore(oServer)
                End With
                oRestore = Nothing
                oServer.DisConnect()
                oServer = Nothing


Any Ides For Me ?

Thanks & Regards
PARAMU
AnswerRe: Convert From Vb.Net 2008 To Vb.Net2010 [DMO Problem] Pin
Simon_Whale18-Apr-11 5:33
Simon_Whale18-Apr-11 5:33 
JokeRe: Convert From Vb.Net 2008 To Vb.Net2010 [DMO Problem] Pin
Andy_L_J24-Apr-11 1:52
Andy_L_J24-Apr-11 1:52 
QuestionLogin Project Help... Pin
dzhello18-Apr-11 4:01
dzhello18-Apr-11 4:01 
AnswerRe: Login Project Help... Pin
Dave Kreskowiak18-Apr-11 4:38
mveDave Kreskowiak18-Apr-11 4:38 
AnswerRe: Login Project Help... Pin
Simon_Whale18-Apr-11 5:31
Simon_Whale18-Apr-11 5:31 
QuestionProject Help! Pin
Member 784273314-Apr-11 16:15
Member 784273314-Apr-11 16:15 
AnswerRe: Project Help! Pin
Luc Pattyn15-Apr-11 0:17
sitebuilderLuc Pattyn15-Apr-11 0:17 
AnswerRe: Project Help! Pin
_Erik_18-Apr-11 3:19
_Erik_18-Apr-11 3:19 
Questionvisual basic data report Pin
sandeepkumardadwal11-Apr-11 19:30
sandeepkumardadwal11-Apr-11 19:30 
AnswerRe: visual basic data report Pin
Abhinav S11-Apr-11 21:00
Abhinav S11-Apr-11 21:00 
AnswerRe: visual basic data report Pin
thatraja12-Apr-11 18:36
professionalthatraja12-Apr-11 18:36 
QuestionBest way to return class at runtime - based on value Pin
DeepToot7-Apr-11 7:23
DeepToot7-Apr-11 7:23 
AnswerRe: Best way to return class at runtime - based on value Pin
Ali Al Omairi(Abu AlHassan)7-Apr-11 11:16
professionalAli Al Omairi(Abu AlHassan)7-Apr-11 11:16 
AnswerRe: Best way to return class at runtime - based on value Pin
Eddy Vluggen8-Apr-11 0:31
professionalEddy Vluggen8-Apr-11 0:31 
GeneralRe: Best way to return class at runtime - based on value Pin
Ali Al Omairi(Abu AlHassan)10-Apr-11 10:06
professionalAli Al Omairi(Abu AlHassan)10-Apr-11 10:06 
GeneralRe: Best way to return class at runtime - based on value Pin
DeepToot11-Apr-11 4:05
DeepToot11-Apr-11 4:05 
QuestionWrite special cahrs from database to text file using vb.net Pin
vijay24825-Apr-11 5:30
vijay24825-Apr-11 5:30 

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.