How can I make the datagridview contains 1 row? Because I have a toolbar that have two button (forward,backward) and I need the datagridview to be single row because each row is a record in The DB. And when I press the forward button I will go to the next record. And btw, which is better this way or make the datagridview display all the records at once?
View 7 Replies
I want to make a translator like this: [URL]...I have already made two textboxes and a button. If I type in textbox 1 abc then textbox 2 must say nop. I already know the If textbox1.text = "abc" then textbox2.text = nop. I don't want that i want to translate the a to a n and the b to a o and the c to p. So i want to translate every single letter and make it 1 word. Its like a secret code. My language looks like that a=nb=oc=pd=qe=rf=sg=th=ui=vj=wk=xl=ym=z n=ao=bp=cq=dr=es=ft=gu=hv=iw=jx=ky=l z=m
View 22 RepliesI have a DGV with a single row that I want to update with new data in a timer. What is the best way to do this? Would I just update each cell in the row individually when the timer fires?
View 3 RepliesI need to display a column called Full Name in a DataGridView, but the DataSource (datatable) does not have a FullName column. It only has FirstName and LastName columns. I'm setting up my DataGridView like this:[code]How can I set the DataPropertyName to use data from both the FirstName and LastName columns in the datatable.?
View 2 RepliesIn previous versions (VB.NET 2003) I would do
datagrid.datasource = dataset.tables(0)
datagrid.datamember = "Column1" 'Where this is the name of the column
This would show me just that column in the grid regardless of the number of columns in the dataset.
In VB.NET 2008 I do: datagridview1.datasource = dataset.tables(0)
I see all the columns.I then add:
datagridview1.datamember = "Column1" 'Where Column1 is the column name
I then have an empty grid.How does one get only a single column to show in the grid from a multi-column data source? I am using internal code to populate the datasets and tables.
I am developing a new project for my daily office use using access database with vb 2005.
In this project I have one bounded datagridview and it is ready to use.
I want to alter a particular field value in the datagridview regularly. so whenever I click the rowheader that particular field should be editable with a combobox with some value, after selection of the value and leaving that particular cell it should be updated with the appropriate record in the database.
I'm using Visual Studio 2008 and SQL Server 2008 and Crystal Reports.
Windows form with datagridview and a printbutton.
Is it possible, if I select a record in the datagridview, to print that record when I click the printbutton?
the datagridview seems more complicated the I thought it would be my problem is: how can I if I added three columns to my datagridview, let the program insert something with 2 variables and in the last column i would have to do some calculations with the column2 (like the sum of all rows in column2)
[Code]...
is it possible to force a DataGridView to be single row only?I cannot set the AllowUserToAddRows to false as i need one row.I cannot re size the grid to display a single row as i need the horizontal scollbar.
View 4 RepliesI've developed an application in vb.net that can run from a usb drive. But i need my app to work only from that usb in which i distribute it.
If someone copies it to other Drive/USB, it must not work. Do u know how to implement this?
how can i make my VB 2008 project just one single .EXE
View 8 Replieshow to make a single column of a datagridview into currency format?
InventoryDataGridView.Columns(5).Name = "inventory_cost"
InventoryDataGridView.Columns(5).DataPropertyName = "inventory_cost"
InventoryDataGridView.Columns(5).Width = 70
InventoryDataGridView.Columns(5).HeaderText = "Cost"
InventoryDataGridView.Columns(5).???
I am filling datagridview with data from SQL server 2008 R2. one column is date which is stored in the data base as yyyy-mm-dd and when i retrieve it displays in the same format. I want to change the display to dd-MMM-yyyy.
Try
Connect_Design_Document_Record()
Dim cmdDrawing As New OleDbCommand("SELECT DRAWING_NO, DRAWING_DESCRIPTION, DRAWN_DATE, REVISION_NO" & _
[Code].....
I have a DataGridView with two columns defined like:
Dim col As New DataGridViewColumn
col.DefaultCellStyle.BackColor = Color.FromArgb(&HFF)
col.Name = "Description"
[code].....
im trying to make a single image appear randomly at any given time i have tryed to figure out the code for this my self however i have had no success any ideas
If HPU.Visible = FalseThen
HPU.Visible = Int((550) * Rnd() + 1)
EndIf
I have a mdicontainer form that summons forms. My problem is when the a user clicks again the menu for that form, it also make another instance of it.
What I did is declare a public class with a public variable on it ex: Boolean isFormOneOpen = false. Then every time formOne opens, it checks first the global variable I declared a while ago if it's false, if it is, instantiate an object of a formOne and then show it. Otherwise, do nothing. Very static, imagine if I have many forms, I have to declare a variable for each form to check if it's already open. Maybe a method that accepts a Form? Or any more clever way to do this.
in vb 2008 express this option is available under application properties. does anyone know what is its function? does it make it so that it's impossible to open two instances at the same time?
View 3 RepliesI have a datagridview with data in it, i have set it so you can only select the row and one at a time.However, i need to get the data from one of the cells in the selected row, i have tried this
View 2 RepliesI have a single form with a datagridview on it showing values from an oracle database. I am trying to set up a way of detecting if the row/column I click on is empty or not, just as a little exercise. I have so far got this:
Private Sub DataGridView1_CellClick(ByVal sender As Object, _
ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) _
Handles DataGridView1.CellClick
Dim c, r As Integer
c = e.ColumnIndex
r = e.RowIndex
[Code] .....
The message going into lbl2 shows the co-ordinate values of any box I click in but as you can see with the IF statement below I am trying to see if the system can detect whenever I click in a value that is empty (null or ''). When I run my form and populate the list with a column of names I can click in 0, 0 cell and I get a message saying the 'Box is not empty' as above.
But when I click in any of the next boxes e.g. (1,0) (2,0) etc I get this:
'Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index'
Pointing to this line of
If Not DataGridView1.Item(r, c).Value Is Nothing Then
Not sure what this means at all. I am under the impression that my piece of code is gathering the value of the item depending on the co-ordinate values. so why should this fail? What index/collection is VB talking about?
I've managed to make some single dimension array lists but I can't figure out a multi dimension arraylist.
Here's what I'm trying to do:
I have a database (mdb) with 5 columns that I want each row to be in an array list.
In PHP what I'd typically do is:
$array[$field1] = array($field2,$field3,$field4,$field5);
How I do the same in vb.net so anytime I need to fetch an item for a specific for the row1 I could call it?
For a single dimension I could do the following, but I can't figure out how to add more fields to a single array row:
Dim tmpArrayX As New ArrayList
tmpArrayX.Add(field(0))
tmpArrayX.Add(field(1))
etc...
How I can change the back color of a single cell of a datagridview in runtime?
View 1 RepliesWith the DataGridView I'm used to just populate them with a list of some object, using the DataSource property. Now I want to just display properties from a single object, and I'm a bit confused on how to do it.. The object is updated through an API event, and I want to select some of the properties for displaying in the DataGridView, to look like this:.where "ValueX" is the name of the properties.Now, what would be my options for binding this to the DataGridView, such that property changes are automatically updated. Since an update also must invoke the control, does that mean I must reassign all bindings, or what logic is necessary in this case?
should I bind to an array, arrayList, stringList, dataTable etc? I guess I'm not sure which type of source will allow binding. Or if I should perhaps build the columns and cells of the grid and populate them "one-by-one" to the properties of the object?
How can I populate a single DataGridView cell with input of a textbox after click event of a button?
View 6 RepliesI don't have an example code, but recently figured out how to make a single sub handle the keydown event for multiple text boxes.What I would like to know is if it is simple enough to have the object name that is sending the event instead of "microsoft..text: 54654" (sender.ToString in a debug window) type of return. I don't know how to make use of that.
View 3 RepliesI am populating a textbox with a single line of numbers that I would like to seperate out into strings.[code]...
View 3 RepliesI am using VS2008 and I have a form which has a datagridview. This is for an invoice where I already have the user select the customer from a details view and want to have the items in the datagridview change based on what the customer selected. Then when the item is selected I want to have the price change accordingly.
So far I have the customer selction as well as the item combobox(not limited to cust items yet) appear, but I cannot figure out how to get the join of the 2 items (cust+item as the price varies from cust to cust) to change the price. Question is, is it possible to do this in the same datagridview, or should i try to just break this down some other way?
I have Visual Basics 2008 express and I tried to make a autotyper, so this is my
Button1: Timer1.Start
Timer1: Timer2.Start
Timer2: SendKeys.Send(Textbox.text)
Button2: Timer2.Stop
So it was my first try ever with VB and it kind of worked... Only 2 problems;
1. Button 2 doesn't really work, I have to click it really many times, then go to a different window, then click it really many times again, in the meantime it keeps on spamming
2. How do I make my autotyper press enter every single time after the textbox message was typed?
Say I have a code with 3 methods that do some pretty intensive work. Would executing these methods on 3 seperate threads be faster then executing them one after the other on a single core cpu? And what if it's a dual core or HT?
View 8 RepliesI am trying to make a list, separated by a comma, of entries from a single column in a SQL database. I have been spending the last several days searching for a way to do this, but every thing I found either didn't work, or wasn't exactly what I was looking for.
The query will pull all the email address that are not null. What I need to know is how to take the result of that query and make it look like this:
email0@address.com, email1@address.com, email2@address.com, etc, etc, ...
I feel like I should know this, but for the life of me, I can't remember nor can I find it in any of the textbooks I have.
I am using Visual Basic 2010 and SQL Server 2005. I also have access to Visual Basic 2005 if needed.
I use SqlParameters when executing database statements. I know that I can replace a single quote with two single quotes... but in the past SqlParameters took care of this for me. I have two projects.. in one, the SqlParameter does this and it handles single quotes fine, in another, it does not and I'm at a loss why (I even copied and pasted the code):
[Code]...
