hi,
I want to know if there is a way - other than backup and restore database (because restore takes too much time as the DB size grows) - to transfer all the data from one database on the server to another on a local SQLServer. it has to be done daily, so that the manager will always have an updated copy of the data on his machine.
Any help?
Thanks in advance
Maira
Last Activity: Feb 14 '08, 07:12 AM
Joined: Feb 19 '07
Location:
-
well i had to reinstall the Visual studio . and everything's back to normal.
thanks -
you are using Vb.NET 2005 ?...Leave a comment:
-
hi,
First your connection string is wrong. you omitted the Database Name.so it would be:
Dim strCNStr As String = "Data Source=ITSAD;In itial Catalog=myDatab aseName;User ID=sa;Password= ;"
Second you must be sure to create the table Branch in your database. and you must modify your query to (put " instead of ' for strings) so it would be
Dim strcmd As String = "Insert into Branch(Fname,Ln ame)...Leave a comment:
-
I am facing the same problem in all the projects....Leave a comment:
-
hi,
you need to get the index of the selected item in the listview
Dim idx As Integer = Listview1.Selec tedItems(0).Ind ex
and then get the information:
Dim Info As String = Listview1.Items (idx).Text
(here it's for the first column).
Use for the other columns: Listview1.Items (idx).subitems( 1).Text
Listview1.Items (idx).subitems( 2).TextLeave a comment:
-
Error while opening a form in vb.net
hi,
I have a problem with my VB.NET project.
I cannot open the properties window of the project anymore while it was working before.
And if I try to open a form with the Visual Basic Form Editor, it gives me the error:
"There is no editor available for .vb.
Make sure the application for the file type (.vb) is installed"
and i cannot open also the file .resx:
"Make sure the application...
No activity results to display
Leave a comment: