I am trying to create a Member database and I am pretty new at vb. I need to be able to set a database query and return only the members that expire in a certain month to a data grid. I would also like the year for the query to be set to the current year so the query doesnt return expirations for the following years. Im not really sure how to even start.
View 5 RepliesI 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 want to create a table (called "Customers") in a Microsoft Access database and then insert/delete records into the table and update the table. The table shall have 3 columns:
ID
Customer Name
Customer Address
I know i need to make the "ID" column as an autonumber and a primary key, as i need to insert and delete records and update the table. I am using the Visual basic 2008 Express edition and quite familar with the OledBcommand.
how do I overcome it? I have created a class and compiled into .dll This code
[Code]...
In Visual Studio 2008, if I do this:
[Code]....
Does anyone here know how to get the above to work WITHOUT warnings being generated?
In the following code i get a warning at line 59:Warning 1: Access of shared member, constant member, enum member or nested type through an instance; qualifying expression will not be evaluated.and.. At line 78 I get this Warning:
Warning 2 Property 'SelectedCustomer' doesn't return a value on all code paths. A null reference exception could occur at run time when the result is used.
The program compiles and runs well, but i cant' undesrtand the reason for these warnings. Any Idea ?
1: Public Class Form1
2:
3: 'Form level members
4: Private objCustomers As New ArrayList
[code]....
Cannot appear to be able to get this function to not have the above error.Private Function GetIncidentActions(ByVal FromAgentID As Integer, ByVal ToAgentID As Integer, ByVal incidentAction As Integer, ByVal ActionDate As Date) As String
[Code]...
I am trying to use httpwebrequest but I keep getting a message that says "Create is not a member of webrequest" every time I try and use the msn example code.
vb
Dim myReq As HttpWebRequest = WebRequest.Create("http://www.contoso.com/")
I am attempting to create an application that a staff member inputs some data, and it is exported with an option to print.The problem being I have some strict standards that I need to stick to One being page layout, certain graphics are required on the page.
View 5 RepliesI am creating a VB.NET application that uses multiple lines of a text files as an array member. I came up with this code to create the array:
Dim PSArray as string = Split(my.computer.Filesystem.readalltext ("E:PS.txt") )
Now that I have created the array, I need to know how I could make each line of the text file an array member.
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 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 would like to read a ValueMember of all checked items in my CheckedListBox. i have sub as below to add im my checkedListBox.[code]Then how to loop each of the checked items in the checkedlistbox so that i can store it to the database.below is the code for storing in database using sp.[code]
View 1 RepliesRecently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
View 1 RepliesI'm "cloning" objects in my code. For instance: objClone = objOriginal My question is: Does the assignment operator in VB.NET 1.1 do a member-by-member copy of the objOriginal to objClone or does objClone simply point as a reference to memory referenced by objOriginal?
View 3 Repliesi changed a class variable to shared so i can access it in all instances of the class, but it caused an error. what is causing this, and how can i fix it?
Private
Shared img As Bitmap
Me
.img = bgImage
I have 2 tables Table A & Table B Table A has the table values that I want to be populated in a datagridview control.The challenge is that column 1 in table A contains an ID(foreign key) to a name field that is a located in table B. I need the datagrid to have the first column be a combobox that displays the names(from Table B) that are already in table A via the ID's, but reference the populating values from Table B. So that when you bring down the combobox you would be choosing from Table B data but populating table A with the ID and you would see a name there instead of an ID.[code] How do I populate my DS dataset with Table B? And how can I create a link to these two tables using a bound datagridview control?
View 1 RepliesI get this error if I follow these steps: Change property Y of an object (an associated entity property)
Attempt to submit changes At this point the value of Y and the value of X (the underlying key) are not in agreement -- LINQ to SQL apparently doesn't synchronize these until GetChangeSet is called.An expected error occurs due to some business logic or database level constraint during the update operation.At this point the value of Y is in agreement with X because GetChangeSet was called.Change the value of Y to Nothing (aka null).Call GetChangeSet.
The error occurs on the last step because the value of X and the original value of X (returned by GetOriginalEntityState) are different, and the new value does not agree with Y? Is that why? Is this a bug in LINQ to SQL. Must be because I don't see the same behavior if I change Y to another (non-null) value instead during step 5. What's the right way around this? I can see a few ways:
Discard the DataContext when an error occurs and leave the UI as-is. I don't like this because then optimistic cocurrency change conflicts cannot be detected. The new context doesn't have the original values in it that were populated at the same time the UI was populated, so if the UI has any stale values in it, they will cause data in the database to revert.Refresh the datacontext (OverwriteCurrent) and leave the UI as-is. I don't like this for the same reason as #1.Refresh the datacontext (OverwriteCurrent) and re-populate the UI. I don't like this because then the error message just presented to the user does not show the user the error they made and allow them to correct it. It also discards all the other changes the user may have made.When the error occurs, explicitly retrieve the key for Y that corresponds to the original value of X and reset Y, then call GetChangeSet to re-synchronize X (X is read-only or private so I can't reset it directly). This seems to work, but seems like a hack, and may require lots of code for other similar errors.
I know I have done this before and as I remember it should be really easy. But for some strange reason I can't do it now and I am about to jump off the building.I will make it simple:Two tables, one is just a list of products and their code.The other table: "details" has a field named product. I want to store only the code there.In the second table's entry form, I am putting a combobox. This combo box should display the list of products, their names, but depending on which one is selected, the code is what is passed to the table "details". Currently If I set the display member to product and the value member to code it still pases the product to the binded data source.
View 3 RepliesI have a database that holds information about a particular job. One of those things is a customerID. CustomerID links to another table containing customer details. I have a combo box attached to a custom object that holds customerID as the valuemember and CustomerName as the displaymember.The JobDetails holds the customerID info. How do I set the default selection in the combobox based on the ValueMember of the combo box?
View 2 RepliesI have developed a windows database application in vb.net 2008 express and sql express 2008. Is there a way to create reports in the application?
View 7 RepliesI have a dataset; I want to create an equivalent record set. What I really want to do is create the XML that a record set can load; I have no other use for the record set per se. I want to be able to load recordsets on other machines (which use VB6 ins of vb.net) with this data. I found some code that loops through the columns in the dataset and creates the fields in the record set; that's executing. However, the code given to open the record set fails with "incompatible or incorrect parameters" or some such. [Code] I can see that a recordset is a construct meant to bridge between running code and a data store of some sort, but in this case the data is "stored" in the dataset, not anywhere else. I want to put that data in the XML form that the recordset uses, so that other code that can only use recordsets (ins of datasets) will be able to read it.
View 2 RepliesI am basically trying to create some records using Structures as you can see below, however the value of Index doesnt seem to be incrementing as I am assigning it to txtCustomerId.text each time form loads, however the value of the text box remains at 1000 all the time
Code:
Public Class Form1
Dim NumberOfCustomers As Integer
Dim Index As Integer
[Code].....
I am using the following code to set a parameter in my report.
Code:
However, if I create the parameter at design time, it seems like I should be able to do something much simpler like
Code:
Since the parameter is already created. However, I can't get anything like that to work.
Probably a very dumb question but I have a program whereby I create and populate an in memory datatable, which I then add to a data-set. I then run a couple of updates on the dataset and need to know how to then send these updates down into the in memory datatable :Here is a mock up of the code structure following the creation and population of the table :
[Code]...
What I want to do is be able to active a query for my datagrid by clicking on a button. How would I do that? Would I create the query as part of my tableadapter???
View 4 RepliesA suite of apps will be using various tables out of the same sql server database.Regardless of which app is being used, the database structure must stay current. (ie:contain all the tables/fields to run any/all of the apps)So, when the user starts any of the apps, it needs to check the database, for the existence of all the tables and fields it needs, then update if necessary.
View 1 RepliesHow can I add a user to a table in a mysql database without datagridview? I already have this:
Code:
Dim conn As MySqlConnection
'connect to DB
conn = New MySqlConnection()
conn.ConnectionString = "server=localhost; user id=root; password=test; database=test_addtable"
[Code] .....
im trying to create this program for tarantula keepers record.im still halfway to its completion.I have MySQL installed on my pc and i used navicat to easily create my database and tables.I exported it as MSAccess file to my Projects folder.I used datagridview to display my data. it works fine on that part but when i close my program and reopen it, my data are not saved and no change has been made to my database.Here's some part of my code:
Dim dbdataadapter As New OleDb.OleDbDataAdapter
Dim sql As String
Dim dbprovider As String
Dim dbsource As String
[code]....
I'm using Visual Basic 2005 and I have created a program to display, edit, and create insurance records. Right now I am using an access database and it is hosted locally. What I want to be able to do is host it on our server here at our office and have the program installed on every computer on the network.
My connection string at the moment looks like this:
Code:
Public con As New OleDb.OleDbConnection
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = C:Insurance ProgramInsurances.mdb"
'Opens connection
con.Open()