[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


Insert data into a table after selecting a  record in a data grid view

Posted on 2009-03-31
Medium Priority
Last Modified: 2013-11-27
Hi all!

I am using VB 2008 Express.
I have two tables: tblInventory and tblTransactions. tblInventory has fields: ID, ItemNo, ItemDescrtiption, QuantityInStock, and Cost while tblTransaction has ID, ItemNo, ItemDescription, TransactionType, Date, and Quantity.
I created a form (frmInventory) with a Filter feature to only display the Items in the Datagrid View which match the criteria in a filter box.
What I wish to happen, after the filtering, is that: when an item/record is  clicked from the datagrid view in frmInventory, my other form, frmTransaction will show and the selected data will automatically populate on the fields particularly the ItemNo and ItemDescription.

Any suggestion and solution you will give is highly appreciated.

Thank you.


Question by:MINDSUPERB
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
LVL 11

Expert Comment

ID: 24029386
How are these two tables related?

Initialize frmTransaction  with the ID from frmInventory. When a row is selected, pass the ID to frm transaction and when form loads get the data from table to populate in the fields.
LVL 19

Author Comment

ID: 24036104
How are these tables related?
They are related by ItemNo.

There is a missing field in tblTransaction that I forgot to include. That is InventoryID.

May I ask how to initialize the frmTransaction and how to pass the ID into another form? Sorry, I am still on the process of learning VB.

LVL 11

Expert Comment

ID: 24038814
In the frmInventory, Once you insert the Inventory record,You will be having ItemNo.

--This part is in frminventory
In the Datagridview click event

Dim objTrans As New frmTransaction

-- In frmTransaction
Dim TransItem As Datatype
Public Sub Initialize(ByVal ItemNo As Datatype)
TransItem = ItemNo

Private sub frm_Load()
Get the data as dataset from datatable with the itemNo and populate all fields
End Sub
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

LVL 11

Expert Comment

ID: 24038960
Here are the events you can use and in the following fashion. Form2 indicates frmtransaction

Private Sub DataGridView1_CellClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellClick
        Dim f2 As New Form2
    End Sub
    Private Sub DataGridView1_CellDoubleClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellDoubleClick
        Dim f2 As New Form2
    End Sub

Open in new window

LVL 11

Accepted Solution

srikanthreddyn143 earned 2000 total points
ID: 24038970
And in the frm transaction,

Public Class Form2
    Dim il As String
    Private Sub Form2_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
    End Sub
    Public Sub Init(ByVal s As String)
        il = s
    End Sub
End Class

Open in new window

LVL 19

Author Closing Comment

ID: 31564781
I am sorry for my delayed response.

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question