Is there a simple sample for read and write to MSaccess from vb2010?I like to display one field of the database in a text box and write to a field in a table whatever I type in the textbox.
View 11 RepliesI need to write, read and delete data from a MSAccess database file (.accdb)
Is there a SIMPLE sample to get me started?
I read a few relevant post about the procedure to create the Read function, but in my case, i would want to read the database with selected item only. Belows are the information of my form.
I have 2 DGVs and 2 buttons is my form.My 1st DGV is filled by 3 fields from my Excel Sheet: No, ProductID, and Quantity.there are 5 fields in my MsAccess Database: ProductID, Selling Price, Product Name, Selling Cost, and Supplier.My first Button is clicked to fill the 1st DGV with 3 fields.
Now my question is:
How can i compared and displayed the Selling Price and Product Name fields of the ProductID in the 2nd DGV? i.e: if only 2 ProductID is loaded, then only display the selling price and product name of that 2 ProductId only.
I'm trying to use XML more often in my apps, but somhow I just can't get it. Examples on the "net" are somehow unclear to me.
[Code]....
I have an excel database with one column and thousands of rows of "number" data. I need to import the data into my form read the first entry, run an algorithm then move the result to the second column then move to the second entry and so on. I am having issues with where to begin. I am able to convert the excel database to a text file if it makes it easier.The algorithm that needs to be ran consists of reading each character one at a time and is as follows:ENTRY example: 12358458754The characters 1,3,8,5,7,4 need to be summed then multiplied by 3. These are all the characters starting with the first one and skipping every other one. I will call them "odds" (not referring to numeric value)The characters that are skipped, I will call them "evens", need to be summed together then added to the result of "odds".
View 20 RepliesThe code below allows me to write a single line to a textfile. Id like to be able to open an entire textfile into a textbox, be able to edit said text and have it automatically write back to the same textfile.
Private myCoolFile As String = "C:UserskevinMy Documentspasswords.txt" '// your file.
Private myCoolFileLines() As String = Nothing '// String Array to read File Lines into.
Private sTemp As String = Nothing '// temp String to be used as needed.
[code]....
need to know exactly how does the API functions Read/Whrite Process works. I'm so confused while working. I know that I have to work using something like sectors. But I don't know how. Can someone give me an example. I dont know hoe to do it. for an example, for you to give me. Create a basic programa with a button and a textbox the button searchs what is in the textbox in a process memory. Search the title of a program for example.
View 2 RepliesI've been scrambling my brain to figure out how to access my FTP server thing to get a list of text files in a folder and to edit the contents of those files online.
View 1 RepliesI've been scouring Google looking for a solution to my problem, but I can't seem to find anything so thought you guys might know a way of solving my problem.Im writing a little program which needs to change a few different memory address variables of a specific process.Does anyone know how first of all I can detect if the specific process is running on the user's machine, and then how I would read the value of the memory addresses, and write to them also.
View 3 RepliesI am trying to make a VB application that can read and write at excel or at SQlite db.With the excel my application works fine, but when i tried to share my application 1 of my friends can open it and all the others no.So i want to try with the SQlite but i dont know what i need for to support the sqlite at my VB project.I am using VB 2010 but i can also i can use C#?
View 8 RepliesI'm gettiing this error from my app: "Attempted to read or write protected memory. This is often an indication that other memory is corrupt." But it carries on for about 5 minutes then stops. The application log shows this:
[Code]...
I have recently decided to give .net another chance, but i have a few questions about it before i get really into it. RE: Files, I use random access files to store data as opposed to databases (namely i don't see the need for a database for storing so little information(records <200 max) knowing that it is an older system and less "cool" i don't care...) Will vs2010 express read, write to random access files? Would it be done kind of like vb6 (which is my current vb version)? I will be needing to print the text of rich text boxes, is vs2010 express capable of doing this?
View 7 Repliesstill working on my game, but a college classmate said that I need to use databases instead of text files...so I'm wanting to know, what databases does visual studios 2010 provide for you to use...what code line should I use to create/write to/read from a databasew, and how do/should I create a database table/refer to it??
I would love to provide code, but I'm both using my cell, and don't have access to my computer right now due to it not being accessale due to not having the ability to have it hooked up right now...got new floors and don't have it plugged in yet/set up again...
I'm converting older VBA code to VB. I'm using Visual Studio or VB 2010 but am new to this "oop" approach and not a seasoned programmer. Scenario:
1. Open new Excel worksheet (see below - will this work?)
[Code].....
I want to compress an ms access database using vb.net. If the database is open this fails. How can I close the database, compress it, then reopen the database using vb.net code to accomplish this. I've already successfully written the code for compression, but I can't find anything on closing the database while leaving ms access open.
View 2 RepliesI'm using OLEDB to connect to an MSAccess database and would like to know which is the correct syntax to get a value from the database and store it into a variable. I'm using the following syntax but it is not working: getStock = "SELECT Stock INTO " & stkActual & " FROM PECAS WHERE PECA_ID = " & Val(Me.PECA_IDTextBox.Text)
View 4 RepliesI have a problem and hope someone have idea to rsolve it. I have a file and inside the file the format is like that :
123.567 456.789 12.345 223 223 221 223
123.555 456.788 12.344 223 223 221 222
123.456 345.678 456.234 445 445 445 445
total line is 3456789903. I want use vb console application to read the line and every 130000 line create a new output file.
I have a folder called movies. In this folder is a collection of different movies each in their own folder with their own xml file called movie.xml.I would like to extract lets say the localtitle and aspectratio from each movie xml and send to Excel. What code would I need to achieve this?So far I have the attached code which reads only one file and it is directly from the xml outside of a folder.
View 36 RepliesIs there anybody out here in the VB, C# 2008 world that can direct me in the right direction? I do not want anything that has todo with c/C++or Direct Draw. When converting, there is no equal for SizeOf, and a few other things. I am using Lame 3.98.2.exe in my app along with LameShell that works fine for resampling, but , not for decoding an mp3 to wav or encoding a wav to mp3. You can find the LameShell project at [URL] . LameShell is a wrapper for the Lame.exe file. Here is the complete LameShell class file along with my app button clicks for the following,
[Code]...
I am trying to extend an application to to write the details from textboxes on a invoice form to an xml file.I have created 3 methods for my invoice class which will open the invoice xml document, write to it, and close it.The open Invoice method creates and invoice.xml file and writes a start tag named invoices.
The WriteInvoice method writes an invoice element for the invoice with attribute named customerName and three child elements named ordertotal, discounTotal and Invoice total. These values are taken from the textboxes form the form.
The CloseInvoice writes the end tag for the root element(invoices) and closes the file.
I have wriiten code for these methods but can only get the open invoice method to work.
My code for the 3 methods is shown below:
Public Sub OpenInvoices()
Dim sInvPath As String = "C:MurachBeginning VB.NETExercise startsVB.NETChapter 14InvoiceInvoices.xml"
Dim InvoiceWriter As New XmlTextWriter(sInvPath, Nothing)
InvoiceWriter.Formatting = Formatting.Indented 'Set formatting of XML file
[Code]...
I have several programs that must write to HKLM in XP and Windows 7/64 Pro.
The programs work in VB6 but not in VB.Net 2008 on target machines. It does works on our development machine.
Same exact windows. [code]...
How to communicate with a USB port using VB.NET?
View 1 Repliesi'm using sharpdevelop to program WPF application(I'm newbie to WPF i've knowledge of VB only and no C#, is it necessary to learn C# to know WPF ?).
and i want to read CSV file first. after that i want to modify and save file. any suggestions and pointers for this ?
How do I read, write and delete a registry using VB 2005/2008?
View 1 Repliesrecommend some tutorials that show very simple examples on how one can read / rwite to an SQL db?
View 3 Repliesi'm trying to read from a file and copy the text into a 2d array withought the selected item from a list box then rewrite the file from the array into the text file. however it writes a single part of the array times the variable count when i write back to the csv file. within the array everything is correct its only when i rewrite to the file is when the problems occur.
[Code]....
I have the following code for reading XML files.[code]...
View 8 Repliesreading and writing files. Let's say I have a text file with multiple lines that I want to be read into my visual basic program. The first line is displayed in textboxA while the rest of the lines are displayed in textboxB. How do I accomplish this? Am I able to use the peek method for textboxB but somehow tell it to skip the first line? Now textboxB is obviously a multiline textbox and I want the user to be able to type something into another textbox (textboxC), press a button, and it will be displayed in textboxA. How do I make the text in textboxC get displayed on the first line of textboxA and move all the other lines down the list?
View 2 RepliesImports System.ComponentModel
Imports System.Drawing
Imports System.Windows.Forms
Imports System.IO
[code]....
I want read the content of the text file and write to vb.net application. My text file name is wires.txt. The above code only read and the file appear on the application. I dont want the file to be visible to the end user.
i am using VB2008 to develop a Settings program for my game Lined World, creating with Game Maker. I've created a settings.ini:
[screen]
fullscreen=(off or on)
resolution=(800x600 or 1024x768)
[code]....
answers are depending on settings
now, i wanna create in the settings app the following:
"fullscreen" (radiobutton-on & radiobutton-off)
[code]....
if radiobutton fullscreen is on, [screen]fullscreen must be on, and if turned to off, the INI value should be "off".