Solved

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

Posted on 2009-03-31
6
487 Views
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.

Ed

0
Comment
Question by:MINDSUPERB
  • 4
  • 2
6 Comments
 
LVL 11

Expert Comment

by:srikanthreddyn143
Comment Utility
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.
0
 
LVL 19

Author Comment

by:MINDSUPERB
Comment Utility
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.

thanks.
0
 
LVL 11

Expert Comment

by:srikanthreddyn143
Comment Utility
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
objTrans.Initialize(IItemNo)
objTrans.Show()

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

Private sub frm_Load()
Get the data as dataset from datatable with the itemNo and populate all fields
End Sub
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 11

Expert Comment

by:srikanthreddyn143
Comment Utility
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

        f2.Init(DataGridView1.Rows(e.RowIndex).Cells("txt").Value.ToString)

        f2.Show()

    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

        f2.Init(DataGridView1.Rows(e.RowIndex).Cells("txt").Value.ToString)

        f2.Show()

    End Sub

Open in new window

0
 
LVL 11

Accepted Solution

by:
srikanthreddyn143 earned 500 total points
Comment Utility
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

0
 
LVL 19

Author Closing Comment

by:MINDSUPERB
Comment Utility
I am sorry for my delayed response.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
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 tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

728 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now