I am writting an application in VB using VS2008 and SQL2005. I would like to save an array to my database and later retreive it. I understand that I need to serialize the array to do this but don't understand the process. I have looked at various resources on the Internet but seem to be missing something.
View 2 RepliesI have a byte array of a file and I need to save it into my database in a field that has been set aside of type image.
However I have a problem my data access class takes a sql string and commits it to the database for example.
"EXECUTE stored proc @parm1, @parm2, @parm3"
However the problem is I cannot figure out how to transfer the byte array to string so that I can add it as an argument.
I hope this make sense.
I also understand that I can build parameters in com objects but I do not want to do this as it will disrupt my whole data access class and I am not prepared to do this at the moment.
I have a queue and i could copy it to an array. How can i save the contents of the array or even queue to Mysql database
Public waiting As New Queue(Of String)
wait.Enqueue(InputBox("enter patId..."))
dim waitArray(waiting.count-1) As String
waiting.copyTo(waitArray, 0)
Can I save an array into my .bin file then read the array again just like a string or Integer??
View 2 RepliesI want to compare two array and save the miss match character into 3rd array.
View 1 Repliescan anyone teach me how to save data in microsoft access database and retrieving it back from database?[code]so, how do i save it in that and how do i load their data by typing their ic no only..
View 5 RepliesIve created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On
Option Strict On
Imports System
Imports System.IO
Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection
Dim mycommand As SqlCeCommand
[CODE]...
1. First off, how do I make my path to my database relative? The path is currently absolute and is: Data Source=J:/College/AS_DSFinalDatabase1.accdb
2. Second of all, where do I save my database in the project? I want it to be included in like project folders...kind of like the App_Data folder in ASP.Net.
3. I'm recieving an error whenever I try to populate more than 1 DataGridView upon form load for some reason...I've tried 5 different ways of writing the code, and I get the same error...there's no error description, so does anyone know what the issue is? Here's the error:
I have a 2d-array but the array is made of a class and I want to know what is the best way to save this array so I can edit and bring it back up and save it back when needed.
So I have this class
Friend Class CellValue
Public CellColor As Color = Color.White
Public CellShape As Shape = Shape.Blank
Public CellName As String = ""
Public CellLocX As String = ""
Public CellLocY As String = ""
End Class
[Code] .....
Apparently the system.collection.arraylist does not work since it is more of a list than anything else. Is there some sort of collection that will save my array as is so that it can be retained latter on application load?
View 5 RepliesI have 2 Structures
Public Structure One
Public ItemOne As String
Public ItemTwo As Integer
End Structure
[Code]...
Results In an Unhandled exception. Bad Record Length. and then If I close it and reopen it I get an 'Unable to read beyond end of stream' error. So what is the best way to save an array of structures? Binary Reader/Writer? and why does this way not work (Even if its derived from VB6)
I have a two dimensional array as string and I what to save it to a file, what should I do?
View 1 RepliesI have Dim a(15) as integer i wont to save this array in Viewstate .
View 2 RepliesI have a string array that is populated with thousands of entries. I am wanting the quickest way to save this data to disk and to also load it back up.
Currently I am looping through the array and appending this data to a string and then saving this string. This takes a long time.
What is the fastest/most efficient way to do this?
Got an array, why cant I save dataread info to array pos?
While myDataReader.Read()
' txtPhone.Text =
Tempstr(i) = myDataReader.Item("Phone").ToString + vbCrLf[code].....
apparently Object reference not set to an instance of an object.
How do you save an array or an arraylist in vb.net using My.Settings? I cannot find the array type anywhere, even in the browse window.I absolutely need to be able to save this.I know I can convert the array to a string, but I do not know how to convert a string to an array. I know that if I were to break it at a delimiter then I could convert a string to an array, but my problem is that any text at all could be stored within the array as a single value, so I cannot pick a delimiter that is likely to be used.
View 3 RepliesI have some code in a module:
Public esUsefullitems as new arraylist
That declares my list and I am using a simple structure to store data in but what I was wondering how can I save the arraylist to my.settings without getting a nasty object reference is not set to an instance of an object error, I know this involves using the 'new' method but I have tried many different ways of doing it but I still get that error, how do I do it?
Now i have some images and i have a database (MS Access)i need to convert all images to !one byte array!(couse i have 1 column for images) and i save this array. Then when i need a picture i should take some pic on this byte array.umm i think i cant explain my status :)
i need to cut this byte array like split function. so then i can choose image whatever i want
saving and loading to a file. I am using Visual Studio Express 2008.
I have an array as follows:
Dim m(100,100) As node
Public Structure node
Public i As Integer
[Code]...
and I'd like to save to a file the m array.
I am not particularly bothered about data security and looked at xml serialization but cannot get this to work to save the m array.
I am using visual studio 8. vb.net.I have an array, array1(100,8) and I want to save it as a csv file so that I can open it in excel and examine the contents more closely. The feature, of saving as a csv file, is not going to form an integral part of the finished vb app, I just need something quick and dirty because the data in the array just requires looking at in excel so that I can fully understand its significance and thus continue coding my app.
View 2 RepliesPrivate Sub LoadButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LoadButton.Click
Dim lin(8) As String, filRead As StreamReader, i, x, t, d As Integer
[Code].....
I am getting a run time error it is not saving to textfile
I am writing a program in VB10 and the programs purpose is to read an encrypted text file and decrypt it into a textbox onscreen. You can then save the text.The problem is that it keeps saving text in files like this:
H
e
l
l
o
I cant figure it out. Here is my save array code:
First the savefiledialog
Sub SaveFileDialog()
Dim strFileName
[code]....
I need to save array into excel file. I'm using code taken from [URL]
Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object
[Code]....
But i want to let users to choose folder and filename themselves instead of determining location and filename like in those code above oBook.SaveAs(sSampleFolder & "Book2.xls") I wonder if i can use SaveFileDialog but i dont know how to do it. Or is there any other way to do this?
How can i save an array of string to disk??
lets say we have
Dim myStringArray() As String = {"A","B","C","D",.......,"Z"}
and wanted to save it to a binary file on my disk.
later i want to be able to read it and load it into memory.
My homework task is to add data to an array of records and then save this to a file.
I'm having problem saving to a text file. I have the following code:
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Dim SW As New StreamWriter("Records.dat", False)
[Code].....
In my test example here I realise that the reason I have 4 lines written is because I have 4 elements to the array, but why am I getting this gobbledegook instead of records with a name and age?
I know I have added the data correctly to the structure because I can redisplay it elsewhere on my form. I just don't get how to save data in a structure to a text file.
My task requires use of an array and/or array of records, a text file
Here's the code i've used in the past to save an integer array to settings (The setting being listed as a String on the dropdown):
Save:
vb
sec0string = String.Join(";", Array.ConvertAll(sec0, Function(n) n.ToString()))
Load:
vb
sec0string = My.Settings.sec0
sec0 = Array.ConvertAll(sec0string.Split(";"c), Function(s) Convert.ToInt32(s))
Suppose i have an image and i extract each pixel color and store it in a color array, is there any way by which i can save the color array along with the image? I was thinking about converting the color array to string and then integer and then append data to a text box, but then again i must store the text along with the image....and i dunno how to do that?
View 1 RepliesSearching for entries in a source
For Each m As Match In Regex.Matches(txtDisplaySourceCode.Text, regExString)
_rtnSourceCode_LinkHolder = m.Value
Return _rtnSourceCode_LinkHolder
Next
But i dont want to just return one instance if there is more. Want to be able to hold all the urls some where that can be accessible from any sub
im trying to figure out how to edit this program and have it save values as a string or array and allow them to be recalled and edited however im at a terrible slup, here is the code im going to base it off of.
Public Class frmHospitalCharges
Dim introomcharge As Integer
Dim decmisccharge As Decimal
[Code].....
i have the basic program written i have to add a input box for names.
I try to read a stream and save it as byte array to add it later to zip file.this is the code that I use
Dim totalbytes As Byte() = Nothing
Dim iBytesRead As Integer
Dim sChunks As FileStream = File.OpenRead("c:myfile.wav")
Dim Totalread As Int64 = 0
[code]....
but there is something is not correct,