I am inserting a record to a text file database using OleDb command Builder I am getting an error in one the fields could not insert .... expect type is decimal The problem is the column contains a mixture of Letter and numbers Ex:
[Code]...
I am looking at trying to make a chart from my data I am retriving form a 3rd part textfile datafile
I am reading on report viewer, but so far everything i see references using an exisitng database, my database will be created at run time
I create datatables uisng OleDb connection and bindingsources to comboboxes and textboxes for display of data
I just need a simple x/y scattered chart/graph
I need to add a row of data to an exisitng TextFile that is in Tba delimited format. My program currently used ADO to read and update the table but that was creating to many problems with varying 3rd party providers of the Text File.
View 14 Repliesunderstand why the first line in this code allows an empty valuebut the second line doesnt?
HTML
dsNewRow.Item("AddressDisplay") = subjectaddtxt.Text
dsNewRow.Item("MLSNUM") = Me.subj_mls_txt.Text
[code].....
How can i get one record in my MYSQL database what command should i use like this one in visual basic. How should i do these in vb.net?. I want to total the amount of items stored in my MYSQL database and show it in my listview. . . .I just want to get one record and get their values is their a command that i can do that?. . . .
this my code in vb using MS ACCESS
While rst.EOF = False
If txtpcode = rst!pcode Then
rst!stocks = Val(rst!stocks) - Val(txtqty)
[Code]....
I hav a web service which pull records from a database and I am hosting these services in IIS which works fine but I am trying to retrieve the record and display the record in a listbox displaying the time field as the text for that record.I have created the following function
public sub get_data()
dim dt as new data.dataTable
dim service as ws webservice.webservice
[code]...
I am creating database application which selects all excel files from a specified folder, which doesn't seem to be the problem.
i am trying to put the name of the file which is selected into a database.
* would i have to manually create a database using the database explorer? or is there code i can use to create this?
I am trying to check a record in database before inerting a new record here is my code but problem is when i enter a names first alphabet it imediatly populate massage. i want to check it after entering whole name
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
Try
Dim cnString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
[CODE]...
I have sucessfully written in excel VBA. The idea is to used the textbox1_change event to find a match in column A of table and once it finds the record, return the value of column B as label1.text. [code] In VB 2008 it's a lot different. I have set up the form the same way with the textbox and labels. I have made a dataset with (1) table (Table1) with (2) columns. Lets call them column A and Column B.I have added the dataset as a binding source to the form and also a table adapter. I also have a standardized query made for the dataset with a very simple SQL statement "SELECT Column A, Column B from Table1"..In order to get the user input to start searching Column A I assume under the textbox_change event i would put something like: [code] I'm getting a bunch of errors of course. Would somepne be able to give me some direction?
View 3 RepliesI have created a project that has an add a new record, edit record and a search form, that has multiple text, combo boxes and is working great.Last nite I have added a checkbox under my add new record form and i am saving the checkbox value to my database, so far so good. I would like to be able to search any record that is mark with a checkbox to show up in my search screen when I do a search: [code] The problem that i am having is that now that I have added the code to my project to search for the checkbox field in the search screen and if I leave everything blank and click on the the search button I get no record found. I expected to see all that data, since I have nothing selected. Now if I click my checkbox, as soon as I click on my search button I see that two records that I have added for my test.
View 1 RepliesI have a problem with my program, and it's really bad because I need to burn it to disk within 12 hours and I can't get it to work: If I create a record, add information to it and click on Next Record, the ID, Status and Notes boxes content will change but the rest of the controls contents are carried over to the next record and I don't know why or how. It was working perfectly but now it stopped and I never done anything.
View 8 RepliesI have records in a database. Each record has a Picture path in it eg. "C:\Pics\Image1.jpg". I would like to display a record from my database and also the picture for that record, in a .rdlc report in vb .net 2008. i have succeded in displaying the record but just can't get the picture to show. I am using an Imagebox in the report.
View 2 Repliesso im trying to do this project, and it gives me a a data file, and asks me to use stream reader to put it in the combobox, and when i click the selected items from the combo box, it fills in the textbox's with other information i retrieved from the datafile...Does anybody know the solution?? heres what i have so far(option strict must be on) Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
this gets all the Item names from the data file to appear on the combobox... now if i knew how to get the other information to appear in the textbox's when i clicked on it,
I have a access database with these columns. USER_ID,COUNT,TIMES
Let say the current record is this:
USER_ID,COUNT,TIMES
STEVE20,24,1.5
Now I want to updated the current count record and times, but before updating I want the old record to be added to the new record. What should be my query?
Im wondering how would i work with a text file. which would allow me to Read the next Record, Cut record out of the program.
View 15 RepliesI have a problem that I�m sure will not be hard to fix for anyone who has been using CR for some time.
To start I have created a program in VB2008 that uses a MS Access data file, I can connect to it with no problem and can also add data and amend data, so all seems to work perfectly. I have published it and it once again runs perfectly on another/s machines.I have now a requirement for a number of reports so have chosen CR for this purpose. I have connected the report to the database and that runs with no problems at all, that is until I try to run it on another machine, it seems not to be able to find the database and comes up with a database Login panel wanting me to log in with a password and Admin name.
I feel it's properly a problem with the path to the database but if I modify the path manually it still won't work.
how to view the next record and previous record in the database.? just like in the picture below.? what condition should we use.?
View 8 RepliesI've made a program that calculates the costs of a transport, wich to my own surprice works. Because the prices vary with the weight of the transport, extra services and delivery within the 3 countries of the Benelux (Belgium, The Netherlands and Luxemburg), I use an array. The array is filled with data from a textfile (in this case not *.txt but *.prc). The data in the datafile is presented as follows :
[Code]...
I was able to successfully connect my database using connection string, i am having a hard time finding tutorials on how to add the items in a textbox. [code]...
View 1 RepliesI am using a VB.net application connected with a .mdf database file.The application is running successfully, and when I try to insert records its accepted.Everytime I close and reopen the application, new records from previous run disappear. This happens inside the VS IDE when I'm testing it.
View 2 RepliesI am having a problem with my program that is desinged to read a 3rd party text file database. I posted previosuly about a problem inserting an item in a new row and the column was expectig a different data type. It appears that sometimes the column is being determined to be of decimal value, I dont understand why. the fields contain information such as
Col1
F123456
CLW-12321 etc....
So my column fills with
123456
12321 the letters just get chopped off
So I added MaxScanRows = 0 to my schema file and that took care of the problem
Except now several of my columns that contain Date Values are coming back
9/24/2010 00:00:00
without the setting MaxScanRows = 0
The date returned 9/24/2010
Here is the code for my schema ini file I am creating:
HTML
Dim fs As New FileStream("Schema.ini", FileMode.Create, FileAccess.Write)
Dim writer As New StreamWriter(fs)
[CODE]............
I have been trying different settings hence the dimmed out lines
Here is the code to fill the datatable:
HTML
[CODE].............
I am thinking that without the MaxScanRows = 0 setting the datatype for Col1 is being incorrectly determined
I am not sure what is happening with other columns that contain date values. Apparently If i use MaxScan Rows=0 all columns are being pulled over as string value which creates numerous problems. If I dont use maxscanrows then all columns appear to be correct except Col21 MLSNUM which is being pulled in as a decimal. Can I change that in the schema file?
i'm using visual studio 2005 vb.net language windows appliction. i have a datagridview and i want when i select a record and press the button delete to delete the row from datagridview and from microsoft access database and i started with this code and i couldn't find the solution:
Dim dbconnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "data source=C:UsersHaidarDesktopcustomer listNew FarahnetFarahnetCustomers.mdb"
Dim dbcommand As String = "Delete From customers where ?????????
[Code]....
I have this problem : Dynamic SQL generation for the DeleteCommand is not supported against a SelectCommand that does not return any key column information.... the button used to delete record in my project is button6 at the end of the code
My code :
Public Class Form1
Dim con As New OleDb.OleDbConnection
[CODE]....................
How would I print the current record, ie the one that shows on the active form. App is VS 2005. DB is Sql 2005.
View 4 RepliesI am importing alot of data from a text file into an access database with the code below. (From a Comma delimited text file) The problem is that I do not want to import duplicate records. I have the "IDNr" column in my access database set to "not allow duplicates" and need my code to check if there is already a record in the database before trying to import the data. Otherwise it will just give me an error or not import the rest of the data. I could do to make sure that there are no duplicates for the IDNr column?
[Code]...
Why does the item I insert have "'s on it? In other words
If my textbox contains Apple Street
the record is inserted as "Apple Street"
HTML
[code]....
Is this the right way to delete a record in a mysql im using a listview do i have to code the listview? I dont have any errors with this but it just wont delete the record in my database and in my listview.Is this the right way to use listview? when deleting a certain record.Not familiar using the mysql commands it makes me confuse and difficult to the properties of each of mysql commands they dont provide enough example using those properties in mysql and it is not well explained for me each of their properties im new with this stuff. [code]
View 8 RepliesI am currently working with VB.net 2005. I am trying to create a login form and use a text file as a database to login. The part login form is fine but i can't connected to the text file. When i use my coding with a database such as access or mysql is work fine.
[Code]...
I currently have the below code to list all tables in a MS Access Database, what I would like to do is alos COUNT the TOTAL records within each table and display that info in a listview control.
how to get that info.
This is the code I am currently using to get the list of tables from the database:
Dim userTables As DataTable = Nothing
Dim i As Integer
Dim restrictions() As String = New String(3) {}
[Code]....
I have the following
Private ReportAdapter As OleDbDataAdapter 'used for controlling database
Private ReportTable As DataTable
Private ReportManager As CurrencyManager
[code].....
