My application is in VS 2008 (vb.net Windows form)
I want tips for this:
What types of care I take for it?
What types of problems can be generally happen?
This is the situation: i have the central location with the main computer,and 14 distanced locations connected in VPN and often we need to update program manually (on distanced locations) by overwriting the existing .dll-s of the program and this is pain in the ass to connect remotely to 14 locations and on each workstation overwrite the .dll files so i want to create application which is going to be installed on each WS and by running this app it will check the program folder on central computer and if there is any file with newer version then existing one on the WS it will copy it from central computer and overwrite the old file/s on WS. It is a small app with two buttons and progress bar but the main thing is the Update now button because i dont�t know which commands it should commit.
View 22 RepliesI have created an application using ODBC data sources.it runs on a local machine well. but i want it to run on client machines from central server. the following is the code that i use:[code]where cleaners is a data source i have manually created in ODBC data sources.and then uses the connection for inserting,deleting and so on.can somebody help me with a code that can enable it access the remote machine.
View 1 RepliesI've got a game I would like to build, it will require a central game server where peoples data (game data :-)) will be sent to and shared with other players - how is the done. Is it remoting? TCP? something else - I need to study up on it but want to make sure I'm learning the right thing.
View 3 Repliesi would like to know how locate the hard disk in a computer. For exemple I have 2 hard disk : C: and E: I would like to locate them and list them in a textbox for exemple.
View 11 RepliesI have an application which writes to and reads from a database. I'd like to be able to have the application installed on a number of computers with the database installed on a central server which all of the applications will connect to.
first of all, installation (installing the app is simple, but how can I get an install program to put the database on the server?), and next, concurrency errors?
I understand that having more than one person trying to update the database at the same time is likely to cause concurrency errors, but short of deploying my application and having everyone try to write to the database at once, I'm not sure how to approach this.
What happen if i want connect to a database server is not my computer local host, is another computer localhost in LAN network? how it works? [code] how about i wan connect the server is another computer localhost database?
View 1 RepliesI wrote a program in VB2005. It is a program that is supposed to run in a client computer accessing an MS Access .mdb file stored in the server. The program itself is stored and run in the clients computer. I am not good in networking at all. The way I do it now is:
1. Have a directory made in the server to hold the MS Access .mdb file, and have the directory to be shared.
2. Have the same directory accessed and mapped in the client computer (say to Z:)
3. Then have the program in the client computer simply access the database as if it is in the same computer (as the directory already mapped into the client computer). In the VB 2005, this is done when we set the connection string of the database connection.
However, my user is complaining that by doing so, the database is basically exposed to the operator of the client computer (through the mapped directory), hence more vunerable for any bad intentions from persons who may have access to the client computer but not the server. He insists that he used to have a program that does exactly the same thing like my program, but the database is shielded in the server, where it cannot be seen in the client computer (I have other people who confirm that this can be done, though they can't tell me how, since they are not programmers themselves). Now, I have no idea on how to connect a database that way, and I don't even know where to start looking.
I'm trying to add a new data connection to a SQL Server database that lives out on my network. When I add the new connection I get the "Choose Data Source" dialog but it only contains the following:
Microsoft Access Database File
Microsoft SQL Server Database File
I don't see an option for a remote SQL database. How can I add that option to my list?
I have linked VB to my sql server and all my tables and data load correctly in VB.I drag and dropped my table in "detail" view and then debugged the program, little did I know, when I tried to add a new instance of data into my table I literally have to enter the primary key. I am trying to figure out how to set the "STU_ID" (PrimaryKey) to auto-increment off of the last row of data on my table.
View 3 RepliesI want to use dataset for sql server for adding/modifying/deleting data from sql server.
View 8 Repliesi have a app in visual basic mobile 2008, so i finish but now i need to tranfer the data generate in the in the app mobile to data base in sql server 2008.
View 1 RepliesI want to backup my database using Linq to SQL:
Dim sql As String = "BACKUP DATABASE SeaCowDatabase TO DISK = _
'" + sfd.FileName + "'"
db.ExecuteCommand(sql)
[code].....
I should create a program for a Pocket PC that reads & writes data from an MSAccess database located on a desktop computer (pocket PC and desktop one are connected through a Wi-Fi connection).Is that possible?
View 3 RepliesI'm displaying data from a database in a datagridview, but the player also needs to be able to add new rows, which isn't allowed because the datagridview is data-bound. What is the simplest workaround to this problem?
View 10 Replieshere's the code:
Try
Dim com As New OleDbCommand
com.Connection = con
[code]......
I have a project I created for my VB class where you enter what type of ticket(combobox), how many tickets(textbox), what type of tickets(listbox) and will give you the total amount.I want to do a little more to the program and was wondering about adding the person's name, address, phone, city, state, zip and then having all the information put into a database. I wanted to also take the information entered from the program and use the printPreview control to view a report from Access(possible?).
I've only worked with viewing database information on the forms in VB but I've never entered data into the database. Is this possible?Can I have the information entered on the form be entered into a database that keeps track of all tickets purchased and customer information?I can see this working in my head but don't know if it's logistically possible.
We are going to change the connection string in Settings.vb so we don't need to worry about what it is when our app runs on a different computer other than the development computer.
[Code]...
Most of the project I do, I use the datagridview to display the data from the database. What is the different between the datagridview and listview? If I want to display the data from the database, should I use the datagridview or the listview?
View 4 RepliesI am trying this..
Imports System.Data.OleDb
Public Class Form1
Dim conn As OleDbConnection
Dim cmd As OleDbCommand
[code]....
I get an error: object reference not set to an instance of an object
Im currently doing a small programme of a register system. I need to add a new group box filed with a few textboxes and a couple comboboxes for each entry in a access 2010 database. for example if i had someone called bob in my database with his details i would like the GUI of the VB app to add in a new textbox for the name, a textbox for the address ect in a set order, this needs to work for multiple entry's so the textboxes ect don't overlap but be placed neatly below the added textbox.
View 3 RepliesImports System.Reflection
Imports System.Data.SqlClient
Imports PSXSTL.Data.DataAccess
[code]....
How do i generate a new GUID and Add a new "CustomerName" to my table if the GUID doesnt exist.
This is written in.NET 1.1 and connected to a SQL 2000 Server Database
[code...]
I have to write a code in vb.net (2010).To get a data from Database A table 1 and dump it to Database B Table 2.What's the best way to do this? Most efficient way? I know I can do this very easily in sql management studio but I need to write a code to do this in vb.net.
View 2 Replies[code].....
View 4 RepliesI have this datagrid containing a couple of items: Attachment 72953 I have a save button which on click will add both the rows to the database table named MSale. The MSale table contains the seven columns present in the datagrid...
View 5 RepliesI have a Visual Basic 2008 Windows form application that processes some scores and data. I want to export the data to an Access database. I have created the Access database and connected it to the VB program.I am looking for a simple set of commands or sample code to add records to the database. Perhaps I am oversimplifying the problem, but it seems like it should be so much easier than it has proven to be. I only want to export the data in code; the user should never see the database or do anything to it while the program is running.
View 3 Repliesi have a task to create a TCP Server (a program that is listening on its network card interfaces for incoming data stream).I have search on the internet and i found that i can use two methods : Socket or TCPListener class.I have created an example for Socket class, but i wondering how could i test it? I need to check that if another computer in the network send some string data to the listener computer , then this message should be displayed.Here is the example from microsoft that i am using for TCP Server using Socket:
Public Shared Sub Main()
' Data buffer for incoming data.
Dim data = nothingc[code]....
But it does not work because of the PORT setting.If in the TCP Server i have "Dim localEndPoint As New IPEndPoint(ipAddress, 0)" the client crashes, but if i change the port from any (0) to 11000 for example,the client works fine.Do you know why?
Later edit2:Maybe i should have started with this question:Which method is recommended for my scope?asynchronous or synchronous method ?
i have encountered a problem, i want to access the data coming to the computer from the in-built bluetooth module of a computer on windows platform, this data has been sent by a remote bluetooth module say a by an autonomous device (just like a bluetooth mouse connecting to the computer). The to be sent is in the form of numbers and i need these to manipulate on the computer.
View 6 RepliesMy tile-based map editor project. So far, it works really awesome. Here, look at a picture: [URL] And the screenshot is outdated: Now I got the Pencil, Rectangle and FloodFill tools too!, the tilesets are from that popular (well, not so popular) game engine called RPGMaker.
Currently, this is how the map is structured:
One ArrayList represents the X coordinates.
One ArrayList in each X represents the Y coordinates.
One ArrayList in each X,Y represents the tile.
The tile is an ArrayList containing three elements:
The Image name (Tileset01 in the screenshot), the X coordinate in the image, and the Y coordinate in the image. Those coordinates are from the TILESET01 image, not map.
Getting the idea?
How do you locate a tile in the map when it is clicked?
First I get the cursor's position on the map picturebox, then convert it to a multiple of 32 (the tiles are 32x32, yes), divide the position X and Y by 32. The results are the indexes I need to get to the tile I clicked.
That method works just fine for me.
When the map picturebox invalidates and needs painting... When that happens, I iterate through each X and Y arrayList. When I get the arrayList that represents the tile, I use it to draw on the map.
For example:
Iterating X arrayList.... step 8......
Iterating Y arrayList..... step 3.......
Found arrayList with three elemetns: ("Tileset01",32,96)
Draw image on the map picturebox, source is "Tileset01" on rectangle (32,96,32,32)... draw it on map picturebox's point (8 * 32) and (3 * 32)
And so on.
Now you understand how I am working with my map editor, how I am locating clicked tiles, and how I am drawing it. Everything goes fine, except for one problem: At some point, the user might want to make a 500x500 map.
That means, an arrayList with 500 elements representing the X tiles. Then an arrayList with 500 elements for each X tile, representing the Y tiles. Then an arrayList in each X,Y pair.
Then multiply that result by 5, because there will be 5 drawing layers. How am I supposed to handle such huge maps?! My app explodes when I set the map dimensions to 500x500! 500x500 is the max setting allowed in my app. I also know that 500x500 map editors are possible, because I have seen others before. With great performance.