I have a classic scenario with a twist, containing the following tables: Users, Roles, UsersInRoles.In my webpage I have some Comboboxes (i.e. DropDownList + TextBox), one for each Role which contain all the Users for that particular Role. What I would like each of them to contain instead is a full list of all users, but grouped and ordered like so...Users for only the given role (ordered by name) - My intention is to highlight these items.The rest of the users, with no repeats (ordered by name)I have been playing around with some SQL and VB trying to work my way toward a solution, but it is not clear yet which is the best approach, nor how to fully implement the solution. I have only figured out small bits and pieces. Forgive me for refraining from posting any code for now. I hoping for some fresh ideas and a clever solution that won't put a lot of demand on the server.
And the query I wrote to that gave me all the subgroups I need to get to where I want I think.
select u.ID, Name, RoleID from UsersInRoles
inner join Users u on UserID = u.ID --This is only to return a name rather than ID
order by ReviewerRoleID, Name
Using the recommendation by Tim, I may use some codebehind like this to bind to each respective drop down list. The one concern I have is that I'm performing a query for each Role which poses a potential burden on the server every time the page is accessed by a user.
Private Sub PopulateUserInRoleCombobox(ByVal key As Integer, ByVal ddl As DropDownList)
Try
Dim dt As New DataTable
Using connection As New SqlConnection(ConfigurationManager.ConnectionStrings("tcomConnectionString").ConnectionString)
Dim spSelect As New SqlCommand("spGetUserInRoleList", connection)
[code]....
how best to write the Javascript for styling each list item depending on if it's a member of the given role or not.
(All of the names on the ListBox are actually .txt files, which contain different values that can be put into the program by a certain window.)
I'm trying to use a ComboBox to order items in a list by a certain value. So say I select "Sort by Alphabetical" in the ComboBox, I'd want it to sort the items in the ListBox in alphabetical order.
Also, if I were to have a certain value in the .txt files that I would like to sort by, is there a way I could order by that?
I'm new to the Vb.net. To display the list of files in the given folder, need to processing the files one by one based on the user given the order/arrangement in form based interface.
How can do this in vb.net 2005 or any suggestion.?
I have an XML dataset that contains multiple records and each record can contain 1 to many sub element with the same identifier group (see E04 elements in file)
I'm looping all the properties in an object via reflection:
For Each p As PropertyInfo In values.[GetType]().GetProperties() If p.CanRead Then 'Do stuff End If Next
how to determine whether the property in question is a generic List(Of T)? If it is I need to loop the list itself.
I've experimented with GetType and TypeOf but have not managed to get anything working.
To clarify, I want to keep this generic. I do not want to specify the type of T, I need to loop the list items and call the ToString method on each item. T could be one of a number of different types (application specific reference types). Is it possible to do this without specifying types?
This program is supposed to allow the user to check items in a checked list box. If the item is checked, it goes into the Completed List Box on the right. The program then adds the unchecked items to the Pending list box on the left. I keep getting placement values (e.g. O,1,2) instead of the strings (e.g. "Key Returned") in the list box results (see photo attached)
Public Class frmCheckOut Dim i As Integer Dim cleaning As String = "Cleaning Inspection" Dim damage As String = "Damage Repaired"
Another program I am working on for fun, I am basically shuffling a list inside a listbox, what I want to do is delete the rest but not sure how to go through with that. At the moment I have this: [code] Just contains the code, declarations outside weren't included.So anyway, once clicked, it will call on the function to basically shuffle in a for loop, I was wondering if I should (or how should) create another function and call it in the click button or have just a loop in the click button so it deletes half the list. What I am doing is I have 20 list of items, I want the program to shuffle the items and then deleting the lower 10, meaning, if I had 10 items and wanted 5 top, I'd want: 0, 1, 2, 3, 4 and deleting 5, 6, 7, 8, 9.
I am attempting to read the results from a SQL query into a List(Of) and I can see the List.count while adding items to the List increments, however in another part of my code when I am attempting to read the List the List.Count returns 0. My List is as follows:
I have an error panel that is subbed in to a page if an error goes wrong to gracefully handle and display errors.Currently, I am just appending the error messages to a string and pushing that to a label. If you have multiple errors, this gets messy.I'd like to push each error to a list item in a bulleted, unordered list.How can I dynamically generate, from a vb codebehind file, new list items inside of an undordered list element?
I have two generic lists, named ListA and ListB. Both ListA and ListB could potentially have duplicate items. What I would like to do is use LINQ to grab the items in ListB that are not in ListA, but I'm unsure how to do so.
i want to search item A (from a list of X items) in list B but i want to get the item not found example Search ITEM A in LIST B if not found then return a print....if found continue with ITEM B..and so on.
That was probably bad title, but I'll illustrate what I'm trying to do. I have a method in a class that I need to call several times. The method returns a List(Of String). I'm just grabbing some information from a database.
VB.NET Public Function GetTestList() As List(Of String) Dim int As Integer = 0
I have a List(Of MyObj), and I want to iterate through that list and compare each element to all other elements in the same list, excluding (if possible) the same element. I have a solution that works, but it's slow and uses double For loops. It may possibly have also summoned Cthulhu from his sleep. This below is a sanitized version of what I have:
Dim MyList As New List(Of MyObj)({Obj1, Obj2, Obj3, Obj4, Obj5, Obj6}) If MyList.Count > 0 Then For i = 0 To (MyList.Count - 1) Step 1
I want to know how to test the 1st list box if it has items more than the other list box but by one item, here is what i have: If lstInvisibleTv. Items.Count > lstInvisiblePc.Items.Count Then it works good if the lstInvisibleTv list box is greater than the other list box by one but it also works if it is greater the other one by one or more which I do not want. I want it to work just by one.
I have a program that will compare an array of grocery list items glist and an array of coupon item clist.When I compare the two and if there is a match somewhere in the array I want to have a picturebox visible.When there is no match, I want the picture box not to be visible. [code] The code seems to work great until I come to the else statement.When the code finds a match it displays the picture box and the msgbox without error, but as soon as the message box is cleared, even though i've input it as an ELSE statement, the picturebox goes false again.Does anyone have any idea of how I can "hold" the picturebox to stay visible while the match between the arrays exists?
i am writing a program that reads a excel report from accounting software with our weeks orders on... so basically the program reads a list of around 100 items which all works fine.I also have a database that holds info on each item, when the excel sheet is parsed the software checks to see if any new items have been added to the list that are not on the softwares database. this is where i am having the issue.I have two lists: ItemsOrdered & ExistsingItems.
All the items ordered this week are in ItemsOrdered and all the items not in the items in the database are in the ExistsingItems list. using these two lists how can i find items that are in ItemsOrdered but not in ExistsingItems.
I have a List object and I want to remove the duplicated items but leaving at least one of the duplicated items in the list;I wrote something like this however I would optimize this code for better performance, is there something faster?
Const chars As String = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz" Dim rnd As New Random() Dim mylist As List(Of String) = Enumerable.Range(1, 100).Select(Function(i)
I am having trouble sorting out a list of items pulled out of the databse, by the date stamp they have on it. I mean the table is called Marks with columns Homework_ID, Pupil_ID, Marks,Comment. Then there is another table called Homework with columns HW_ID, Class_ID, HW_name, HW_set, HW_due. The HW_set and HW_due are dates in format YYYY-MM-DD. Right, I can pull it out of database easy what I want but then how do I order it by the date when the HW was set ? is it some tweak in the query ? or do I need to write some code for it
I am calling external DLL (written in Fortran) function that has a multidimensional array argument. In VB6 the array is column major (the same as Fortran). However, I recently noticed that in VB.Net the array passed to the DLL seems to be in row major.
I am developing a Blackjack game in VB.Net using Visual Studio 2008. I have Picture boxes to display the players cards. The issue I have is that when the player chooses to hit , the third card stacks properly over the first two, but on the forth hit,the picturebox(which contains the forth card) appears under the third card. The same happens for the fourth , fifth, and sixth card . I have looked at the properties for the picturebox hoping there was some kind of index (similiar to zindex in css) to order the cards so they would would "stack" on top of one another but leaving the numbers of the cards visible, to no avail as I am here posting I have a screenie of the situation to better illuminate my struggle.
If you look at the picturebox with the 8 of diamonds card in it , everything is fine, but you will notice that the 10, 4, and 8 of clubs is underneath. I would like these cards to stack as the 4 of clubs, the 9 of diamonds and the 8 of diamond did.
I have a Datatable- table1 and i want to sort/order this datatable in ascending order depending on 2 columns-column0,column1 of table1. how can i do that?
I have a Datatable- table1 and i want to sort/order this datatable in ascending order depending on 2 columns-column0 ,column1 of table1.how can i do that?
Dim dir As New System.IO.DirectoryInfo("C:")For Each f As System.IO.FileInfo In dir.GetFiles("*.rtf")Next using the code above, how can arrange the object (file(s)) Descendingly?
I have inherited a frankenstein VB6 "Converted" to VB.NET winform application. This application has a metric ton of fields in it, the users rightfully complained that the tab order is off (after a certain point it starts jumping all over the form).Figuring something in tab order was off, I went in and turned on View > Tab Order and it looked good. To be sure I went through the form again fresh and when I'm in tab order view all is well, but when the app runs it still starts jumping around the same area as before?! Has anyone else encountered this and how did you resolve if you did?
My main Application A starts a 3rd party Application B that runs as a console application. So I don't have access to the Application B source code. When specific things happen in Application A, I can properly launch a vb.net Application C that I built, which properly shuts down Application B, by sending a Ctrl-C signal to it, the same as hitting Ctrl-C in a console window. But I cannot have this occur on Windows shutdown because Application B shuts down on its own before I even have the chance to launch Application C to shut it down. Is there a way to keep some kind of control over Application B when I launch it, or any way to have it be last in the shut down of programs in Windows?
If TextBox1.Text = ("weburl") Then WebBrowser1.Document.GetElementById("price_category").SetAttribute("value", "4") End If If TextBox1.Text = ("weburl") Then WebBrowser1.Document.GetElementById("fullprice_quantity").SetAttribute("value", "4") End If If WebBrowser1.DocumentText.Contains("Add to shopping list") Then WebBrowser1.Document.GetElementById("add_to_list").InvokeMember("click") End If.
I want them to go in order. But what it is doing at the moment is going to the third if statement first.
i am creating a maths program that works out five number summarys of a range of data. i am having trouble working out the median in a group of numbers.so far i have used the code below to declare all the the inputs.
dim m as integer no1 = Val(TextBox1.Text) no2 = Val(TextBox2.Text) no3 = Val(TextBox3.Text)
[Code]...
i am completly stuck for how to order the variables, and find the middle no.. as i am using 11 variables, the middle no would be the 6th in the order..
I decided to take up the task of writing an app for Dungeons and Dragons. I play with my friends and I'm trying to make it a little bit easier.Before every round of combat players roll dice for Initiative. It basically tells the games manager who goes first and in what order the rest of the players go. When players roll for initiative they roll 20 sided dice. On Form1 I have a button that says "Initiative" which opens another window where the manager would type in each players values. Then I want the program to take those values and order the players from highest to lowest in a list on Form1. Kind of like...
