如何使用vb.net 2008动态连接两个表？ [英] how to connect two tables dynamically using vb.net 2008?

问题描述

你好朋友



我在vb.net 2008上制作了一个医疗应用程序，我的后手是sql server 2008？我的问题是，当我尝试运行我的水晶报告时，我没有问题，当它是单个表。但是对于两个表它显示我的SQL错误，并问我登录ID和密码？我已附加我的代码为您的参考。



代码开始：---

---------------------- ---------------------------------------------

Frm bill_print代码动态

----------------------------------- -------------------------------

Imports System.Data.SqlClient

Imports System.Data

Imports CrystalDecisions.CrystalReports.Engine

Imports CrystalDecisions.Shared

Imports CrystalDecisions.ReportSource



公共类frmbillprint



Private Sub frmbillprint_Load（ByVal sender As System.Object，ByVal e As System.EventArgs）处理我.Load

connectdb（）

Dim ad As New SqlDataAdapter（select * from sales_invoice，cn）

Dim ds As新数据集

ds.Clear（）

ad.Fill（ds，sales_invoice）

Dim strReportPath As String = pth&\\ \\ billprint.rpt

Dim cr As New ReportDocument（）

cr.Load（strReportPath）

cr.SetDataSource（ds.Tables（ sales_invoice））

CrystalReportViewer1.DisplayGroupTree = False

CrystalReportViewer1.ReportSource = cr

End Sub

< br $> b $ b

结束班级

------------------------- -----------------------------------------------

它包含数据库Sales_invoice和Sales_details

Sales_invoice - （bilno，billdat，so_id，cust_code，cust_name，amount，vat，net_amount）

sales_details-- - （medi_code，qty，amt）



-------------------------- -----------------------------------------------

它给我看错误



数据库登录

每次询问登录ID和密码

___________________________________________________________________________



朋友们请帮帮我.....

Hello friends

I have made an medical app in vb.net 2008 and my back hand is sql server 2008? My problem is when i try to run my crystal report i have no problem when it is for single table.But for two table it shows me sql error and asking me login id and password?I have attached my code for your refrence.

CODE BEGINS:---
-------------------------------------------------------------------
Frm bill_print code dynamically
------------------------------------------------------------------
Imports System.Data.SqlClient
Imports System.Data
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Imports CrystalDecisions.ReportSource

Public Class frmbillprint

Private Sub frmbillprint_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Me.Load
connectdb()
Dim ad As New SqlDataAdapter("Select * from sales_invoice", cn)
Dim ds As New DataSet
ds.Clear()
ad.Fill(ds, "sales_invoice")
Dim strReportPath As String = pth & "\billprint.rpt"
Dim cr As New ReportDocument()
cr.Load(strReportPath)
cr.SetDataSource(ds.Tables("sales_invoice"))
CrystalReportViewer1.DisplayGroupTree = False
CrystalReportViewer1.ReportSource = cr
End Sub


End Class
------------------------------------------------------------------------
It contain database Sales_invoice and Sales_details
Sales_invoice--(bilno,billdat,so_id,cust_code,cust_name,amount,vat,net_amount)
sales_details---(medi_code,qty,amt)

-------------------------------------------------------------------------
It show me error

Database Login
Ask every time for login id and password
___________________________________________________________________________

Friends plz help me out.....

推荐答案

在代码中添加以下行

add following line in your code

cr.SetDatabaseLogon(loginid, password)

这篇关于如何使用vb.net 2008动态连接两个表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！