I use a Datagridview control, in which I need to display info and after that to export it to an excel document(but the export to excel part it's not important right now). I need to display in the Datagridview 2 fields:name and item, from a table(here 's where I thought I should use select) and also the value field which has to be calculated using a certain formula...
Let's say value= a+b
I need to pull from an access database to populate a combobox. Then from there I need to have a second combo box populated depending on the selection in the first box. My thought of an example would be a website that is setup for selecting car make, modle,year...can that be done in VB?
I am trying to select a dropdown and populate about 10 textboxes with information. The information is in a database. I know one option would be to write a stored procedure and pass the value of the dropdown box to the sp and then use SqlDataReader to readthe values to populate the textboxes. I am new to VB and was wondering if i should attempt this using LINQ?
I've spent FAR too long trying to troubleshoot this simple operation.I want the user to select multiple files in an OpenFileDialog (called OpenFileDialog1), click OK, and then have the filenames display in a listbox (called ListBox1). When I run, the openFile dialog allows the user to select mutliple files. However, on clicking OK, the dialog repons allowing the user to select only a SINGLE file. Then, it throws an "outside of array" exception.
i am developing a simple vb.net application. i have three forms in my app. the first form has 2 radio buttons from which i need to select one. based on the selection made in my next form a combobox ll be populated.so far so good.there is a back button on my 2nd form which when clicked redirects me to the first form. here when i select the next radio button the combo box in the next form does not populate accordingly. it still holds the old values. \[code]
this code links to the access database but but I just get only the first row in each combobox...
and I want also cboBox3 depend from cboBox2 depends from cboBox1, how can I do it?
Imports System.Data Imports System.Data.OleDb Public Class frm Dim objConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = DBSOURCEDB.mdb;Jet OLEDB:Database Password=pass;")
I have more than 100 controls (labels, textboxes, menu, Gridviews etc).I want onclick a button to turn all these controls to visible = true Now I need to code them one by one. Is there a code (in VB if possible) to make it applies to all in the control ?
On button Click I want to Set the Select command of a Gridview. I do this and then databind the grid but it doesn't work. What am i doing wrong? [code]
I need to filter a measurements table that consists of 63 measurement objects that may or may not be tested more then once. The entries are put in a Batch table on a SQL server in the following fashion:
ID: | Serie | Test object | Min Amps | Max Amps | OK? DateTime| String | Integer | Double | Double | Boolean
So there may be multiple entries in my database with the same series and testobject number but with (slightly) different results.
Currently I just select: SELECT * FROM Measurements WHERE Serie = 'XXXX' and use a datareader object to fill a datatable and then I let loose a routine on it that will either: Get the last result that produced a good measurement, so OK = 1 and max ID. Or the last result that produced a bad measurement if there are no good ones. I then end up with a list of 63 either good or bad measurement objects with the last good result, and if there isn't one then the last bad result.
Now I know that SQL is quite powerfull and I suppose that it must be possible to directly query for these results without a programatical routine re-filtering the results. I suppose it's like Selecting within a select statement..
I'm trying to create this select command against Access Database----Keeps giving me error saying operator is missing I just can't seem to figure it out
I posted a while ago about having issues with a database, and selecting a value from the database. I was told that there were things missing from my code, and I've not gone back and added the things I was advised to. Now, my code seems to be working more, but outputting the wrong value.
For example I have 2 things in the listbox:Install Registry keyDelete filesIf I choose "Install Registry Key" then the button should install the registry key when clickedIf I choose "delete Files" then the button should delete files when clicked
I am trying to enable the user the ability to select a folder and the folders music files populate a list box. I want two list boxes on the page, one with all the contents of the folder and then the other one for files selected from the first box. I have no clue on how to do this at all.
I'm getting ok connection to the database... but it's always telling me that I don't have permission to use the SELECT command with some table called 'proc'.
So based on what is selected in a radiobuttonlist i want the select command to change for my datasource. The problem I'm facing is that if i set the default selected radio button the query will work for that
my radiobuttonlist , user (dropdownlist are all located in an update panel that is not updated after the button is clicked
this my button code
If user.Text = "ALL" Then SqlDataSource22.SelectCommand = "SELECT * FROM [dashboardtasks] WHERE [completed] = 'NO'"
I see the examples where I can export a table into an Excel Worksheet by using SELECT * INTO [Excel 8.0;Database=C:Book1.xls].[Sheet1] FROM [MyTable] But I can only use [MyTable] if it is a binding source correct? What i would like to do is something like:
I am working on a Windows forms project that connects to a Microsoft Access database, reads the the file, does some math and then provides some basic statistics back.I am teaching myself VB and I know the code below could be more efficient.However, right now I am just trying to make it functional.The program filters the data it needs via sql, and there are several sql statements.I separated the code for each of the sql statements and into a subroutine so that I could call each one when the form loads and also when the user clicks a button to update.The program works fine on the form load, however, when you click the update button you get the following error on the 'odaCalls.Fill' in subroutine Count(): "The select command property has not been initialized before calling 'Fill'.[code]
I have my mysql query selected fields (item_code, item_name, item quantity, item_selltype, item_selldetail) but some of these fields are variants.
Dim sqlConn As String = ("SELECT item_code, item_name, item_quantity, item_selltype, item_selldetail FROM qa_items") Dim objDataAdapter As New MySqlDataAdapter(sqlConn, objConn)
Dim edit1 As OleDbCommand = New OleDbCommand("select * from [exporter] where exp_id='" & t1.Text & "'", con1)
now:-
t1 is a textbox
and in my table exp_id is "Number" now when i run this i get an error at the time executing reader (Data type mismatch in criteria expression.) but when i change exp_id properties to "Text" it run's properly
I have two DataGridViews in one window. The first one displays 2 columns, itemNo and taskWhen I click on a row in this grid, I want to populate the second grid with corresponding material. It is organized so that the itemNo in grid1 is 1, 2, 3, and so on, and so when a row is clicked, I want grid2 to show data that is 1.0, 1.1, 1.2, 2.0, 2.1 and so on. This data is all available in a table that exists within a dataset. However, tableAdapters do not use the .StartsWith function. I am able to get the information from grid1 when it is clicked on using Me.DataGridView1.CurrentRow.Cells(0).Value.ToString but how can I use this to get the data from the table into grid2
I have a DataGridView that I'm trying to populate using a For loop:
Dim serverName As String = SQLServerName + "" + Instance Dim server As Server = New Server(serverName) Dim Datatable1 As New DataTable For Each database As Database In server.Databases Dim row As DataRow = Datatable1.NewRow
[Code]...
The DGV has been designed with the designer (columns, layout etc). Using the above the DGV does not populate. I was using a ListView for this but I need images in a subitem so have switched to using a DGV.