Solved

Datagrid Events

Posted on 2004-05-02
17
258 Views
Last Modified: 2012-06-27
In my datagrid there are four fields (no,qty,rate and amt).
I want to display automaticaly to the amt field after multiplying qty and rate. Which datagrid event is used for this purpose.Please help me with an example
0
Comment
Question by:sijijames
  • 7
  • 6
  • 2
17 Comments
 
LVL 21

Expert Comment

by:tovvenki
ID: 10974805
is it windows forms app or a we app??

venki
0
 
LVL 25

Expert Comment

by:RonaldBiemans
ID: 10975186
You don't have to use an event for that, when you create the datagrid you can add extra columns

here is a nice example from MSDN

Private Sub CalcColumns()
     Dim cPrice As DataColumn
     Dim cTax As DataColumn
     Dim cTotal As DataColumn
     Dim rate As Single
     rate = .0862
     dim t as DataTable = New DataTable
 
     ' Create the first column.
     cPrice = New DataColumn
     With cPrice
         .DataType = System.Type.GetType("System.Decimal")
         .ColumnName = "price"
         .DefaultValue = 50
     End With
     
     ' Create the second, calculated, column.
     cTax = New DataColumn
     With cTax
         .DataType = System.Type.GetType("System.Decimal")
         .ColumnName = "tax"
         .Expression = "price * 0.0862"
     End With
     
    ' Create third column
     cTotal = New DataColumn
     With cTotal
         .DataType = System.Type.GetType("System.Decimal")
         .ColumnName = "total"
         .Expression = "price + tax"
     End With
 
     ' Add columns to DataTable
     With t.Columns
         .Add(cPrice)
         .Add(cTax)
         .Add(cTotal)
     End With
   
     Dim r As DataRow
     r = t.NewRow
     t.Rows.Add(r)
     Dim dView As New DataView
     dView.Table = t
     DataGrid1.DataSource = dView
 End Sub
0
 

Author Comment

by:sijijames
ID: 10975499
sir,
     In the previous example all values are assigned. But I want to give value  at run time and  do the calculation using these values.
 
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 25

Expert Comment

by:RonaldBiemans
ID: 10975528
Where do you assign the values ? In the datagrid or somewhere else ?
0
 

Author Comment

by:sijijames
ID: 10975787
I assign the values in the datagrid.


 Dim i, j, n As Integer
        n = Dg.VisibleRowCount()
        n = n - 2
        For i = 0 To n
        Dg(i, 5) = (Val(Dg(i, 2)) * (Val(Dg(i, 3)))) + (Val(Dg(i,4)))
        Next

I write this code inside the click event of a button.Using this code, I got the answer by clicking the button.But it is not display automatically in the amt field.
0
 
LVL 25

Expert Comment

by:RonaldBiemans
ID: 10975815
So your datagrid isn't  bound to a datatable or dataview ?
0
 

Author Comment

by:sijijames
ID: 10975955
sir,
     I connect my datagrid to a Database. How I can display
the amt automatically. Please help me with an give example .
0
 
LVL 25

Accepted Solution

by:
RonaldBiemans earned 20 total points
ID: 10976061
You can use the example a gave above this will automatically display amt

yourds.tables("yourtable").columns.add("AMT",gettype(single),"no * (qty + rate)")
yourdatagrid.datasource =  yourds.tables("yourtable")

put this in the load event of your form

0
 

Author Comment

by:sijijames
ID: 10976202
sir,
             My question is  that, how I could display the value automatically (when focus comes to the amt field , this field is already created in the design time) in the amt field .
ie, amt=(qty*rate)+tax .
0
 
LVL 25

Expert Comment

by:RonaldBiemans
ID: 10976243
I really don't understand your question, my example shows the value automatically, even if you add new rows during runtime it will automatically calculate amt
0
 

Author Comment

by:sijijames
ID: 10976665
sir,
    I want to know how to display the contents of datatable to datagrid.please help me with an suitable code.
0
 
LVL 25

Expert Comment

by:RonaldBiemans
ID: 10976723
Ok, I'll try again
I assume your dataset is named DS and your datatable (DT)  looks like this :
No, QTY, Rate, Tax and that you want to calculate AMT automatically

form_LOAD event:

DS.tables("DT").columns.add("AMT",gettype(single),"(qty * rate) + Tax")
datagrid1.datasource =  ds.tables("DT")



0
 

Author Comment

by:sijijames
ID: 10984059
sir,
   My project is windows application.

My next  problem is that when data is inserted through datagrid to database only two rows are inserted other rows are avoided due some unknown reasons. My code is enclosed below.


Private Sub SvBn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SvBn.Click
        Dim con As New SqlConnection("server=PROJECTJ22;uid=sa;pwd=hello;database=Purchase")
        Dim a ,n As Integer
        Dim cmd As New SqlCommand()
        Dim cmd1 As New SqlCommand()
        cmd.Connection = con
        cmd1.Connection = con
        con.Open()
        n = Dg.VisibleRowCount()  'dg is datagrid name
               n = n - 1
        For a = 0 To n
            cmd.CommandText = "Insert into purtran values(" & PurIdTb.Text & " ," & Dg(a, 1) & "," & Dg(a, 2) & "," & Dg(a, 3) & "," & Dg(a, 4) & "," & Dg(a, 5) & "  ) "
            cmd.ExecuteNonQuery()
        Next
        cmd1.CommandText = "Insert into Purse values( " & InNoTb.Text & "," & PurIdTb.Text & "," & SupIdTb.Text & ",'" & DtpTb.Text & "') "
        cmd1.ExecuteNonQuery()
        con.Close()
End sub
0
 
LVL 21

Expert Comment

by:tovvenki
ID: 10984184
Hi,
in n = Dg.VisibleRowCount()  'dg is datagrid name
VisibleRowCount()  will only return the number of rows visible and not the full row count.
0
 

Author Comment

by:sijijames
ID: 10984233
sir,
    Can you please help me with a suitable example ?. I want to insert only the rows having values given at run time.Which method is used to count the rows having values ?
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

830 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