i manage to get my dropdown list working, but when change related data in the built program, it does not save it when exiting the program. How do I save the data when exiting?My database name is Database1.sdf?
View 2 RepliesIm using VB.NET 2008
I know I can exit a program by using the End statement.
But i was wanting to know how to check to see if the data has been changed since it was loaded and bring up a diaglog box up saying the data has been changed or not saved, would you like to save the data before exiting?
I will have a form that will have a yes, no, and cancel buttons.
Im using VB.NET 2008 I know I can exit a program by using the End statement.But i was wanting to know how to check to see if the data has been changed since it was loaded and bring up a diaglog box up saying the data has been changed or not saved, would you like to save the data before exiting?
I will have a form that will have a yes, no, and cancel buttons.
I have a Visual Basic application that I use to access an SQL 2008 database. When I add a record to my table everything appears to be fine. As long as I keep visual studio running the data remains in the database. But if I exit visual studio and then reopen visual studio the data in the table is gone. I can reenter the data and again everything look fine. When I created this application I selected my SQL Server database from the Add New Item dialog. I selected service-based database. Instead of creating the database from the server explorer. Are there settings I need to change when a database is created this way?
We have an application that works well on XP/Pro, Vista, Windows 7, Windows 2003 Server, Windows 2008 Server (32 bit) but is problematic on Windows 2008 Server (64 bit). The application uses an unsigned activeX control which may or may not be related to the problem. To install we need to add the program name and regsvr32 as DEP exceptions. Once that is done the application installs correctly and operates normally except when the application closes.
If a user clicks the 'exit' button our code basically says 'unload me' (where me = the main form of the application) and there is no code in the form_unload section of the program.
Everything works well on every Windows platform except Win 2008 64 bit where we get
APPCRASH
Application Name: PDFPrint.exe
Application Version: 10.10.0.18
Application Timestamp: 4d238253
[Code].....
After we continue to close the program we see a message box with run time error 216 at 00002B24 message.
I know you can open a windows program like calculator but is there anyway if calculator is open i can close it with code ?
View 5 RepliesI had designed a simple form with Groupbox and some checkboxes (colors)where I need to program the following :When I checked one checkbox in this collection I need the previously checked checkbox to be unchecked and the new one to be checkedbut what I'm getting is not like this where after writting the following code :
Private Sub obj_checked(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles chkred.CheckedChanged, chkblue.CheckedChanged, chkbrown.CheckedChanged, _
chkgreen.CheckedChanged, chkwhite.CheckedChanged, chkyellow.CheckedChanged
[code].....
after running what i wanted in the DOS command prompt with:
System.Diagnostics.Process.Start("cmd.exe","/C C:gds2asc.exe C: emp.gds C: emp.txt")
How do i exit or close the command prompt window?
How to save data in datagridview using vb2008.
View 1 RepliesI have a set of labels that contain number values that need to be saved into a txt file and recalled from a text file by a button click event.
Ive been searching these fourms for days trying to find the answer to the save / load data problem. From what I understand, XML should be used to do this. But no matter how much I read I cant make sense out of how to solve this issue. I just need a simple and quick fix that dosen't have to use XML[code]...
I have a set of labels that contain number values that need to be saved into a txt file and or recalled from a text file by a button click event.assume the value of label1 label2 and label3 must be stored in a text file on the users computer and then later loaded back into the program from that text file.How can this be done without using XML ?
View 1 RepliesI am currently puting together a data driven application just for fun and to get to know sql. The problem i am having is on my new customer form I cannot get the data in my text boxes to save into my database table at runtime. I simply have 4 textboxes and a save button the code for my save button is as follows:
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Dim Connection As SqlConnection = MSDB.GetConnection
Dim mySqlCommand As SqlCommand = New SqlCommand
Connection.Open()
[Code] ....
All this does is bring up an error in runtime. How to get that to work when I press save the details in my text boxes are actually saved into my database table.
I was trying to export a data from the listview control into an excel format and I was able to make it successfully using a command button directly. I want to use a SaveFileDialog to export and save the content of the listview.
I searched from MSDN website and got a sample code which was originally intended for saving an image file. I tried to used it and edit the code and combine my code to export the data content. It ran successfully and attempt to export the data in an excel format but when you open the file in the path as to where you save the data, it gives you a message "Excel cannot open the file 'Filename.xlsx' because the file format or extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file." and it just leaves an empty excel file.
I read from the MSDN site that if you are using an MS Office 2007, the file extension for excel would be '.xlsx' and not 'xls'. Let me give you the two codes I tried to use. First, I used command button and was able to successfully export and save the content in an excel format but using the SaveFileDialog was not successful.I suspected that there's something wrong within this line
'oBook.SaveAs("saveFileDialog1.FileName.GetType()")' and 'Dim fs As System.IO.FileStream = CType _(saveFileDialog1.OpenFile(), System.IO.FileStream)'.
Here are the two diffrent codes I used:
'Using the command button-----successful
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
[code]....
i use this gridview to save data to database. but everytime i save, the only data that saved was checkbox that i was recently checked. so checkbox that was supposed checked not saved to database. [code]
View 3 RepliesI wrote the programme with vs2008 and access 2007,i built its setup.when i execute my setup on winxp ,its true,but when i execute it on win 7 ,when i want to save my data i have an error.
View 1 Replieswhat the best way to do this?
View 2 Replieshow do i save everything thats in a listbox and save dialog shows extensions like .txt .text .html .htm .url types and it writes to where you save it too also check path files would be awesome.
View 7 RepliesI am using MS Access 2007 as database and VB 2008 to build an application to show the content of 2 tables as a single table.I have two tables in MS Access and i have linked both the tables using "ID" as primary key(1st Table),foreign key(2nd Table). I used Query Wizard to show the data of both tables in a single table(3rd Table).I am able to view the content of all 3 tables using datagridview in vb 2008(Using Code), but i am unable to add,delete,save and search the content of the table using code. My concern is,i will be able to do all these operations using codes only.Would you please help me out in this.
View 5 RepliesI'm using the 2008 express edition. Now, I created an application that will allow the user to choose transaction in the combobox.text and input its price and quantity using an textbox.text. When the user click button1, it will be push in the datagrid/datable I created. And when the user click the button2, it must be save to excel file. The only thing I need is how to save the data from datagrid/datatable to excel. This is my code.
Imports System.Data
Imports System.Data.SqlClient
Imports Excel = Microsoft.Office.Interop.Excel
[Code]....
modify code to insert the data to MS SQL and save changes when click save button for the second time?
View 14 Replieshow to code for the save button in vb.net datagrid view by using insert into sql and update sql statements (it should be able to insert & update the data grid and save the changes) when the save button is clicked .
View 2 RepliesHow to save all the data displayed in DataGridview( 2 column, no primary key) and have a button and
View 7 RepliesI am working on desktop application. I had created number of dynamic textbox and label and I want to save that data on clicking the save button.
View 4 Repliesin my form i have 4 textboxes and i want all not to be empty while saving the data.I have put condition in save button,when user presses the save button to save data, to check all the textboxes not to be empty. My question is that, i want to focus to that particular textbox which is empty during saving the data.
For example: i have txt1,txt2,txt3,txt4 as textboxes in the form if txt1 is empty while saving, the focus should switch to txt1 rather user himself have to go there.
I've previously posted with regards to searching for a string within Excel, although the replies were enough to get my application 'working' the solution was riddled with over-complicated methods.Therefore I bought some books and figured it out for myself and came up with the below (which works like a charm may I add).
Dim oExcel As New Microsoft.Office.Interop.Excel.Application
Dim oBook As Microsoft.Office.Interop.Excel.Workbook
Dim oSheet As Microsoft.Office.Interop.Excel.Worksheet
[code]....
None of these (even if combined) make ANY effect whatsoever.I have also saved the workbook on exit, again to no avail.
Trying to exit an application but can't seem to kill it without an error."An error occurred creating the form. See Exception.InnerException for details. The error is: The form referred to itself during construction from a default instance, which led to infinite recursion. Within the Form's constructor refer to the form using 'Me.'"The form hasn't loaded yet, it is still in the process of looking for a file to load, if the user doesn't want to specify a working directory, that is their choice, but I need to close the app since it can't continue without it.I'm stuck in a class and can't get back to the main form without it continuing to load everything up. I wan't to force a shut down. [code] I was trying to get back to the main form without loading any more from the class to kill it there. [code]
View 6 RepliesI have a project that has three windows running at the same time, and exiting anyone one of them leave the others windows running.What is the best way in the code to stop the whole thing executing?
View 1 RepliesI find myself frequently turning off Intellisense because it adds wrong choices to my code. For example if I try to type "i " (without the quotes) it causes "int " to be put into my code. If I type "for " it may put "form " into my text.
Reaching for the ESC key constantly slows down my typing. (It's such a long way to reach for small hands). Is there an alternative way to exit out of intellisense without the highlighted choice being placed into my code, or is a way I can define a different key for this purpose?
I want to make a button that opens a program. Just for the sake of this post, we'll call the program Notepad.I want the users of my program to open Notepad, but not everyone saves Notepad in the same location. Is it possible to save a value (and the text in the TextBox) so the user doesn't have to retype it every time the program loads?
View 4 RepliesI have a simple for loop with the following code
For i As Integer = 0 To 4
Snake(i).X = (120 - 20 * i)
Snake(i).Y = 120
SnakeBody(i).Location = New Point(Snake(i).X, Snake(i).Y)
Snake(i).Facing = 3
Next i
But for some reason I unable to debug it. I place a breakpoint on the line Snake(i).X = (120 - 20 * i) and When I try to see what the values are the second time the loop iterates it simply exits the loop.