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 RepliesI have my battle systems code set to (attempt) to replace the test enemies data with the data that I have saved into a text file every time you either kill the enemy, or you leave the battle and come back to it... or if youve run away from the enemy.ive got two functions in the battle page, one of which is an agressive attack, the other of which is the running away function, and both of them are supposed to run the function that resets and reloads the enemies data from a text file, yet none of them are doing what they are supposed to do...
the problem that I am having is that when I either run away, or I kill the enemy, its data is never reset to the baseline of 2000, it is always, in the case of running away, what it was when I ran away, or if I killed it, it is a random value less than 2000...
here is the respective code
agressive attack:
Private Sub CMDagressive_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CMDagressive.Click
'Dim previousdamage As Integer
'Dim originaldamage As String
[code]....
Not sure what I am doing wrong here but I have 2 buttons and a rich text box. The issue is when I click the second button to add text to the rich text box and it over writes the current text that is already in the rich text box. How can I code this second button so that the text is added to the rich text box and not replacing the current text?
Here's my
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
RichTextBox1.Text = "This is the first line"
[Code] .....
Also how can I add spaces in a line of text (or in the middle of a sentence) so that I can insert a variable in the line.
Example:
"This is the" variable1 "line of text"
"This is the" variable2 "line of text"
I need to get a text file into a blank datatable that already exists. The table has its column names already so I need to insert the data into the fields. The text file is set up as so for example:
[Code]...
I am working with VB.NET.. i have a DataTable called "QUESTION", containing 3 fields:
QuestionNumber (unique integer key)
QuestionText
QuestionType
In my SQL Server database I created a Table called "QUESTION" with the same fields.
QuestionNumber is defined as integer unique key, auto increment
Now, when i make a bulk copy to insert the DataTable into the SQL Server, the database overwrites my QuestionNumber from the DataTable and generates new ones (starting from 1 increment 1).
How do i have to change my database setup, that the original QuestionNumbers are copied into the database?
i need to import a Single Column Excel File to an Existing SQl Server Table.
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 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]...
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]...
programing script in vb for saveing and restoring?
View 1 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 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 Repliestxt1 = help and txt2 = me! txt3 = not here, when i enter the other box i want the okay to drop sign to come up, after drop txt1=me! and txt2 = help.if i drag to txt3 display the can't drop sign.Iv'e tried everything all i can do is replace one way.also,i want the can't drop and can drop simbols to show.so far
Public
Class Form1
Private
Sub tbMouseDown(ByVal
[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 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 need to make a program in vb that takes a 1 page existing pdf that i specify and inserts that into another existing pdf that i specify.
View 4 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 have a code snippet that cleans a string of various characters. [Code]. Is there a better way to do it than this?
View 3 RepliesWhile my user is typing text into a textbox i want the characters " to be replaced with ' '. The thing is, when i put ' ' in the replace code, it thinks it is a comment so i cannot run the code without producing an error.Also in my multitext box, everytime i write text and hit ENTER, save and then load it back again, the last line ends with a comma, so:
Line 1
Line 2,
When the text is written to the file i read from, it will show like this:
"Line 1Line 2",
So i need a way of trimming ", when the apostrophe " and the comma , are together. My code already trims "".
I have dates like the following (note trailing 'T')
2011-11-07T15:24:28
2011-11-07T
With regex i need to extract just the date part so both will look like this
20111107
20111107
.net Have a webservice that is returning a date like 2011-11-07T15:24:28, but on some occasions it returns date with no time but still with the trailing T. This causes .net's cdate function to bail out.
In c programming language,
I can do
printf("%d
", value);
But in c#, how can I do it? For example string is "Good %s everybody"
I want to replace %s with the variable. Are there any solution except str.Replace("%s","good morning");
I have a datagridview which gets it's info from a datatable. Everytime I add a new record to the datatable, the datagridview replaces the first record with the new one, instead of adding the new row under the old row.
(Datatable is already declared.)
Private Sub btnWebSave_Click(sender As System.Object, e As System.EventArgs) Handles btnWebSave.Click
'first make sure all text boxes are full of data.
Dim ds As New DataSet
dt = New DataTable
[Code] .....
I have file paths such as:
' Any number of folders before and after the Project name
C:acdProject1efgsomefile.someextension'
How would I:Extract only the path before the project name?
C:acd
Extract the path after the project name?
efgsomefile.someextension
Note: Of course given the filename.Would Split be better or some complicated regex?
i have 2 groups of text in my text file
Bottom
11.0 28 Red (2 13.10 04.0) [1 16.71 33.3] 130611 2948 229111 28275
6.5 28 Blue (2 03.00 03.0) [1 05.36 58.3] 132111 -67725 191611 -51225
2.0 28 Blue (1 05.36 45.3) [1 05.36 58.3] 211111 51225 210454 34691
[Code].....