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]...
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]...
programing script in vb for saveing and restoring?
View 1 RepliesSometimes 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 Replieshow 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 have a rectangle with drawings inside it. I want to draw something else on top, but later restore the original insides without necessarily know what they were.
View 4 RepliesI'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 RepliesI 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 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?
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 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 RepliesI have managed to create a connection to the database and am able to save information to it from my form, the form contains 22 textboxes, a save and another exit button. I have set the form to retrieve data in the form_load. I have used the "UPDATE" SQL command on the save button and it does save the data on all 22 textboxes (all textboxes are linked to their separate columns). But only one record will be needed that is why I did not use the "INSERT" command.
The problem arises when I click the save button, all (19) textboxes are saved but when I retrieve the text (by reloading the form), each of the 20, 21, 22 textboxes (only) the text of the 20th textbox keeps on moving tho the next textbox e.g. 20>21>22>20>21>22 is interchanged amongst themselves.
[Code]...
can u see what is the error in this code because it not saving in the data base the error is Data type mismatch in criteria expression.
[code]...
I have a datagridview that's bound to an access database, and it loads fine, and runs without errors, but it doesn't save. Here's my code:
Imports System.Data.OleDb
Public Class Form1
Private Sub Form1_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing
Dim myDA As OleDbDataAdapter
[code].....
I'm working on a project which are generating some data from my VB.NET software and I wish to save those data into sql server. But my concerns is the speed of saving and the large amount of data. For every 0.5s, one set of data will be generated and the process will keep running for about 8 hours, so at the end of 8 hours, roughly there will be 60,000 set of data generated.May i know what is the best option/method of saving the data into the sql server in not hanging up my software and also keeping the pace with the speed of 0.5s data being generated?
- Speed of 0.5s. I have to maintained for every 0.5s, one data must be generated. Cannot delay too much.
- I can afford delay in the sql database, meant the data might not be necessary close to real time.
What is the best way on saving changes in datagridview into database? Whatever the user made changes in the datagridview will reflect right away in the database? The fastest and accurate way.
View 3 Repliesi need to save an image that will be displayed on a vb.net form. how do i get round this:
1. how do i get the image before saving it in the database?
2. how do i save the image in the database?
3. how do i fetch and display the image from the database on a form?
I created a database in access 2007, linked it to my project in visual studio 2008 (vb). When I enter some data using the UI, it does not save it in the database, and it's gone as soon as I run the program again. I dragged the textboxes from the datasource panel, onto the UI..
this is the code that was automatically generated by vs for the save button:
[code]Private Sub StaffBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles StaffBindingNavigatorSaveItem.Click
[Code].....
I am developing a software for a restaurant which is owned by my sister. I would like a functionality that will make her send all purchased items into a listbox,and afterwards which will calculate for the total plus VAT. Whereby, there will be another button which will print out a items and the total from the listbox to a POS printer, and at the same time save into the sales database.
View 2 RepliesI'm saving data to a database, data from a listbox and checkboxes.In the listbox, on the form, there are 20 records and then there are 20 corresponding checkboxes.I need to save all 20 records to the database so really I need 20 new rows. What I have managed to get working so far is that it will save the last record only.Here is the code that works:
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
'setup the relationship
objDataSet.Relations.Clear()
[code]...
but that's not right.How can I get to save 20 new rows to the database table?
im having problems saving and and updating my database. created in the database explorer.Run thorugh what ive done, created tables saved the job, imported the database dragged items on to screen.
Ive looked at my xsd file and Update and delete comands havent been set, how do i set them and is there a default to preset them when ive i create new databases. its really great you helped out..
In my project the "teacher" must enter grades in the Grades database then save it and click the Semester Average button(btnSA)to display the grades in the database. Well I can't the the data to save. After I completely fill in the grades and click the save button in my tool strip I get the following error "OleDbException was unhandled: Command text was not set for the command object"
Public Class Form1
Dim connStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=GRADEBOOK.MDB"
[code]......
I have read all the posts on this and tried a million different suggestions from the posts and I still can't get this and I don't know what I am doing wrong. I am new to working with DataGrids, Table Adapters, and Binding Sources so please bear with me.I have a form with a datagrid that loads when someone makes a selection in a combobox. I want the ability to make changes in the grid when they hit the save button. This is my data connection and variables, etc.
Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=C:Documents and SettingsTodd LerewMy DocumentsVisual Studio 2008ProjectsPracticeAppPracticeAppTFPOperationsDatabase.mdb")
Dim myAdapter As New OleDbDataAdapter
[Code]...
I am making a simple program in Visual Studio 2010.My program connects to a MySQL 5.5.8 database running on my computer through XXAMP. I have used the Connector/Net 6.3.7 for MySQL to allow me to do this.
This is the local information for the MySQL server:
Server: 127.0.0.1
Port: 3306 (default)
Username: root
Password: admin
I have successfully created a Data Source for this server. The DataSet is called 'testdbDataSet'.
This is what my program looks like:I do not want to use the navigation bar that Visual Studio gives me at the top. Instead, I want to use the buttons shown below the input fields. The btnAdd button I believe should clear the two fields. It is currently working fine. I want the btnSave button to save the stored values of the two input fields to the database. I do not know how to do this.
this is roughly the add form where i have created... i am suppose to send this information into the database that i am using which is mysql.It is suppose to grab the incident date and the Type and also a count that increases by 1 if the date is the same or else it will be back to one.
This is the code
Dim count As Integer
Dim hotelcode As Integer
[code].....