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
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 RepliesI 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]...
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 RepliesI want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
View 3 RepliesI am trying to copy a table from a network database to a local database. I used DAO and could check if the network table existed using a function that tried to assign a TableDef object to the table in question. If there was no error then I assumed that the table existed and the function returned true...Or it would error out and return false.I could then proceed with the copy or not as the case may be.I am converting the code to ADO.net and need to know how to check for a table. [code]
View 1 RepliesI 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]...
programing script in vb for saveing and restoring?
View 1 RepliesRecently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
View 1 RepliesI 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 RepliesI 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.
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?
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 RepliesI 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 RepliesI have a form and a button on that form.When the user clicks on the button an MS-Excel sheet is generated from MS-Sql Server 2005 and saved in a particular location.As this generation of excel tkes sometime to complete,what i want to do is i want to show a progressbar loading till the entire sheet is generated. Showing the progress bar will help the user to understand that the generating of excel is under process.
Below My code to Save the File
ExcelWorkSheetObject.SaveAs(ExcelSheetName)
Below My Progressbar Code
[Code]....
In the old version Visual Basic 6, my code to connect to our Prophet 21 Progress database was:
Global DBConnect (5) as new ADODB.connection Global DBRec(5) as new ADODB.recordset Public Function Open_P21(SQL_Str As String, Ch As Integer, Status As Boolean)
[Code]...
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 Repliesrecommend 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]...
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 RepliesHow to make a progress bar base on saving data in database ? Lets say I'm going to save 10 datas so i want to make a progress bar base on saving on that 10 datas ?
View 5 Repliesi wanted to update my status to indicate e order is delivered or progress in my database and the form itself. so i decided to use progressbar. but im not sure how the coding going to works. or is there other alternatives suggestions on how im going to update my status?
View 13 RepliesI 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 Repliesim making a web browser which is intertwind in a project, but i cant get the progress bar to display the current percent of a page that is loaded, i want to have 10 segments, each standing for 10% of the total page loaded. So say a page is loaded 67%, 6 out of 10 of the segments will be shown.
View 3 RepliesI am trying to implement a BGW and want to report progress to a progress bar for my TextFieldParser program, sometimes if your opening very large files it takes a while and I would like the user to be able to see the progress and have some interaction so they know the program is still running I am a little hung up on what to in the reportprogress
I have:
worker.ReportProgress(0, myReader.ReadFields())
and its not doing anything, I didnt expect it too since ReadFields is an array
parser
Private Sub BackgroundWorker1_DoWork(ByVal sender As Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles BackgroundWorker1.DoWork
Dim worker As System.ComponentModel.BackgroundWorker = DirectCast(sender, System.ComponentModel.BackgroundWorker)
[code]....
I copied the code here and translate the code to vb [URL]it is working fine but there is one small problem but I cannot solve? Here is my code: SyncClientVB Another Source The scenario is... the progress is reported by an event (OnCopyingFile event)
Public Sub OnCopyingFile(ByVal sender As Object, ByVal e As CopyingFileEventArgs)
If pbFileTransfer.Value <> e.PercentCopied Then
If txtCurrentFile.Text <> e.FilePath Then
txtCurrentFile.Text = e.FilePath
[code]....
The problem is that it is ok when runned but when I click the form it starts to hang but in the console... it is still continuing.
dp.SyntaxHighlighter.ClipboardSwf = '/dp.SyntaxHighlighter/Scripts/clipboard.swf'
dp.SyntaxHighlighter.HighlightAll('6f5d1b01659646618ff3bdca29fb1b7f')
get the progress bar show the progress of the batchfile running in the background?
View 10 RepliesI have two forms, when the user selects a button, the second form opens and an external executable begins an automated process. The point of the second form, is to only show the current progress of the automated tasks and closes when those tasks are completed.How would I use a progress bar to show the current progress of an action on a different form without knowing how long it will take?
View 9 RepliesfrmMain - Allows user to pick process or combination of processes they want to run frmProcess - Shows progress of their selection I have three modules. Each runs a specific process. The frmMain allows the user to run any one of the three modules individually or all together in a single process (basically, runs the one after the other until done).
[Code]...
Looked through many tuts, can't find one.
View 1 RepliesI need to programmatically add a row to a MS Database.How is this done?
View 2 Replies
