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
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 have to create buttons at rum time based on database records and implement their events.
View 5 RepliesI have decided I would start small and make a program that would create a "receipt" list in a listbox and a total. Now, I would like the user to be able to add their own "menu" items. I'm assuming the best way to go about this would be to have them actually add it to a database and then a function in the program will refresh the dataset with the new list. However, this is where my problem lies. How can I tell VB .net 2010 that I want to create a new button (or buttons) on the fly, in an orderly pattern on the form, based on the input from a DB?
View 10 RepliesI 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]...
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.
I have an application I am creating that displays pump information based on customers in a database. I am using VB2008 .NET3.5.I have a combobox that has a selection for a unit of measure. What I want to happen is when that is changes the labels that have a unit of measure change to reflect the change. There are 15 labels total that need to be changed and all there names are the only ones in the project that start with a X if that helps at all.
I would like to avoid creating a bunch of labels and changing the visible property and just change the text value of each one. I have just started learning VB.NET
I am wanting to create a menu based on items in my MS SQL database i have 3 tables
FormTbl
FormID - Int Eg (1)
FormName - nvarchar(50) Eg (Form1)
[CODE]...................
I can get the form names to be populated in to the menu and can open it my question is how do i set where the menu items will be placed. Eg File with FormHierarch 0 will be the very first one. Exit with FormHierarch 0.1 will be the very first one under File
Private Sub Main_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim menu As New MenuStrip()
Dim dst As DataTable = User.MenuItems(Me.ToolStripStatusLabel1.Text)
[CODE].....................................
I basically want to do what you can do for controls like the textbox where adding a new textbox automatically autonumbers itself based on the existing textboxes(e.g. textbox1,textbox2, textbox3) except for an array or some other comparable instrument.
View 5 RepliesI use Visual Studio 2010 and SQL Server 2008 R2. I have created an Entity Model in a class library which I have referenced in a VB Winforms project. I created a data source in the project based on the entity model in the dll. However, all columns in the data source are listed in alphabetical order instead of the native order from the SQL Server database. I cannot locate the cause of this as much as I try.
This might not seem a huge problem, but it is costing me valuable time in rearranging controls dragged to forms and reindexing their tabstop indexes.
I get the following string expression provided:"ChildObject.FullName" ...where ChildObject is an instance property on the MyObject1 type.ChildObject has a property named "FullName" and I want to sort a collection of type "MyObject1" based on this child properties "FullName" value.
I can do this all day long on properties directly on MyObject1 but I run into 2 challanges when doing it on a child instance and I can't get all the pieces working. The main 2 challanges are:
MyObject1 has a few different child property types so I can't hardcode the type for ChildObject. The string could be of any type.The sort expression is a String and not a known type.Above the value returned from the last line in the expression (if I run the code outsode the OrderBy method, does provide me the 'FullName' information I need. So the code must be close, but it still does not work.
Any ideas on how I can accomplish this? What I am trying to prevent is hardcoding a series of 'If' blocks on the child's type to then hardcode in its type to the sort or OrderBy method.
I've inherited some code (not mine- I swear!) which uses a session variable in the header of the HTML to determine which javascript file to link to.
i.e.
CODE:
It does work, except that it won't let me change to design view. It gives the message
"Could not open in design view. Quote Values differently inside a '<%... "value" ...%>' block."
I plan on using SQL Standard as the db, and VB to create the app. I am not sure what the easiest/best query solution is. Crystal Reports? Or?
View 1 RepliesI am trying to create a program to order pizza what i have is a textbox to input the customers name, i have a masked textbox for the phone number, a group of two radio buttons for pick up or delivery with if delivery is selected a rich text box appears to input an address, a group of 3 radio buttons for pizza size s,m,l and then also a list box with 10 items for toppings what i want is when i hit the order button for the selected buttons and inputted info to generate a order summary on another form?
View 6 RepliesFor 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 RepliesI'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.
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.
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 RepliesWe 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.
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 RepliesEssentially 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 RepliesI 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?
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.
I have an ASP project which references a WCF service. Does exactly half of what I need.
A button on the page calls a function from the WCF, which returns a list of objects (variable names). When returned, the vb code dynamically adds textboxes to a panel on the page.[code]...
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 Repliesi 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 RepliesI 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..
I've created some dynamic controls on page load and added an event handler to handle the click event of a dynamic link button. Within the sub of the click event handler, I need to reference some other (non-dynamic) controls on the page and change their value. However, I get a null reference exception - object not set to an instance of an object - each time I try to reference a control on the page (in this case label1). What am I doing wrong in creating these dynamic controls or with my event handler?
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'Get the data to populate the controls
[Code]....
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].....