I need to link different arrays of data that I am gathering from different Select Cases.For Example:Araray A, B and C from Case 1Array C, D and F from Case 2 Note: Array C is common between two cases.I know in C++ I could have used Pointers and use SQL in Java.
View 1 RepliesI have a program that simply checks if the account number and pass word match. And if not it allows you to create it. But i have no idea on how to create something that will hold the data and will allow the user to add and remove sets of data.
View 1 RepliesI have a basic application that allows pre-defined users to use the application.The Username & passwords along with some other basic user info is stored in a simple access dbIn my application I want a user to login, Username & PasswordI create a connection string, a data adapter and a dataset, I then need to validate the password the user has entered.Would it be best to query the access db directly, or the dataset?
View 5 RepliesI collect two sets of data from two different databases, This data is now in two collections. I then join/append the one collection to the other and then put it in to a list view.I really would like to order this list view by the first column without the click event.To make this even harder the First column contains Data that is DateTime and i have found that it orders the items by the day number and not the months or years or time.I have found one way but it then cause's me further agony when doing some checks upon the data within the listview later in my code. This answer is to rearrange the format to "yyyy-MM-dd HH:mm:SS" then using the listview.sorting = sortorder.
View 7 RepliesI have only 2 sets of "fixed" numbers used, that I need to be able to toggle between. Particularly, for array sizes/for loops. Is it best to use "Collections" in VB.NET to accomplish this?
View 5 RepliesI have a regular expression that I use to grab data between two sets of id's for example:
<CLASSCOD>70</CLASSCOD>
The regular expression I use is:
(?<=<CLASSCOD>)(?:[^<]|<(?!/CLASSCOD))*
Which works in most case but when I have a single value like this
<CLASSCOD>N</CLASSCOD>
It says there are no matches.
The whole data string looks like this :
<STATUS>PRESOL</STATUS>
<DATE>0601</DATE>
<YEAR>11</YEAR>
<AGENCY>Department of the Interior</AGENCY>
<OFFICE>Bureau of Indian Affairs</OFFICE>
[Code] .....
I have a USB device which creates a Virtual Serial Port on Windows. I am using VB.Net to write and read from the port. My device responds with specific sized set of bytes, but I am finding that SerialPort.Read(byte-array,offset,number-bytes) does not return the full number-bytes but it also does not timeout or generate an exception. Repeated calls return additional fragments (up to 3 calls required). Python code using pySerial does not have the same problem.So, what am I doing wrong here? Am I expecting too much?
Some scenarios are:I write a command to the port and expect to get 4 bytes in response. I get 1 byte first and then 3 bytes on the subsequent call.I write a command and expect 21120 bytes in response. I get 1, 12671 and then 8448 bytes in 3 calls to read from the port.
Here are some excerpts from my code:
Private Sub SetupVirtualSerialPort()
Dim portName As String = "COM" + (m_DeviceContext * -1).ToString
Const baud As Int32 = 9600 '7680000
Const parity As Parity = parity.None
[code]....
I am a newbie at VB.net and would like for you to review my code in order to improve its performance.My objective is to append a bunch of ".csv" files into daily data sets. Within a directory I have about 2500 individual text file (.csv). Each file represents minute intraday stock market data for an individual stock covering 5 days or one week of data. This means that each symbol has 1950 string lines..Here is an example of what a string line looks like: "2011-06-27,10:07,48.15,48.15,48.02,48.02,25421". Not that is relevant but these represent Date, time,Open, High, Low, Close & Volume. Since I have 2500 files within a directory; doing some math, I am processing 2500*1950 = 4,875,000 lines. This process takes me about 16 hrs to run.[code]
View 7 RepliesI have a customer and booking data sets on my form. customer id is a foreign key in booking table .but when i click delete button. it gives me an error: The DELETE statement conflicted with the REFERENCE constraint "FK_Booking_Customer". The conflict occurred in database "photoshoot", table "dbo.Booking", column 'Cust_id'. The statement has been terminated. Its a one to many relation between customer and booking. one customer can make many bookings each booking will belong to only 1 customer.
View 1 RepliesI have one main form and another dialog box that is used to search records. What code is used to declare a public variable in the dialog box form in order to get the record found by the user displayed back into the main form?
View 4 Repliesin VB6 we was use this code for linking :
Set DataGrid1.DataSource = Rs
what is the code which do it in VB9 ?
So I'm doing an assignment with VS 10 at college that involves making a program for calculating orders but got stuck in trying to link the "invoice" listbox for the receipt to the one on my main form.
Let me illustrate my example:
This is the "main menu" is where the user adds bikes, edits existing ones and deletes if needed.
This is my receipt form, it opens perfectly fine and even shows the totals that are stated in my main form:
However, the listbox in my receipt form doesn't link or take in the information stored in my main form, which in this case, would be all the bikes. Here's my
Public Class BillForm
Private Sub ReceiptForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]....
What is wrong with it? The text boxes link up, but the list box always shows up empty when I try to add some bikes in on the main form.
I'm trying to generate my own dataset and create parent/child relation on the fly so that the subsequent datagridviews (dgv) that will be displaying the information will filter each child dgv by the record chosen in the parent dgv (I hope this makes sense).
So far I am able to display info in each dgv, but every record from each corresponding table is displayed in each dgv- no filtering is occuring. I think the problem might be in how I'm creating the relation and/or how I'm linking it to the dgv. Here's the code I have on the UI:
[Code]...
I am trying to link two columns with dates and time to a new column, but the original columns are not in DateTime format. Here is sample of the data:
C_DATE C_TIME
231110
211152
[Code].....
After trawling around the net for a good few days, i decided to post something here.
Basically, i've got a problem linking a data source (Access 2007 database) to a VB 2008 project.
I've broken it down to having a problem dragging a table onto my form, when it generates the nav bar, it says "0 of {0}", and the table is empty (despite the actual database containing values)
However, this happens only at home, at college it works totally fine. The only difference that's obvious is that i'm using Windows 7 at home, and Windows XP at college.
I have an icon file (32x32) and I added it as application icon in the properties and it is coming fine only if the view is set to "Medium Icons" else it is showing only the default icon. How can I add all sets of icons to an application so that my Icon will be visible in all modes?
View 2 RepliesI have a simple control that sets a variable to a value. What I want to be able to do is check the value of this variable on another form.Here's the code:
[Code]...
I am coming from VB6 and I am starting to convert an existing VB6 code to VB.Net. What tools can I use to automate this task?
View 3 RepliesI have some text in an .rtf file which uses a non-English character-set (it's chinese).When I open this in Wordpad or Word I see just the chinese characters.When my app opens the .rtf file and reads the file's contents and puts it into a RichTextBox for display, I get "everything" from the .rtf file, i.e.:
{
tf1ansiansicpg1252deff0deflang2057{fonttbl{f0fnilfcharset134 SimSun;}{f1fnilfcharset0 Calibri;}}
[code].....
I want to get two sets of information from a source file. Say user name and address to their profile. I so far I'm using two for next loops to get the information I want and save it into the text file. Works great. Problem: I would like to print to file first line of For Next output then append to that the first output of the second For Next loop. Then do the same for second out put until the end of each For Next loop is complete. [Code]
View 14 RepliesSince plan1 and plan 2 all plans having same fields but due to their variable values total I make 4 tables having one to many relationship so that duplicate data for few fields get accomodated under different Id. and now there is no need of filtering data also and 4 databinding sources give a serial values to my comboboxes to select veriables to get further calculations.
I have another question now in further calculation there are many calculation sets with using if elseif if statment for such number of sets how to connect them since in form1.vb code file
if I place them one after other some calculations get correct some gets wrong.I hope you understand my question.is there any method to connect such sets( if elseif if) statments one by one under one buttion_click to get correct answer for all the sets.
There are plenty of seemingly related Linq questions, however a quick browse through the content doesn't seem to answer my question specifically enough for my limited intelligence to grasp.
We have a table named PropertyInteractions in which is stored threaded messages via a thread id, the thread identifier is the Id of the initial interaction record. Given the following Linq query (which retrieves all interactions concerning a user), how might I split interactions into lists of PropertyInteractions grouped by Id?
[Code]...
I have a stored procedure:
CREATE PROCEDURE [TestProc]
AS
BEGIN
select '1a', '1b'
select '2a', '2b', '2c'
select '3a', '3b'
END
If I execute the following query using SQL Management Studio,
[Code]...
How can I get the three result sets using SqlDataReader? Or even three SqlDataReader's? Or is it possible to get multiple result sets in just one query in VB.NET? Is DataSet my only option?
There is a stored proc.. Which was returning to result sets..
Ex:
select * from table1
select * from table2
If I get this data to a Dataset, Definitely I will get 2 data tables with index (0,1)..But what if go though a Datareader? I had checked that just now.. And I got a result of first result set (i.e Table1 in our example)..
I am trying to write a program that will help people script for a game. Ok so when you write on visual baiscs if you start an if statment it changes the "if" to the color blue. How could i do that in my richtextbox?
View 1 RepliesHow do I make a property to have a set of selectable values, in a way such that they work by intellisense-drop-down, as i.e. the color.white, color.black etc.? I want to do this like for integer values I may want to have selectable by "keywords" with the hard values only existing in a unique class file, or whatever is necessary ..?
View 2 RepliesIs there an easy way to get the relative complement of two sets? Perhaps using LINQ?I have to find the relative compliment of a set A relative to B. Both A and B are of type HashSet<T> but I think the algorithm could be made more general (IEnumerable<T> or even ISet<T>)?
View 1 Repliesinserting date/time to database manually using sql query.
[Code]...
I would like to have one Window (without child-windows) that can have multiple content-sets.For example: I want to have a set of lables and textboxes to save information for an object (like a person). This person has several sub-items. I want to have a set of lables and textboxes for these sub-items in my mainform too. But I don't want the lables- and textboxes-set of these two objects to be both visible at the same time.
View 2 Replieshow do you make a statement that sets the focus to the txtPassword control?
View 1 Replies