Alright, let's try this again. I have an mdb file as a database in my program, I need this mdb file to be what my published program reads off of. Is there any way to have Visual Basic (2008 Express) not encode my mdb file to Example.mdb.deploy?
View 1 RepliesI am attempting to run an update query on a Microsoft Access Database File and am not having any luck with the update. It appears to update the RecordSet but not the actual Access Database (when I run the following code, close the debug window, then re-open it a field referring to the Count_Value column reflects the update). I am using Microsoft Visual Basic 2008 Express to work with this code, if that is of any interest. If you could look through the code below and see what is causing the RecordSet to update but not the actut
Code:
Dim strDBpath As String
strDBpath = Application.StartupPath & "CourseData.mdb"
[code].....
i have code which display one table content to datagridview successfully using following code.
[Code]...
I'm using an access database in a program that I'm making for my school, the user is able to select an item from the menu, then it sends it to a list box, there is also a textbox to put a quantity of how much of the item you want. I have a field in my database called Amout Ordered, I want to update it with the amount of each item ordered, and I can't figure out how.
View 1 RepliesI'm currently looking to add a code where, when executed, finds the appropriate value (searches for it), then on the same line, but in a different category, changes the text to 'YES'.
[Code]...
I have got problem when using the SQLCommandBuilder class. For me it throws an error saying that the select statement does not return any primary columns.... Which is weird becouse i am sure it does since the select statement is "SELECT * FROM MyTable" I am prety sure that selects everything including the primary column which is set to primary , realy i checked and doublechecked.
Secondly i tried to manually set the column(0) as primary by setting it's property bu no such luck of making it work.
I have these two functions in a class that i instanciate an object from in the main program:
Code:
Public Function GetDB(ByVal DBName As String) As Data.DataSetDim SQLAdapter As SqlClient.SqlDataAdapter = Nothing
Try_SQLdataSet = Nothing
[CODE]...
This Functtion fills the dataset and returns it to my main program where i do lovely stuff with it. (Just as a side note this is a SCADA system and i always need the entire DB which is never bigger then just a few ( 6 ) entries so i must go for "*" ^^). Good part is, this works like a charm, i love it. Now i need to reset a few status bits etc and i assume with the update command. And that is where my joy starts to get stomped on a bit.... The code:
Code:
Public Function SetDB(ByVal dataTable As Data.DataSet, ByVal DBName As String) As BooleanDim SQLAdapter As SqlClient.SqlDataAdapter = Nothing
Dim SQLCommandBuilder As SqlClient.SqlCommandBuilder
[CODE]...
Now this would have been a great and small sollution to updating datasets with the server but obviously it doesn't work. There is that pesky error about my table having no primary key and I know it's lying it just want to annoy me :P. But seriously I am puzzeld why that error wont go away and i have exhausted all the tutorials i can find on this.
I am using VB.net 2003. I am working on a stand alone windows program that stores data in an Access database via ADO.net via MS jet 4.0 OLEDb. I have progressed to the point that I would now like to provide the end user the oportunity to back-up the data they have stored and re-install if they choose. I am envisioning a menu item for "maintenance" with sub-items for "back-up" and "restore"
View 1 RepliesI created an executable file of an application done in VB Express 2010 which connects to a Access 2010 database. When installling the executable file at one of the user's computer, the file is installed correctly, but it fail's when trying to connect to the database. It says that Microsoft Dataengine cannot open the database. The user's computer doesn't have Access installed, does it need to be installed? or can I install a framework or application to avoid installing Access at the user's computer?
View 8 Repliesi just want some opinnion or suggestions regarding database softwares. we are going to develop a system for 20 or less users, i am planning to use MYSQL community server as our database to lessen the budget for that system, i just want to know if it is ok to use that version.is there a big differece between mysql community server, enterprise server and MS SQL Server in terms of handling data i.e security, speed, etc...
View 2 RepliesI am using the Mysql .NET connect and can connect to my database using my program. i want to be able to get a Users Password from the database using there user name
This is the query i want to use: "SELECT Password FROM staff WHERE Username = " & textbox1.text & " '". But i don't know how to run that query and to get it to store the Password as a variable
Here's what I'm attempting: The user browses for and opens a dbf file. The user is presented with a checkedlistbox which shows the column headers. The user then selects the columns they wish to run a report on. ex. total # of cells not empty, longest cell length, etc.
I'm to the point of populating the checkedlistbox with all of the columns shown but I'm unsure if the users selections are actually linked to my data and if they are how I go about isolating said selections for the reports. I have a feeling that my approach to populating the checkedlistbox is not the proper way for what I'm trying to accomplish.
Here is the code
Public Sub btnGetFile_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetFile.Click
Dim fileLookUp As New OpenFileDialog
[CODE]......................
I have a form thats an invoice generator. You type numbers into the text box and it displays totals in the listbox at the bottom. I was trying to make it so that as you typed into the textbox it would update the listbox.
Private Sub txtWBQuantity_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtWBQuantity.KeyPress
'This section makes it so that you can not type a letter into the txtWBQuantity textbox
[Code]....
It works kind of, after I hit the next key it calculates the total of the first number I typed then writes the next number, how can I make it calculate the total after I hit the key?
I use the following code to read the standard output from a command line application from a main winforms application, and then I use the BeginInvoke code to update a textbox with the status. What I am not sure about is if I can have a smoother process. The code loads up about 10 to 20 text inserts, and those are all seen at once... not a smooth process where each status is updated. Any thoughts on if the reading of the standard output and/or the beginvoke code could seem more smooth to the user?
Delegate Sub UpdateUIStatusHandler(ByVal StatusMessage As String, ByVal JobName As String, ByVal Direction As String)
Dim ProcessJob As New ProcessStartInfo(GSyncExe, RunJob)
ProcessJob.UseShellExecute = False : ProcessJob.CreateNoWindow = True : ProcessJob.RedirectStandardOutput = True : ProcessJob.RedirectStandardError
[code]....
I am trying to read from a MySQL DB, and then output to the console like this:
[Code]...
I have been banging my head against a brick wall for 2 days on this one. Someone please help, I am sure I am doing something stupidly wrong.I have a stored procedure that accepts 2 inputs and has 4 outputs. The SP checks the users database against a given username and password.
[Code]...
I have a oracle database. I use the OracleDataAdapter(Oracle.DataAccess.dll) for select, update, insert, delete operations. I don't set any (table) locks on my own(I only start a transaction). I have a oracle table named "test" with the entry "test1".
Now my question: Can Person A read the entry "test1" while Person B is updating/deleting the entry at the exact same time? What happens in the worst case? An old match/empty match or can it cause any kind of exception/error(e.g. "TableLocked-Exception")?
I am attempting to modify DBaseIV files using ADO in .NET I am able to open and read the data with no problem but everything is showing as read only and there is no way (at least that I can find) to perform Updates/Inserts/Deletes to the underlying Database table.
There seems to be almost no documentation that I have been able to find dealing with DBASE files. I have found a few references that BDE (Bordland Database Engine) needs to be installed and used for changing DBASE database files. However, it appears that BDE must be purchased. I found one reference that indicated ADO Jet 3.5 would work but 4.0 would not. Then I found another that said 4.0 had been updated to include Update/Insert/delete SQL interfaces.
Can anyone point me in the right direction for being able to modify a DBASE IV database table using ADO (or some other method within .NET) It is currently not possible to change from DBASE to another database structure this may be coming in the next year or so but will still need to perform modification to DBASE files for the forseable future.
I am using Visual Basic 2008 Express edition along with mysql manager 2008.I have made a bank database and am looking to add a feature to update the balances of customers (individually) when i withdrawl or add money.The code i am using currently is
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
Me.Validate()
Me.StudentBindingSource.EndEdit()
[code]....
This is the same function as the Save record but, i want to be able to enter a value into a text box and then click the button to update the balance.
This may seem like a simple problem, but I am completely baffled. I am working on a timekeeping application using Visual Basic 2008 Express and Access 2000.
There are three tables being updated by three separate sub routines. Two work fine, one does not.
In trying to resolve the issue I test one field at a time. The test Access query and the code only reference the one field to change and two ID fields. The program runs but the field is not updated. The table has 42 fields to be updated when I get it working.
The Access query is:
--------------------
UPDATE tPPSummary SET W1MonHours = [@W1MonHours]
WHERE EmployeeID=[@EmployeeID] AND PPID=[@PPID];
[Code]....
When I pause the running program at the intRowsAffected it shows 1 record which is correct.
I am really out of options as tho where to go from here. There are no simple spelling errors in the parameters, there are no error messages and the sub runs to the end.
I am trying to update one table with results from another table as such:
Table A (field, type) : Table B
ID (key) Integer : ID (key) Integer
ParentID Integer : IssueID Integer
Number String : ParentID Integer
: Number String
I need to construct and UPDATE statement that does:
Sets B.IssueID = A.ID When B.ParentID = A.ParentID AND B.Number = A.Number AND B.IssueID = 0
Here is what I have so far but it is producing an SQL syntax error (missing operator)
sqlStr = "UPDATE B SET IssueID = A.id FROM B JOIN A ON (B.ParentID = A.ParentID AND B.Number = A.Number) WHERE B.IssueID = 0
I have also tried
sqlStr = "UPDATE B SET IssueID = A.id FROM B, A WHERE (B.ParentID = A.ParentID AND B.Number = A.Number AND B.IssueID = 0)
I am designing a fairly small application to manage a waiting area for a clinical department. There will be a receptionist who books appointments and updates exisiting appointments to say that a patient has "Arrived". In seperate rooms will be nurses who call patients who have "Arrived" and update the appointment as "In Session" and finally as "Discharged". The appointments are viewed in a flexgrid with nurses across the top and time down the left, patient names are displayed at the relevant times and the cells are shaded a colour to represent the current appointment status ("Booked", "Arrived", "In Session" and "Discharged").
I am using SQL Server as the back-end and Visual Basic 6 (I know) as my front-end.I have been told that there will be 2 or 3 nurses plus the receptionist logged in to the system but I would like to cater for growth.My question is what is the best mechanism to use in order to reflect the status change made by one user on the screens of the other users currently logged in?
I have been thinking about using a timer to refresh the data at a set interval but I do not want to keep hitting the server excessively (although what is considered excessive? we would be talking about a call for data every 60 secs per user). Plus the server could be serving data for many other applications so this is another consideration.Alternatively I have been thinking about sending some kind of message via Winsock to the other users notifying them of data changes as they happen. I don't have a lot of experience with this and am concerned about clients not receiving messages and users seeing old data. It also seems strange to me that once the days appointments have been retrieved from the database that "in theory" a client could go the whole day without having to query the database again to pick up changes - kind of scary.Some information on the data:We would probably be looking at around 100 appointments per day We capture patient name, date of birth, date and time of appointment and appointment status.What is the standard approach / best practice for this kind of scenario?
I am writing a simple app using Visual Basic 2008 Pro, and SQL Server 2005 as the backend. However, I copied the database file (.mdf) from another computer onto my laptop. I added it as a Data Source by having the Data Provider as "Microsoft SQL Server Database File" and have it attach the file to the local SQL server. However, it isn't set to copy the database to the output directory every time the program is run for debugging, as I thought that would save time.
Now however, the data update to the database are very wierd. I run the program, add some new data, save it, and it returns the new primary keys properly (that is, it turns from -1 to 4 or 5 or whatever, indicating that the data has been saved). When I close and re-run the application to check that the data has indeed been saved, it reflects the changes and shows me the new data. However, when the program is run again after some time, the changes I made are gone. I'm assuming this is due to some wierd way in which VB is updating the database that temporarily updates its cached or copied database, but doesn't actually change the real database. How do I fix this? I had previously done the same project on another computer, except there the data source was directly the local SQL server, and I had created the database directly on the server through Visual Studio itself, and I didn't face those problems then. Is there any way to manually attach the SQL Server database file (.mdf) to the local SQL server instance permanently, and change the app to use the attached database instead?
I have a code made in Visual.net 2005, and I have a problem. I have an excel file where I store records. I can read this records without problem, but when I want to make a modification I get the ERROR :
"Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype"I hope you can help me, I know that by default the file is open as readonly, but I dont know where do I have to specify the opposite.
[Code]...
I have a datagrid that I use to display data from a SQL 2000 table. I am trying to write back any changes the user makes to the datagrid data back to the original table but don't know the proper method to do this.
[Code]...
I have a storedProcedure that populates a dataset, this dataset is then used for a dataSource for a third party grid control. This all works fine, however I am having real trouble in updating the dataSet with the most recent data from my database.Below is the code that I am using to populate the dataSet:
[code]...
I am not sure how to update the dataSet with new data so that my grid control displays the most recent data. Could someone show me the code to do this?
I have followed a tutorial at url.... It is a very good tutorial but it is also a little dated. Most people who visit it praise it to high heaven so I decided it was a good place to start as an absolute beginner to programming. (I have teamed it up with Dan Mabbut Vis basic tutorial at about.com and joined DreamInCode in order to learn what I can accomplish with Visual Basic 2008 Express ). I am up to part 6 of 7 but keep going back to part 4 because there is one aspect I just cant work out.I am creating a form which logs staff in or out of work and allows staff to include a message with their ( at work /away from work ) status details on the form.The form is supposed to update a users status in a new row when they click a button. In my form the rows per user are being over-written with the updated information - it is not being written in a new row. There is a login form which precedes the staff status form - this has a little relevant code re calling the user info from the database but I think my problem is related to the insert statement in the middle of the below code.[code]
My code has changed quite a bit since the above as the form has progressed but the problem started at the stage above and has not changed with the forms progression. Every other aspect of staff update info is working well in my form - just not in a new row.I am going bald - The tutorial was written for VB2005 Express - I am using VB2008 Express though it has not made too much difference to the tutorial.
I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
View 3 RepliesI have a problem when updating an entity (User) in my application.
The entity is located in session when the user has been logged. So I made it:
Dim u as User = (From x in ctx.Users).First()
Session("user") = u
[code]...
I got the follow error:
An object with a key that matches the key of the supplied object could not be found in the ObjectState Manager.Verify that the key values of the supplied object match the key values of the object to which changes must be applied.
I would like to know the best, or standard, way to accomplish real-time client updates in a small multi-user application using an access data table as a data source.Specifically, this application will be used by 3-4 people. It uses a datatable which is filled on form load and bound to a datagrid at design time. The datatable is stored on a shared drive. The data table on the shared drive is updated in two ways:
1) Users can update the datagrid which then updates the datatable on the shared drive via the data adapter's Update method.
2) A server application does some work on some text files, periodically updating the data table.
I need the clients to reflect the changes to the data table on the shared drive as closely to real-time as possible. I know that the data table stored in memory on the client is disconnected from the data table on the shared drive, so I must query again to get the updates.
1) Is there an alternvative model I can use which is connected, and which will automatically reflect the updates in the data table on the shared drive?
2) If not, what is the best way to check for changes in the data table (so I can know when to call the data adapter fill method)? I am planning to poll the drive for a change to the .mdb file, raise an event and then fill the data adapter when the event is triggered. I am using this method successfully now to check for changes to a text file in another application, and I know how to implement it?
I am trying to copy a table from a network database to a local database. I used DAO and could check if the network table existed using a function that tried to assign a TableDef object to the table in question. If there was no error then I assumed that the table existed and the function returned true...Or it would error out and return false.I could then proceed with the copy or not as the case may be.I am converting the code to ADO.net and need to know how to check for a table. [code]
View 1 Replies