Is there any way to query an array of mine in VB.net? I just need something temporary in order to query it for a report but I do not want to make an external database just for something that's going to be temp. I just need to be able to say select * from tempTable etc etc.
View 2 Replies
I have an array of people stored in a custom structure array... how can i copy this array to a temp array so that the temp array has all the same values as the original custom array?
View 4 RepliesI am working in VB.NET08 I was created Crosstab for table called 'Crosstabtemp' as given below:
Crosstabtemp= CrossTab(tblB, "PersonID", "ContactMedium", "ContactNumber", "Personal_")
I was declared Crosstabtemp as a Datatable in my above code.
I want to use the Crosstabtemp in my further sql query.
I need to join few Db tables with this Crosstabtemp??
In my desktop, I have folder containing some word document files. I want the filenames of the documents in that folder. So, I used:
Dim strFiles() As String = IO.Directory.GetFiles("X:Documents and SettingsXXXDesktopvvvvv", "*.doc")
All filenames are stored in that array. But it would also include the temp document that Word generates. I am somewhat confused on how to remove this from array. I only need full filenames of the actual documents, which excludes the temp document.
I am using Access DB.I want to create Temp Tables in My DB.What is the Syntax for Crate Temp tables in VB.NET??
View 5 RepliesHow to get the file path of the Temp directory (% temp%)? I use Visual Basic 2010
View 1 RepliesAm trying to copy contents of file temp.fxl to temp.seq. I want them to look exactly them. I don't want to copy the file though. I use the following code
Dim fs As New FileStream("c:\fxlate\output\temp.fxl", FileMode.Open, FileAccess.Read)
Dim s As New StreamReader(fs)
[Code].....
With such simple code, the last line in temp.seq is truncated as attached and the size of the file is smaller than temp.fxl. See attached files. What do I need to do on the above code. Is VB.NET failing to write 1024 characters on one line.
I didn't think it fair to post a comment on Fredrik Mörk's answer in this 2 year old post, so I thought I'd just ask it as a new question instead..NB: This is not a critiscm of the answer in any way, I'm simply trying to understand this all before delving into memory management / the marshal class.
In that answer, the function GetByteArray allocates memory to each object within the given array, within a loop.Would the GetByteArray function on the aforementioned post have benefited at all from allocating memory for the total size of the provided array:
Dim arrayBufferPtr = Marshal.AllocHGlobal(Marshal.SizeOf(<arrayElement>) * <array>.Count)
I just wonder if allocating the memory, as shown in the answer, causes any kind of fragmentation? Assuming there may be fragmentation, would there be much of an impact to be concerned with? Would allocating the memory in the way I've shown force you to call IntPtr.ToInt## to obtain pointer offsets from the overall allocation pointer, and therefore force you to check the underlying architecture to ensure the correct method is used*1 or is there a better way? (ToInt32/ToInt64 depending on x86/64?)
*1 I read elsewhere that calling the wrong IntPtr.ToInt## will cause overflow exceptions. What I mean by that statement is would I use:
Dim anOffsetPtr As New IntPtr(arrayBufferPtr.ToInt## + (loopIndex * <arrayElementSize>))
I've read through a few articles on the VB.Net Marshal class and memory allocation; listed below, but if you know fo any other good articles I'm all ears![URL]..
mbedde resources writing to temp folder and they all works fine but i have the exe that requires the files in a folder example folder1 , my path isMy.Computer.FileSystem.SpecialDirectories.Temp for all the files im using but how can i addMy.Computer.FileSystem.SpecialDirectories.Temp.folder1to string so it creates the folder and i can write the two files to this one instead of regular temp ????
View 18 RepliesHere's my code: System.IO.File.Move(Form6.OpenFileDialog1.FileName, "Temp") I'm trying to make it so that the program copies the file that you select in the OpenFileDialog and moves it into the "Temp" folder. It gives me an error saying: Cannot create file when file already exists.
View 7 RepliesThis was an experiment to see if I could create a fake array using generics instead of using an array. I decided to try it, because I may use it if I find any advantages to using it over an array. it works, I am just asking for a second or third opinion, have I screwed anything up, or is there an easier way to accomplish this? If I use it, it will be for a 2D game I am creating, and is used to draw the 2D screen graphics, placing an image based on what image identifier is located at what coordinates. The value stored in the fake array is an integer that disignates the graphic to draw and whether it is passible or not, i.e. 0 = a floor image, 501 = a wall image that is impassible (any image number > 500 is impassable) The Class definition:
[Code]...
I have a few running totals and a name associated with these totals and was wondering if an array would be quicker to use instead of storing it in a database.Basically what happens is I need to search a name and if it exists I add the necessary amounts to the totals and if it doesn't exists I add a new record.
View 4 RepliesI am having trouble using FOR loop with array in query.What I am trying to do is for all the data pulled out of database I convert it to an array list and then string (this works fine). After that I am trying to make a FOR loop query for each of the data pulled out and this is where i am having trouble.
[Code]...
How would I go about running a query in asp and storing it in an array. Then with the array go through each record without having to refresh the page every time.
For example
Sub loaddata()
Dim conn As New IfxConnection(connectionstring)
Dim results() As String
Dim i As Integer = 0
conn.ConnectionString = connectionstring
[Code] .....
The results are stored in results(i). Say I have a button that says next and everytime I want it to go to the next item in the results array. I don't want the page to refresh. How do I do that?
I am new to LINQ, but have been able to query SQL using LINQ to SQL and then I can data bind the results to a GRID or DROPDOWN LIST with no problem. What I would like to do is load a column into an array. I have seen examples for something like this in C#[code]...
View 12 RepliesI'm using VB.Net and have the following LINQ Query...
Dim ACFTTail5 = (From tailcounts In db.TailCounts _
Where tailcounts.Model = "UH-60A" _
Group tailcounts By _
tailcounts.Tail, tailcounts.Model _
[Code].....
But get the following error...
"Unable to cast object of type 'System.Data.Linq.DataQuery1[VB$AnonymousType_42[System.String,System.String]]' to type 'System.String[,]'."
Dim Builders As New System.Data.OleDb.OleDbConnectionStringBuilder
Builders("Provider") = "Microsoft.Jet.OLEDB.4.0"
Builders("Data Source") = "C:UsersJohnDocumentsVisual Studio 2008ProjectsSimpleSQLTestSimpleSQLTestdictionary.mdb"
[code]....
So trying to speed up the query. The read of the last item is just to see how long it takes. I do a different method in VB6 and it loads very quickly. Trying to load a dictionary that is over 200,000 rows.
Scenario: Writing a scanning program, thing is I can't have duplicate file names(which I generate). The img file paths r saved in a database.I'm trying to write a function that will return all the records I need using a SQL SELECT. To make this work I need to put all the retrieved records(just the one field from the database) into an array.My Problem: I have no idea how to put the retrieved SQL query into an array and then return it.
Private Function fileNameAcquisition(ByVal path As String, ByVal id As Integer) As String
Dim conn As New SqlConnection
Dim dr As SqlDataReader
[code].....
I seem to be having a heck of a time trying to figure out how to add the results from a mySQL query to an array in vb.net. Right now, I only understand that you have to define the dimension of the array, however this is shy of impossible since the dimension of the array will change due to different results from the query. What is the proper way to take my results and put them in an array?
View 12 RepliesHow should I create between clause in my query?
View 3 RepliesI'm attempting to make a generic query executer function. I want to be able to send it a query string and have it return a two-dimensional array containing the results. Below is my code for how to do it with a (9,x) array. How can I do it with an (y,x) sized array? Also, I feel like there must be a more efficient way to do this..
[Code]...
I created a sql query to check if the mobile number is registered or not. If its registered, it will send the new pin code to the customer and if its not, the customer will get a message that "This number is not registered or you are not authorized to this"... something like that... Sending of new code is already working. I just dont know how to make it as conditional statement like PHP. After you query on PHP, you can just set a variable and make a conditional statement..Here is my script in vb.net:
Private Sub CheSMS()
Dim SQLServer As String = My.Settings.SQLServer
Dim conn As SqlConnection[code]......
I'm triying to create a dynamic query to Entity FW (i'm using Self tracking Entities over EF)
This is what i'm doing:
Public Class Specification(Of TEntity As Class)
Private _predicado As Expression(Of Func(Of TEntity, Boolean))
Public Sub New(ByVal columna As String, ByVal condicion As OperadoresComparacion, ByVal valor As Object)
[Code].....
i try to convert this kind of sql query into linq in visual basic, but i get stuck on how to make a percent.. I also don't know how to use linqpad for creating this linq
SELECT CASE RIGHT(PICName, 3)
WHEN '(P)' THEN 'Problem'
WHEN '(R)' THEN 'Request'
[Code].....
Trying to figure out the right way to query a MySql database and find a user defined variable from a Textbox.Text property. I'm not sure what to put for the where clause in order to search every cell of every row for a match. I have looked at coalesce and contains, but neither are really making sense to me and I'm not sure if they are my best option. I'm thinking that the query string will look something like this:
View 2 Repliescreate an EDI 837 /X12 file from a SQL query. I will be creating a temp table then inserting data to the file.The X12 file has essentially 3 parts: The Header, The Detail, and The Footer
The Header looks like this
ISA*00* *00* *ZZ*HIS199 *ZZ*300002373 *060920*2314*U*00401*000000089*0*P*:~
GS*HC*HIS199*300002373*20060920*2314*43*X*004010X098A1~
ST*837*000000001~
BHT*0019*00*90*20060920*2314*CH~
[code]....
What method choices do I have to choose from to assemble this to a file?
How can I pass a paramator to another page without using Session variables or passing the Querysting in the URL?
View 1 RepliesIm trying to create a form in VB that allows the user to perform queries on a number of tables which are in access.
View 3 Replieswhich contains a combobox with two Gender options, Male and Female. When the form runs the user can select either male or female to perform a query. I made the ComboBox public and shared so that it can be viewed by other forms. On another form i added a ReportViewer and a dataset based on my database (MS Access 2007 database with 1 table named tblStudents). I don't have any problems when i try to run a simple query without parameters, but there is a problem with my
View 13 RepliesI'm trying to create a web service that will query active directory. Here's my code. The error happens on com.Execute() line. I've got an old vb6 script with same code that works perfectly.
<WebMethod()> _
Public Function Find(ByVal compname As String) As String
Dim strDomainSearch As String = "OU=XXXX,OU=XXXX,DC=XXXX,DC=XXXX,DC=XXXX,DC=XXXX"
[code]....
