After a save, if the program crashes before I close the window I am loosing my changes. Is there a way to commit? here is my saving
vb
Private Sub TicketBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TicketBindingNavigatorSaveItem.Click
Me.Validate()
[code]....
I was creating an enrollment system for my Thesis, and my adviser told me that I must have a Code in my program that Synchronize database from client and server so that if the terminal connection is "Up" the data will go to the server and if the connection is "Down" the data will go to the installed server on the the local machine. and every 20 mins or 30 mins will sync the database.
View 5 RepliesHow can I display column contents of a MS SQL Database on Text Box using VB 2008
View 2 RepliesI 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?
Is it possible to make one project that saves all the database information on through forms. Then also have a word document that could access the database through labels on a separate project? Also i am using ms access for my database and is there any way after i publish them that they can access the same database?
View 2 Replieshow to backup my database in local drive when i press a backup button in my vb2010 application...
View 6 RepliesI need to save pictures in my database, my database is MSSQL as of now, my code for getting the picture is this:
Private Sub browsepic_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles browsepic.Click
With dialogpic 'Open File Dialog sa toolbox
.InitialDirectory = "C:UsersCAMILLEPictures"
[code]....
how to save the picture and how to retrieve it?
I am aware about the COPY ALWAYS or DO NOT COPY features for files and database files.But my problem is the following:This is the
Public Sub New()
' This call is required by the designer.
InitializeComponent()
Dim mhkos As Integer = 1
Dim ypsos As Integer = 1
[code].....
where the MDF file is located I am getting an error...as the MSSQL server does not allow even to copy the file to an other location.
I am trying to Insert/Delete records in a MSSQL database based on if a checkbox is checked or unchecked. The checkbox is an item template in a datagrid, I can check/uncheck the checkbox but it doesn't do an insert or delete. Here is my code:
[Code].....
But then I get the error that the control chkmap has not been declared. I am confused as to how this needs to be declared, do I set a variable to the FindControl("chkmap") and then set it as variable.checked = true ?
I have a question on a datagrid object in vb.net 2008, that I what to be populated with certain values of a parameter from mssql database. The connection is made, the column header are loaded, but I what, when the form is loaded, to populate the datagrid only with certain values, doing a select commnad where id has a value given by me.What is the command to have this select done and display the values in the datagrid?
View 3 RepliesI have a datetimepicker but the custom format is set to HH:mm tt so that I can get eg 11:20 AM
this value I have stored in database with the help of Label4.Text = DateTimePicker3.Value.ToShortTimeString.
How fast did the VB.net inserts a data in a Mssql database??
View 1 RepliesI have to attach an excel file to a MSSQL 2005 database, using a project written in VB.NET 2005.
View 1 RepliesHow can i backup my mssql database using the save file dialog?
View 5 Replieshow to use a dynamic table for my MS SQL database? Im using vb.net 2008...any idea on how to do it?
e.g. - Output
ID LastName FirstName Address Order
001 Doe John Kentucky 10-10
002 Smith Jack Kansas 10-11
I have a little problem regarding the use of DBNull, NULL etc. in VB.net in combination with SQL Server 2k.
More specifically, I want to do something along the lines of this:If x = 0 Then
x = DBNull.Value where x is declared by Dim x as Object. I would rather use Double, but I can't assign DBNull.Value to this, and using Object works quite well, too. But every time I hit this condition, I get an exception: A first chance exception of type 'System.InvalidCastException' occurred in Microsoft.VisualBasic.dll This is not a major show-stopper, since the database value I write x to in the next step, is NULL by default - most of the time! So I need the ability to write NULL to it. If that was not the case, I would have been able to work around this by catching exceptions, I think - but sadly, this isn't really of use then.
I have a problem which I cannot find a solution to, when someone picks a tab to start off on it saves a setting as the name of the tab and in the startup if that setting is the name of the tab then that tab will open. here is the
[code]...
how to copy a file, for example a file from C:imagesample.bmp and saves it using a folderbrowserdialog that automatically save the same filename.
View 3 RepliesHow to insert and retrive multiple asp.net checkboxes values to MSSQl database as comma seperaed string 1,2,3,4,5 using vb.net ? and retrieve the inserted checkbox chekched in disabled form ..using vb.net url...I want this type of whole layout in vb.net means if user registered selected seats then then next the same page load for todays date the selected seats will be disabled
View 2 RepliesI have 2 problems, this may sound odd but is there an easy way to store and read vba/vbs inside a database (MSSQL)? Second problem, how to create vba/vbs so i can use it to interact with my own software?
View 7 RepliesDoes anyone have any suggestions how I might store the contents of a RichTextBox that also includes images to a MSSQL 2005 database?I suppose a possible answer to this would be to convert the entire content of the RichTextBox to a Byte Array, and then insert the array as a varbinary(max) datatype.But how do I convert the content ?
View 1 RepliesThe sample below does what I want it to do and that is once I've filled the maskedtextbox and press enter it goes and does stuff. However, because the maskedtextbox is full I get an annoying 'beep'. So I figured I'd just use the tab key, I changed theChrW(Keys.Return) to ChrW(Keys.Tab) but it doesn't fall through, it just changes focus to the next maskedtextbox that I have. Is there a way to lose the beep? Or how do I get the tab key to fall through?
[Code]...
I have a datagridview. If the user adds a new row, and then clicks away from the grid. How can i stop them from doing this?
I want them to finish the row add first or cancel it. I want to then update the table adapter in the grid's leave event.
If the row validation fails, i want to display a message and re-focus to the cell in question.
The first problem i am running into is that the focus continues to go to the control that the user clicked on to move away from the grid.
How do i cancel that event?
As an example, if the grid is on a tab page and the user clicks on another tab page, i want to prevent that page from displaying if there is an error on the row that is being added to the grid.
I was hopeing for a cancel option in the lost focus event of the grid.
Ok, So I have this prettey simple code to get the window titles of all running programs:
lstTitles.Items.Clear()
For Each p As Process In Process.GetProcesses
If p.MainWindowTitle = "" Then
[code]......
That works fine, but the highlighted line creates a new bitmap, so the exif metadata are not exported to the resized image.
Is there a way to resize a picture without loosing exif data?
Creating a new bitmap with the new size is the only way to resize a picture?
how I can implement my calendar with VB .net express 2008 and MSSQL 2008 Express. How do I get it to work with datasets, binding source etc.If I go to Properties>settings my connection string is:
Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|CalendarDatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True
and I have a table with fields:-
CalendarID
Subject
Location
Purpose
[code]....
I can Add the event to the calendar I have the necessary items on my form linked to my table and I can save them to my table:
Me.Validate()
Me.CalendarTableBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.CalendarDatabaseDataSet)
But I cant keep the event displayed on my calendar when I close it and open it again.
Window based application:I am populating gridview in a child form on load event as well as formatting gridview cell colors.Data is picked-up from parent form grid(Grid to datatable) by setting up global public datatable variable in child form.
Gridview formatting works fine for the first run.All the future runs the gridview formatting function in the child form is executed but the color changes are not reflected on the grid.
In a form I have an ImageList named MainLogoImageList containing a 100x100 pixel 32-bit colordepth image. That is my app logo.
I am too lazy to set up an icon editor and edit an icon of that logo, or convert the image to an .ICO file. (Ergh, well, I am not allowed to install custom utilities.)
To set my forms' icon, I use
Icon = IconFromImage(MainLogoImageList.Images(0))
in the OnLoad event handler to set the window icon.
In my about box, i have a PictureBox with no image. In its OnLoad event, I use
LogoPictureBox.Image = MyMainForm.MainLogoImageList.Images(0)
Icon = IconFromImage(MyMainForm.MainLogoImageList.Images(0))
to set the About box's icon and content.
So far, so good, the icon looks pretty good for a being created from a 100x100 pixel bitmap.
Is there an easy "no utility required" :-) way to get the icon that is returned my IconFromImage saved into an .ICO file so that it will keep the color depth when loaded as the app icon? I want to use exactly the icon that IconFromImage creates.
Saving it using
Dim S As New FileStream("MyAppIcon.ico", FileMode.Append, FileAccess.Write, FileShare.Write)
Icon.Save(S)
S.Close()
in the main form's OnLoad event handler and loading that .ICO file as the app icon in VS's project properties dialog yields and icon that is obviously converted to 16 colors, and looks awful.
I have to display all the digits of 2^90. This is within the reach of the Decimal format which can display up to 2^96-1. The Decimal format stops displaying after the 15th digit.The real answer for 2^90 is : 12 379 400 392 853 802 274 899 124 224 (29 digits)
Here is what I do:
Dim a As Decimal = 2^90
TextBox1.Text = a
[code].....
How do I do this? If I cut and paste, then it wipes the code, sometimes the stuff doesn't even show up when I run the program (I guess it's loosing all the handler information) I read about not cutting / pasting controls in the sticky at the top.
View 4 Replies
