I have a thesis project. it is composed of a webpage created on php and a system using vb.net 2008. As of now , they are both connected to the same database. I am wondering if it is possible that if i packaged the system and live the website, will still be connected with one database?
View 1 RepliesI am designing a Point Of Sale system to be used by sales representatives. The sales rep should be able to place an order of a specific product on behalf of the customer. I have defined my relationships between the tables, Product, Order and Customer. When i try to save my orders i get an error that says "you cannot add or change a record becuase a rerlated record is required in table Product"
View 1 RepliesI have a connection to an access database, I have used the data sources tool provided because in this particular instance I don't want to do much with it other than display the records (which I can do) and edit them (which I'm haveing some trouble with).I have created a system whereby the database is connected to using the preset tools available like; BindingSource, TableAdapter, BindingNavigator etc.
I also have a button for edit. This doesn't work and I was wondering if anyone could help me with this? I can't really provide any code for this, because I didn't code the connection by hand and the code I have been attempting to use for editting the records in the database doesn't even sort of work.
How do I create a Login Verification routine (Login Form) in vb.net . i have an windows application with login form contain user name , password , ok button and cancel button .
as this one:
Imports System.Data.OleDb
Public Class LoginForm1
' OK button
[Code].....
but i want to run my application from desktop and will get confirmation if the user name and password correct by checking them in MS Access Database in the server.
so the the application in the desktop and the tabel of user name and password in the server.
create website involving payments plus some data entry eg booking of some facilities with the main data kept at a LAN window system.
View 4 RepliesI am working on a client system . How i will get IPAddress of all the system connected through lan.
View 1 RepliesWhat I'm looking to do is 'hook' a physical drive connected to the system so I can process data coming through the API before it's written to the disk. I have a sense DeviceIOControl is where I should be, but I can't seem to find any IOCTL code that uses a callback (which is what I expect I should be using to scan/process data on its way through the API).
View 2 Repliescreate database management system in vb 2008
View 2 Repliesi don't want to use the system date and time in my mini project.i want to create my own system date and time to be in sync with standard time i specify?
View 3 RepliesFor whatever odd reason, we have a legacy data recorder device that runs at 9600 baud. Except when it needs to transfer its recorded data to a PC, in which case it switches to 57600 baud.
The old VB6 code worked, although it had its own set of problems of course.
The routine is this: Do several COMMAND/RESPONSE routines to populate a list of available records, listed by timestamp, at 9600 baud. Once a timestamp or several are selected, display a file save dialog. At the moment that dialog is closed, send a command to the device to tell it "hey we're going to warp", sleep for 100ms, then set the baud rate property of the persistent COM1 connection to 57600, before beginning to process XMODEM data and do the progress bar dance.
The problem I'm having is that it doesn't appear that the data received is ever really kosher as far as the byte marshaling is concerned. Which makes me wonder just how well SerialPort is at dynamically changing bauds on the fly. The VB6 version used MSComm.
I've even attempted to just use MSComm through the compatibility layer but "CTL_E is not supported" which makes it sound like it's incapable of doing XMODEM. (?)
I'm trying to teach myself how to create an Occasionally Connected Application. I want to create a simple app (like a survey) that will store all the data on a server but have the front end run on the users computer. The users computer may or may not be connected to a server when the data is entered (they may be collecting data in the field).
Program does 3 things:
1. Shows data from database (ie, displays survey data stored on server)
2. Saves data to database (ie, new entries or changes to old entries)
3. Has a background thread that checks for network connection
a. If no connection exists:
i. Gets data, to show, from local database
ii. Saves data to local database
b. If connections exists:
i. Sync local database with network database
ii. To read data: Gets data to show from local database which is now synced with network)
iii. To save changes/new entry: Save changes to local database then sync changes with network, then send update call to anyone else running this app on a different computer so they will get the same changes?
I would like to create/use a system-wide independent universal 'counter object' that can be called via COM in a thread-safe manner. The counter object will be passed an ID to identify which counter to return, handle the counting, 'persist' the count (occasionally), have reasonable performance (as fast as possible) perhaps capable of 1000 counts per second or better (1mS) and be accessible cross-process/out-of-process. The current count status must be persisted between object restarts/shutdowns.
The counter object is liklely to be a 'singleton' type object implemented in some form of free-threaded dictionary, containing maybe 10 counters (perhaps 50 max). The count needs to be monotonic and consistent, (ie: guaranteed unique sequential values).Each counter should have a few methods, like reset, inc, dec, set, clear, remove. As a luxury, I would like to have a variable-increment (ie: 'step by' value). To support thread-safefty, perhaps some sorm of critical-section or mutex call. It just needs to return a long/4byte signed integer.
I really want something that can be called from anywhere, including VBScript, so I figure COM is my preferred solution.The primary use of this is for database keys. I am unable to use autoinc or guid type keys and have ruled out database-generated counting systems at this point.I've spent days researching this and I have really struggled to find a solution. The best I can find is a free-threaded dictionary object that can be instantiated using COM+ from Motobit - it seems to offer all the 'basics' and I guess I could create some form of wrapper for this.
[Code]...
I'm viewing reports on a VB.net form using CrystalReportViewer. Once a report is opened, the Access database that is used within the report is locked (i.e., the Access MDB file can't be deleted). Even after the report is closed, the database stays locked until the VB.net app "ends". This is a problem because I want to be able to delete the MDB file at some point while running the app and can't. The VB.net app starts by opening a form named "Startup". No database connection occurs here. A button is pressed using this [code]I must not be properly closing the CrystalReportViewer or the Report form.How do I close the Crystal report and unlock/release the Access database?
View 2 RepliesI have connected a database query that I made using MS Access 2007 to my form in VB 2008. I know how to pull the fields onto the form and get the information to display on the form by clicking the binding navigator at the top of the form. My question is that is there a way that I could input the ID number in a textbox and click a button to display the rest of the field in some more textboxes
View 1 RepliesOn my program I am trying to make a ToolStripStatusLabel's text change to "connected" if connected to a network and if not connected to a network change the text to " Not Connected" then I don't know how to display a image if connected to a network or not connected. So if the computer is connected to a network I have a image that I would like to be displayed next to the ToolStripStatusLabel. And if not connected to a network, can the program display a different image? I tried this:
My.Computer.Network.IsAvailable=True(ToolStripStatusLabel2.Text "Connected")
My.Computer.Network.IsAvailable=False(ToolStripStatusLabel2.Text "Not Connected")
I am trying to find out if the connection of my sockets (TCPClient) is connected or not connected. I am using the following code:
[Code]...
My project is basically a addition test for 5 to 9 year old children. On my form I have a button which when clicked, it inputs a number from 1 to 10,( which is chosen by the user via an combo box drop down), into ten text boxes. I have built and array and used a, for loop for this and it works fine. [code] My problem is I need to create another array connected to the same button to genarate 10 random numbers. Which will allow the user to add the two numbers together.My problem is that visual basic wont let me add a second array to the same button?
View 6 RepliesI am trying to add a data source from a connected database but it doesnt seem to be working well.Initailly the table name was mispelled and there where fields missing. The table was modified to include the new fields and it was also renamed.The changes are reflected in the dbml file within the project, and the solution has been built with a sucessfull result.The problem is, when I try to add a new data object into my solution, the changes that were made to the database arnt reflected in this new data object.
View 3 Repliesi am using Visual Studio 2008 and VB.NET 2008 and SQL Server 2005 as the database. I just finished designing & writing codes for a customer information and , however after it has been connected to the database only one of the datetimepicker can be click, and the rest of the function including in the form are not working!it seem that the form stuck and NOT responding. i cant even close the form (X button), so i have to stop the process using compiler (visual studio 2008), however if i press the 'Delete' button before the 'Add' button, it will successfully delete the data.. but if i disconnected the form from the database, (disabled the form_load codes [put 'quote']) the both of datetimepicker will work and able to view the date interval (after pressing the 'Calculate Period' button) in addition how to make it appear automatically in screen without using the button? below are the code, I try to make some other form.. but it is still the same
Code:
Imports System.Data.SqlClient
Imports System
Imports System.Data[code].....
i am wondering if it is possible to get the source code for the following:
1. use vb.net code to set on/off primary key when connected to Access database
2. update a particular data.
for e.g: hostname: AES-19 *use source code to check data in Microsoft Access database
if hostname is new, insert into Access. if hostname already exist, update into Access
*so that i will not have duplicate data in Access.
[Code]...
I have connected a form to my database, which displays info when the form loads, butttt it displays them from load, which is not what I need, can someone tell me how to clear the form upon load so that none of the textbox fierlds have data within them? Untill I request them to.
View 4 Repliescn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:ESHAN PROJECTUSMANasp.net_projectsHEALTHFOUNDATION PROJECTdatabasehvaccine.mdb")
View 2 RepliesI have a system that can add, edit, delete and search data that is in ms access. That ms access is connected to my vb 2008. I'm upgrading my system so that it can print the access file.
View 1 Replieshow do i delete selected row from a datagrid connected to sql server database...?? Delete selected row and update database.
View 2 RepliesI am trying to develop an application using VS 2008 connected to MySQL database. Previously in vb6 i was using adodb and now when i googled and got a few sample projects done using VS2008 in which most of the module codes were OLEDB.....To which method should i stick to...?
View 2 Replieswhen i will enter form no. in the text box this should check the on the lost focus event either this form no. is already exsist or not.if exist show msgbox?
View 1 RepliesWhen a vb project is connected to ms access(DB) whenever u make any changes in d db using addNew or insert or delete follwed by update command the changes are reflected in copy of original db in the debug folder of our project.in which updated values chnges with each run .. no changes are reflected in d original db.is dere any command to make dese changes permanent.
View 8 RepliesI am trying to create a VB.Net windows application that will list out IIS websites from a remote server when the user pushes a button as a means of verifying that a website got installed (from a previous section of the app...that part already works).I have googled all over the place and all I can seem to find is how to create a website or delete one, but not how to create a list.
View 1 RepliesI have a windows app that has a bindingNavigator connected to BindingSource that connects to an Access database. I am manually adding a record to the underlying database using an OLEDBConnection/command (cloning the current record). The insert into the database works fine, what I am not sure on how to do is force the bindingNavigatgor to refresh and read the new record and refelect it in the record count/next/previous buttons.Jack
View 7 RepliesI've searched the forums but never seems to find an answer for this one.. I recently connected to MySQL database server "Automatically" in Visual Studio 2010. I want to know if there's a way to determine the connection state for "Automatically created" connections in Visual Studio 2010. I know how to do it for"programmatically created" connections but just want to know how on the auto-generated ones.
View 1 Replies