I am learning to use the datagrid in VB 2010. I pulled down some data from an SQL server. My aim is to display a red or green orb in column 0 depending on the value of the date field. if it is at least 7 days old (from date.now) display a red orb else display a green orb.[code]...
View 2 RepliesI don't understand the error, Argument not specified for parameter 'test' of 'Public Shared Function TestThis(test As String)'.
Partial Public Class Form1
Shared Sub ReceiveCallback(ByVal ar As IAsyncResult)
Form1.Invoke(TestThis, New Object(){"test"}) 'error
[code].....
I have been working on a class project for sometime now. Currently stuck and need some help. Project is due today, so I'm desperate for some help. Please see attached project file.
[Code]...
I need test data for a IP Subnet calculator I have developed. I have tested some obvious scenarios, and all seems good, but the person developing can often be the wrong person to test. The calculator can do one of two things:
1 - given an existing network and CIDR(mask), and a new CIDR it will create a number of networks with the appropriate number of hosts.
2 - given an existing network and CIDR(mask), and a list of c,h, (c = count, h=number of hosts) it will create the networks.
I need test data for a IP Subnet calculator I have developed. I have tested some obvious scenarios, and all seems good, but the person developing can often be the wrong person to test.
The calculator can do one of two things:
1 - given an existing network and CIDR(mask), and a new CIDR it will create a number of networks with the appropriate number of hosts.
2 - given an existing network and CIDR(mask), and a list of c,h, (c = count, h=number of hosts) it will create the networks.
The Question sound like this.Assume the theater keep 20% of its box office receipts. Use the Following test data to determine if the Application is calculating properly :
[Code]...
How i clear all data and not delete data or column in datagridview?
View 1 Replies[code]...
and from VB6 project I reference to Test.dll but an error messege was appear A reference to Test.dll file could not be added (If I create VB NET project and reference to file Test.dll it OK )
Probably a dumb question, but can you write a unit test project in one language to test against another project in a different language?I'd like to translate one of our VB assemblies into C#, but want to build unit tests to verify the results. I've tried to set a unit test project up to do this, but I can't seem to access the VB code within a unit test... I can't figure out if I'm just missing/doing something stupid, or it really isn't allowed.
View 2 RepliesI want to see if anyone has used one table that has a primary key (not displayed) in the DataGridView. Then use a text box on the same form to call and group what if viewed in the DataGridView table. I want to group the displayed data of the DataGridView by the primary key of both tables.
View 1 RepliesI have two data tables. the second related to the first. Using a datagridview for the first table I am able to enter and save data ok. if I run the code twice in a row the data is still there. When I edit the data in the related table in it's own datagirdview the data is there and displays correctly, but on running the code a second time the related data is lost. In both cellendedit events I am using
Me.table.Update(Me.FigsDataSet.table)
Me.Validate()
how can i insert data from data base with selected Datagridview columns i have insert combobox to Datagridview and it can load data from DB now i need insert data to another columns in Datagridview when i change combobox items?
View 7 RepliesI am trying to click on certain rows in a datagridview and have the information in the rows sent to a textbox. It does not append each row to the textbox though, which is what I want it to do. it just replaces it with the row I click on. What's wrong with my code. I have tried cell click too.
Private Sub dgProducts_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles dgProducts.Click
Dim i As Integer
[Code]....
I have three tables in SQL server which I would like to show and access on a form. Table 1 contains account data, address, contact details etc. Table two contains data attached to a Person, tel no , Mobile no, Email etc. Table three contains details on what awards the person holds, i.e. one person can hold several awards.
Therefore I have a one many relationship between the first two tables and a one many relationship between the second two tables. This is set up in SQL
The first two tables are shown on a form, table 1 via a set of text boxes, table 2 via a datagrid control.
I would like the functionality whereby I could select a row in the datagrid showing the persons name and find the Persons_ID number then use that as a filter to a second datagrid view so that only the selected persons awards show in the datagrid.
I have a datagrid view in my windows form which is bound to a datatable. one of the column have the status code and i want to display the status description of the same which is defined in an array.can we have display text and value of the column different. i dont want to go with datagridcombobox column.
View 1 Repliesi'm got this sql query code in dataset designer
SELECT pkt.fldPackageID, pkt.fldPSID, pkt.fldQuantity, pkt.fldQuantityUsed, pkt.fldRetail, pkt.fldPK, ps.fldName
FROM tblPaketRow AS pkt INNER JOIN
tblProdukDanService AS ps ON ps.fldID = pkt.fldPSID
WHERE (pkt.fldPSID = @param)
I'm trying to display the results in datagridview,i drag from the data source in vs 2008..I can't figure out to do that.I use this code to set the @param on form_load event.
Me.TblPaketRowTableAdapter.JoinTable(SalonDataSet.tblPaketRow, modCommon.s)
I execute a stored procedure which updates data. Is there a way to refresh the data in a datagridview to match the database's data.
View 9 RepliesI have two datagridview's both are databound. First one shows items for sale and the second stores all the items that were sold. I am trying too transfer selected rows from one to the other but no matter what I keep getting told "Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound."
View 2 RepliesI want to save my data from 1st datagridview to 2nd datagridview. I only able to get each cell value from datagridview.
Private Sub dgv_CellClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgv.CellClick
curRow = dgv.CurrentRow.Index
[Code]....
I wish to copy only certain row data when user click on the cell and add in into 2nd datagridview when click button add.
How can i edit the data of the value "Test" in "HKEY_LOCAL_MACHINESOFTWAREest" to example "Hello"?
View 2 RepliesI want to add data into different field using the datagridview.This is how i want it to work i have some combo boxes and textboxes on my form and any time i type some in them i want the data to be entered into an appropriate field/column in the datagrid view.. like this if the data in a txtbox goes to a particular column in the datagrid and the the value or data in another combo box goes to another column of the datagrid view.[code]...
View 2 RepliesI have a particular DataGridView that is populated by a MySQL query. The following data is queried.
employee_id
firstname
lastname
The column employee_id is hidden in the DataGridView. If a user selects an employee by his firstname or lastname, how can I get the employee_id for that employee in that row?
i want to get specific data in gridview specifc cell with the help of sql query from sql table [code]
View 2 RepliesRe: how to get data out from datagridview
View 9 RepliesI have a DataGridView that I am filling from an entity. Then the user selects the row and presses a button to do an action such as printing with those details. My issue is trying to get the data back out of the DataGridView easily.Here is part of my code:
Public Class form1
Private selected As New Car
Private Sub form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load[code].....
In this example I'm only pulling 4 items from the grid into selected, but my actual program will have many more items that I would have to code. Is there an easier way to fill selected?
I'm writing a program for my job in which we are keeping track of employees usage of food at work. The form in question interacts with an access database to a binded control with labels and textboxes. This form I'm working on is the user view which doesn't allow them to input their username, I have the user name saved to a variable but it will not display when I the add a new record. I tried many things but I'm just getting frustrated.
Is there away to add data to a row that is not displayed on the screen in a textbox for the user to see? There are 3 different "cells" (textboxes) I want to be filled in by other code without the users knowledge.
I'm currently using MSAccess 2010 and Visual Studio.net 2010
i want to add data into a datagridview line by line.for example on a point of sale window where you pick item by item and populate the grid.ode. i also want to know if the datagridview is the best for this. can i achieve the same with another control and still be able to go back to each line to edit.
View 4 RepliesI wrote small program which is reading xml data to datagridview (table). I used open file dialog and everything works fine. Now I would like to add some edit options to my program (add, delete, save). I decided to bind data and then use binding navigator?
View 10 RepliesI have a bit of code which loads data from a stored procedure in MS SQL Server and then loads the data to a datagridview, which works fine. What i want is for the code that connects / loads the data to sit in my Database Class and then everything associated with the datagridview to be stored in my Form but i am having problems passing the contents of the bindingsource over to the Form from the Database Class.
[Code]...
i can't get the data to be shown in the datagridview
what am i doing wrong here? i think the problem starts in the ---- if then statement
Private stylist As String
Private treatments As String
Private klantnaam As String
Private Collindex As Integer
[Code]...