i want to display data on the datagripview, this is my code but the error message am get is :"there is already an open DataReader associated with this Command which must be closed first."
Imports System.Data.Sql
Imports System.Data.SqlClient
Public Class Invoice
[Code]...
have been trying to display on my data grip view but is not. i want a situation where by it will display on the datagrip view base on the invoice number, below are the code
Private Sub getLastID()
Dim oleDBDR As SqlDataReader
Dim oleDBCommand As New SqlCommand
[Code]....
Cannot get list box to display each increment and cannot get data to save correctly in order to display.
Public Class Projectile_Motion
Dim initialHeight As Double ' Holds beginning height
Dim initialVelocity As Double ' holds velocity
[code]....
QuoteI would like to display my password from database (MS Access)into datagrid but in invisible. Below is my coding retrieve data from database, but my password is visible,
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = " & connectionpath
con.Open()
[Code].....
I have just started with vb and would like to know if there is a way to input several boxes of data on one form and display individual pieces of that data on several other forms at timed events in the future?
View 1 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].....
I have an Address Book project with a listbox. The listbox is bound to the database via the little arrow pop-up box in the corner of the listbox. I have the DisplayMember set to FirstName, and obviously only display the First Name of the contact in the ListBox. Is there an easy way to change it so that it displays the First and Last names? I can't change the binding because I need it to get the ID of the record selected.Here's the basis of my code...
Private Sub MainForm_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'CompanyDataSet.Contacts' table. You can move,
[code].....
I have an excel file that I would like to load into my form and display there.
View 1 Replieshow to display data in grid view using code that you can edit, update and delete the data...do i need to have a stored proc in this?
View 4 RepliesI have a data set with a parent child relationship between a patient table and an insurance table. There can be up to 4 insurances for each patient. I want to display them in 4 separate panels of a vb.net form. So if a patient had 2 insurances, then txtName1.text on panel 1 would have the company name of the first insurance, txtName2.text on panel 2 would hold the company name of the second insurance, and so on.
How do I display only the insurances related to the current patient? I've tried moving through the rows of the related table, but that gives me all the rows, not the ones I need. Everything I see on the internet suggest using a datagrid, but that's not an option in this case.
i'm got this sql query code in dataset designer
SELECT pkt.fldPackageID, pkt.fldPSID, pkt.fldQuantity, pkt.fldQuantityUsed, pkt.fldRetail, pkt.fldPK, ps.fldName
FROM tblPaketRow AS pkt INNER JOIN
tblProdukDanService AS ps ON ps.fldID = pkt.fldPSID
WHERE (pkt.fldPSID = @param)
I'm trying to display the results in datagridview,i drag from the data source in vs 2008..I can't figure out to do that.I use this code to set the @param on form_load event.
Me.TblPaketRowTableAdapter.JoinTable(SalonDataSet.tblPaketRow, modCommon.s)
I got a system which i want to insert, delete, update the data into my database and the data from database will be display using datagrid. The below is the coding for one of my button, delete.
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
Try
btnSearchEmpNo.Enabled = False[code].....
Now I wanna set when user click on this button to delete a employee (for example) then the datagrid that i have in my application will not show the data of the deleted employee but in the background, the employee haven't been deleted from database.The employee only will be deleted from database when the user click on SAVE button.I know this application have to use RowState but how?
I created Dataentry forms. In the form there are so many controls like DropDowns and textboxes. I am using Access database. Now I enterd the few records into the controls, and these records are saved into the Database. But now if i enter the any data which i recently saved in the database to the textbox or any other control then the remaining controls should be display the related data.
For example i have 4 controls in my form one is dropdown and 3 are textboxes. If i select the data in the dropdown then the remaining 3 textboxes shows the related data. How can i dispaly the corresponding data to the other controls?
How I can remove or hide the first colomn in Data Grid View , only I want to see data ? if not can remove I want other way to display data as a table [code]...
View 8 RepliesThis question is a follow up to an earlier question I had that was quickly resolved. The previous question can be found here: Selecting TOP 4 records from multiple SQL Server tables. Using vb.net..I selected the top 4 rows from multiple SQL tables ordered by date. How would I then go about placing that data into labels. There should be 16 items in total (4 columns, 4 rows). However if I try to use sqldatareader I only get items 0-3 and anything more is outside of the array. Should I not be using an IF statement in this case? In addition to the newly formed select statement based on the previously linked question, here is what I have: [code]
View 2 Repliesi use this command to display data from my ms access database table, but, it is not working
[CODE...]
Spend a day trying o find the reason why data grid will not display the data in the form... Simple Data set. Just ONE table with 2 fields (ID,Name). I Drag and drop to the form from Dataset. I can see the data in the dataset but not in the form. Tried with Access and Advantage data bases.
View 3 RepliesI'm trying to develop a windows application, I'm using VB.NET(Visual Studio 2005) and MySql database.
View 2 RepliesI'm running a script which should display data from a .txt file
I declare variables:
division = Request.Form("division")
if division = "view_all" then
operation = "viewall"
[Code]....
however no matter what i do it ends up writing File does not exist, read aborted.
I want to show data from database in datagrid My problem is Ex : i got 100000 records
but I dont want to show all cuz it abit slow, I want to show 1000 records and have button Next
I have been programming in VB6 for a while now and am switching over to .net. There are a few basic functions which I just can't get for some reason... I am forced at the moment to use a DAO/ADO connection, and I've been primarily using DAO in vb6, so I thought I'd carry this over to .net... atleast for the time being[code]...
View 7 RepliesI'm new here but I've got some questions. First of all how do you add data to a datagridview? I have an Access database and there are some records I want to add to the datagridview by use of a query.
View 3 RepliesI am new to VB.NET.I am creating an database windows application in VS2010 and SQL server 2008 express.In one of my form i have a datagrid.My requirement is that i want to display the sum of an column of a DB table and other related data from other tables in the datagrid which is having 4 fields :1. MatNo , 2.Quantity ,3. Opening Stock , 4. Closing Stock Db table1 hav following fields : MatNo , Qty1 Qty1 is the field for which i hav to find the sum against MatNo entered by user.In Db table2 hav again following fields : MatNo , Qty2 Mapping of data to datagrid : 1. MatNo : will contain the Matno entered by user.User can also enter a range of material like from 1000 to 2000.2. Quantity : For each of the material entered calculate sum of QTY1 from Db table1.3. Opening Stock : value in Quantity field of datagrid - value of QTY2 from Db table2 based on some select query )
View 2 RepliesTable gpass has data as
[Code]...
I have 3 tables in access database. I want to display all the records from these 3 tables. But I am only able to display 1 table records instead of 3. Currently I am using Visual Basic 2008. This is the code.
If CheckBox3.CheckState = CheckState.Checked Then
If checkbcexists() = True Then
MyConnection.Open()
[Code]....
I just want to know how to display data in the listview.[code]...
View 1 RepliesWas researching this but could only find how to use a datagrid which is displaying from a database? I currently have a for loop which goes through a 2d array and prints out all the things I want into a textbox but, what I want is to be able to have a table and print the things I want into rows and columns instead. I am new to VB.NET in Java it was just a matter of creating a table and a table model and loading the data through that way but not sure how to do it in .NET
[Code]....
I'm a beginner in .Net languages and need an example to be able to go further.
So, my objective is to display dates and comments from a datatable, below general information about a client.
The view needs to become something like that [code]...
In the application i am developing is there a way i can see tha values of certain variables?[code]...
if i do: messagebox.show(varRequest1.ContentLength) it print numerically the value, but i really need to see what the cookie contains to see where i'm going wrong kinda thing i have tried .tostring but i get an error
I am using visual studio 2008. I have a winforms app that takes data from an xml doc. I store the data in a ms sql database that I have created via a stored procedure. When Irun the app the data from the xml doc is captured and put in the database, but I can only see old data, the data that is captured during the current session can not be seen unless I close the app down and restart it. I have tried the following, and every variation I can think of to allow me to see the new data but to no avail.[code]
View 4 Replies
