I'm somewhat of a novice at VB.I have a DataGrid that I am manually populating from a SQL query-based dataset (see code below). Question: How do a capture the value of a specific column of the selected row (mouse click in the row) to use as a variable in other parts of the overall solution?Also, how do I add cell padding around the contents of the data grid cells?
[Code]...
I have written an application which extracts a list of URL's (currently in Internet Explorer cache) from an XML file and displays them in a data grid view. From here i would like to launch Internet Explorer in a hidden mode and capture an image for each of the selected URL's in the data grid view. Is this possbile? If so what is the best way to go about it?
View 2 RepliesI have UltraGrid and i need when i click on grid row to get content from specific column of that grid. For example if I click in cell of fourth column then i need to get value of first column of the same row where i clicked.
View 1 Repliesi'm trying to get index of selected rows in this why
For Each riga As Integer In lbFolder.SelectedRows
MsgBox(lbFolder.Rows(lbFolder.CurrentRow.Index).Cells(2).ToString)
Next
[code]....
Is there a way to automatically put a Data Grid Row Column in a data Grid?[code]...
View 5 RepliesI just want to display data in a DataGridView (from SQL - already made the connection) based on what is selected in a ComboBox (data that is also coming from SQL). The 2 are separete on the form. I am using VB 2010.
This doesn't work for me:
objCommand2.CommandText = "SELECT ProductID, Name, Color, Size, ListPrice FROM SalesLT.Product WHERE ProductCategoryID = " & cbCategory.SelectedValue
[code].....
How can i delete selected row from data grid using delete button [code]...
View 4 RepliesI have one datagrid with bound items and Radio button.
I want a index of the row which i selected by chacked the
the radio button.
i used Datagrid.selectedindex
but it gives -1 every time.
i m using these code for selecting data grid row [code]but , when no of row more then grid showing rows then grid not show selected row in grid screen, for showing selected row we have to use scroll bar, my problem is how to show selected row in grid automatically
View 2 RepliesMy application was designed in Visual Basic 08. There is a feature in the application that allows users of the app, to view a "Recording" page from the application, and works with a Soap API. Once the application sends the requested data to the API, the API responds with a custom URL, which must then be opened in a browser.How do I capture the response, or to be more specific, the URL that is being sent back from the API? Below, I have included the full parameters of the api, as well as the code that I have so far. What I really need to do, is figure out how to caputure the URL that is being sent back from the API to a text box. This will allow me to then transfer that text to the browser. But again, I have listed the full specifications, or parameters of the api below, as well as the code that I have so far. In case it helps, the app was designed for Windows Mobile using Visual Basic 08. [code] I am able to send the correct information to the api, but when the api returns the response, with the URL in it, I am unable to obtain that URL, and therefore unable to open that URL in a web browser, which has to be done as you can see from the API specs.
View 18 RepliesAs the title says, is it possible, if so then how can I do it
View 2 RepliesPublic
Class LoanCalc
Private Sub butCalc_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles butCalc.Click
'This procedure executes when the user clicks the Calculate
'button to produce a loan payment based on the requirements
'as stated in the service request.
'Variable Declarations
Dim douPrincipal As Double = Me.txtPrincipal.Text
Dim douInterest() As Double = {5.35, 5.5, 5.75}[CODE]......
I am trying to make an address book and need help. I am in the middle of making a search function for the program and I've got that working fine. What I would like to do is take the row that is selected from the search results and make that the selected entry for the main form. To explain what I mean I will include pics..
View 6 RepliesIn a data grid, I have a data grid with a column like this:
Dim colAdd As New HeaderAndDataAlignColumn
With colAdd
.MappingName = "Address"
.HeaderText = "Nationality"
[code]....
How can I disable this column entirely, I mean even disable focus event (can't click, can't use Tab or arrow keys, etc.)
How would I hard code the column width for my Data Grid?
View 1 RepliesI am trying to figure out how to remove the far left column from a datagridview. You can see more of what I am talking about in the screen shot provided.
I have seen multiple examples on google and on these forums about how to do this. It seems there are two approaches:
1 - Add the column directly to the DGV and populate it
2 - Add the column to the underlying dataset
[Code]...
I 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 have a datagrid that shows tickets that are in an OPEN status. The first column is the ticket number. Is there a way with a data grid control where I can click that number in the Ticket Column and close the ticket etc?
View 2 RepliesHow can i get the value accumulated from the date i select from datetimepicker1 to datetimepicker2 in vb.net and mysql? the value here refers to the daily sales and i need to find the total sales between the range dates that i choose..
View 4 RepliesI've a data grid whose source is a data table.The columns in the data table are Serial No.,Item,Description I want the width of each column to be different, like ,the width of serial no. should be very small and that of Description to be lengthier.But, everything is of the same default width.How to adjust the width of each column in a Data Grid so that appearance could be improved?
View 3 RepliesHow could I change the column header of the Data Grid to center or right but not left as default? [We are talking 'bout Data Grid here, recently I always receive answers for Data Grid View instead :( ] I just want to re-align the header only, not the whole column. There's another topic discussed bout this already but it's not working in my case. Here is my code:
Public Class Form1
Private Sub DataGrid1_Paint(ByVal sender As Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles DataGrid1.Paint
[Code].....
How i can change data grid view column type runtime. like i want to make a coloumn checkbox but runtime.
View 8 RepliesI am wondering if data grid automatically shows a first column (empty) before the others, if that can be edited out.
View 14 RepliesIn my project, form_double Click and Form_Maximize is not working when i do break point. Its not Button_Click, Form_Load. I want to do like this. "My project design form grid column size is small when form load and want to be large grid column size when the form is maximize."
View 1 RepliesIv've always done a loop like below to go through each row of my DataGridView..For Each row As DataGridViewRow In DataGridView1.Rows....Is there a way to specif a specific row and column that i want to get data from? I tried this below but didnt work
MessageBox.Show(dataGridView1.Rows[1].Cells[0].value)
and
MessageBox.Show(dataGridView1[0, 1].Value)
let's say the datagridview have 3 column
|--------------------------------
| id | name | age |
-----------------------------------
| 1 | john | 20 |
------------------------------------
i want to get "id" only from every row i tried this code,but it wont work
For cn As Integer = 0 To DataGridView1.RowCount - 1
DataGridView1.Rows(cn).Cells(0).Value)
Next
I know this has to be a very simple answer but I seem to be overlooking it. I have an Access database that I have conected to and have created a DataSet. The DataSet consists of one table with several rows and a bunch of columns. What I am trying to do is get the data for one specific row and column so that I can use this data is some calculations. I can position the row if I need to but I can't figure out how to get the data in the specific column I need.
View 3 RepliesI would like to bind different queries for a long set of columns in datagridview that has been set already during the formload, e.g:
With dgvGrid
.Columns(0).Name = "Dept Code"
.Columns(1).Name = "Emp ID"[code]....
there are still more of it. The data needed for those columns is coming from a different table.
So I have a datagridview being populated with data from a database.At this point a user may or may not selected (via mouse click / key press) one or more rows within the datagridview.I need to (upon selection) create a new dataset, datatable and add rows with the some data from the said datagridview.
For example, if a table had nothing but names, e.g.
Joe
Sean
Larry
Chris
Upon the user clicking, dragging a selection over Sean and Larry to add those names to a new dataset so I can pass it to another method for further processing.
[Code]...
Input array is longer than the number of columns in this table.It looks like I'm either missing a column declaration or adding the table to the set?