Data Display

Sign in to answer this question.

• 

  Suthish Nair15y agoPosted Jun 27, 2011, 8:02 AM

  i think this ca easily done on SQL level. anyways you got the required output.
• 

  Mayur Gujrathi15y agoPosted Jun 27, 2011, 2:57 AM

  Thanks Body
  
  I have solved in this way
    Dim strtbl As New StringBuilder
   dtParam.Columns.Add(New DataColumn("@PA_EXCH_CD", GetType(String)))
          dtParam.Columns.Add(New DataColumn("@pa_audit_report_no", GetType(String)))
          dtParam.Columns.Add(New DataColumn("@pa_from_dt", GetType(String)))
          dtParam.Columns.Add(New DataColumn("@pa_to_dt", GetType(String)))
          drParam = dtParam.NewRow()
          drParam("@PA_EXCH_CD") = ddldp.SelectedItem.Value
          drParam("@pa_audit_report_no") = 6
          drParam("@pa_from_dt") = Request("txtfrmdt").ToString
          drParam("@pa_to_dt") = Request("txttodt").ToString
          dtParam.Rows.Add(drParam)
          clsdb.Objdatareader = clsdb.ExecuteNonQueryWithReturnCursor("pr_auditreport", dtParam, "pkg_mak_chk")
          strtbl.Append("

  ")
          strtbl.Append("
  ")
          strtbl.Append("")
          strtbl.Append("")
          strtbl1.Append("")
          strtbl2.Append("")
          strtbl3.Append("")
          strtbl4.Append("")
          strtbl5.Append("")
          strtbl6.Append("")
  
          If clsdb.Objdatareader.HasRows Then
              While clsdb.Objdatareader.Read()
                  j = j + 1
                  count = count + clsdb.Objdatareader("NO OF SLIP PROCESSED")
  
                  PrevEntm = clsdb.Objdatareader("TRANSACTION TYPE")
                  If (clsdb.Objdatareader("TRANSACTION TYPE") = "ACCOUNT TRANSFER") Then
                      flag1 = True
  
                      strtbl1.Append("")
                      strtbl1.Append("")
                      strtbl1.Append("")
                      strtbl1.Append("")
                      strtbl1.Append("")
                  ElseIf (clsdb.Objdatareader("TRANSACTION TYPE") = "DELIVARY OUT TRANSFER") Then
                      flag2 = True
                      strtbl2.Append("")
                      strtbl2.Append("")
                      strtbl2.Append("")
                      strtbl2.Append("")
                      strtbl2.Append("")
                  ElseIf (clsdb.Objdatareader("TRANSACTION TYPE") = "EARLY PAYIN TRANSFER") Then
                      flag3 = True
                      strtbl3.Append("")
                      strtbl3.Append("")
                      strtbl3.Append("")
                      strtbl3.Append("")
                      strtbl3.Append("")
                  ElseIf (clsdb.Objdatareader("TRANSACTION TYPE") = "INTER DP TRANSFER") Then
                      flag4 = True
                      strtbl4.Append("")
                      strtbl4.Append("")
                      strtbl4.Append("")
                      strtbl4.Append("")
                      strtbl4.Append("")
                  ElseIf (clsdb.Objdatareader("TRANSACTION TYPE") = "INTER SETTLEMENT TRANSFER") Then
                      flag5 = True
                      strtbl5.Append("")
                      strtbl5.Append("")
                      strtbl5.Append("")
                      strtbl5.Append("")
                      strtbl5.Append("")
                  ElseIf (clsdb.Objdatareader("TRANSACTION TYPE") = "POOL TO POOL TRANSFER") Then
                      flag6 = True
  
                      strtbl6.Append("")
                      strtbl6.Append("")
                      strtbl6.Append("")
                      strtbl6.Append("")
                      strtbl6.Append("")
                  End If
              End While
              If (flag1) Then
                  strtbl.Append(strtbl1)
              End If
  
              If (flag2) Then
                  strtbl.Append(strtbl2)
              End If
              If (flag3) Then
                  strtbl.Append(strtbl3)
              End If
              If (flag4) Then
                  strtbl.Append(strtbl4)
              End If
              If (flag5) Then
                  strtbl.Append(strtbl5)
              End If
              If (flag6) Then
                  strtbl.Append(strtbl6)
              End If
              strtbl.Append("" & count & "")
              strtbl.Append("

  ACCOUNT TRANSFER
  DELIVARY OUT TRANSFER
  EARLY PAYIN TRANSFER
  INTER DP TRANSFER
  INTER SETTLEMENT TRANSFER
  POOL TO POOL TRANSFER
  " & j & "	" & clsdb.Objdatareader("dptd_slip_no") & "	" & clsdb.Objdatareader("NO OF SLIP PROCESSED") & "
  " & j & "	" & clsdb.Objdatareader("dptd_slip_no") & "	" & clsdb.Objdatareader("NO OF SLIP PROCESSED") & "
  " & j & "	" & clsdb.Objdatareader("dptd_slip_no") & "	" & clsdb.Objdatareader("NO OF SLIP PROCESSED") & "
  " & j & "	" & clsdb.Objdatareader("dptd_slip_no") & "	" & clsdb.Objdatareader("NO OF SLIP PROCESSED") & "
  " & j & "	" & clsdb.Objdatareader("dptd_slip_no") & "	" & clsdb.Objdatareader("NO OF SLIP PROCESSED") & "
  " & j & "	" & clsdb.Objdatareader("dptd_slip_no") & "	" & clsdb.Objdatareader("NO OF SLIP PROCESSED") & "
  GRAND TOTAL OF SLIPS

  ")
              strtbl.Append("

  ")
  
              Response.Write(strtbl.ToString())
             
  
  
• 

  Suthish Nair15y agoPosted Jun 27, 2011, 2:06 AM

  You need two different queries. 1. using group by. 2. for taking counts. later combine both and do a sorting.
• 

  Mayur Gujrathi15y agoPosted Jun 27, 2011, 1:07 AM

  ACCOUNT TRANSFER

  COM09000000025

  COM09000000025

  POA09000000621

  NO OF SLIP ISSUED 3
  

  INTER DP TRANSFER

  10129

  NO OF SLIP ISSUED 1
  

  Ok consider in this way

  
  
• 

  Sam Hobbs15y agoPosted Jun 24, 2011, 4:38 PM

  I think that no one can understand what you need to do since in the first version there is only one COM09000000025 but in the second version you show 3 of them.
• 

  Mayur Gujrathi15y agoPosted Jun 24, 2011, 1:13 AM

  BUT I want to display inthis way previously i am showing in gridview
  

  ACCOUNT TRANSFER

  COM09000000025

  COM09000000025

  COM09000000025

  NO OF SLIP ISSUED 3

  
  

  Please help

  Also not getting in which control i should display