how to check if a field( a cell within a database for talk sake date of birth) has been edited in the past then flag it now this field may not be change for a year but how do i keep a record of that and the flag it if it is change.
View 1 RepliesAlright, when I open my program I want it to check for updates and if there is an update I want it to download. So far I have a text file saying the most recent version and then it downloads that file and compares it to the current file version. If the current file version < recent version then it will download the file. :O Can someone help me with the code? :3 I have a hosting server with direct download links.
View 5 RepliesI'm unsure of how realistic it is for this to work but I know a lot is possible in vb. I have an application called WindowsPRO available from my filesharewebsit This application is intended for those in school to easily be able to do several daily tasks such as calculate and use notepad within one window. I have been working on this application in part with the help of MSDN.Back OT, currently when I click the "Check for updates" I use process.start to open my website. Not very complicated is it. What I want to do is open a form in whichchecks for the update from my site. Whenever I upload a file, I'll upload it as a .zip onto my site and always name it like: "Application name v1.0" or whatever the version number is. That is the only thing that changes.
When the user presses the check for updates, I want to checkhe site in background for a "higher" version number. If my application is v1.2, I want it to check for anything higher than 1.2. So if I have on the site 1.2.2, or 1.3, I want it to check for the highest number version and download it.My question simply is, how do I check for a "higher version" from a website?
I don't like to build myprogram to a click-onceapplication becauseI lose the .exe and I don't know how to edit it after building it. So unless someone this, here is my main question:I was thinking about updating a .txt file that have uploaded somewhere that has the current available version. Can I use streamreader for an online file? And if so, if the available version is updated, how can I edit the code and everything to updatethe file?
View 14 RepliesI have a program with commercial uses. Currently I have email out updates. I would prefer that when the program loads, it searches for updates either from the web or I was toying with the idea of creating a file host server. I want the program to search for updates without opening a web browser, however (giving anyone power to email out a free download link). I think of the way Digsby opens, checking for updates, or gimp. This is what I want.
View 12 RepliesAs most programers will want after spending a long time on a program is to implement program updates, so have i.
What i want is a nice simple way of doing the following check if file exists as "www.mydomain.com/program/install.exe" if true, download and launch install.exe on completion, un intstall current vertion ( if possible )
I have created a backup script which my organization uses to back up a specific set of data weekly, to a server, by clicking and running the app.I am always updating it/ improving it and instead of redistributing to the select employees there has to be a way to code in a "check for updates" type of thing.
I was wondering how to make my created app check with that server to see if i am running the latest version.
How do i incorporate a "version" in my app, or would it just be a naming convention thing? and how do i check for updates? Would a button being selected to check updates be preferable? or is there a way to auto detect it?
I am making a calculator application that's in beta and will check for updates every so often. What I'm asking is if its possible to make a program check for updates.
View 6 RepliesI have a little prob guys. How can we set vb.net setup project will check for an update of its newer version first before proceeding in installation.
View 5 RepliesI can get the program to easily, upon startup, look for updates and then install them. I want to have a button that the user can click that will check/install updates.
View 5 RepliesI'm trying to make my app check for updates by reading a text file and comparing it to a 'currentversion' setting in my application (or if checking the executable file version is easy, that would be good).
Here are the basic steps: -Read text file hosted on [URL]..-Check if the version number (eg '1.1') is higher than the number in the 'currentversion' setting or the executable file version (whichever is easier).
-If the text file version number is the same, change form background colour to green, if it is higher, change the background colour to red.
i am making a software =D (Does the Name matter ??)
Ohk so its gonna be my first try
my last soft was a success with 800+ downloads
so i want my program to check for updates everytime it opens or like when it clicks on a button
then it checks if there are updates then it will show the link to download the new exe file in a messsage box or in a textbox
I remember seeing a tutorial a while ago about making your application check online for updates..I did this a year or two ago but have since lost my example. Can someone explain how you do this or supply me with a link if you know a good tutorial?
View 20 RepliesOkay so i made a small code that my application can check for updates onstart time. The problem is that it freeze up the application. How can i make it work faster.
Try
My.Computer.FileSystem.DeleteFile(My.Application.Info.DirectoryPath.ToString & "" &
"v.txt")
[code].....
I got the printing. Now how can I allow users to update the database, such as Add, Change, or Delete records accordingly? Then I am finished with my project.
View 1 RepliesI have one specific problem, that is relative to DataTable Updates to Database.
Code:
auxDatatable = Mydataset.MyDatatable.GetChanges
Now i'm going to Accept or Reject Changes based on some Criteria. The problem is that I wish to Update Only the Records that in Fact exist on the Database, as you can imagine I was forced to create some Dummy Records in Datatable, to a specific job.
My approach to this issue was to do something like this :
Code:
Private Sub MySub (ByVal auxDatatable As DataTable)
Dim drView As Mydataset.Mydatatable
For i As Integer = 0 To auxDatatable.Rows.Count - 1
[CODE]...
As you can see I tried to Delete the rows that are Dummys, but the rows in fact are not being deleted. As consequence I get an error after that Sub, when i try to make :
Code:
MyTableAdapter.Update(auxDatatable)
This is naturaly caused by the dummy Records.
I'm using mysql database..I have forms setup main form has datagrid..you can add to this datagrid and save to datbase with my add form and it works fine. I can delete from the datagrid and it works fine...when I select an account to edit is when I have my issue...form edit brings up the selected account but when I save my changes it doesn't save to the selected account it changes my first account in the database......
Here is a sample of my code
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
' 'Save changes to database and exit
Dim intResponse As String
intResponse = MsgBox("Do you want to SAVE Changes to this record?", vbOKCancel, "Save?")
If intResponse = vbOK Then
[CODE]...
I have a form in my application that presents users with a datagridview which pulls data from database-a. I then offer the users the ability to edit that data but what I'd like to do is when they click the save event, that it saves their changes to database-b.
View 2 RepliesIve only recently starting fiddling with Visual Basic Express and Sql Databases. Ive managed to get a database up and running, and can query information from it. I have even created a form that can add a new entry to the table im using.The first form has a ComboBox that list the PlayerNames in my table. Form2 allows you to add a new name to the table, but anything I add isnt immediately updated in Form1. I have to relaunch the program to see the new entries. Even then, these new entries dont seem to be permanent as they eventually dissappear.The code I have for Form1:
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
.................0......................................................
00
[code]....
what's the best way to handle the updates to the database.For example i have one datagridview that's binded to a datatable (with two fields, id auto incremented and a varchar). The user can do all the operations Insert, Update, Delete.If i insert one row (only the text) and call the update method to save the changes to the database, and after that remove the same row and call the update method the adapter will throw a exception because it didn't update the datatable with the value of the id. So the best way to do this is always calling the fill method after every update?
View 22 RepliesSince ADO.Net uses a 'disconnected' model where the data available to a single program is just a copy of what is in the database, what is the normal way to handle multiple programs needing to update the same table in a database? The problem I see is that a program can't update unless his copy of the data is the most up-to-date. Are we supposed to read before updating and hope that the update occurs before someone else changes the data?
View 2 RepliesI'm using a SQL database and I'm writing a VB.NET client application. This application is used on multiple computers at the same time. If one of the clients makes an update to the database I would like to have the other clients to be aware of the update.
Has ony one already done this before?
I've got a question below:load data from a table in database into a datagridview,make change in datagridview,and use update function to update change back to tablebut 13 changes, only 12 being update back to databaseonly the top row on the datagridview not being update??
For Each orow As DataGridViewRow In DataGridView1.Rows
orow.Cells(1).Value = TextBox1.Text
Next
[code]......
how to implement UI, BL and DAL in a project the way that I see it as a requirement for some projects. The way I am able to do a project now is from a form create an object of a class in which there are properties and functions that do database selects, updates and deletes. Looks to me that doing a project like that is separating the UI from the DAL. In an update button click event I may call Obj. Delete (txtCustID.txt) for example. I don't understand the part of further breaking it down to include a Business layer; in which a vb solution is made up of three solutions.What goes in the BL?Does the BL call the DAL?
View 2 Repliesi seem to have a problem when i try to update a certain record in an Access 2007 Database. I have a small Access 2007 database with 1 table which has 3 Columns and several records. The 3 columns are RecordNumber (Primary Key and it is autonumber), FirstName(text) and LastName(text). What i am trying to do in VB 2008 is implement a search form which when you find a record you can update it. I do not have any problems with the search, but i cannot seem to edit any other record than the first one. For example i search for John which exists, if that record is the 3rd record when i try to edit it whatever changes i make (for example change that to James), the changes i make are made to the first record and not the current one. I tried a lot of things but nothing works, here is my code:
[code]...
This is my problem.I have a field set up in MS Access to Boolean YES/NO, this field is populated when the user check a checkbox on a windows form. If the user check a checkbox, the value is written as checked in the data field (MS Access).The problem is when I search for the user information, I need the information from the Data base to populate(return) to the windows form. Example: If I enter a users phone number and the user data is present, the form gets populated with the information the user previously entered which was store in the database.Example: If the user selected checkbox1 and submits the form. When I search for the user info, the check box should check(populate) because the user had checked it on submit.Here is what I have done:
[code]...
I am getting the check value correctly in the database using a Boolean.Here is one of the errors I am getting. Unable to cast object of type
'System.Boolean' to type 'System.Windows.Forms.CheckBox.I am having trouble putting the codes in a code tag or block
My application is like this : i have to search my data from database with some check box and text box when user select check box specific function go on and then when user enters some range of value in textbox then the result will shown in data grid view after that i can print it by selecting data
my vb.net code is as follow:
Imports System.Data
Imports System.Data.SqlClient
Public Class XtraForm1
[CODE]............
I m also pasting the demo picture.
Details: I want to compare these above two table1 and 2 . The unmatched records should be save in a new table .
objectives
1 Should take input the table and fields we want to match each other.
2 Then after searching or reading the record from table and selected fields save the unmatch records in a new table
hi there,first of i know nothing at all and my goal is to make a app for xp to check a database and check/patch a iso and then to burn the result to dvd-dl, basically like a app called abgx360 checks the database then like xbox backup creator burns the game, i'd like to make a app to do both, i'm going to college next year in september to learn programing c+ andf a few other things, but thats a longtime away.
View 14 RepliesI have a Boolean that writes to a data field. The data field(column) is set to YES/NO, if the user check a checkbox, the value is written as check in the data field.The problem is when I search for the user information, I need to get to form to the state it was in when the user submitted it.
Example: If the use select checkbox1 and submits the form. When I search the form, I need to make that particular check box check.
[Code]...