I'm creating a program for a bookstore & I'd like to create an "inventory table" using the DataGridView function. I've created a form with 2 tabs for the bookstore clerk. I'd like to have a new row created once the information for a new book is entered.[code]
View 8 RepliesI have a datagridview control that where I need to color the rows based on a value in one of the cells in each row. I'm using the CellFormatting event like so: [code]This works fine when the grid loads and when I scroll it, etc. But when I click on the column headers to sort the grid, e.Row Index is always zero and all of the rows get the formatting of the first row..[code]For some reason, e.RowIndex is set correctly here but not on the other methods. The only thing you have to worry about here is it can be -1. But when I tried to use other methods, including PrePaint, I had to deal with it always coming up zero on a sort. If I exclude the zero case, like I excluded the negative one case about, then the first row is always white!!! I'm not sure why this works, but it does. It also produces no flicker beyond what I got using the CellFormatting event.
View 2 RepliesI have a FlexGrid control in my Windows application that contains a row of data. The data in this row is related to even more data that won't all fit on the same row. For Example:The main data row contains Username, Last Name, First Name, Middle Name, E-mail Address, Phone Number, etcA secondary row to this might contain user permissions to certain resources, such as File Server Access, FTP Access, Remote Access, etc.Now, I can use the subtotal and outline capabilities of the VSFlexGrid to make a second row, but the column widths are still bound by those set for the main data row. Additionally, I can't put real "headers" on the supplemental data. I have to fake it by creating an additional row, setting the background color of that row to gray, putting the header strings into those fields, and then adding the next row with the actual details.
What I would like to do is create separate grids for these secondary rows and "embed" them in a blank row of the existing FlexGrid control directly under the related main data row. This would give me the ability to use a different number of columns, to format these columns independently of the "parent" FlexGrid settings, as well as put a new header row for the new grid that identifies its data.In other words, I'd like to somehow make a "child" grid that's related to a particular row of the "parent" grid (not the entire grid itself). I don't know if this is possible, and if there is another way for me to accomplish this goal, I'm all ears. However, if it IS possible, I'd love some advice on how to implement it.
I have a page with multiple RadPageViews, some with RadGrids in them. They all need command item template in order for the user to edit and refresh the grid. On my first page view, the item template works perfectly, poping-up the edit form for the user to edit the data of the selected row. On my second page view, the command item template buttons don't seem to want to work (not even the refresh). If it were just the edit button then i would suppose there'd be a problem with my edit form, but not its that no buttons seems to work (not even refresh). The grid does display the information correctly too.
Here is the code of the pageview who's radgrid doesn't seem to work:
CODE:
I've been going through it many times and i don't understand why it doesn't work. I've also compared it to the working pageview and there doesn't seem to be any noticeable difference between them both.
I have used VB (versions 2 - 6) through many years; however, I am crash-course training myself into the VB2008 / VB2010 world kicking a screaming. I would like suggestions as to what SQL database access method should I focus more on in my learning process without making me feel that I'm a million years behind. I know I have WinForms where I can create a datasourse and drag / drop fields or tables on a form to create a grid (not really what I'm looking for).
My trouble isn't so much designing the form but in how I access the database. Theres XML, LINQ to SQL, ADO.NET, and many other methods. Not only do I need to grasp these methods quickly but I also need to know what type of projects I should create. What I mean is...I was thinking that I would design a WinForm app; however, I see that there are WPF apps and others to chose from. This is getting deep. I know it depends on the project that I'm working on. My plans are to write an app based off of either an SQL Express 2008 or SQL Server 2008 database. This first app will be standalone for now but may later become multi-user. I know I'm far behind on my learning curve coming from VB6. I have read a bit on VB2005 / 2008 / 2010. I own
both VB2008 and VB2010. I use VB2008 at work. I know ADO.NET is still alive but by what I read online, it's a dying method and is only kept for backward compatibility. XML and LINQ to SQL and other methods are all pretty new to me.
I would like to do that. Find the board on-screen that convert it to Color Grid on a picture. I have tested few things but they did not work. It randomly draws white and greyish squares instead I would like it to create what it reads off the screen.
Private Sub PictureBox1_Paint(ByVal sender As Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles PictureBox1.Paint
Dim img As New Bitmap(PictureBox1.Width, PictureBox1.Height)
Dim gr As Graphics = Graphics.FromImage(img)
gr.Clear(Color.White)
[Code] .....
im trying to create a hierarchical grid on vb net but im failing to acomplish
this is what i have already but not working
Private
Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
[Code].....
I am trying to create a context menu that will only appear over a grid but I am having difficulty. Below is what I've tried ( was also declared at the form level but did not make a difference):
[Code]...
I'd like to create a visual 2 dimensional grid (x,y) which contains an array of booleans that I could refer to by the 'coordinates' of the grid, and could actually SEE the grid on a form and work with it. for example:
If grid(10,20) = True Then Show(BlackSpot, grid(10,20))
how to create data grid table and how to link it to MS SQL Server 2005 Express database
View 1 RepliesI'm trying to accomplish is having a 20x20 pixel image show up multiple times as determined by the grid selected. To keep things simple, what I'm trying to do is create a 9x9 grid of a image onto a form. I'm assuming that a picture box is the way to go, but don't know how to make that happen or if it's even possible.
So it would go something like this:
2D array already assigned:
Sub ShowGrid()
For rw As Short = 0 To 8
[Code].....
But instead of using a text box with values, I want to show a grid of a small image file, like cup.png which is 20x20 pixels or whatever, so what would show up on the form in this case would be a 9x9 grid of the image file over and over to create a grid.
Then the next step I hope to accomplish is to have that 20x20 square picture hold the grid(x,y) value for a mouse click. So if the image at grid(3,5) is clicked, it will give me that value, 3-5.
I have a DataGridView control that is bound to a dataset that I set up in design mode. This grid will contain addresses for a client. The relationship is 1 client to many addresses. So, when the user selects a client, I wish for this grid to populate with only the address records for that client. How do I set up in code a way for the grid to recognize this?
View 1 RepliesIs it possible to take the last row added to the grid and enlarge it for viewing? Then when another row is added it enlarges and the previous goes back to normal size. When I say enlarge, almost like a magnify effect. Am I making sense?
View 1 Repliesright now my datagridview is like select.JPG in the attachment. but i need my datagridview disply should be Modified grid.JPG in the attachment. how to remove the line which is before the column question in my datagridview.
View 6 RepliesI have a databound datagridview.I have disabled automatically adding new rows to the grid. The datagridview is bound to a datatable.In it,I have also set the Protected Overloads Overrides Function ProcessCmdKeyto handle and process the 'Enter' keypress.When the user presses Enter within the Datagridview,I want the grid to add a new single row to the bottom of the grid.I have tried several methods to do so,but the grid always adds the new row to the top of the grid instead of to the bottom.I tried posting this issue in the Windows Forms Data Controls and DataBinding board, but didn't recieve any help there, that's why I'm posting this here instead.The only person to help me there said she couldn't reproduce my issue, even when I supplied her with the exact code I was using.I believe there is more than one way to implement this adding of a new row to a datagridview programatically, and browsing through the various msdn forums, I came across several and tried implementing them all, always with the same result.I don't remember all the various implementations I have tried, but here are my few most recent ones:(This is within a class I created that inherits the datagridview. This custom class was the only place I could specify the ProcessCmdKey function, it doesn't work in an instance of the datagridview instantiated directly onto a form. That is why I'm using the me keyword to refer to the datagridview)#1)
If keyData = Keys.Enter ThenMe.Rows.Insert(Me.RowCount(), 1)Return TrueEnd IfReturn MyBase.ProcessCmdKey(msg, keyData)
#2)If keyData = Keys.Enter ThenMe.Rows.Add()Return TrueEnd IfReturn MyBase.ProcessCmdKey(msg, keyData)#3)If keyData = Keys.Enter ThenDim row As System.Data.DataRow = dt.NewRow()dt.Rows.InsertAt(row, dt.Rows.Count)Return TrueEnd IfReturn MyBase.ProcessCmdKey(msg, keyData)
I generate a DataGridView using the result of a query. The query generates a LOT of columns (more than 75). Obviously the DataGridView does not show all of them. I wrote a small procedure that extracts data from the DataGridView and generates an Excel file ora .csv file.
[Code]...
How to create a Filter in Data Grid view.
View 3 Replieshow can I create a grid with a cell with multiple data.I want to Display Product Name,ProductID and Price in one cell.How can this be done in VB2005. [URL]
View 2 RepliesIs there any way to create a total row at the last of grid view without using loop
I mean if I want to get the sum of a column of a datatable then can I do it without using loop.
for example if we have add a product to that data grid and then we have add another product, i want that another product places at under the 1st product in that data grid and if we add the same product then just the quantity have increase.. TQ so much.. and the field in that top column data grid is..
NoProduct NameProduct Quantity Price SubTotalPrice
how can i implement a pre vb.net style snap to grid effect on a panel (at design time)?if you remember, you start dragging a control + the grid has a (gravitational) pull on the control
View 6 RepliesTo Remove[code]...
To Add: I used this[code]...
How do I add the button that scrolls down / up as I add or delete rows on the grid?
I have a DataGridView that I am adding rows to programmatically.Normally, when I add the first row of data the SelectionChanged event firesBut my Grid is anchored to the top and bottom of the form and when I make the form smaller such that the height of the Grid is zero, the SelectionChanged event does not fire when adding the first rowIs this by design? It doesn't seem logical to me.
With DataGridView1
.Rows.Clear()
.Columns.Clear()
[code].....
How to change vb .net datagridview row color based on grid checkbox value. Having bound DataGridView. BindingSource as data source. called DGV. I m using this code under cell_formatting event
[Code]...
Im making a Cinema Script Editor in VB.net. I import some columns from excel to a database, and put this data into a datagridview to edit it. i have 2 columns in the grid, with multiline like this:
Me.DataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells
Me.DataGridView1.DefaultCellStyle.WrapMode = DataGridViewTriState.True
I need to navigate in the grid like if i were in Word, i mean, pressing the up or down arrow the cursor should move first in the lines of a cell, and when it reaches the cell end, it has to go to the next cell in the column. But now, if i press up or down arrow, it moves from cell to cell...
I've been trying to customise a datagridview but no luck so far, thing is, i want some of the cells to not have the same grid colour and width as all the rest of the grid. Do you guys know how can this be done? I know it is possible cause i've seen it before but i have no clue how to accomplish that.
View 4 RepliesI have a datagridview that's taking a while to load because my table contains almost 5000 records. How can I provide an easy way for clients to filter the grid based on a product name. I was thinking of having labels with each alphabet on my form and when they click a label it filters the bindingsource according to the chosen alphabet. this seems like an awkward solution though.
View 2 RepliesHow to create composite grid. ie , i need all the features of gridview in the Framework 3.5 and above,but also need to include some other functionality to that grid.please suggest me what to do . if possible please share sample code.
View 2 RepliesI want to know how to create unbound column in data grid view and use that column to display the sum of two fields.
View 5 RepliesI want to create a grid of checkboxes dynamically on my form for example the user may key in 16 which is a 4x4 grid of checkboxes or 81 which is a 9x9 grid.my code seems to be generating the correct values but the checkboxes dont go to the correct location on the form
Public Class Form1
Public NumberOfInputs As Integer = 81
Public CheckBoxArray() As Control
[code]....