I work at a school that utilizes several servers in our network. I wrote a program for a class I was teaching and then they changed the servers so there is a new path to the different components. When I test each component it works correctly but when I try to utilize the menu it utilizes the old path and the programs wont operateSteve.
View 3 RepliesI have a problem with my code. My code is using the fileupload control to browse for a filename when you add a filename it processes it and the code runs fine on when it lives on local host, but when I put the code on our prodution server it cannot find the filenames listed by user.
For example if I use the upload control to browse to B:MISCH IntiveRPTTOFL_3.csv and the code lives on my localhost which know what that file path means it works, but if the code is moved to a production server it may or maynot know what B:/ is or B:/ maybe mapped to something else. Even if I am browsing to a file on my C drive it will work on if the code is on the machine that the C drive is on, but it will not work if the code is on another machine because obviously that file wouldnt be on that C drive.
[Code]...
We are developing applications using VB .NET as front end and SQL Server as back end. We want to store and retrieve pictures in a database. We do not want to store the pictures directly into the database but rather the path of the pcitures so that through the same paths we can retrieve them.
View 14 RepliesCommand = New OleDbCommand("SELECT dbo.tbl_staff.staff_id, dbo.tbl_staff.username, dbo.tbl_staff.password, dbo.tbl_useraccount.position_id " & _
"FROM dbo.tbl_position INNER JOIN " & _
[code]....
It says incorrect syntax.
i have problem about datetime i use os vista,sql server 2005,vb.net 2008 string is = "insert into ....... values('23/3/2009')" in program time is correct but when i go to sql server,it's show 23/3/2555 when i saw at os is 23/3/2009 i think this problem at sql server but i don't know how to fix it Do you understand me?
View 1 RepliesWhen subtracting two doubles the result appears to be correct but when I save said results in a SQL Server table they are incorrect. I know their are problems with decimal values in the binary world but isn't there a work around for this?For example 421.2 - 418.9 = 2.3, but the result stored in the SQL Server table is 2.29!In the VB code I used Math.Round to round to two digits and the values appear correct during debugging but, as I've said, in the end they are off by .01. [code] decimal(10,2)BTW, I've tried numerous methods of getting the correct value but have not met with any success. I've used Math.Round on Val1 and Val2 separately, after the subtraction, and on the ResultVal. I've also converted the ResultVal to a string using Format(ResultVal, "#####.00") and then back to a number but still the value that ends up in the SQL Server table is wrong.
View 5 RepliesI've been trying to make a login system for my application. Which seems to work, but when I try to connect to the database itself, it won't work. I used this code to check the exception:
Catch myex As MySqlException
MsgBox(myex.Message)
That gives this exception:
"Acces denied for user '[my db user]'@'[My IP-Address]' (Using Password: YES)"
The code I use for the connection is:
Dim Connection As New MySqlConnection("server=[The SERVER IP]; user id=[DATABASE USER]; password=[DB USER PW]; port=3306; database=[DB NAME]; pooling=false")
Connection.Open()
MsgBox("Connected")
As you can see, I've tried to change the 'server' part, but it won't affect anything. It will just say my ip address (localhost, I assume) in the exception. Telling me that it couldn't connect to it. Which is not even what I'm wanting to do.
May I ask a question to you all.I have vb.net project that generate sales report from SQL Server Database.I changed SQL Server 2005 Express to SQL Server 2005 Standard Edition.
After that my program can't run properly and every time I got Time Out Expire message.
That program work properly with SQL Server 2005 Express.May I request suggestion how to fix this.
I have been working on a project. In this project I wish to be able to create electronic signatures. I have perfected the signing routine and also creating the memory astream and saving and retrieving an image. The problem comes in when I retrieve the image from the database. The image being saved does not capture the signature (the changes I've made to the picturebox)
1. I load a small bmp as the template on where to sign with by setting the picturebox.imagelocation to a network share
2. Using mousemove and mouseclick, and draw events I draw a signature on top of the picture box
3. I picturebox.image.save(memorystream) the picture box to a sql server from a button click event.
4. When I retrieve the saved image there are no edits (No signature) only the original image. I am sure that the original image is going in and that it is coming out every time.
My question is thus: How can I capture the signature that I have edited into the picture box. I have tried picturebox.save like I mentioned above and I have tried picturebox.update() but without success. Does anyone know what I missing I think that the answer lies in refreshing or updating the picturebox, but I'm not sure how.
im currently working with an SQL Server 2008 database and im trying to change values in the database usign visual basic.The following code runs correctly and I have tested changing passwords and have been able to logoff and then back on again using the new password. The problem i am facing is that as soon as the application exits the database returns to its origional values so the next time i run the program the passwords are back to the old values.
[Code]...
My Scenario is that i have fetch data from one SQL Server table into vb.net DataTable.Now if any record is changed or New Record is saved into SQL Server Table i want to fetch or update only that record into my data table. is it possible.
View 1 RepliesI am trying to migrate from Access Database to SQL server database. Do I need to make changes (for saving, reading, deleting etc. data) to my code as well?
I understand I need to change connection but what about code?
I'm basically trying to implement the functionality of the example here ax/grid/examples/dataediting/editondblclick/defaultvb.aspx) on my own site, but instead of using a data source control located in the page markup (like in the example: essionDataSource), I'm using a dataset that I get from some server code-behind. I am able to successfully get my double-clicked row into edit mode with my dropdowns successfully
View 2 RepliesI am getting an exception when I run the below VB.NET code to validate a user..The exception says that "Incorrect syntax near variable user" where am I going wrong ?
[Code]....
I changed my Username on my computer from i.e. "xxxxxx x xxxxx" to "Dennis"
VB 2008 during a compile gave me the following error: Error reading icon 'C:Usersxxxxxx x xxxxxAppDataRoamingMicrosoftVBExpress9.0VSProjectApplication.ico' -- The system cannot find the path specified.
The file "VSProjectApplication.ico" is in 'C:UsersDennisAppDataRoamingMicrosoftVBExpress9.0'
Somewhere in the VB2008 "configuration" files I believe that I need to manually change the old path to the new path.
I found the old path in the ".suo" file. The ".suo" file is not a text file. How can I edit the .suo file, save it so that it will work?
on my Form I have a DataViewGrid and some textboxes with a save button (they are filled with additional data of the selected row).Save is disabled first, when I change something in the textboxes the save button is enabled.When the user changes a gow in the grid, I want to ask before changing the grid row, if he wants to save (if the button is enabled).I am using RowEnter but this is too late, then the selected row already changed (and my textboxes already got new data)...What event can I use to ask if I should save stuff before the user changes a row?Something like BeforeRowChanging with a chance to cancel changing the row?
View 2 Repliesi just want to make a program with first form to enter the serial if correct just continue to form2 if incorrect just a popup say like "Serial Incorrect" how i can make it ?
View 2 RepliesI'm having issues with program that uses radio buttons to select between 2 different forms, that are displayed using showDialog. When I click a button to perform calculations in either form, it will act normally and display the information, however when I click the Clear button to begin a new calculation, the form will close, does anyone know why?
View 1 RepliesI have a form that I am using to search for records in a dataset, it has a text box for entry of the search criteria and a 'Search' button to initiate the editing of the entry and .Filter on the BindingSource. This is one form in a project with many, when I show it using .ShowDialog it always disappears, (not visible and not loaded) after the 'Search' button is clicked, I have stepped through and there is no .Hide or .Close that it encounters, it performs all of the logic correctly but control is returned to the main form it was shown from. When I use the .Show method, I do not have this problem.
View 5 Replieswhere I am starting another thread which opens a form. Succinctly, it is an animated "Please wait.. processing" type of form. The issue is that I want to make this form a child form of the parent (main thread or main GUI) when I open it.The issue is that I prefer to use frmProcessing.ShowDialog(frmMain) instead of just frmProcessing.Show, because of form disappearing issues. It, of course, gives me an error of illegal cross thread operation. My question is, how do I perform frmProcessing.ShowDialog(frmMain) to show from within another thread, that the newly opened form is actually a child of the main thread. Is there a better way for me to make a small processing form telling the user to be patient while background processes are working? [code]
View 2 RepliesWhen I run this code, it does not seem to open the OpenFileDiaplog diaplg box, or if it does, it closes it immediately, and I get at index out of bounds exception at the " infileStream = getFile.OpenFile()"This exact same code works without problem in another application I am building. So maybe its something about the IDE environment?I think, but am not certain, that this code worked in 2003 .net. I then used the VS wizard to automatically convert to the 2005 environment that I am now coding in.
Dim infileStream As Stream
Dim getFile As New OpenFileDialog
getFile.Filter = "All files (*.*)|*.*"
[Code]....
I converted this app from VB6. I have 2 forms. Form1 instantiates Form2 via a Menu Item.I am having trouble getting Form2 to end when clicking close (X). If Form2 is 'idle' it closes fine; but if I am in a loop processing anything all the events fire, but it continues processing in Form2. I've tried messing with Dispose, Close, Application.Exit, Application.ExitThread. My last attempt was creating my own event to fire back to Form1 and dispose Form2 -- and it hits it but Form2 is still running. What is the deal? BTW if I use just Show vs ShowDialog -- Form2 just blinks and disappears.[code]
View 2 RepliesI converted this app from VB6. I have 2 forms. Form1 instantiates Form2 via a Menu Item.I am having trouble getting Form2 to end when clicking close (X). If Form2 is 'idle' it closes fine; but if I am in a loop processing anything all the events fire, but it continues processing in Form2. I've tried messing with Dispose, Close, Application.Exit,pplication.ExitThread. My last attempt was creating my own event to fire back to Form1 and dispose Form2 -- and it hits it but Form2 is still running. What is the deal? BTW if I use just Show vs ShowDialog -- Form2 just blinks and disappears.
Form1 does this
Dim f2 as Import
:
[code].....
I have a form that uses another class to do some work, and the class throws events regarding text updates, and the main form handles them and passes them on the the StatusForm, which displays the process progress via usercontrol. Using a BackgroundWorker and Events I'm able to update the usercontrol on the Status form if I use frmStatus.Show(). Unfortunately, the Status form should use ShowDialog() so it can't lose focus while the application is processing data. Now, for some reason the UserControl will not update if I use ShowDialog(). Any ideas?
View 7 RepliesI wanna overload the ShowDilog for my form. I wanted to clarify whether the Owner should be passed as Value or Reference.
View 2 Replies[code] For some reason, and I don't know why. The same CustomSplashScreen that had a handle for UpdateText shows to not have a handle when I call .Close().So basically it would show the splashscreen and update the text, but the form would be left opened and not closed like it is supposed to be.
View 2 RepliesIn my program I use WebBrowser control for OAuth. It's located on vk_auth_window form. So in the code I call vk_auth_window.WebBrowser1.Navigate(vkauthurl). If authentication is successful, I silently get token, but if user is not authenticated a form vk_auth_window is showed to them to enter username and password. To check this I catch _DocumentComplete event and check for the right URL. I need no other code being executed until the user finished authentication or closed authentication form. ShowDialog() does the trick, but it somehow hides cursor from username and password fields in WebBrowser control. So I introduced a variable Dim showform as Boolean=True in and set it to False from the _DocumenComplete event and in the main code I use infinite loop.
While showform
System.Threading.Thread.Sleep(100)
Application.DoEvents()
End While
However it makes userinput slow due to thread sleeps. And If i remove them, it loads CPU quite a lot. Is there a better way to wait for form to close? What is it?
I have a new developer that is calling Showdialog (in VB.NET) on a Windows Forms form without first creating an instance of the form.How is this possible? I don't see a shared method for ShowDialog...
I'm not crazy about this approach either as it seems to me that the dialog will not be disposed until the application exits.What am I missing? Is this a new best practice?OK, Form2 is just a blank form.Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button1.Click
Form2.ShowDialog()
End Sub
End Class
So you know how when you call "Form.ShowDialog" from where ever you call it, it blocks until the form being displayed closes. And then the function returns whatever result it was.I want to know how to block like, but without a form, yet still have the "main ui thread".Basically I have this long process that needs to thread out and do several things... and it's heavily event based. It jumps between two threads, the main ui thread, and it's own background thread. The main ui thread needs to have access so that I can randomly open different dialog boxes for things... sometimes they're just windows asking to hit OK or Cancel to continue, others it's to perform some action, etc etc.
But there is NO central form related to it. It's a complete background thread running that randomly hops over to the main ui thread for things.Right now I have this class I designed called lets say "DoJobProcessor". On it is a function called "BeginDoJob" that threads off from the thread pool... when ever I need to jump back I use a ManualResetEvent to block on the background thread, jump over to to the main thread with "invoke" and passing a reference to the MRE, then release the block when done there and continue on on this background thread.
All while this is going on I just set the form I'm trying to block the main ui thread from managing by just setting its Enabled property false.It all feels just messy and annoying... and I was just writing something using ShowDialog and I was like... HEY, what if I could block this BeginDoJob method, hi-jack the main ui thread, then let that function return the result when done instead of having this "Complete" event with the return value in it. It's obviously possible because ShowDialog does it, but I don't know how.
This way the job I'm performing isn't always waiting for the main ui thread, instead its the other way around... the ui thread waiting for it, the way it aught to be. Show something, branch off do some stuff and just idle the display while it does it, come back show something else, branch off and just idle while it does that.
I have a form that is called w/ ShowDialog. Inside that form, I want to pop a message box to ask the user a question, but it doesn't show.[code]
View 2 Replies