我想在《晶体报告》中增加2个数据表。
Private Sub btbPrint_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btbPrint.Click
Dim ds As New DataSet1
Dim t As DataTable = GetInvoice(txtBillNo.Text)
Dim dt As DataTable = GetDCDetails(t.Rows(0).Item("DcID"))
Dim objRpt As New CrystalReport1
Dim adopter As New SqlDataAdapter
在此,我想在数据来源中添加数据表。
objRpt.SetDataSource(t)
CrystalReportViewer1.ReportSource = objRpt
CrystalReportViewer1.Refresh()
End Sub
我认为,作为数据来源,你可以提供多份数据表,最好的选择是加入表格(发票及其细节载于图表),并将数据输入数据,并作为数据来源确定。
你们可以使用这样的东西。
Set datasource for each table
objRpt.Database.Tables("table1").SetDataSource(t)
objRpt.Database.Tables("table2").SetDataSource(dt)
CrystalReportViewer1.ReportSource = objRpt
CrystalReportViewer1.Refresh()
如果“表1”和“表2”是报告中的数据库表
I was wondering when I write Shared ReadOnly Variable As DataType = New DataType() Or alternatively Shared ReadOnly Variable As New DataType() Is it lazy loaded or as the instance initializes? ...
I would like to write a little application in VB.NET that will detect a baby s cry. How would I get started with such an application?
I have many fields in the page and the last field is a dropdown with list of values. When I select an item in a dropdown and press Enter, it doesn t do the "Ok". Instead I have to manually click on Ok ...
I am using VS2008 and creating forms. By default, the underscore of the character in a textbox when using an ampersand is not shown when I run the application. ex. "&Goto Here" is not ...
On button Click I want to Set the Select command of a Gridview. I do this and then databind the grid but it doesn t work. What am i doing wrong? protected void bttnView_Click(object sender, ...
I have a relatively simple question regarding the best way to call the DataGridView.Rows.Add function when it is inherited into the current control. Which is the best way to make the call to the ...
I m trying to create something like a tooltip suddenly hoovering over the mouse pointer when specific words in the richt text box is hovered over. How can this be done?
Can I use two command object with one open connection in one procedure at VB.NET?