I'm looking for a recursive subroutine.I have the dataset from sql-server with in the datasource-table a parent- and a child-column.
I made a routine to put the parent-nodes in the tree.The problem starts with the childs over so many levels.I can write it out but it is to much code, I'm sure it can be done more efficient with a recursive subroutine.
The tree will be about 25 levels deep.A few days ago I saw a recursive subroutine to fill the childnodes without the above difficulty to write alle the levels in code.That example I cannot find it any more, but it had a line of code more or less like this here below:
Dim
Nodes As TreeNodeCollection = tv.Nodes(A).Nodes
I have a requirement to create a multi level treeview in ASP.Net (with VB) but I am completely stuck on how to start this. Currently my treeview is a fixed 2 level approach but now I need to rewrite this to be more dynamic and support extra levels being added into our database tables.So this treeview needs to support as many levels as needed without having to rewrite any code each time we want to add new level, Ideally we will just insert the data at the database level.I think I have the database part designed correctly, I created 2 tables Menu and MenuItemsMenu has 2 columns ItemID and ChildIDMenuItems has 2 columns ItemID and Description Doing this query:
I have a database with values as shown in the attached image "Image1.jpg". There are multiple other columns not shown on the screenshot (over 30), for the sake of this question we'll say I'm interested in columns called "Col1", "Col2", "Col3" & "Col4".
I was able to get this information automatically filled into a TreeView as shown on attached image "Image2.jpg".
At this point I also want to fill a DataGridView from the same database.
I managed to accomplish this with the following
Private Sub FillDataGrid() Dim DA As New OleDbDataAdapter Dim DS As New DataSet
[Code]....
But unfortunately this uses the manual binding of data to the DataGridView, which I'm sorry to say I struggled to "convert" if you like, to using SQL commands and coding to connect a database to DataGridView.
How to fill a TreeView from two related tables (Customers 1 -> Products n)? I have seen the example of microsoft using Northwin Database and I do not understand this, I need something simpler.
I am after some GDI+ help, Basically I have an LED display which for example is 300 LEDs wide by 300 LED's deep, so you could say it has a resolution of 300x300.I am intending to use windows to process images ready to be sent to the display (as the display is dumb and simply displays what it is sent, But I require that the images are animated as well as static sort of like the basic PowerPoint animations (scroll on/off etc).to achieve this I need to write some code that creates frames much like gif's. So to scroll a 300x300 image onto the display I would need 300 separate frames.
So I have written the following code that uses the GDI+ objects to build the frames needed to scroll an image from the right or left.
I have created a form with a tab control that I want to be able to make a copy of in such a way that all the child controls and their data are copied as well. I have tried this: Dim NewPage as TabPage = tcViews.TabPages.Item(0) tcViews.TabPages.Add(NewPage)
I end up with a reference to the first page. That is, if I change something in the old page, it changes in the new one as well. I believe this is because VB.NET treats assignments of classes as references, rather than values. Hence only the memory address of the original is copied, so essentially both refer to the same tab page in memory. I also tried serialization and deserialization.
The TabPage is apparently not serializable. And I heard about MemberwiseClone, but it isn't accessible, according to Visual Studio. There doesn't appear to be a Clone method available either. How do I make a new tab page that is totally independent of the original, but that has copies of the original page's controls and their property data, which can then be edited independently of the originals?
Shallow vs. Deep copies of objects. Why would anyone want a shallow copy of, say, a multidimensional array?! If I wanted something to act just like something else (and this is what shallow copies do), why would I create a second instance to do what the 1st instance does already? I think I understand the point of objects and that just copying the contents of one object to another does not make them independent, but it seems that the whole point of doing:
If I have a generic.list(of ClassA), is there a simple way to create a deep copy of this list that will not affect the original copy? It seems to work if I have a generic list of Structures, but for some reason the copy constructor for lists of classes only copies pointers to the elements (or maybe a pointer to the whole list?). I would move to structures if it were not for the fact that I can't find a way to edit the members in the structs in the list. eg:list(0).a = 5 'Does not workIs there some way to get around this without declaring an instance of that structure, like this:dim str as StructA = list(0)str.a = 5I'd
If I instantiate an object within a function in VB.NET and return it, does it return it be reference or by value. IE - should I be worried about performance if I write something like this:
Public Function ret_obj_func() As big_object Dim ret_obj As New big_obj(<lots of stuff>) Return ret_obj End Function
If I call this function from somewhere else, will it instantiate the object in the ret_obj and then create a deep copy to pass back a copy to the caller, Or will it just pass back a reference?
I have a button ad a list box, the button when clicked lets the user select a directory on the HDD, and then the app is meant to list all the sub directory's of that folder int he list box. However I cant seem to get it to list just the sub directory names, not the full paths, and also to only scan by 1 folder deep (selected foldersub folder).
i have a login form and it has 3 user levels - admin, manager & accountant - which have limited privileges using the system. For ex., if admin logged in, this user can access the whole system; if manager logged in, this user can only access the employee records; & accountant user can only access the payroll.
i actually have the idea but because i lack knowledge about vb.net, i don't know how to code it.
[code..]
At the main menu, buttons are enabled & disabled depending on the user level that was entered.
Following up on my question yesterday to deepcopy an object with events in C# and attach the events of the original object to the Cloned copy is pretty easy, you just set the Event declaration in the Copy = the value in the original. Deep Clone when events are attached. How do you do this in VB.Net? (Using .Net 2). Maybe there was something with reflection where you can examine what events are bound and somehow transfer those to the new object.
hello everyone, i m using treeview control in vb .net . How do we usee a recursive function to add data at different levels from different tables in a database.
Let's say I have three lists: Departments, Divisions, and Groups. A Department is made up of Divisions, which in turn is made up of Groups.The Divisions have the Department ID as a foreign key. The Groups have the Division ID as a foreign key.I'd like to produce a report that looks like this:
[code]...
But since I can't include a subreport within a subreport, I'll need to go about it some other way. Is there a way to do this?
i'm developing an application with vb.net and mysql. I want to add additional users to the application but with different access levels. this is my original code [code]If i add a third parameter named level to the sql statement, how do i determine which form shows???
I need to create an application that allows staff members to login and see different things.I need to be able to have different user levels for this so that certain staff can see some things and other staff can't.I would like the login system powered by the MS SQL Database that the rest of the programs data is stored in.
I want to use a DataGridView to show parent-records that are expandable to show children records. Basically, the top-level data shows class names, and expanding each class name shows the students enrolled in that class... that kind of thing.
Essentially what I want to do is copy a WebBrowser object such that I can do the equivalent of "Open In New Tab" or "Open In New Window" actions, maintaining any posted data. I don't just want to navigate to the same URL as in the original WebBrowser object, rather I want to repeat the HttpWebRequest.
I have an object (a third component gridview) which is serializable, and I need a deep clone of this object. I have the following code which throws the exception."The type System.Windows.Forms.Control in assembly System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKey Token=b77a5c5 61934e089 is not serializable".So the gridview's base class is System.Windows.Forms.Control, which is not serializable. How can I get a deep clone from the gridview? [code]
With a steady tone feeding my audio input jack, the VU meters jump and bounce about 30%. I can also see the problem in the byte array of the capture buffer. I am running 8 bit mono so there isn't a chance that I'm getting a byte swap in a 16 bit word. My on board sound card is "Realtek HD Audio Input", direct sound 1.0.2902.0 and XP. Here is the real kick in the head, if I run anything that captures sound using the winmm library or if I use the winmm library in my application along with direct sound, the meters become stable. No errors are reported. Although I have written this in vb.net, I download another persons application that was written in C++ that uses direct sound with the same bouncing meters. I used the VU meters in Audacity to look at my audio levels and they are stable.
I am working on a multiple choice quiz, admin screen, student login screen where they choose their level of difficulty. I have been able to start the quiz, have the questions and answers filled, user answers question, check if correct or not, if correct then the score is incremented.I am able to set up a variable for 'level' and want to write some code so that whatever is selected then that table / questions will be selected and displayed to the user.
The way I'm thinking at the moment seems very long winded. I think I'll have to write an IF ELSE statement/case statement for each of the 'navigaterecords' and the sql statment for beginners, intermediate and advanced.Assume there is a variable 'LEVEL' - have not actually done this yet. Where the code refers to 'advanced' is where I have been trying it out to select questions from the advanced table.
I want to make different levels of access for a vb.net program i'm writing.I have a database called "stratocast". I want to show a specific form for entries in this table with "IsManager" checked and another specific form for those with "IsAdmin" checked.Im using MySql server and visual basic 2010 express
EDIT:To clear up any misconceptions about my post, ill explain further: In my vb.net application i have a login form with two textboxes; One for the username and one for password. I also have three other forms, one is called "frmAdmin", another called "frmManager" and another one called "frmEmployee".
On my database i have a table called "employee" with columns called "name", "title", "IsManager", "IsAdmin", "Username" and "Password".
IsManager and IsAdmin are both Boolean columns
This means that their values can only be 0 or 1 and the result is displayed as a checkbox.When the employee logs into this applcation i want it to check whether or not the employee is a manager, an administrator, or just a regular employee with no additional rights. If the employee is a manager, i want to show "frmManager". If the employee is an Administrator i want to show "frmAdmin". And if the employee has no additional rights then i want to show "frmEmployee".
I'd like to keep the configuration for access level checking confined to the one table but if it's better to have separate tables for each level of access (ie: tables called Admin,Manager, and Employee) then ill consider that too.
I am using Cursor.Draw to draw the default cursor on an image however this does not draw the alpha levels - they just draw the alpha pixels with a black backing how can i draw a cursor to an image and KEEP THE ALPHA channel?
