I have a form that requires 5 columns of textboxes that the user will populate. By design I will provide the first row but, the user will need the ability to add or delete subsequent rows. Is there an easy way to approach this requirement?
View 19 RepliesI need some input refactoring an asp.net (c#) application that is basically a framework for creating dynamic forms (any forms). From a high level point of view, there is a table that has the forms, and then there is a table that has all the form fields, where it is one to many between the two. There is a validation table, where each field can have multiple types of validation, and it is a one to many from the form fields table to the validation table.
So the issue is that this application has been sold as the be-all-end-all customizable solution to all the clients. So, the idea is whatever form they want, we can build it jsut using DB configurations. The thing is, that is not always possible, because there is complex relationship between the fields, and complex relationship between the forms themselves. Also, there is only once codebase, and this is for multiple clients - all of whom host it on their own. There is very specific logic for each of the clients, and they are ALL in the same codebase, with no real separation. Sometimes it was too difficult to make it generic, so there are instances where it has hard coded logic (as in if formID = XXX then do _). You can also have nested forms, as in, one set of fields on its own within each form.
So usually, when one client requests a change, we make the change and deploy it to that client - but then another client requests a different change, and we make the change and deploy it for THAT client, but the change from the earlier client breaks it, and its a headache trying to debug, because EVERYTHING is dynamic. There is no way we can rollback the earlier change, because then the other client would be screwed.
Its not done in a real 3-tier architecture - its a web site with references to a DB class, and a class library. There is business logic in the web site itself, in the class library, and the database stored procs (Validation is done in the stored procs).
I think this is a bad model in general, because one of the things I heard one of the developers say is that anytime any client makes a change, we should deploy to everybody - but that is not realistic, if we have say 20 clients - there will need to be regression testing on EVERYTHING, since we don't know the impact...There are about 100 forms in total, and their is some similarity in them (not much). But I think the idea that a dynamic engine can solve ALL form requests was not realistic as well. Clients come up with the most weird requests. For example, they have this engine doing a regular data entry form AND a search form.
There is a lot of preserving state between pages, and it is all done using session variables, which is ok, except that it is not really tracked, and so sessions from the same user keep getting overwritten, and I think sessions should be got rid of.Should I really just rewrite the whole thing? This app is about 3 years old, and there has been lots of testing and things done, and serious business logic implemented, so I hate to get rid of all that (joel's advice). But its really a mess of a sphagetti code, and everything takes forever to do, and things break all the time because of minor changes.
I've been reading Martin Fowlers "Refactoring" and Michael Feathers "working effectively with legacy code" - and they are good, but I feel they were written for an application that was 'slightly' better architected, where it is still a 3-tiered architecture, and there is 'some' resemblance of logic..
I have a reguirement to enable the creation of excel workbooks from sql stored procedure. To do this I want to create a vb class to generate and save the excel files. Then and ASP.net page will enable opening the excel file via the browser or enable the user to download the file.The class should be able to be called from a vareity of pages within the web app and have the ability to handle 8 to 10 separate stored procedures that will return various data sets.
View 2 RepliesI'm trying to build a form which generates itself as it is used. I have created a really simplistic example, loosely related to what I'm trying to do below, but which demonstrates the problem.The user types a word in the text box, clicks the Button and a new TextBox is loaded into a Panel, with the value in the original TextBox that the user has entered. The user should then be able to type something else/the same and create another text box with that in it by clicking the button, basically permitting 0,1,..,n textboxes appearing above the "txtFeeder" TextBox on the form.The problem is that everytime you click the button, it doesn't add a new control, it seems to just update the one that has already been created with the new (incremental) ID. I'm not sure if I'm doing something wrong, or if what I'm trying to do can't be done (which I find hard to believe)?Here's the .aspx...
<form id="frmMain" runat="server">
<asp:Panel ID="pnlAdded" runat="server"></asp:Panel>
<asp:TextBox ID="txtFeeder" runat="server"></asp:TextBox>[code].....
How can i add columns to rdlc report at runtime in windows based application using vb.net
View 1 RepliesI am trying to get the hang of Dynamic loading of objects from assemblies on the same machine (But NOT part of the same project).In the sample below, Form1 implements an interface built as part of the .dll I placed in C:Release. I am trying to create a local instance of Form1, and Cast it as Iform, so that the local code can access the properties and methods exposed by the interface.The assumption here is that at runtime, local code will have access to the String name of a form, and an interface which is implemented by the form (and is compiled into the .dll as well as the client application), and that is it.
When I run this code, I get a exception: "Unable to cast object of type 'WindowsApplication1.Form1' to type 'WindowsApplication1.Iform'.
Public Function fApplicationObject() As Iform
Dim sLocation As String = "C:ReleaseWindowsApplication1.dll"
Dim sType As String = "WindowsApplication1.Form1"
[code]....
I seem unable to dynamically load an object from a dll and then utilize an interface to access it's properties and such.
I am trying to make a program that will include a drag/drop view where you can arrange objects around in a view and add/delete objects as needed (objects are actually controls I create dynamically), I have made some code which I include below.If I run this code it works but not the part when I click on a newly created control, then mousemove function is not used, I should be able to move controls using the mouse functions..but these do not work. I thought code like:
AddHandler logicif(i).MouseMove, AddressOf logicif_MouseMove
should work! Can anyone give me pointers on what I am missing?
Public Class Form1
Dim logicif(20) As Panel
Dim count = 0
[code]....
Every time i enter set of values like Group Name,Group Abbreviation,URL in the text boxes and click the save button automatically its saves in the database and for each set of values a new details view has to be generated dynamically with a web panel and the header of the web panel should have the value of Group Name.
Example:
[Code].....
A new details view with web panel like the above has to be generated every time the save button is clicked.
Can i create a table with the input taken from user at runtime from vb.net.?
From vb.net in sqlserver 2008
I'm currently working on a program where I'm trying to dynamically create a picture box, a button, and a label for each item in a text file. Any ideas on how to do this? What I have: a plain text file with a list of numbers. Each number corresponds to a location. When that file is read, I want to create a picture box, a button, and a label related to each number. If I want to add something to the screen, all I Have to do is add a number to the file. So, lets say the file has. 1, 2
When the file loads, it will create a unique item on the display for each location. say pic1, button1, and label1 and pic2, button2, and label2. Right now, if I add something to the file, I have to go back into the editor and manually add everything. Which is a pain.
I have started a new blank project for VB 2007. I have taken the old code (VB 2003) and added it to the project.The line marked below worked on the old VB, now it does not. I get the following error:
Object reference not set to an instance of an object.
Troubleshooting tips:
Use the "new" keyword to create an object instance.
Check to determine if the object is null before calling the method.I have tried several forms of using the "New" keyword and still get the error.
Public Sub BuildChooseFileMenuItems()
Dim k As Integer
Dim numChecked As Integer
[code].....
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 RepliesI've been trying to learn enough to develop the family tree diagram and making progress.[URL]..It illustrates many of the drawing, saving, re-opening, editing, drag/drop features that the family tree diagram would need, and is a good starting point.
To adapt this for the project, after searching for snippets online, I've tried to add dynamic insertion of a label as a start (eventually, it should be a textbox that the user, in runtime, can enter text into, save, re-open, edit). But, I can't get this to work. No errors display, but I must be doing something wrong.
Here's the label code which I've so far appended at the end:
[Code]...
I started editing an existing code (basicaly to learn vb) without any real previou experience. Well let's get to the point; I have a form that gathers data from db ordering by user ID (on click count). I have one DataGridView with a list of user, some have data in db, some have not. I came so far that if I CLICK on a user that have data, all data is dissplayed in 6 dinamyc textboxes. If user has no data inly first (emty) row with 6 dinamyc textboxes is created.
Then I have a button that simultaneously adds a row of dinamyc textboxes bellow and multiplyies textbox04 (name is clickcount & 4) and textbox05 and displays the result in textbox06. I want to add a messagebox that shows if textbox04 & 05 are empty and in that case exits sub. Of course if they are not empty, their sum should be multiplyed in textbox06 (on 2 decimal places exact) Here is my code so far:
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Reset warnings
[Code].....
I am creating dynamic text boxes on button click and then showing values on another button click. It works fine until I use ajax updatepanel. In that case values are not shown when I hit second button. My aspx code is:
aspx markup is:
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<div id="divRT" runat="server">
[Code].....
If i have multiple textboxes with the same Id and name in a form, how to fetch there values separately in vb.net? in javascript iv used fetched them like this
[Code]...
I have a code in Save Button, and part of it, a code that checks if the dynamic text boxes that has been created is empty. But when the system runs, it only check the first set of text box and an an message appears "Collection was Modified; enumareation operation may not execute.".
Here's the code:
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Try
For Each txt As TextBox In TextBoxes2
If String.IsNullOrEmpty(txt.Text) Then
[Code]...
I have to delete all the textboxes after I clicked the Save button, I have a delete code here that deletes the textboxes one by one. I'm just starting in vb.net.
Public Class FunctionProcessor
Dim TextBoxes1 As List(Of DateTimePicker) = New List(Of DateTimePicker)
Dim TextBoxes2 As List(Of TextBox) = New List(Of TextBox)
[Code].....
I have 10 textboxes. I want to make a certain number of these textboxes visible. The user enters a number from 1 to 10 to determine how many textboxes are visible.The textboxes are named textbox1, textbox2, .... , textbox10How do I set up a simple for loop to accomplish this?
View 2 RepliesIn my form, A user can do some stuff on my program which will create a new tabpage with a text box on it. The user also selects the name of the tab, which is then the name of the textbox with a "2" on the end of it.
What I need to know is how to get the texts from however many tabpage's textboxes there are and combine them into one textbox, as a sort of receipt.
What I was thinking, because I have this method of removing all the tabpages, is using a code like the one below maybe to do the job, not sure how I would alter it to work though. [code]...
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]...
I have a web page with 5 checkboxes and 2 textboxes per checkbox. When the user checks one or more checkboxes the corresponding textboxes become enalbed for UI. I need to insure that the input for the textboxes is an integer-that I will do with a validators. There is a gridView on the same page. When the user checks one or more checkboxes the 2 columns of the gridView rows become active for input through enabled textboxes.
There are 4 columns in the grid. The minimum number of rows enabled are 2 and the maximum are 26. The UI for the grid's textbox input is numbers. Those numbers have to be equal to or less than the total. How do I validate UI of numbers(integers) into the grid's dynamically generated textboxes and then add the total and compare it to the alloted total? I prefer to do this with the code behind - using VB.NET - rather than with ASP.NET or absolutely not javascript.
I have 12 textboxes named TextBox1 to TextBox12. How can I loop through these textboxes to assign and read the values? I.e.:
Dim strTextboxName As String
For i As Integer = 1 To 12
strTextboxName = "TextBox" & i
TextBox{i}.Text = ...... ?????
Next
I'm just getting back into programming after a few years break and I'm a little clueless as to how I would achieve a small part of a project to get my back into the swing of things.Basically we have a command that sets what the machine does at a certain time of the day. This command has a limit of 8 steps and always has to equal 1440 (24hrs).An example of this command would be: 001*A*480*B*60*C*600*A*300
So this would do..
"A" during 00:00-08:00
"B" till 09:00
"C" till 19:00
"A" till 24:00
I can do the easy part i.e. split them up but I would like someway of dynamically creating another text box if they dont add up to 1440 (I am okay with doing dynamic text boxes and have the findcontrol stuff i guess its just updating the x and y axis on the boxes below so it looks neat?)
I could do 8 textboxes etc but we can have upto 8 of these commands wanting to display on one tab.
i have created a dynamic tabpage and a dynamic tablelayoutpanel inside it then added dynamic textboxes and labels inside the tablelayoutpanel...the thing is , i am having a problem on how to access the value of those textboxes and labels and add them as new columns in the new table(tagpage) in mysql database, i can already create the table in the database but i cant add the new columns in it. heres the code for accessing the values of the labels and textboxes
error: NullReferenceException was unhandled....Object variable or With block variable not set.
sql = "alter table " & tbl_selected(counter) & " add " & frmMain.Controls("TLP_" & SecArrList_sp(counter2)).controls.item(SecArrList_sp(counter2) & "label" & counter).Text & " varchar(100) NULL;"
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.
On my form, i've got some textboxes and some richtextboxes. I'm using the following code, to search through the text properties of each of the two types of control. see below:-
For Each ctl As Control In Me.Controls
If ctl.Text = "7777" Then
ctl.Text = "found the sevens"
End If
Next
What i'd like to do is isolate the textboxes only, is there a way to do that? I tried this but i got an error:-
For Each box As TextBox In Me.Controls
If box.Text = "7777" Then
box.Text = "Found"
End If
Next
Basically i have one TabControl with a form and 2 browsers within one form I have ProBlem To call the dynamic browser to navigate with dynamic Textbox.text
[Code]...
My goal is to, Pull information from a websight's textboxes in IE into my program textboxes. and to later Put changes from into other values on the websight from my program into it. The sight has multiple textboxes, on different frames. within it.I need to keep it as a exsiting open browser instead of making a new one. only gotten as far as finding the open internet explorer window, by useing
[Code]...
I need to represent the following query using LINQ:
DECLARE @PurchasedInventoryItemID Int = 2
DECLARE @PurchasedInventorySectionID Int = 0
DECLARE @PurchasedInventoryItem_PurchasingCategoryID Int = 3
DECLARE @PurchasedInventorySection_PurchasingCategoryID Int = 0
[code]....
Now, I know that a query in .NET doesnt look like this, this is my test in the SQL Design Studio. Naturally VB.NET variables will be used in place of the SQL local variables.My problem is this: All of the conditions after "WHERE" are optional. In that a query might be made that uses one, some, all, or none of the conditions. V.PropertyID and V.Value can also appear any number of times.In VB.NET I can make this query easy enough by simply concatenating strings, and using a loop to append the "V.PropertyID/V.Value" conditions.I can also make a Stored Procedure in MS SQL, which is easy enough.However, I want to accomplish this using LINQ.