[URL]..And put into a dynamic array where each month represents a record in the array with 3 given with C/P, Strike and Settle
The criterion is for every month grab all C/P that have matching strikes thus returning the following for every month. See data below and what I would like to return below. Want to use excel VBA to return the values from array into a sheet in excel. See data below
[Code]...
I have a SQL database which I'm running a query against to return a list of names - eg using "select names from table"I would like to add all of these names to an array so I can use them later. To do this I would need to use a dynamic array as the number of names returned could be anything.Apart from first running "select count(names) from table", getting a value and then Redim'ing the array on the count is there another method I can use.I've seen there's a dataset row.count? Can I somehow use this?
connection.Open()
reader = command.ExecuteReader()
While reader.Read()
[code]....
I need to dynamically create some sort of 'table' on my form. It should look like:
PIC1 INTEGER1 TIME1
PIC2 INTEGER2 TIME2
PIC3 INTEGER3 TIME3
On top of that it should look like a table and have gridlines between the 'cells' containing the picture/data, which makes it even more difficult for me. Before, control arrays were quite simple in VB6, but I've been searching for 1,5 hours now and I can't figure out how to do this in VB.NET 2010. Any idea how to tackle this the most efficiently?
I am using .rdlc Microsoft Reporting reports. I have a form with one reportviewer on it. What I want to use is a combo box where they select the report and then click generate, and it shows a specific report. I have this code so far that changes the report:
[Code]...
I am attempting to figure out the best way to place values into an array using dynamic data that is continuously streaming in from a ComPort. I want the array to hold 5 values at a time, with the newest incoming data point taking the place of the oldest data point. Each set of values in the array will be used in finding a trendline, which is then used in a later portion of the code.
View 1 RepliesI am new in this forum, also new in VB.Net I need to create a public class for insert and delete data to database Public Class My_DBFunctions
[Code]...
I am teaching myself VB with the use of a basics book, but I can't seem to find help for my project in the book.I am working on a project in which I have to open data from a csv file and use it to make graphs and analysis. The data is displayed in such a manner:
row 1: column titles
row 2: units
row 3-100: data
what I want to do is create arrays for each column in the csv, populated with the data.
I would like to create a sorted array of data. This is what I would like to have: A Textbox with numerical values, example: 72, 101, 108, 108, 111, 116, 104, 101, 114, 101, 046, 72, 111, 119, 97, 114, 101, 121, 111, 117, 100, 111, 105, 109, 103, and 163( these numbers will very and the amount of the numbers will very as-well). I would like to take these values and put them into an array.
View 2 RepliesIm a newby in creating programs using vb.net. Currently 'm creating an program that will display array data to datagridview. Can somebody help me how to do it?
View 3 RepliesRecently I have learned visual basic 2008 express edition and developed programs for data crunching and analysis. The VB 2008 express edition has microsoft visual studio 2008 v. 9.0.30729.1 SP and .NET Framework version 3.5 SP1. Now I want to create x-Y (date-Y value) graphs using the crunched data stored in an array list simulating a data base access. I download and installed the "Microsoft Chart Control for .NET Framework " and try to learn to use it within the VB 2008 express edition using the tutorial. It seems that the chart control did not get installed?
1. Do I need at VB 2008 professional to allow using the chart control?
2. Why after installing chart control, there is no change on the items under the NET components within the Toolbox>ChooseItem>.
3. How do I get to use the chart control under VB 2008 express edition.
4. Any code available to generate versatile graphics without using the chart control? Because the chart control has tons of classes already it seems the best is to just use the existing and downloadable chart control?
I have a VB.Net WinForm Program. I dynamically create panels with controls.Each panel has:
2 Labels
1 DataGridView
1 Button
Everything works fine the first time I create the panels.
Everything gets created, and everything is functional.
If I have to re-create the form, I get rid of the existing panels (and their controls) with this code:
[Code]...
When I re-create the panels, I get the panels and all of their controls except Buttons.When I step through the debugger, I see the buttons being removed, and I see them being created, but they don't appear in the panel
i want to create a modalpopup dynamically but i come across a problem.I pasted my sub here and i dont know what to do for that problem.When i want to show modalpopup,it says "Control 'mdldelete2' of type 'ModalPopupExtender' must be placed inside a form tag with runat=server."
Public Sub Raise_Alarm(ByRef p_Page As Page,
ByRef p_AssignedButton As System.Web.UI.WebControls.Button,
ByVal p_Message As String)
[Code].....
I am trying to access VB.Net exe on a client system through LAN.Its working fine for server with static IP address.In case I try to access it with server having dynamic IP address, It doesn't provide access(config file containing server name).
View 2 RepliesWhat im trying to accomplish is I have a table which im creating dynamically and I want in the first tablecell a radiobutton, second tablecell first name, third tablecell last name.The second and third tablecell work fine but having trouble with the radiobutton. Im making it a radiobutton list b/c only one name should be selectable. Below is how im creating the radiobutton list. I have omitted the second and third tablecell as its working properly. The yesNo variable is used to say i
tblrow = New TableHeaderRow
tblcell = New TableCell
If yesNo = "yes" Then
[code].....
heres my code i have it set up so when i press spacebar it should create and display a picture box my help is two parts one why is the picture box not displaying and how to i set it so that every time the space bar is pressed a picture box is created. The second part to that is how do i create a timer with that picture box that makes it move, i know how to make a picturebox move im just not sure how to do the for each statement to set a dynamic name and how to use the timer to affect it...
Private Sub Form1_KeyDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles MyBase.KeyDown
' Sets Handled to true to prevent other controls from
[Code].....
please tell me what is below code doing? is it creating array with two values or its creating to string index which will take value later? [code]
View 4 RepliesI am writing an application that requires button controls to be created at run time because the amoutn of controls created depends on data retrieved from a database.
I believe I am creating the control properly but I am not capturing the click event.
Code example:
Dim myButton As Button
myButton = New Button
myButton.id = "id"
[Code]....
I need the ability to create a dynamic number of hotspots in an imagemap the pseudo code for what I want to do is below:
Protected Sub AddHotSpot()
Dim r1 New RectangleHotSpot
For Each Item as datarow in dataset
[Code]....
I am looking at creating a Dynamic Menustrip.I have managed to write the code to add subItems to a Item. The root item is called item1 and when the form is run, item1 gets populated by items called subItem[0-5].I am wondering how do I assign an action to a subItem when click? At the moment I want a message box to popup with the subItem's name that has been clicked. I.E If subItem3 is clicked, I want a msgbox to pop up with "subItem3".
code
Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
For j As Integer = 0 To 4
Dim subItem As String = String.Format("subItem{0}", j.ToString())
[code]....
I am trying to create a dynamic dropdown after a dropdown has been selested (in asp.net vb)
For example: I have a dropdown question that asks: What brand of car do you drive (Toyota, Ford, Honda, Nissan, Chevrolet)
When the brand is selected I want another dropdown to appear under it with new chocies
For example: If Nissan is chosen, the second dropdown will be populated (from the database) with (Altima, Maxima, etc...)
And in some cases I would like a text box to appear, but If I can figure out the dropdown portion, I am sure I can figure out the textbox.
What Im trying to do is create a function that sees how many items Im wanting to add, then add each item to the combo box, without me having to add each item individually. Basically its to save space coding, and make my code easier to follow.
An example of what Ive got is:
Dim option_one As String = "Inches"
Dim option_two As String = "Feet"
Dim option_three As String = "cm"
Dim option_four As String = "mm"
[code]....
So the function would go instead of all those add items, and it would just say Call ItemFunction() or something like that.
I had been searching as to how I could create an array of controls dynamically, and after some searching found some helpful code as shown below [code]This way in the above code "structureComboBoxes" will have an array of comboBoxes (VB6.0 was way easy to get this crap done!! I guess its cleaner here)Now my next problem is How do i code for events of each of these combo boxes?
View 6 RepliesI am building a program to keep tract of student signup and classesroom.
1.I have an admin form that gives the admin users the right to create a classroom. This class is available / show up when the student signup. Because of future plans I want the admin to have the right to add / delete and classroom if the class is no longer needed to offering.
When a student signup the available class will show up in a datagridviewer and I have added a check box to select the classes taken.
[Code]...
I am making a hangman clone for boredom and I can't seem to make the labels show up properly. Maybe I'm doing this wrong entirely and should just limit what's visible instead.
vb.net
Imports System.IO
Imports System.Text
Public Class Form1
[code]....
I need to create some serial port controlls manually. My program reads through a config file, and it if comes across an entry called COMPORT then I need to create a contol to talk to this port. The entries in the ini file might be
COMPORT=COM1
COMPORT=COM3
COMPORT=COM7
So here is my problem! I'd like to create the variable control name with part of the com port number, so I can always refer back to it.
EG.
Dim strVar as sring = "COM1"
Dim CName+strVar As New System.IO.Ports.SerialPort
I am looking to create an order reference which is something like this
PLC0000001
Where the 1 would be my order id
but lets say it gets to 100 would like
PLC0000100
In VB.NET how could I build up a string like where i know i.e.
the starting part = PLC
Ending part = Order ID
middle = fill in 0's
How can I create a class so that I'll just call it to my form:This is the code of my Add Text box button that adds multiple text boxes.
Public Class Form3
[Code]...
I have a Comma Separated value file in .txt format... simply put, its a bunch of data delimited by commas and text qualifier is separated with ""For example:
"So and so","1234","Blah Blah", "Foo","Bar","","","",""
"foofoo","barbar","etc.."
Where ever there is a carriage return it signifies a new row and every comma separates a new column from another.My next step is to go into VB.net and create an array using these values and having the commas serve as the delimeter and somehow making the array into a table where the text files' format matches the array After that array has been created, I need to select only certain parts of that array and store the value into a variable for later use.... how to make the array and selecting the certain info out of it..
I needed to create an Access table programmatically an was able to by using Martin Xie's post but how can I set the Field1 - Field Property Index to Yes (No Duplicates)?
[code]...
Wish you all are doing fine at the start of a new year
I am a beginner developer. I am developing a website. I have few divs which made up dragable boxes enhanced by jquery portlets. see the codes below.(html).
<div class="portlet">
<div class="portlet-header"> Category A </div>
<div class="portlet-content">
[Code]....
I also have a stored procedure from the database developer that return the list of categories. Depending on the user selection, the list of categories can vary.
So i have to dynamically create those Boxes. Each categories returned by the SP should replace Category A, Category B, and so on. As i can't know the number of categories returned by the SP i just hard coded those divs. My question is simply how ? How can i achieve this?
I have to be using VB.net in VS 2010. The database is in SQL server 2008.