|
-
Oct 22nd, 2007, 08:39 PM
#1
Thread Starter
Fanatic Member
Hi, can help me here it is not honoring the filtering code... Crystal report
help me here why it's not honor the filtering code..?
Private Sub GetRecordsPrintSat()
ds.Clear()
Dim cmd As New OleDbCommand
ds = New DataSet
cmd.Connection = cn
cmd.CommandType = CommandType.Text
cmd.CommandText = "Select * from FinalCustItemRSO where RSONO=" & cboPrintRsoNo.Text & ""
da.SelectCommand = cmd
'Dim da As OleDbDataAdapter
'da = New OleDbDataAdapter("Select * from FinalCustItemRSO where RSONO=" & cboPrintRsoNo.Text & "", cn)
da.Fill(ds, "FinalCustItemRSO")
' MsgBox(ds)
End Sub
Private Sub BtnPrint_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnPrint.Click
Dim Meprint As New PrintSat
Me.myRSONO_rpt = Me.cboPrintRsoNo.Text
Dim newRep As New LunisCryatal
GetRecordsPrintSat()
newRep.SetDataSource(ds)
newRep.Refresh()
CrystalReportViewer1.RefreshReport()
Meprint.Refresh()
End Sub
i try this one but it steel not work...? Why, Please Help...?
Private Sub GetRecordsPrintSat()
ds.Clear()
ds = New DataSet
cmd.Connection = cn
da.SelectCommand = cmd
Dim da As OleDbDataAdapter
da = New OleDbDataAdapter("Select * from FinalCustItemRSO where RSONO=" & cboPrintRsoNo.Text & "", cn)
da.Fill(ds, "FinalCustItemRSO")
' MsgBox(ds)
End Sub
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|