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.
View 2 Repliescoding multi column combobox in a DataGridView cell. When I click the combobox cell from datagridview, It shows the multiple column such as Name, address and telephone. When I choose the item, it will return the value.
View 12 RepliesI'm filling a DGV by setting it's datasource property to a datatable, but for a DateTime columns it doesn't show seconds.
View 4 RepliesI am using Datagridview to show some table data from database. It is working but its appearance is not what i am looking for.Is there a way to edit columns and rows manually ?This is a list of what i want to do :
1. First of all i want to change column captions. because they are like "Fld_name" etc.
2. There is a column that shows date. I want to write a code for it ( convert date type )
3. I want to add a button at the end of each row and write a code for it ( show detail about that record )
SQL statements:
SQL = "SHOW TABLES;"
Try
conn.Open()
The remarked area works fine when I'm accessing a specific table. I've successfully inserted the products_model field into the combobox too. The datagridview does show the table names in the db using the SHOW TABLES sql statment, but I'm not understanding how to get this info into the combobox instead.
I am trying to show the following code in a text box on separate lines. Is it possible to code in a hard return?
[Code]...
How do you refresh a datagridview in code to show to show new data in the DB?
View 3 RepliesI want to add this multicolumn combobox in DataGridView [URL]
View 2 RepliesIs it possible to have a multi column combox box, being used as a lookup list, in a DataGridView.
View 2 RepliesI need some advice to accomplish this, i have a datagridview with this data:
Column1 Column2
item1 3
item2 1
item1 2
item1 5
item2 3
item3 1
item1 3
I need an array with distinct values of column1 and the sum of the values in the second dimension of the array: ar(item1,13), ar(item2,4),ar(item3,1).
I don't know how many items i will have, so i don't know the correct dimension of the array...
I want the user to select multiple rows in the datagridView and have this code:
[Code]...
But when I select several rows using the mouse the "DataGridView5_MultiSelectChanged" event is not fired, I must have a property not set correctly, Multiselect is set to true. There are properties for AllowUser to add/delete rows etc, but none for selecting rows.
Using Visual Basic 2005 So this is the problem I have run into. I need to populate a Datagrid with Data from 4 different tables of which I have gotten down to 3 DataTables in one DataSet.
The first one is called Letters and includes: LastPrintedOn & requiredpaper The second is called ImportParams and includes: ImportParamsID, BlockLetterGroup1, BlockLetterGroup2 and BlockLetterGroup3
The Last is called ClientInfo and includes: ClientGroupID, CapturedOn, ProcesingCommittedOn, ProcessingStartedOn, ProcessingCompletedOn, ImportParamsID
Now I can attack this from one of two ways (at least that is how I see it)
Select the ClientGroupID's I need (1,2,3,6) from that I will have the ImportParamsID which will then get me to the second table which has the blocked letters 1, 2 or 3 of them of which I can then check against the last table to get the date. There is one clients as of now that will end up with 3 thus being 3 seperate lines on the DGV or Table to show the different letter types.
Method 2:Bascially the reverse, look at the letter types and work backwards though I think the first method is easier. Where should I start? I'm not looking for code but the path I need to be on to get to the end.
I want to highlight some of the letters in each row of col1
[Code]....
whether the text can be said in reverse color or in bold font is ok for me.
I'm trying to make a game in Visual Basic, but I can't figure out how to add in different levels.
Essentially, what I'm looking for is the Tab Control, minus the tabs. On a different note, is there a way to make a group of controls? Like instead of
TextBox1.Text = "Hello"
TextBox2.Text = "Hello"
I could have something along the lines of TextBoxGroup.Text = "Hello"
whats the difference with high and low level of programming
View 1 Repliesi 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.
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.
View 2 RepliesI'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.
.tv_Ana.Nodes(A).Nodes(B).Nodes(C).Nodes(D).Nodes(E).Nodes(F).Nodes(G).Nodes(H).Nodes.Add(Trim(sLev_nI + "-" + row_nI("MidCod").ToString()))
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
but it doesn't work yet!
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:
SELECT
menu.Item_ID,
menu.Child_ID ,
[code].....
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???
View 3 RepliesI 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.
View 4 RepliesI've written a simple WAV player in VB 2010 - a Windows Form App with no menus. I'm trying to create a hotkey, like CTRL-D that would make a text box visible. Typing the correct password in the box will expand the form and show some Administrative functions. I'm having issues creating the hotkey with more than one key.I've got the following code, but it does not work. I do have KeyPreview set to True.
Private Sub _KeyDown(sender As Object, e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown
If e.KeyCode = Keys.Control And e.KeyCode = Keys.D Then
txtPWD.Visible = True
I've also tried
If e.Keycode = Keys.ControlKey & e.KeyCode = Keys.D
and many other variations including changing to ALT and SHIFT but nothing seems to work. If I remove one of the Keys, it works just fine.
I've been raking my brain for quite some time on this. Is there any way with VB.NET that I can use multiple IP's in one instance of a program? For example, I want to be able to navigate to a web page 10 times at once, with each one using a different IP. I want them to be parallel (multi-threaded) rather than going sequentially. Going sequentially, I could just do the action, change the IP, do the action, change the IP.
View 5 RepliesHow do i go about multi-threading that, it's just an example project, so i can try and learn from it. As i'm having a hard time understanding JMC's tutorial as it doesn't directly relate to what i'm trying to do [code]When you hit 'Start', the start button is disabled and the Label1 then changes to "Downloading".The data is then downloaded and put into the Textbox1.Label then reads "Complete" Start button is enabled.
View 5 RepliesI have a button and when it's clicked a HTTP request is sent out to a website to do a few things, but because its got to load the external resources it makes the interface frozen. I've moved the HTTP onto another thread using the follow
VB.NET Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim Thread1 As New System.Threading.Thread(AddressOf check_accounts)
[Code]...
When i want to update a label that is on my main form (from the check_accounts sub). I know that isn't the right way, but i have no idea what the right way is. All the documentation i can find is very (excuse me for this) nerdy and really doesn't offer much insight on how to incorporate it into a project.
I want to be able to have a numericupdown box that can let the user change the amount of threads they want to use. I assume more threads allow the http requests to be done faster and at the same time?Also if i wanted to pause the HTTP requests, would the best method to use be pausing the thread?
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.
View 2 RepliesI 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.
Imports System.Data
Imports System.Random
Imports System.Data.OleDb
[code]....
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?
View 1 Replies