I'm trying to read values from a DB ,I tried to run the query manually and it works , there is a data. But the result I get on my app is always "" (empty). The empty value are "keywordd" and "dateee"
[Code]...
I have this code, to read image (saved as varbinary(max) in database):
Private Sub ReadImage()
Dim connection As New SqlConnection(strConnectionString)
Dim command As New SqlCommand("SELECT [Image] FROM z1 WHERE x=1 AND y=1", connection)
[code]....
But it isn't very convenient code. It reads bytes from table, save them to file, and finally open file as image.How can I read it directly to image, without saving as file?
Have some written code that enables me to log RPM from a drum, that I then convert to speed (KmH).Everything works fine so far.My current delima is trying to figure out how to read the RPM "changes" per timer interval.For example if I have at any given time a reading of ,let's say for simplicity,2000 RPM,and after the next timer interval it's 3000 RPM.I then have a change of 1000 RPM in that given interval.I need to have a way to determin this change store it into a textbox or combo box or something so I can work with it.As of now there are 2 Timers running.T1 is for the counting interval and T2 is for holding the count till the new count comes around.I had tried to add a 3rd timer to count the change but got rid of it because it did'nt seem to work.
Here's the part of my code I use for reading RPM and Speed cal..(VB2008 not VS 2010)
Public Class Form1
Dim product1 As Double
Dim product2 As Double
Dim product3 As Double
[code]....
I am building an app to read a customers .xls file in to a array list the array is the being reordered and im writing a file out the back end.its doing several lookups in the .xls file to see if relivant data is there and it writes a different file (9 different specs) depending what is in each line/column.Sound simple and I have the app working great however when I use a customers live data I get an ex.message = "Could not decrypt file" the file opens in excel witthout any password prompts however it does look like the sheet is write protected but all im doing in my app is reading the data.
Using fileConn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & OpenFileDialog1.FileName & "; Extended Properties='Excel 12.0 Xml; HDR=yes; IMEX=1'")
fileConn.Open()
[code]....
I have a .csv file (created by external program). In my vb.net application I want to read the last cell value. External program updates the last cell value every 3 sec.For this I use the below code. But cpu usage increases (because timer event opens&closes new excel sheet every second)I was successfully doing this with vb6 without any problem, but with vb.net I'm stuck.
[Code]...
I need to read in each line of a file that is comma delimited and I know how to do this.ut for this file, some of the values have quotes around them that contain commas and others do not. For example, the name field has "Doe, John and Lisa" and the other fields do not. How will this be handled? Will it read that whole field in as one or will it still seperate it as seperate fields?
View 3 RepliesI'm sending an http request through a proxy using tcp, and then using a streamreader to read the netstream...The streamreader is supposed read each line up to </html> , however it doesn't seem to be waiting for the packet/response to be fully received, as it always returns only the first 5-10 lines of HTML.If I add a breakpoint at the line "Using sr", and pause it there for a few seconds and then continue the execution, it will return the full HTML up to the </html> as it should.This is the part of my code which reads the response.
Dim sendbytes As Byte()
sendbytes = System.Text.Encoding.ASCII.GetBytes(ReqHeaders)
netstream = tcp.GetStream()
netstream.Write(sendbytes, 0, sendbytes.Length)
[code].....
i have my .xml files written like:
vb.net
<?xml version="1.0" encoding="utf-8"?>
<hiddenFields>
[code]....
I'm trying to read the values but i'm not having much luck, i have this:
vb.net
Function functionLoadHiddenFields(ByVal fileLocation As String)
Try
[code]....
i'm not to sure how to get the individual values?
I have a program where I'm writing an xml file and later the same program is to read it. I'm writing the file just fine and get this output:
[Code]...
i have read a lot about reading data from pdf but still very confused. i have to gather data from a invoice which is in a pdf format and store it in the database now the invoice contains text, tables, signature and barcode. this i have to again print after adding some of my data in another format and hence i need to get the data from the pdf file.
View 1 RepliesI'm trying to read lines from a file using:Dim FileLine As String = ""Dim File As Integer = FreeFile()
Open "C:ext.txt" for Line Input # File But I get this error: 'Open' is not declared. File I/O functionality is available in the 'Microsoft.VisualBasic' namespace.
I tried to add Microsoft.VisualBasic as a reference, but it didn't work.
I am working on a project in which the user can play another user on over the internet. Basically, how would i go about this?
What type of server would i need? Would i just use a designated computer as a server?
Also, what is the general process in contacting a server, reading/ writing from/to a server and storing data onto a server?
how do i read from registry, i want my program to do this once u open it it reads the registry for a number 1 means non-active 1.2 means active i its active it bring you to form 2 if not it just stays t form 1
View 6 RepliesI'm trying to make it so that it reads the xml, gets all the tables and puts all the tables names into the combobox..
i have tried..
ds1.ReadXml(meDirectory & "saves.xml")
With ComboBox1
.DisplayMember = "name"
[Code]....
I'm trying to read the tag from the checkbox. For example: Private Sub CheckedListBox1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles CheckedListBox1.Click
[Code]...
I have an XML file (see attached) that has numerous different sections/categories.What I'm looking for is advice on how to pick out the different levels/categories and display them one after the other, with the click of a button obviously. Much like you would/can with a recordset using ADO.
View 5 RepliesI am making a program that stores information for my applications. There are 4 main things I need in the XML file, the login information (User name and password), Application names and keys, and the owner of the application (who bought it). The program allows the user to enter as many applications and owners as they want and once login information is correct it loads the data. Then on exit all the data saves to a XML file.My XML file looks like this[code]....
Once I read all that the only thing I get is one application and no owners. How do I make it read all of the Apps then stop at the end of the Application Element?
Ive searched for the pass hour on how to do this. Everything ive found is for vb6 and it wont work with 08 for some reason. Here is what i am doing, and the way i want to do it.I have a login form that has a checkbox remember me. Inside the if statement (If chkRemember.Checked = true) I want the code to write the username and password in a config.ini file in this format;
[LoginInfo]
Callsign=dsfsdf
Password=dsfdsf
[GeneralInfo]
Can someone provide me with a code i can use for this? I also want to be able to read that data to.
here is my current code.
[code]...
Now that aint workin. What i want it to do is read and compare usernames and passwords of text box 1 and 2 with 2 text files on my website. I am not caring about encryption at this piont so plz dont reply about the security of this method i know the risks. What i need is some source code i can look at witch has a simular method to mine
im just wondering is it possible to do this easily as im not great at VB I have a simple webbrowser open when i click a menu item, and when it loads it goes to a text page on a online server i have (ends in .txt) which just has some text on, is it possible for me to add a button which when i press it, it searches the page for a certain number/word, then opens a message box with some text in relation to the number/text, or is this not possible with a webpage.
View 6 RepliesI'm a new VB programmer, although I have a decent background in java.Anyways, I'm learning VB and I'm trying to read data from an Excel file using VB 2008 and can't figure out how to accomplish this. I can't seem to get any data from the Excel spreadsheet to display in a simple Windows form. Also, there's a decent amount of data in the spreadsheet so I was wondering if it makes sense to just read data as needed from the excel spreadsheet or if there was some type of data structure that I could import the entire Excel spreadsheet into and do my analysis from there.
View 1 RepliesI have microcontroller interfaced with serial port of my computer. In my microcontroller I have 2000 sample data and my primary target is to read those data. Now I can read those data in hyper terminal, but when it comes to my application it doesnt show anything.
Private Sub sp1_DataReceived(ByVal sender As Object, ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) Handles sp1.DataReceived
sp1.Open()
MsgBox(sp1.ReadExisting())
End Sub
this simple code block should show me the data.But it doesnt.data format coming Microcontroller is in this following formate :
nitialization successful !,1023
Starting sampling process... 1023,1023 1023,1023
0,2 1023,1023 1023,1023 1023,1023 212,686 1023,1023 1023,1023
1,5 1023,1023 1023,1023 1023,1023,659 213,689 1023,1023 1023,1023
now, I dont understand why it doesn't read anything :NB: SP1 has a baudrate of 19200,Databits 8 and no parity,COM1 port. I aisnt sure whether I will be needing a buffer or not
I have a dataset which creates a table adapter to the table I need. I call a query on that table adapter which returns the number of fields returned. In this case it's one field and will always be one field.. I am filling a variable with that query.. however instead of the fields returned I need the actual data.
This is how my current code sits...
vb.net
Dim aUserName As String
'TODO: This line of code loads data into the 'DataSet1.IT_Staff' table. You can move, or remove it, as needed.
aUserName = Me.IT_StaffTableAdapter.FillByUsername(Me.DataSet1.IT_Staff, SystemInformation.UserName)
Do I have to load this into a variable declared as a datatable then somehow call the column and row 0's value? If so how?
I have several quesions about reading/writing structures from/to files.In a scenario when I open a data file having its own header and variable data fields I create a structure that represents a header consisting of 9 bytes:
Public Structure HeaderInfo
Public DataField1 As Integer
Public DataField2 As Byte
Public DateField3 As Integer
End Structure
I'm using this code for the time being:
vb.net
Public Function ReadHeader(ByVal FileName As String) As HeaderInfo Dim ReturnInfo As HeaderInfo Try Using br As New IO.BinaryReader(New IO.FileStream(FileName, IO.FileMode.Open, IO.FileAccess.Read, IO.FileShare.Read)) With ReturnInfo
[code]....
The first question is - can I fill the structure directly somehow? Some structures are very long and filling them this way will be tedious. For example, if I know the length of the structure I could read the needed number of bytes in a byte array and somehow marshal these bytes into the structure.I can use Marshal.PtrToStructure, but then I would need to get an IntPtr of my byte array. I use <Serializable()> attribute for my structure.
I am having some trouble thinking of a way to do this, what i have is an .xml file loaded and data read from it and used in my application, the thing is the data varies in each .xml for example:
vb.net
Dim XMLD As New Xml.XmlDocument
'// Find and load the XML file
XMLD.Load("Debug/xForm.xml")
[code]....
The fields vary on application execution, there maybe 5 fields with data one time, then 13 the next etc, if only 5 fields have been written to the xml and i load them all like above i get an error (because that data hasn't been written)is there a way to load the data dynamically based on how many fields have been written kinda thing?
t possible to do this easily as im not great at VB I have a simple webbrowser open when i click a menu item, and when it loads it goes to a text page on a online server i have (ends in .txt) which just has some text on, is it possible for me to add a button which when i press it, it searches the page for a certain number/word, then opens a message box with some text in relation to the number/text, or is this not possible with a webpage.
View 5 RepliesSay I have the data below:
Dim dateToday As Integer = 16
Dim dayToday As String = "Thursday"
Dim monthToday As String = "April"
[code].....
I have built everything for Beta one and I thought I had done very well until and Exception happens when I try and run it. Please could someone take a look at this and see if you know whats causing it:
Message: {"No value given for one or more required parameters."} Error -2147217904 Item: In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user. I don't know whether more info is required from the error but it happens on this line:
DReader = DSelectCommand.ExecuteReader
[Code]...
I have checked the database is in the target location and the table names and column names are all correct.
Here's what I have that Doesn't work (I have one button, one OpenFileDialog, and a label named Status):
Public Sub ProcessBytes(ByVal Bytes() As Byte)
Status.Text = "Status: Processing . . ."
Try
[code].....
I've got a program which reads a text file, in this file there are 2 or 3 lines between paragraphs. However when displaying in my textbox on my form i have 14-18 lines. Why? and how can I remove them?
View 3 Replies