Creating Dynamic Array Based On SQL Count?
Sep 15, 2009
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]....
View 5 Replies
ADVERTISEMENT
Aug 5, 2011
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
View 2 Replies
Jul 20, 2009
ArrayList is a generic structure. Let's say I have my own structure (contained of Boolean+string+int). I want to set a dynamic array based on my own structure. How....?
View 9 Replies
Sep 20, 2009
[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]...
View 2 Replies
Oct 31, 2011
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?
View 2 Replies
Apr 26, 2012
I have a array based on a structure that I want to build a datatable from. Here is what my structure looks like currently,
Public Structure QRQFiles
Public Complex As String
Public DescriptiveName As String[code]....
Since I have a structure with in the structure will I have to define two datatables to represent this?
View 5 Replies
May 1, 2009
how to write the code for my project.I am to base my new project on an existing one(existing one has code that works 100%)and create an Array of a structure that bascially holds the information from a summary form AND the totals from an AddToOrder_Click event. If you are still with me)... I cant figure out what the code is for my structure and Array so that I STILL have a Summary Form but I have an array that shows when I click my PrintPreview. So an Array is basically a "space" that holds information, like my summary form except it doesnt show until I click PrintPreview right?
If I just wanted to show the table then my code belongs in the PrintDocument1_PrintPage to show the array but the actual structure code belongs in the Click_Event of my AddToOrder? Please Please understand I AM NOT asking for anyone to write my code, basically I am asking for some clarification on what exactly creating an array from a structure is and therefore determing where the structure is to be placed in my code..
View 6 Replies
Feb 5, 2010
I would like to bind a DataGridView to a different LINQ query every time (in order to reuse the same form/DGV for different queries), like this:
[Code]....
but the "Qry", and the number of comboboxes, and their field names would change every time.
View 5 Replies
Oct 8, 2009
I have a fair bit of experience with VB.NET and C# (In this case I chose VB.NET, blame my laziness), but I do most of my professional work using PHP. I have no experience what so ever in using any database with VB.NET let alone MySQL.Just FYI, at the moment I am only trying to Query the database to gather the information required to activate. The Activation wizard and algorithm building (which is finished anyway), and everything else will come soon. I chose the MySQL database because I have experience with it, and it seems the best option for remote usage.The whole idea already works in PHP, I'm just have major issues moving it accross into VB.NET (Using the MySQL Connector.NET);I understand the basics, and all I need to know how to do is Count Rows and gain access to the other information in a row based on provoided information (in PHP, through mysql_ result)
So, here goes nothing, this is the Query code I am using in PHP to complete the job I want to do in VB.NET. [code] As you can see, I basically need to get the PHP code into VB.NET to fit into the 'btnQueryDB.Click' Command in VB.NET. By Equivalent, the Product ID in VB.NET will come from 'txtPID' and similar, Serial Number will come from txtSNUM. Once counted to be 1, the Activation Code and Status will be fed into 2 other text boxes in the form. (acCode, and acStatus).
View 3 Replies
Nov 13, 2009
I've tried searching on this but can't seem to find an answer anywhere, so hopefully someone here can help. I want to insert an conditional XML tag based on whether or not a count is above one, but am not sure how to do it.For example, I have two XElements that are like this:
<Blob>
<Group>
Stuff 1
</Group>
</Blob>
[Code]...
But that is not working. Does anyone have a way to do this from within the XML Literal as desired above?
View 1 Replies
Jun 21, 2010
I have a form that needs to create textboxes based off the count of rows in my dataset table. The amount of rows could vary from 10 to 20, so I need a loop to add the textboxes to add the textboxes on load. Right now I have the loop down and other things shown below.[code]...
View 7 Replies
Jun 22, 2011
How to get word count from a word document based on the page
How to get text from a word document based on the page[code]...
View 1 Replies
Feb 26, 2009
If it's 0-based, how can we add a placeholder to make it 1-based?
View 4 Replies
May 11, 2009
I am trying to figure the best way to programmatically re-size table column headers in ReportViewer.Basically, my current resolution is the following: ColumnWidth = Header Caption_CharacterCount * 0.32...Where 0.32 is an estimated width of a typical character using my current font size.The issue is that the width leaves a lot of whitespace for longer captions.The more characters a caption has, the more whitespace I end up with.The issue with estimating this way is that not all characters are the same width. A good example would the the "I" character, which takes up less screen width than the rest of the alphabet.[code]
View 1 Replies
Feb 15, 2009
I have two multiline textboxes, and I want to compare and count the text differences between them. The algorithm appears very complex.. To be exact, I need to check for the spelling mistakes (spaces and newlines can be ignored..)
View 6 Replies
Jun 5, 2012
I'm trying to figure the best way to verify the contents of a folder based on another count via a listbox. Here is my current code to count the number of PDFs in two different locations and total them together for a grand total.
'counts test1 pdfs
Dim f As String, c As Long
[code]....
I have another process before this that will create the PDF's based on the files listed in the listbox.What I am having trouble with is verifying that the PDFs that are created in the Test1 and Test2 folders equal the counts from the listboxes. This count needs to match before running the next process. I'm kind looking for wait or loop until both counts match, again before running the next process.
View 2 Replies
Nov 10, 2010
For comparison: something like the shirt builder application at [URL]Say, if I have fabric image and want to generate base, collar, cuff etc. How should I do it on server side in .NET, and generate different components of shirt.
View 1 Replies
Aug 16, 2010
I'm making a new design for my website, but I want to keep the old one and possibly switch between the two.
Unfortunately, I've changed the content on the Master Page (luckily I have a backup).What I was thinking was to keep separate master files for each theme, and then just determine which one to server based on which stylesheet is loaded.
The only way I can think to do this is to keep a "settings" file on the website that has a "stylesheet=1/2/3/4/etc" line. Depending on the number there, the server will serve the correct master page.
Alternatively it might be easier to do something similar, but instead of serving a whole different master page, set a specific stylesheet to use.In both cases, I need a little help with actually doing the work on the server. I can read a text file (even encrypt/decrypt a file before and after it gets read for security), but actually giving the server the instructions based on what is read is where I'm lost.
View 2 Replies
Jun 2, 2011
I have an array filled with values from Excel cells. Each of the values is a concatenation of two things separated by a pipe, like "Machines|MachinesCode"
I need to, as I fill this array, strip out the pipe and everything in front of it so that the array being filled is only filled with the "MachinesCode" part of the cell value, but I haven't had much luck finding how I should do this. Each cell is dynamically filled and will never have a set length, so I can't set a trip by a particular number value of characters in the strings.
This subroutine is what I'm using. I am filling array FieldArray with another array (ExcelArray) currently holding the concatenated values.
Public Shared Sub PopulateFieldArray(ByRef FieldArray() As String, ByVal iFieldCount As Integer, ByVal ExcelArray(,) As Object)
Dim iIndex As Integer
For iIndex = 1 To iFieldCount
FieldArray(iIndex) = CStr(ExcelArray(2, iIndex))
Next
End Sub
But I don't know what to wrap around the CStr Excel array to cut off the pipe and all values before it while I fill FieldArray.
View 5 Replies
Nov 9, 2011
When i press W, i'm creating a dynamic picturebox of a bullet but i have no clue how to make it move to the target.I can create myself a picturebox and call it picBullet1, but what about bullet 2, 3,4 etc? what should i read/learn?
View 3 Replies
Nov 2, 2009
We have a GUI that displays a radio selection box (3 options) that are the three sites where our hospitals are. We need to dropdown located on the form to fill with only the locations based on the selected radio option.
Here is the code behind we have so far (sorry, VB)
[Code]....
For the record the Location dropdown is currently databound but its a static SELECT statement which brings us all the locations but we'd prefer it to be cleaner if it only returned the locations based on Site. We are using Visual Basic 2008 Express Edition for development.
View 2 Replies
Apr 9, 2009
i saw jim example in the codebank and i added the percent progress parameter to report progress method (to change the progress bar value)this is jim example:-
vb.net
Private Sub BackgroundWorker1_DoWork(ByVal sender As Object, _
ByVal e As DoWorkEventArgs) Handles BackgroundWorker1.DoWork
[code]....
View 2 Replies
Mar 10, 2011
Essentially what I want to do is have a few pages that act as templates for data. If a url is url... I want to query a friendly url field for "/home" which would return url...
View 1 Replies
Jan 1, 2012
I have done this in Php with a function before. I just don't know how to do it in VB.I have a character sheet creator for a game I am making. What I am wanting to do is write a single function, where in you click on a button and it will pass the text box name (so that it knows which text box to edit), as well as the value inside of the text box (to make sure that the new character stat ceiling is taken into account).
Private Sub Button_Click
AddtoValue(Textbox1,stats)
End Sub[code].....
Essentially, I need to know what to put for noidea, and noidea2, like, byval or byref or what?
View 3 Replies
Feb 11, 2009
I am attempting to set up a datagridview that is dynamic based on user input. The user input is a start and end date. The start date defines the first column the next column is the next date... until the end date (x-axis). The y-axis is technicians and the fields will show the assignment for the technician on that date.
All the advise I am seeing on datagridviews is to create a property methods to provide the information for each column. for example:
Dim 12-Oct-2009 as string
Dim 13-Oct-2009 as string
[Code]...
How do I create a object data source that allows me to populate the data grid? I want the column headers to be included as a string in row 0 of the multidimensional array. The amount of columns will be dynamic with a minimum of 1 and maximum viewing of 100 days based on what dates are selected in the start date and end date fields.The input dates will be used to generate a query to a database that will populate the multidimensional array.One solution I see is pick a start date and have a set number of dates and code for set number of columns (100) in a row and then set the names of the columns dynamically...ahhhh code repetition!
I am not sure how else to do this but looking for a more suttle way.I am using this to create a simple scheduling tool to see resource schedules by date. There is an unmoveable end date so initially I will need to look ahead 100 days but as the end date gets closer, I will have fewer and fewer dates. So eventually the end date will be that start date.
View 3 Replies
Jan 27, 2011
My page has a drop down whose values are dynamically populated. Based on which item is selected, a number of TextBoxes are dynamically created during runtime.The user then fills in information into the textboxes and clicks a submit button.After postback from the submit button, I need to again dynamically create the TextBoxes during Page_Init (BEFORE LoadViewState) so that after the ViewState loads, my Button_Click event can save/do whatever with the user input. PROBLEM is, I cannot recreate the textboxes based on the selection in the dropdown, because the dropdown hasn't been "selected" yet by LoadViewState.SO, how can I read from the view state, create my textboxes, then let the viewstate populate the textboxes, and then the Button_Click will use the values??The one thing I've attempted is to override the LoadViewState function so that I can read from the view state, create the boxes, and then load the viewstate again. This did NOT work, because the debugger never seemed to hit my overridden function.[code]
View 1 Replies
Apr 20, 2012
i need to create sql tables based on user needs lets say a guy needs a table of 4 rows 5 columns other user needs 3 rows 3 columns each with different types so how is the best way for letting them choose like they write in a text box ( this will be the value of rows)4 and another text bvox the count of columns and i have those 2( rows and columns needed) numbers i create the table as is.based on those. by default i create type as varchar max then later on we must fill the table using datagrid.
View 14 Replies
Oct 26, 2011
I have a bit of a tricky scenario. It consists of some partial problems for which I have individually found solutions, but I couldn't find anything that makes it all work together smoothly.
-Upon selecting an item in a datagrid, a new page loads with the details regarding that entity.
-The entity represents a product that can have any amount of variants (such as a t-shirt's color or size)
-I dynamically add dropdownlists to this detail-page that represent these variants (there can be any amount of variants, and each variant can have any amount of different values, each value or combination or values from different variants representing a unique product entity)
-Upon selecting a different variant in a dropdown, a delegate is called that will change the session variable to the productId associated with the selected variant and a postback is fired that will reload the page with new data based on this productId
The problem: the postback is fired BEFORE the dropdownlist's (OnSelectedIndexChanged) delegate is called. Since this delegate defines the productId in the session, the new to-be-used productId isn't known at the time of postback.
Result: loading the correct data in the page is always delayed by one postback. Each time I change the selected index of any of the dropdowns, the page is loaded with data based on the session variable that the PREVIOUS OnSelectedIndexChanged delegate of the dropdown set.
I have a LoadData() method that sets the values of all textboxes, fields, labels etc. based on the productId stored in the current session. This method is called on Page_Load.
Private Property CurrentProduct As Product
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
LoadData()
[Code] .....
It seems that I haven't been completely clear on what does and doesn't apply to this scenario regarding Page Lifecycle.
1) My dropdownlists are added dynamically, which works fine on the first page_load.
2) The content of the dropdownlists is defined by what entity's details i'm loading on the page.
3) What entity's details I'm loading on the page is at first(not-postback) defined by the product I selected in a gridview in the previous page.
4) At postback, this entity is based on a sessionvariable containing the id of the entity.
5) This session variable is defined by what item in the dropdownlist I select.
6) This dropdownlist dissapears after postback since it's not defined on the page, but dynamically. So is the event.
So my guess would go towards some clientside script that stored the selected value before postback, but then I would be clueless on how to get that variable to the server since the logic that retrieves the entity is in the business logic layer which is far away from this page..
View 3 Replies
Jul 13, 2010
i have an array contains a-z.Then i have a textbox and when click on the button, it will replace the text inside the textbox to the index number of the array.Example, from "abc" will become "0 1 2" The code below do the job.how to do so that i can replace the text inside the textbox from "0 1 2" back to "abc" based on the array?
Dim txtKey As String = readKeyTxt.Text
readKeyTxt.Text = ""
For Each b As String In txtKey[code].....
View 2 Replies
Nov 5, 2011
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
View 3 Replies
