I have a datagrid which I have manually added columns to and adding rows at runtime (code I am using below if that helps in anyway). When that row is sellected I wish to get the data from different columns.
I'm adding to the grid:
Dim dgvRow As New DataGridViewRow
Dim dgvCell As DataGridViewCell
dgvCell = New DataGridViewTextBoxCell()
[Code]......
How do you read the data from a file on the computer? I have an mp3 stored on my root folder and I want the form to read the raw data from it so I can do some encryption etc.
Dim fileOpen As New IO.StreamReader("C:file.mp3")
Dim stream As String = fileOpen.ReadToEnd
TextBox1.Text = stream
how to read data from a USB Port. I have a games joystick connected to a USB port on my computer and the joystick has 10 buttons which each when pressed sends some binary code into the computer via the USB port. I need to capture these button clicks and perform a different event for each button click.
View 8 RepliesI've been using the process shown here: [url]
For including images in my database, what i would like to do during the import process is capture some of the meta data to store against fields in my database as well.
In this case we will be using iPhone 4s which i believe capture data in EXIF format.
I did a bit of looking around on my own and apart from: [url]
Private Sub receive_data(ByVal sender As System.Object, ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) Handles SerialPort1.DataReceived
Dim aBuffer(255) As Byte
Do While SerialPort1.BytesToRead > 0
[code]....
Basically, what I am trying to do is everytime I receive data from the serial port, I turn that data into an array (aBuffer) and I then call another sub using that info.The problem I'm having is that everytime I receive data, the array only fills up to the first 8 bytes! This isn't a problem when I receive smaller packets of 6 bytes but anything else gets chopped off.
What is really frustrating is that it seems quite fickle. I've read somewhere that this happens because the computer is handling the bytes received faster than they are being put in the buffer?? Not really sure but if I put a couple of breakpoints during debug, sometimes the array fills up correctly... Note the maximum size of any one incoming message would be 255 bytes.
Here's what i've got so far, i've written all of the data that i'm going to put into my config file, however i'm having trouble reading the specific string values that I need from that ini file. The parts of the ini lines I want to get are the values in between the I've tried using streamreader a couple things but i'm having trouble figuring that out. I need to parse each line of the ini file to get that value in between the single quotations, so that I can set the value for my richtextbox background and text color as well as a few other things that i've set up in my notepad including tab spacing and so on. lots of these different values need to be converted from a string value to integers, and boolean values as well. (4 of them, the rest of them don't have to be changed because they are already string values when my application reads them to determine it's application load settings.
EDIT: I just noticed in the preview that this is from the version of the app where I had streamwriter write "______ value=" & Something to a file. lol some of the (')s are still in this version, so please excuse that little part. I had them in, but took them out so that I could trim data to get a value easier, but I want to use (')s hopefully when all is said and done.For example, just to restate what I want - in the ini file it will read [setting name] value='VALUE'I want to be able to "get" the string value of "VALUE" within the ini file between the 2 single quotations '
This is an amateur radio project. I have a TNC (modem) that receives a digital stream (AX.25) from my radio. The TNC decodes the AX.25 frames and translates them to KISS frames (the protocol used between the TNC and the PC, see documentation here: [URL] It sends the data as HEX values.
What I'm looking for on the serial stream is the beginning of a data frame marked by 0xC0 0x00 and ending with 0xC0. Should be easy. Using serialport.readbyte() I should get binary data that I can convert to hex and look for the beginning of a data frame and then convert the subsequent data to ascii, as it will be text from a chat session.
Just to try it out and see the raw data coming from the port, I use teraterm or realterm and capture the data and it's a mix of junk (control frames and what not) and valid text. When I display the same data in a text box in VB I get data that look like this:
[Code].....
I like to make a data grid that get data from a .csv and display on the table (note all the data is separated by ",") but I have no idea how to do this.
GRW,1001,LGAV,LGTS,"NEVRA Z507 OSMOS",SX-GRI,240,161,00:00," 00:00"," 1.05"," Flight Level:240"," 80"," P"," 0123456"," 1"
GRW,1002,LGTS,LGAV,"LEKPO UB1 ABLON",SX-GRI,250,161,00:00," 00:00"," 1.05"," Flight Level:250"," 80"," P"," 0123456"," 1"
GRW,1003,LGAV,LGRP,"VARIX UL995 ASIMI",SX-GRI,270,218,00:00," 00:00"," 1.2"," Flight Level:270"," 100"," P"," 0123456"," 1"
GRW,1004,LGRP,LGAV,"ASIMI UL995 VARIX",SX-GRI,280,218,00:00," 00:00"," 1.2"," Flight Level:280"," 100"," P"," 0123456"," 1"
GRW,1005,LGAV,LGKR,"PIKAD L53 KRK",SX-GRE,240,213,00:00," 00:00"," 1.15"," Flight Level:240"," 80"," P"," 0123456"," 1"
want to know how can i click the data in my datagrid view and then pass the data to the textbox.. also i want to make my datagrid view not editablemy auto increment field has a 7 data (for example 1-7)now when i delete the no ata the actual data is delete
View 6 RepliesI have a datagrid where i am entering numeric values. at design time, i have set the format for each column to C2. So at run time, When i am entering the values, it is being set in the current format. When i am displaying data from sql, instead of showing 400.00, it is showing only 400.
View 15 RepliesI have some trouble with opening a excel sheet and getting some data out of it.
I want my program to have a button, when pressed, gives a "select excel file" popup and then load the data from some cells into my sql database.
So, when opening a excel file the program should get the data from cell D3 to D8 and put that into the sql database.
I now have the following, but that will only open the excel file.
Public Class Form1
Dim oConn As ADODB.Connection
Private Sub ConnectDB()
[Code]....
I finally got this code to work:
vb
Dim path As String = OpenFileDialog1.FileName
Dim myDataset As New DataSet()
Dim strConn = New OleDbConnection("Provider=Microsoft.ACE.Oledb.12.0;Data Source=" & path & ";Extended Properties=""Excel 12.0;HDR=YES;IMEX=1""")
Dim myData As New OleDb.OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn)
myData.Fill(myDataset)
DataGridView1.DataSource = myDataset.Tables(0).DefaultView
Now that I figured that out I was going to try and place the data in a specific location. On my application I have a datagridview set up with 4 columns. What I would like to do is put column A of the excel file under the 1st column of the datagridview and column C of the Excel File in the second column of the datagridview.
So replace:
vb
DataGridView1.DataSource = myDataset.Tables(0).DefaultView
With:
vb
DataGridView1.columns(0) = myDataset.Tables(0).columns(0)
DataGridView1.columns(1) = myDataset.Tables(0).columns(2)
Obviously this doesnt work, and something tells me I might need a for loop to import the data, but I have never imported information from an Excel file before and to make it worse I have never worked with datagridviews before so I have no idea how to go about this.
I would like to do something like this if I could:
vb
For x = 1 To xldoc.rows.length - 1
DataGridView1.Item(0, x).Value = CType(xlDoc.Cells(0, x + 1), Excel.Range).Text
Next
I have a SQL stored procedure that I bind to a Silverlight Datagrid. That works ok, the problem is when I use the same stored procedure to bind a different dataset to the same grid, it doesn't display the new data, only empty columns from the last dataset that was bound. What is going on here? I tried to set the grid = Nothing and I tried using Datagrid1.columns.clear() but that didn't work.
View 3 RepliesIn my application I read data (using data binding) from an Excel spreadsheet into a DataGridView. This works, but the data columns contain text fields (strings). I would like to set the data type for some columns to "Date" and Decimal. I cant do this on the DataGridView (error: cant change properties for data-bound stuff) and I cant figure out how to do it on the dataset or data-table that I bind to the DataGridView.The following is the code I use to read and bind the data:
Using con As OleDbConnection = New OleDbConnection(cs)
'
'open the OleDbConnection
[code]....
The commented out code (below the 'Todo: comment) causes a additional table, but I want to change the table with the data.
I have conquered the problem of the database however what i need is the serial port data sent to a database and outputted on screen however i keep getting cross thread errors ..
Imports System.Data.OleDb
Imports System
Imports System.ComponentModel
Imports System.Threading
[code]....
I'm new to visual basic 2010 ultimate. I want to make a search button to "search" ms access 2007 database for specific data and display the results in datagridview. I also want to display the data to textboxes.
View 1 RepliesI have an XML file with the following Structure:
<?xml version="1.0" encoding="ISO-8859-1"?>
<Library>
<DVD>
[CODE]................
When I try to load the XML in a Datagrid,I am able to load the data under the "description" element properly, however when it comes to loading the data under the "production" element, only data for the last movie is loaded and is repeated for all 3 movies.
Below is the code i am using:
'-------Initiate the OpenFileDialog to load the Load XML file
Dim x As New OpenFileDialog
If x.ShowDialog = Windows.Forms.DialogResult.OK Then
[CODE]...........................
I want to read in a file and as I do put the contents into a datagrid, can this be done ?I have the following code so far
myPath = "C:SYNC_DATA�0 - LGW�5 - Archived�0 - IST Logs2008"
myFile = "istlog" & d.Year.ToString & d.Month.ToString.PadLeft(2, "0"c) & d.Day.ToString.PadLeft(2, "0"c) & ".txt"
Dim sFile As System.IO.StreamReader = New System.IO.StreamReader(myPath & myFile)
[code]....
I get an error on "adapter.Fill(dt)" which is propably incorrect.How can I get the ontents to be displayed in a datagrid on the screen called "DataGridView1"
I placed a datagrid in my form which l retrive data from my sql. i am using oledb connection. if i run the form i can retrive the data but i am not getting the data in the grid at first ,there is a "+" sign, i have to clik that then it shows the table name and after clicking the table name i can view the data displays in the grid..
View 1 RepliesI am working in windows forms with Vb.NET 2008. I am trying to read text in from an external program. So far I have been able to read text in from a standard text box or button, however I am trying to read data in from an external data grid.
When I try to use the following I get no information about the grid
ChildHandle = FindWindowEx(ParentHandle, IntPtr.Zero, "classnameofexternaldatagrid", Nothing)
Dim Hndl As IntPtr = Marshal.AllocHGlobal(2000)
NumText = SendMessage(ChildHandle, WM_GETTEXT, 2000, Hndl)
Text = Marshal.PtrToStringUni(Hndl)
Usually if it is a standard text box I will get the text data with no problem, but it is a standard data grid and there are no further sub handles to try and read from. If WM_GETTEXT wont read information from an external data grid then how would I read in the data?
Here is the code in question:
filePath = "..authors.xml"
dsAuthors.ReadXml(filePath)
With DataGrid1
.DataSource = dsAuthors
.DataMember = "authors"
End With
However, it will not allow me to reference .DataMember, it keeps popping up with the error text "'DataMember' is not a member of 'System.Windows.Forms.DataGrid'". What can I do to resolve this error? Or how else can I read into the DataGrid?
Note: I have the most recent Framework installed with Service Pack 1
read data from text file , 3 data types saved on the file, "location", "time","sighting" eed to extract all data from file and save on a 2d array and display on a datagrid view.ata sorted by ascending order of time.
View 14 RepliesI have a modbus TCP device that I have managed to connected to through my VB source code.
I want to poll (continueously read) data from certain registers of the device, and store the polled data in a file (text,csv, excel).
Data binding should be an extremely simple thing to manage but I can't find a SIMPLE solution to the following problem.
I have two forms
Form1 contains a 4x4 MSFlexGrid (unfortunately an unmanaged COM object but I can merge cells, which I can't do with a managed Datagrid)
Form2 contains other controls which change the data in the Flexgrid.
I connect the two with a Public 4x4 array. Form2 changes the data in this array. I can update the grid data by reading the array. But how do I bind the Grid to the array so that it auto-updates - which is the whole point of binding isn't it?
I am reading data from a socket (as bytes) and storing this data in a string. Then later i need to access specific bytes within the string and do some math with them. However the bytes that I read back from the string are not what I am expecting.
[Code]...
Possible Duplicate: DataGridView - Validating for Cell?i have a requirement. i dont know how to get the data from the datagrid after the user entered data in textboxcolumn. i also want to validate the entered text in datagrid cell.
View 2 Repliesi want to binding excel data to a datagrid without no header, just the data.for example :my excel files consist of 3x3 matriks data in 3x3 excel cell like this
1 2 3
4 5 6
7 8 9
and i want to show all this data on data grid i have tried with some code like this
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
Dim ds As New DataSet
MyConnection = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; " & _
[code]....
but the first row of that data ( 1 2 3 ) is not shown up in the datagrid, just the 2nd and the 3rd row that shown up in datagrid?
I'm having a little trouble trying to read a word document in vb. how to get the text out of the word document would be great.
View 4 Replieshave made a connection to a database through VB and i was able to extract a single value from a record and display it in a datagrid table, but i don't know how to display that value in a textbox. i tried doing e.g. txtABC.text = datagrid123.item but it seems that the values cannot be converted between the datagrid and the textbox.
View 2 RepliesI've been asked to prepare a proposal for a client for a new development. The finished product will require copying of personal DVDs, e.g. a wedding or christening video, to AVI or similar format.
Is it possible in vb.NET to read data from a DVD and encode it as an AVI file? If so, can you give me some pointers to how I might research this more.