1-i have a peer to peer network (every computer can be server and clinet) and i want to write a server- client program with vb 2005 and access date base to install on any comuter as a server. that serve has a data base with user name , password and credit field filled in access database .clients must connect to server and get permissin from data base field(username and password) to open an special program.
View 1 Repliesi cant for the life of me get a free direct link file hosting for my updater program. what im thinking of is now creating a small peer to peer network that the user could connect to my computer and i could have a drop box with the files in it. is this a feesable solution to this problem or should i go in a different direction? if so how would i go about constructing something like this?
View 3 RepliesI want to implement peer-to-peer video streaming in my WPF project.Plz help me by referring any web site or sample code which i can use in my project.
View 4 RepliesI know how to add flash player in vb.net, but I cannot find the tutorial for class library that make me control on flash. And I cannot find the source code for peer-to-peer connection in flash??
View 23 RepliesAs it says on the tin, I need an example of a simple winforms peer to peer chat app in VB.Net 2005 as a basis for a works project I'm working on. I've scoured the net and found many C# versions, but time is a bit too limited to convert everything to VB. Does anyone know of any such example code or a link where I can get some pointers?
View 2 RepliesI am architecting a program that I need some help on. I need to have a "watcher" program that will sit on a server and monitor a SQL Server. At configured intervals, the watcher will run a query on the server and create a dataset of information I want to share to any clients that are listening. I am looking at WCF Peer channel but all I can see is peer to peer chat and most of the examples I have seen are partial examples. I have looked at the example program from Microsoft but I am still a bit confused. The listener programs will receive the dataset of values from the watcher and filter the data at the local level and display the data they need and display it to the end user. I don't know if a TCP client/server would be a better solution, but the dataset may contain up to 10,000 rows of data. From what I read the WCF Peer channel will transmit at 50 mbps and should handle this load. My other option is a server/client architecture using TCP spawning a new thread for each request. Does anyone have any good examples, or articles about WCF and VB that they can point me to?
View 2 RepliesThere are a lot of different generic collections available, so the wisdom in creating a new one may be questionable right from the start.However, I often find myself wanting the same features from my custom generic lists, but cannot quite find all of those features in an existing object; namely, I would like to have a generic collection which works like a List or Dictionary (much like the System.Collections. ObjectModel. Keyed Collection(Of TKey, TValue)), but also works like a BindingSource does when it is bound to an ADO object (that is, it supports full sorting and filtering as well as currency).A feature I almost never need however, is transactional adds (the BindingSource's ability to 'cancel add-new').Again, with so many existing collections out there, I should take a moment to go over the reasons why none of them quite meet my needs.There is the System. ComponentModel. BindingList(Of T) which would provide some of the functionality of a BindingSource, but has strict requirements about the type {T} implementing IComparable in order to support sorting, and does not provide filtering (it is not an IBindingListView).It also only maintains a base item list by index, so does not provide keyed access.We could use simple databinding with a custom list inheriting from System.Collections. ObjectModel. Keyed Collection(Of TKey, TValue) bound to a BindingSource, but again TValue would have to implement IComparable to support sorting and we would still not have filter support.So to get all the features I was after, I decided that the best thing would be to create a new generic collection object which implemented IList, IDictionary, IBindingList, and IBindingListView (along with a few others) and would be capable of serving as a simple list, or as a binding source while providing full sorting and filtering over any newable object type.
To that end, I've created the KeyedObjectModel which contains the KeyedBindingList(Of TKey, T) generic collection/binding source. This collection can be used as a typical list, or as a binding source (you do not need an additional BindingSource component between the collection and UI controls, although you could certainly have one).Various constructors are provided in order to initialize an instance of the collection as either an enhanced list-dictionary, or as a complete BindingSource.Any object that has a public constructor which takes no arguments can be used at type {T}, providing that the object has a property of type {TKey} which will contain unique values for each entity in a given collection.If the object implements System.ComponentModel.NotifyPropertyChanged then the collection will also bubble up property changes on the current item to the collection's CurrentItemChanged event.An implementation of IComparable on type {T} is irrelevant because sorting and filtering are performed on the property values of {T} based on the type of the specified property.The current design of KeyedBindingList(Of TKey, T) is in an 'alpha' stage.The class is mostly complete from a feature implementation standpoint, however, the code has not yet been optimized and the base collections of values, keys, and view are being maintianed in generic lists of their own, rather than raw arrays.However, even without performance tuning, the collection appears to be performing quite well, up to a few thousand entries, given the amount of flexibility and funcitonality it provides.At this stage, I would really love to get some peers to try using the compiled DLL and beat up the collection a bit.Once the code has been proven and optimized, I will publish it as an example.It is a fairly complex class though (currently made up of eleven or so partial classes) so I don't really want to post the code until it has been optimized. [code]
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 RepliesI 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 want to connect an access dabase from a central server using vb.net 2005.
View 1 RepliesI am working on a project based on networking. My problem is that database on server (time to time updated by clients Application) is available in shared folder sometime any client delete that database file from shared folder then project stopped working. So give me process for accomplish this problem is there any way through which is database on server work invisibly and client unable to delete that file. I tried read only attribute on shared folder then my project unable to insert record in that database file.
View 1 RepliesI am developing a Visual Basic .NET application to be used by the staff of a small training centre nearby. The front-end (UI, menus, etc.) will all be in VB .NET, and there will be a back-end database for storing all of the required data, such as student records and meeting information. What I would like to know is if it's possible to use a Microsoft Access database for this purpose, and have it accessible by all the staff in the centre (on the same network) at the same time. For example, would I be able to put the database in a shared network folder, and have a copy of the VB application on each PC that would all be able to read/edit/add to the database?
View 2 RepliesI'm trying to connect to a database on a big corperate network (access db). I can not load my application and DB on a shared network drive as it does not have the correct permissions. How else can I try connecting to a db of some sort and allow users to insert/edit/delete rows? as it's a network drive I can not install a DB such as SQL Server on it.
View 4 RepliesI have an access 2007 database that I have been developing a front end for in vb.NET for the past 3-4 weeks using vs2008 in a Windows 7 enviroment. Yesterday I started getting an error of "Your network access was interrupted. To continue close the database and then open it again." This happens in the Form Load on the line:
gotData = Me.LeaguesTableAdapter.Fill(Me.LeaguesSeasonsPlayersDataSet.Leagues)
I can go into access 2007 and view all the data fine and in vs2008 I can view the server explorer and browse the tables. However, under data sources if I try and preview the data, I get the same error message as before. What confuses me the most is that the database is not stored on a server is just stored in My Documents. It was origionally stored on my desktop pc but has been copied to the My Documents on my laptop. But as I mentioned previously it has been working fine and has just all of a sudden started throwing this exception by my Try Catch routine. FYI I have tried creating a new DB and importing the tables from the old DB but this hasn't solved the problem either.
---3 laptops running same VB.NET application locally AND access/share same database located on one of these machines. Is this Possible? an easy way? ---OR would the best sollution create a website with database ?
View 1 RepliesI'm building an aplication with an MS Access database behind the scene. In many of my forms I'm gonna use DataGridViews to show data from the database, not an entire table but data based on manually built queries. So, I have few questions without answers, by now. Solutions or 1. I haven't decided how will I bring the database into the project: from the menu -> Add New Data Source, or within the code, at runtime. I still don't know which one's best or why.2. How exactly can I execute any SQL query (SELECT, INSERT, UPDATE, DELETE etc) on my Access database from my aplication?
View 3 Repliesi have an ACCESS database with 3 columns. I establish the connection with the VB 2008 Express and put the data in the form but i don't know how to add the text of a textbox in the database.
View 5 RepliesI installed Visual Studio 2008 and Office Enterprise 2007 in my new computer.I made some codes for a data reader to get data from an Access dabase. On the step where it will open the connection an exception appeared which says "Microsoft.Jet.Oledb.4.0 provider is not registered on the local machine".
View 7 RepliesI'm trying to query an access database, but my query results only display the first cell of the query results.
For example, if I select 3 columns, 5 rows, only Column 1 Row 1 is displayed. Someone mentioned something about EOF but I can't find EOF code for OleDB. Should I be using another type of connection?;
Code:
Private Sub btnGetReport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetReport.Click
Dim StartDate, EndDate As Date
[Code]....
I wanna create an access database programmatically.How should this be done?Do you recommend that I do it via code?I don't know how to create an access 2003 compatible file at run-tim
View 4 RepliesI'm trying to create a database driven application using VS 2008. I want my database to be generic, i.e it shouldn't rely on the existence of MS Access or similar application. So how do I create such a database, add tables , values..etc?
View 7 RepliesI need to update a database app written in VB, Visual Studio 2003, using an Access Database.Currently: Customer has 4 users, local network. Access Database is 30MB, about 50 tables.Wanted: Customer is opening new offices, and wants to connect to the database via the internet. There will be 10-15 users.App background: I have all data access via OleDbDataAdapters and one OleDbDataConnection.There are 4 DataSets: Global, Lookup, Reports, FormSpecific.
I have one Private function: FillTable:
Private Function FillTable(ByVal TableToFill As DataTable, _
Optional ByVal OleDbAdpToUse As OleDb.OleDbDataAdapter = Nothing) As Integer
' fills the table by using OleDbDataAdapter.Fill(aTable)
[code]...
All is working well.What I Need to Do:I think I need to migrate the Access Database to MS SQL. What I Have:Visual Studio 2008 Professional. I have started the MS SQL walkthroughs. I did the �Create a Data Connection to the Northwind Database� walkthrough, and connected via MS SQL Server. I cannot find where I can modify the SQL Commands. If I convert my Access Database to a MS SQL Database then can I
1) Just update the OleDbConnection, so it connects to the MS SQL Database (not the Access database).
2) If I cannot do #1, what do I need to start with?
I'm using Access 2001 and my Database is structured as follows:
Chance(Number, Detail, Action, Amount, Owner)
CommunityChest(Number, Detail, Action, Amount, Owner)
[CODE]........
I'm making a Monopoly Game which i'll make sure i post up here when done, I'm using Visual Basics 2005 and OLEDB Connection, i know how to work all that but i have the following scenarios to find SQL for.
Upgrade Property - I need to use the Update Query for this. A PropertyName is selected from a list box and someone then clicks to upgrade a property.
Properties.HousesOwned should have it's value raised by 1 Where the player owns all 3 sets. The Houseprice should then be took off the Players Money.
Downgrade Property - I need to use the Update Query for this. A PropertyName is selected from a list box and someone then clicks to downgrade a property.
Properties.HousesOwned should have it's value lowered by 1 (until it gets to 0) Where the player owns all 3 sets. The Houseprice should then be added to the Players Money.
I'm trying to update an MS Access database, but that doesn't seem to work. I do NOT get an error, but nothing changes in the database.
Code:
Dim myCommand As OleDbCommand = Nothing
Dim strUpdate As String
strUpdate = "Update Settings Set Data = @Data Where Name = @Name"
[Code].....
I'm new to Visual Basic. I came across a random number generator tutorial. Got it working fine and then I thought, Is there a way to get it to access a database Here's the thing
1. Generate the random number.
2. looks at the database and finds the corresponding id number.
3. Takes the field for that number and enters it into a text field in the program.
So for example the number generated is 32. Then the program looks at the database and looks for id number 32. then takes the text in line 32 and enters it into a textbox in the program.Now I have my database and the program. But just can't seam to figure out how to get the two connected like I want. I have looked and searched but have found nothing like it I am using Visual Basic 2010 and Access 2007.
I'm working on a VB.Net Windows form that is supposed to manipulate an Access Database. I can Already read data from the database (placing them in a combobox) using the following:
Code:
Private Sub Form2a_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
OpenFileDialog1.FileName = ""
OpenFileDialog1.Title = "C# Corner Open File Dialog"
[code]....
I have two tables in the MS Access 2003 database " SAMPLE" and they are : 1. INFO 2 INFO2Now i have created a form in VB 2008 express edition with the text boxes: Name, Age, Occupation.he tables INFO has - Name, Age as columnsAnd INFO 2 has - Name, Age, Occupation.All i want is when the user presses the ok button, it should add the name & age to INFO and also add Name, Age Occupation to the INFO 2 Table.
View 10 RepliesHow can I get information what data type a certain column is. (Integer, string, memo,...)
View 1 RepliesI've been googling to find a guide on how to access a database with visual studio.I cant find anything complete or up to date. I should point out that I dont have a great deal of experience with SQL.I'm not really 100% sure where to start. Most of the guides I've found tend to assume your accessing an existing SQL database and I need to set one up from scratch. I'm not sure if I'm even setting SQL server up correctly. point me in the right direction on where to get started. A good, up to date tutorial would be great.
For my purposes the SQL database will only be written to from the local machine but there will also be another machine writing to this database.I'm currently using Visual basic Express 2010 and SQL Server Express 2008 R2, mostly because they are the most recent when I googled it.
I have developed a Windows Forms application using VB.NET and MS SQL Server 2005 Express Edition. My database name is 'AC'. I do not want ANY user, SQL Server or Windows authenticated, to access, read, write to, update, drop or take backups of this database, except this login 'Adel'. So my connection string looks very similar to:[code]What configurations should I make in the MS SQL Server Management Studio 2005 Express Edition to 'Adel' login, 'AC' database, and all other logins to accomplish this?Given the following:I do not own the server; my client owns the server. They have a domain set up (LAN network).They have ASP.NET applications running using other databases on the same server. However, these applications have nothing to do with my database 'AC' or login 'Adel'.Some of their applications do not specify 'User Id' in the connection string; they use 'Integrated Security=True'.
View 2 Replies