I am currently using the follwoing in my install routine, the idea is to check if the db exists. if the db does exist then leave the mdf name as is and attach it as a temp db then i can run a compare between the 2 db. however if the db does not exist i want to rename the mdf and attach it. however after renaming the mdf i cant attach the file.[code]
View 1 RepliesIs it always a good idea to use dispose prior to close? Or only under certain circumstances?
View 10 RepliesIn the members region I declare _Name and assign it the value "NameA" but how do I assign this value conditionally?The idea is that if in some file there's a value set than that should be the default value and not the hard coded one, if non is set the hard coded one should stick.
#Region "Members"
Private _Name As String = "NameA"
#End Region
#Region "Properties"
[code]....
I'm creating a Macro for reporting purposes and trying to create a formula that will look at a prior days report, save it out, and work off of that one.
View 2 RepliesI want to display an equation prior to solving it. Obviously in MS word etc I can use equation editor to write an equation, but I'm writing my own program.
Is there an easy way to display an equation. Obviously I could use text to write eg as text "a=b^2-3(c-d)/5" and everyone here would have little problem interpretting what I want but I want this to be accessible to 12 year old children.
Alternatively I could try and manipulate lots of text boxes one on top of the other to try and explain what I'm doing
The third alternative I thought of was to write in equation editor export the graphic and then import a graphic.
I'm sure I must be trying to reinvent the wheel - which I believe is the one thing OE programming is supposed to avoid.
I have a stopwatch that begins counting from "00:00:00" upon clicking Button2 (in UserInterfacefrm). When the user
View 6 RepliesI have an application that will require using dates prior to 1/1/1900. (Some historical analysis). What kind of date function can I use for this -- I want to be able to use all the standard features that are available for date, e.g. format, date differences, charting.
View 4 RepliesBeen trying to figure out why my progress bars (one in the status bar when the main window is open and the other in a window by itself before the main window is shown) go up most of the way, then stop till the processing is done.I have refresh in there where the action takes place, and that made it work mostely.Basically I'm loading a file into a string, then while in a loop, I'm processing the file by lines. I have a function that retrieves a line, then it does a:
pbProgress.Value = pbProgress.Maximum - sWork.length
pbProgress.ProgressBar.Refresh()
StatusBar1.Refresh()
[code].....
I am currently trying to publish my project, not to web but to the cd/dvd option, I have done a test and it works all fine. During my project i have code that plays an audio file (wav) in background. This file i have placed manually in my c-drive and and i reference its loaction when i call it via;
[Code]...
I would like to develop a structure to maintain my user's text input somehow on each form to allow user to return to the form and see the prior input for potential editing. My app has four forms which accept user input and form a string for output to printer. In the eventuality that the user notes a mistake in the input after leaving the app, I would like to develop a structure to "save" the user input at the form level and allow for repopulating the text boxes with the prior user input. Make sense? I have no idea how accomplish that functionality. Maybe it's too complex for my purposes. What do the pros think?
View 2 RepliesI have used the following query for my task and it returns the table..
objSQLCon.Open()
Dim da As SqlDataAdapter= New SqlDataAdapter(strSqlQuery, objSQLCon)
da.Fill(dt)
objSQLCon.Close()
[Code]...
But the same query some times not working and I got "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" sqlexecption error. I have searched and referred lot of links (cmd.CommandTimeout= 0) and I did not seen any usefull info for my case..
i have a Checkedlistbox in a windows form, and have defined 5 values in it.Also the form holds a datagrid in it. i have manually defined 2 columns in it.Now i would like to populate datagrid with some data according to the check list values selection. When any selection was done in the checkedlistbox, some data need to added to the gird.in case if i am ticking further selection, i need the datagrid to be inserted with additional values with the prior populated data.
being a beginner, i am not able to get any idea to get this worked.
I am getting the following error:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding works fine with the other 400+ updates before this one. There are only 5k records right now, and update string works fine from myphpadmin.
mysqlstr2 = "update " & turncolor & piececount & " set status1 = '1' where layoutstring = '" & layoutstring & "' limit 1"
' mysqlstr2 value at error = "update black32 set status1 = '1' where layoutstring = 'rnbqkbnrppppppp................p.....N..........PPPPPPPPRNBQKB.R' limit 1"
Dim command3 As New MySql.Data.MySqlClient.MySqlCommand(mysqlstr2, cn2)
Dim rowsaffected As Integer = 0
rowsaffected = command3.ExecuteNonQuery
I'm reading a file and then closing it with the following code, but my problem is later when I start a batch process it says the file is still in use. Am I doing something wrong in closing it? The process was working fine prior to my adding this code to read the file.
[code]...
This rexx exec is trying to write to the file that I read from in the prior step before creating a PowerPoint presentation, but fails becuase of the lock.I'm at a loss. I should qualify and say the process actually starts, but fails in the rexxexec after it starts, it isn't failing on the process start the rexx exec issues a message that it can't write to the file becuase it is in use.
I am developing a desktop application in VB.NET 2005. I have a requirement whereby a user need to select a .txt file from his machine (client) and after clicking the save button, i need this file to be saved in the server into a specific folder. Similarly, i should be able to retrieve the file as well.
View 3 RepliesI am using following code to attach my database to SQL Server. The problem is if I create a new file and attach it through my code but when I detach the file using SSMS and again run the same code, it gives error. [code] All the permissions are the same even first time.Also what should be the connection string if I need to use DB with uid sa and pwd abc123?
View 1 RepliesI don't know if I am asking the question correctly, but I want to keep a program I use all the time in memory (running).So instead of closing the program (main form), I would like to simply set it's visible =false. This is easily done and works.Then on restart (I already know how to check to see if it is running) I would like to attach to it and make that running version's main form be visible again.
View 5 RepliesJust after installing my application, I need to attach my DB to SQL server. I am using following code for it.
Dim cmd As New SqlCommand()
Dim vrMyConString As String = "Data Source=.SQLExpress; INITIAL CATALOG=master; uid=sa; pwd=sa;"
Dim conn As System.Data.SqlClient.SqlConnection = New SqlConnection(vrMyConString)
cmd.CommandText = "sp_attach_db 'e:dbTest.mdf', 'e:dbTest.ldf'"
' conn.ConnectionString = "Data Source=.SQLExpress; INITIAL CATALOG=master; uid=sa; pwd=sa;"
conn.Open()
[Code]...
It returns an error:"Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection."
I am trying to write code to send a mail message with an attached file.my code works fine if I don't try to attach a file but crashes when I do. I have not been able to figure this out.[code]
View 2 RepliesI have a project that I am doing which is as follows and need your help to complete the last section I can start word no problem with process.start("winword.exe")the problem is the attachment I attached the documents using project resources and then add exisiting text files and attach it to the project but when I debug I get the following error the code used is as follows
Process.Start(My.Resources.Results
How to attach any type of file in VB.NET.I want information or if possible code to attach any type of file in VB.NET.
View 4 RepliesI already made a .VB project using MVS 2010,I'm new in attaching database to SQL server and I'm confused attaching which database I'm going to attach because in the same folder i found that there's two
View 2 RepliesJust after installing my application, I need to attach my DB to SQL server. I am using following code for it.[code]It returns an error: "Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection."
View 11 RepliesI've written a simple program for viewing images. My issue is how someone would view these images If I deployed my project to a client. To display the images, I have an Access 2007 database with the full path written for each and the program reads the full path into the Picturebox.ImageLocation property. I've also stored the full, root, and relative paths in the database as separate fields. My issue is how to add these pictures to my project. and which project to add them to.
Do I add them to the main project with my forms?Do I add them to the installer/setup-wizard Project?Should I all the files individually or as a compressed .zip file? Additionally, I don't know how to point to these files once they're installed on a different machine/network. Do I write a different root path to the database when the program is installed somehow?
say I have a library, in which I added a few Console.WriteLine(..) statements tot during the implementation and see w going on when I use the library in a Console AppNow I want to use the same library in an ASP.NET app. Ideally I would be able to log on to the production webserver, and somehow start a command prompt and attach it to the website and see the messages in real time as they occur. How do I do that?
View 2 RepliesHow can i create a setup that should also install MSDE and attached the database
View 16 RepliesI want the program I am making to show the cursors position on the process it is attached to. Sorry if this is a lot to ask for. Can you tell me how to.
1. Make a drop down menu with the list of process.
2. When i click on one of the processes, my program attaches to it.
3. When I move the cursor over the process, my program tells me the co-ordinates of the mouse on the process.
4. When i press F3, Timer3 Starts.
5. Make the mouse move to a co-ordinate on this process.
If it is too much to ask for, can you just tell me how to do 1 of them and hopefully someone else will tell me to do the others.
if user needs to attach the databases to the instance of server manually before being able to use the application?I have added the mdf file to my Setup project. It installs and copies the file to application folder. I donot know if the file needs to be attached or there is a way that application could do it automatically (attach to MyComputerSQLExpress)
View 1 RepliesI'm trying to make a mouse over for a stack panel in WPF using a custom DependencyProperty (StackPanels do not handle the MouseEnter event).
I've created a class for the DependencyProperty like so:
Public Class MouseEnterBehavior
Public Shared Property MouseEnterProperty As DependencyProperty =
DependencyProperty.RegisterAttached("MouseEnter",
[Code]....
I was able to get the code to compile and run, however the binding doesn't occur.
simple way of attaching a progress bar to the tasks of a button.When I press a button, several tasks will commence and I want a progress bar to show it's... well... progress.
View 5 Replies