Restoring Sql Database From Within Basic Program
Apr 12, 2012
I have written a windows form which allows a user to backup the database to medium of their choice and this works fine. I am now trying to use a very similar windows form to restore the database from previous backups.The problem I am having is the restore fails because the database is in use by this session. Googling this fault there appears to be several different solutions including using the master database, using tempdb or setting the database to single user but I cant find out how to do any of them with regarding what code to use.The option of changing to single user mode seemed the easiest but what coding do I have to use.[code]
View 17 Replies
ADVERTISEMENT
Mar 24, 2009
how to restore a database from vb.net,I tried to restore using stored procedure by taking retore template script from sql server2005. but there is error "the database is already in use please use a master database.."
View 3 Replies
May 25, 2010
I save my database in my application like this:
Public Sub save_mandant(Optional ByVal SName As String = "")
Dim set_temp As New DataSet
Dim set_tables As New DataSet
Dim ada_temp As New SqlDataAdapter("Select name from Sys.tables", SQLcon)
ada_temp.Fill(set_tables, "T")
[Code]...
View 8 Replies
Jun 6, 2010
I'm using the below to restore a database in VB.NET.This works but causes the interface to lockup if the user clicks anything.Also, I cannot get the progress label to update incrementally, it's blank until the backup is complete then displays 100%.[code]
View 1 Replies
Apr 8, 2012
I have a procedure at the end of my console application that ask the user to either hit enter to end the program, or type s to perform another search. The issue I'm having is no matter what the user types in the program end. What I would like to happen is if the user types s, then the program starts over and lets the user perform another search. The program is procedural and I need to find a way to start back off at the top of the program which ask the user to type a name to search.
[Code]....
View 1 Replies
Mar 1, 2012
This is going to be a lot to ask, but I'd like to convert my old GW-BASIC program to a command line program with arguments. I'd like it to operate as follows:
elapse [drive:][path]filename This is my old code.
5 CLS
10 OPEN "G:Calc.txt" FOR INPUT AS #1
20 WHILE NOT EOF(1): INPUT #1, A$, B$
30 IF MID$(A$,3,1)=":" THEN C$="DOUBLE DIGIT":GOTO 50
40 IF MID$(A$,2,1)=":" THEN C$="SINGLE DIGIT":GOTO 120
[Code]...
View 3 Replies
Jan 13, 2010
I am using asp.net and the .net framework 2.0. I may be able to upgrade the servers to 3.5 if the solution is compelling enough. Here is the problem. I have two pieces of xml. I'll refer to piece number 1 as the template and piece number 2 as the actual. Here's a basic example:
[Code]...
View 2 Replies
Oct 13, 2011
programing script in vb for saveing and restoring?
View 1 Replies
Feb 21, 2012
I am trying to restore SQL server DB, replacing the existing one but donot know how to do it.My purpose is to restore the backup file selected by user, no matter if file with this name is already attached to the server or not. If it is there, it should be replaced by the new one.
View 1 Replies
Jun 25, 2012
I have created an ASP.NET class derived from the standard WebControls.TextBox, with the intention of adding extra properties that will persist between post-backs. However, I cannot figure how to get the values in these properties to persist. I have tried setting the value of the properties into the controls ViewState as part of the PreRender handler, but the value is then not accessible in the Init handler on the post-back, because the ViewState has not yet been setup.
I could look for the ViewState value in the Load handler of the control, but if the page/usercontrol that is using the control asks for the properties value during its Load handler, the control hasn't yet reached it's Load handler, and it therefore not there.
[Code]...
In the end, the way I managed to get it to work was to use a <asp:PlaceHolder> control within the repeater, create an instance of my control within the ItemDataBound handler of the repeater, and then add the control to the <asp:PlaceHolder>... all done within the Init section (which fortunately I'm able to do).
As Andrew found out in this previous question you can end up in a chicken/egg situation, where you need to create the controls in the Init, but you won't know what controls you need until the Load.
View 1 Replies
Feb 29, 2012
I need to create an application that will restore a user's mapped drives from a database. To do this, I need to create a script that will automatically back up the user's mapped drives on logon.
What would be the best way to go about doing this?
View 2 Replies
Aug 26, 2010
Sometimes I select a value in my Combobox by hand, and sometimes the value to show is chosen elsewhere in my program logic. I want to carry out a certain action only when I have chosen a value by hand, and not when the value is changed by the program. For this reason I use the DropDownClosed event (and not, for example, SelectedValueChanged or SelectedIndexChanged). This works fine, but if I set AutoCompleteMode of my Combobox to Suggest, selecting a value from the suggested list doesn't fire the DropDownClosed event (perhaps logical, as the actual drop down list doesn't actually open).
View 2 Replies
Nov 15, 2009
I just downloaded VS 2010 beta to try my hand at re-learning (from scratch it seems) some of this to do a somewhat basic app. At the moment I have a tree view and it contains/will contain paired parent and child data. There's a Title (the parent) and a URL (child) and that's it with regard to depth. There will be potentially lots of these pairs. That said there may be some options associated with those pairs that would also need to be stored later. I'm thinking the best way to deal with this is to store the data in XML format but, of course, I've never really done much with XML though I can physically read it. Could someone point me or provide a piece of code that saves and restores a tree? [Code]
View 1 Replies
Feb 23, 2012
I have an MDI application that uses the menustrip control. When the MDI Child window is maximized, there is no way to restore its size. There's a restore on the MDI parent but that restores the entire application. However, when I use the Main menu, there are two sets of Maximize/Minimize controls, one for the MDI parent and one for the MDI Child. The Mainmenu control adds a band that is used to display the Maximize/Minimize controls but the band the menustrip creates is not used to do the same.
View 3 Replies
Jul 7, 2009
recommend the cleanest way to save / restore a winform's location and state? For some time now I've been using a method similiar to what I posted below (based on the CodeProject: [URL]..The problem with this method is that when the form loads, it is drawn in an initial location, then moved / maximized afterwards. The effect creates somewhat of an eye sore watching the window draw, then quickly update... but in Vista it is a lot more obvious.
What I would like to do is restore a form to it's previously saved location / state invisible to the user, then show it once it's where it needs to be. Or, just know of the ideal way this is supposed to be done - specifically in Vista.
[Code]...
View 4 Replies
Sep 8, 2010
I have a DGV where I'm setting the backcolor of certain cells to light gray. But I need to be able to restore the backcolor to what it was before I changed it to gray. I could just set it to transparent, but the problem with that is that I use an alternating row color of alice blue for the DGV & setting a cell in a blue row to transparent makes it white. So, in summary, I need to be able to restore white rows to white & blue rows to blue. Any ideas? I thought about checking the backcolor of another column in the row & then using that to reset the cell, but that seems kind of a hack.
View 1 Replies
Oct 21, 2010
I have a DataGridView in one of my form which at a certain point I resize an change it's position. I would like to be able to restore it to the designer's default position at runtime. I know I could save it before changing and then restoring it later, but I feel like there surely is a way in .NET to just restore a control position to it's default.
View 2 Replies
Aug 26, 2009
i'd like to make a tiny program that shows an image 2 images selected by a scrollbox that can be zoomed and pannedthere also would need to be a coordinate system added to the image so that the user can ad points of intrest (small cross apears on map)to the picture by entering the coordinates. these points of intrest should then be saved in a db file so they can be reloaded when the program is stopped and rerun.
View 6 Replies
Jul 22, 2009
I am trying to make a basic "paint" like form for one of my programs.I would like it to be like a function, where I put the input in, the user changes it, and when the user is done, it returns the changed picture.I know how to draw the picture and then draw lines, dots, whatever where the user clicks, but I don't know how to do some of the features like: text, color picker, zoom, erase, select (copy and pasting parts of the image) , and fill. I also don't really want to have a color picker dialog open ever time that the user wants to change color.
View 9 Replies
Sep 30, 2010
[code].....
View 3 Replies
Oct 19, 2010
i am trying to make a auto updater built into my program.[code]not it kinda works only its telling me i have updates when its the same version!
View 6 Replies
Apr 20, 2011
First off, I'm not sure if this is the right forum, please move it if it isn't. I am only just beginning with visual basic and I am trying to write a basic program to calculate the prime numbers from 1 to 100. This is what I have so far:
[Code]...
View 3 Replies
Jun 20, 2010
When I have tried to run a program in vb 2008 I get the following error message BC32400: Class 'CLSID_CorSymWriter' could not be created: System Error &H8004015 I have tried to uninstall and re install visual studio 2008 (academic) (several times) to no avail.
View 3 Replies
Feb 17, 2009
Anyone know of a way to do addon's with a visual basic program? I want to create a program that has some basic functions, but to stay away from bloatware and unused functions. How would you create a main program when it is installed and then be able to add and remove features to it?
View 4 Replies
Feb 12, 2010
i need to know how to make my Visual Basic program install onto the computer. right now my program is a simple .exe file and does not require instalation.
View 3 Replies
Aug 6, 2010
How would I open a program within Visual Basic 2010? (Like running "Application.txt" from "C:" within a Visual Basic project.
Public Class getfrom
Dim getfrom As String
Dim saveto As String
Dim download As Boolean
[code]....
View 2 Replies
May 6, 2011
How do you remove a Reference from a Visual Basic progam?
View 3 Replies
Apr 17, 2009
What is the code to shut down my computer with visual basic?
View 9 Replies
Dec 22, 2009
I have a program written in VB.NET which stops a service that uses file x, modifies x, and restarts the service.
I have modified my code for testing so that it just reads in the file as a string and immediately writes it back out.
Shell("net stop " & SERVICE_NAME, , True)
Dim myReader As System.IO.StreamReader
myReader = My.Computer.FileSystem.OpenTextFileReader(x)
fileString = myReader.ReadToEnd()
[Code]....
The stopping of the service is no problem, and modifying the file is no problem, but when the service starts it stops immediately because, as best I can guess, the file is in use. Even when I try to start the service manually, it stops immediately. However, I found that I can open file x, click save without modifying anything, close the file, and start the service and everything works correctly.
If I comment out the writing part, everything works fine.
Also, the file I'm modifying has a .conf file extension. I don't know if this is relevant.
View 4 Replies
Feb 24, 2011
I'm doing a baseball program for a class project. And I almost have it complete, but it's giving me a syntax error. I can't figure out what i'm doing wrong. I'm using two functions to return a value for different type of baseball tickets to the button that calculates them. Here are the instructions 1.)User selects whether to purchase season tickets or single-game tickets 2.) User enters the number of tickets needed and the type of seats based on whether they selected season single-game tickets.3.) User clicks the Compute Ticket Cost Button to display final cost4.) User clicks the Clear Form button to clear the responseI just can't figure out what I did wrong. I know it's something stupid that i'm doing.the errors are happening inside the btnCompute sub routine. with syntax erros on SingleGameCost() and SeasonalCost() line 114 and 118
Public Class Form1
'Global Variables
Dim intTicketChoice As Integer
[code]...
View 2 Replies
