I am having problem how to make a listview like a datagridview,to be specific, how can I configure the padding of the listview items,im using vbexpress 2008 and MS SQL 2008 here is some picture to be more specific
[code]...
In stead of using Datagrid for filtering and importing - listview for filter and import can it be possible?
View 2 RepliesWhat I am trying to do basically is open an access query in a datagrid view and then be able to make changes to the datagrid and then save it back to the database.When I try to save:
Me.BindingSource.EndEdit()
Me.TableAdapter.Update(DataSet)
It says that update is not a member of the tableadapter... Why is that?
I've created a basic form, entering the name and song of an artist. They can select a priority (1, 2 or 3) and it will drop the information into seperate columns of a listview. Based on the priority, the row is assigned an image in the item field of either an up, rgiht or down arrow. This works all fine. I selected the checkbox function to true and it places checkboxes next to every image as planned. However the checkboxes are just the arrows. If you click the 'checkbox' it keeps cycling through the 3 images.
View 2 RepliesI am positive it's possible to make a custom listview, like a custom tool or something. I have no idea how to do that though, and I googled it. Any ideas?
View 7 RepliesI created table named "tb_sale" using ms access 2007, it has 5 columns (date, product, qty, price, total)
I created a listview which has same columns with tb_sale (date, product, qty, price, total) Then, I dragged a datagrid (tb_saledatagridview) from tb_sale to the form, hoping i can insert multiple records from listview to tb_saledatagridview.
I manage to insert record from listview to unbound datagrid, but not for bound datagrid. code that I can use to insert and save data from the listview to tb_saledatagridview.
I've a ListView with 5 columns and the CheckBoxes property is set to true, Now how do i make the Checkboxes on any other column rather then the 1St column? Also i would like to change the state picture of the checkbox to something else when it's checked and unchecked.
View 2 RepliesI want to make a program that displays files in listview and makes the files clickable. How could I do this? I just need a little bit of help and I want the files to be displayed on form_load and if you need a location to display files from for an example, here is my location:C:WINDOWS
I'm not asking for anything huge, just an explanation or example, maybe a small amount of code.
I'm making a program that search for files with the specified extension. It also shows hidden files. How can I make the hidden files get a different color in the Listview? And how do I do that with only the hidden files?
View 5 Replieshow to, by a listview selected item make an picturebox appears?for exemple. got a listview in a form, and a hide picture box, and when i select an listview item, the picture box appears, turn the visible to true.
View 6 Repliesim trying to make the listview sort the listview items by column (whichever column was clicked, sort the list based on that column)
in vb6 it was done by:
Private Sub ListView1_ColumnClick(ByVal ColumnHeader As MSComctlLib.ColumnHeader)
Static olditem&
With ListView1
[Code].....
I am using the TableAdapter Configuration Wizard and under Advanced option I click on "Refresh the data table" and carry through to the end of the wizard. However when I run my code and want to update the dataset on the form I get the error message "Update requires a valid Update Command when passed with DataRow collection with modified rows". So, ok, when I look back at the Dataset with right click and configure I find that that the "Refresh the data table" under Advanced Options is no longer ticked, even though I had ticked it before and finished the wizard. Somewhere along the line the tableAdapter is losing this value.
View 1 Repliesthe GUI shows that (in the listview portion) when i click sa "save" button, the item/s in the listview will be updated to the "remaining stocks" (datagridview portion).
Here is my running code for that
Dim a As Integer
Dim y As Integer
Dim x As Integer
[Code].....
I am switching from listviews to datagrids and one of my listviews uses a sort in it. How can I sort in code using a datagrid?
View 2 RepliesI want to populate a listview with items from datagrid view. I've been searching for solutions but it seems that all the scenarios I found were about populating listview with items from tables in database, not from another listview or datagrid view.
I'm trying this code:
For count As Integer = 0 To (DataGridView1.Rows.Count() - 1)
Dim row As DataRow = DataGridView1.Rows(count)
Dim item As ListViewItem = New ListViewItem(row(fieldfirstcol).ToString())
item.SubItems.Add(row(fieldsecondcol.ToString()))
ListView1.Items.Add(item)
But it doesn't work; it says DataGridViewRow cannot be converted to DataRow.
I have the following code which works fine with a listview called LvwColProc;. This inserts the value to textbox TxtColType. TxtColType.Text = LvwColProc.Items(0).SubItems(1).Text
Now I have a datagridview, called DgvActiveProjects..How will change the above code to enter the same value to TxtColType textbox.
I include a piece of code below. Whta I'm doing is: I'm tring to select the maximum code from table "Items".However, SQLReader returns 0 (probably a null value) when I use the code below.In fact, the maximum value in the table is "503". Can anybody tell me what I'm doing wrong?
Public Function MaxItemCode() As String
Dim SQLConnection As New System.Data.SqlClient.SqlConnection
Dim SQLCommand As New System.Data.SqlClient.SqlCommand
[code].....
I am trying to make a listview custom control based on the standard listview control that will allow me to drag a column header outside the standard listview control and drop it on a panel. I plan to use the drop event to determine which column I should group by view on.
View 2 RepliesI have a vb-2008 program that contains a (listview) control.
View = details
AllowColumnReorder = true
Lets say the table has 3 columns (a,b,c) and 1 row of data.
a b c
1 2 3
I want the user to be able to re-arrange the columns (by dragging the column headers) before printing the contents of the table.
c a b
3 1 2
Statements like:
.. ListViewX.Columns(2).Text
.. ListViewX.Columns.Item(2).Text
.. ListViewX.Items(0).SubItems(2).ToString
Give the column-name (c) and cell-contents (3) of the origional table .. not the (3rd) column (b) of the re-arranged table.
How can i get the column-name and cell-contents of the (3rd) column of the re-arranged table?
Do I really have to go through all this just to find out what item has been selected in a ListView?
[Code]...
Isn't there something fundamental like this? Is absolutely everything in VB.NET buried beneath a colossal heap of bureaucracy?
i am developing a point of sales system. currently i have my product code scanned and displayed in a listview. lets say that i have 5 product codes displayed in my first listview. By clicking on a button, how can i use these codes to call upon the details (prices, product name, etc.) of the corresponding codes and display in another listview?
i am using Visual Basic 2008 and MsAccess as my database. who have the idea on solving my question. (As my last thread has not been answered at all..
I want ListView instead of CheckedListBox files in checkedListBox is being updated via ListBox1 How can I add the size of file too in listview
[Code]....
I am using VB.Net 2003 with an Access 2000 database. The program contains three options for the content of a DataGrid, each from a different table. I have finished programming the DataGrid which loads as the default when the program starts.When I run the program the DataDrid appears, but it is empty, except for a small box with a "+" in it. I click the + and the table name appears, I click the table name and the DataGrid is populated exactly as I wanted it.
View 4 Repliesof code to transfer from a datagridview to Excel.I used to convert to adodb and do it that way, but I'm trying to get away from activex.o... I made the following method: It takes about 45 seconds to run. It also locks out my application's gui thread for that time period and it would be nice to also run this as a seperate thread...Can this go any faster? The background colors are important to the person I'm doing this for
Public Shared Sub toExcel(ByRef DGV As DataGridView, ByVal Name As String, ByVal lastSaved As String)
Dim rowNo1 As Integer
[code].....
after pulling the data into the datagrid. how can i make the cell clickable ,like if i select any cell ,the new form should come up.
im using ms access 2007
May I ask a suggestion about this datagrid. I have this datagrid but it has so many column and I am going to total each and every column. If I am going to put a textbox or label, it'll be kinda difficult because it will not align to the column. Any solution you may suggest?
Another thing is this form for Daily Income. I want the form at the back (Main Form) not clickable unless I closes the Daily Income Form. So that the Daily Income Form will not go at the back of the Main Form. It is like you were saving a file on a text editor that you can't click the window behind it.
How do i make like 3 textboxes and 2 checkboxes work together with a datagrid so if u filled them out and u click add it adds them to the datagrid and it stays like that?
View 1 RepliesHow can i make a multiple filtering in datagrid view
View 1 RepliesHow to make query from mutiple datagrid so that the data from datagrid will create chart?
View 10 RepliesMy question is how can I create an event that would catch an enter key when I am editing it. Like I would type a note and hit enter key when I finish. Because columns of the datagrid does not have events like other controls or datagrid itself. What I need is something like this:
Private Sub ColumnNote_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles ColumnNote.KeyPress
End Sub
[Code]....