not too sure if i posted at the correct place. but anyway.. here's my problem. i'm using vb web developer 2008. i'm trying to pull out data and display using the imagemap/hotspots. for example, when i search for this item 1, it will pull out the data from the database and then shows me where the item is placed on the map.
I have a floor map of a buiding. It has cubicles. The application must display the floor area information of a cubicle when the user clicks on the cubicle?
I was thinking about use picture bixes for each cubicle but it seems complicated.
How to i create clickable areas on the form and load images to those areas?
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,
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?
I 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
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,
I 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.
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.
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]...
This 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]
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.
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]...
I'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.
I 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 )
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()
Was 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