如何在使用Vb.net和VS 2005的CryStal报告中使用Sql查询 [英] How Use Sql Query in CryStal Report Using Vb.net and VS 2005

问题描述

如何在使用Vb.net和VS 2005的CryStal报告中使用Sql查询



我正在使用Vb.net， Visual Studio 2005

i使用DataSet创建Crystal Report但是可以在数据集的帮助下创建简单的Report但是如何用sqlcommand 来编写where子句或条件

现在我使用这些步骤创建的日子>>

第一次创建数据集使用TableAdapter（在图片1中显示）

第二个DataSet附加Crystal报告

此代码在Vb.net中使用按钮





Private Sub Button1_Click（ByVal sender As System.Object，ByVal e As System .EventArgs）处理Button1.Click

Dim rpt as testformularpt = new testformularpt

Dim ds as testformuladataset = new testformuladataset

Dim adp as testformuladatasetTableAdapters。 DCMasterTableAdapter =新testformuladatasetTableAdapters.DCMasterTableAdapter

adp.Fill（ds.DCMaster）

rpt.SetDataSource（ds）

CrystalReportViewer1.ReportSource = rpt

CrystalReportViewer1.SelectionFormula（）={DcMaster.DCNo} in [''&修剪（txttest.Text）& ''，''&修剪（Txttest1.Text）& '']





End Sub



但我不能wrtie手动Sql查询

我只是在这里编写Sql查询select * from emp where date& textbox1& and& textbox2&

我应该在这里改变什么在这里写Sql查询



图像1和2这里

http://postimg.org/image/ro5qm2puf/[^]

http://postimg.org/image/4nz39qs0n/[^]

How Use Sql Query in CryStal Report Using Vb.net and VS 2005

i Am Using Vb.net , Visual Studio 2005
i Create Crystal Report with DataSet But can create simple Report with the help of dataset but how i can write where clause or condition with sqlcommand
now a days i create with these step >>
1st Create Dataset use TableAdapter (show in image1)
2nd DataSet Attach With Crystal Report
3rd this Code use in Vb.net of Button


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim rpt As testformularpt = New testformularpt
Dim ds As testformuladataset = New testformuladataset
Dim adp As testformuladatasetTableAdapters.DCMasterTableAdapter = New testformuladatasetTableAdapters.DCMasterTableAdapter
adp.Fill(ds.DCMaster)
rpt.SetDataSource(ds)
CrystalReportViewer1.ReportSource = rpt
CrystalReportViewer1.SelectionFormula() = "{DcMaster.DCNo}in [''" & Trim(txttest.Text) & "'' ,''" & Trim(Txttest1.Text) & "''] "


End Sub

But i Cant wrtie Manual Sql Query
Just I Write Sql Query herelike this "select * from emp where Date between &textbox1& and &textbox2&
What Should i Change here to Write Sql Query here

image 1 and 2 here
http://postimg.org/image/ro5qm2puf/[^]
http://postimg.org/image/4nz39qs0n/[^]

推荐答案

亲爱的saimm，



只需按照此代码。







protected void Page_Load（对象发送者） ，EventArgs e）

{

int sectid;



CrystalDecisions.Shared.ConnectionInfo myconn = new CrystalDecisions。 Shared.ConnectionInfo（）;

sectid = int.Parse（Session [SectId]。ToString（））;

ReportDocument doc = new ReportDocument（）;

s tring path;

path = Server.MapPath（Request.Path.Substring（0，Request.Path.LastIndexOf（/））+\\Reports\\）;

doc.Load（path +exammarkscard.rpt）;



JPCIReports.ExammarkscardDataTable exmdt = new JPCIReports.ExammarkscardDataTable（）; <登记/>
SqlDataAdapter的广告=新的SqlDataAdapter（选择JPCTsnTestRExamResult.strRegno，JPCTsnTestRExamResult.strStudentName，strFatherName，strMotherName，strMedium，strAcademicYear，strSectionName，strTestName，strFirstLangName，strFirstLangMarks，strSecondLangName，strSecondLangMarks，strSub1Name，strSub1Marks，strSub1LabMarks，strSub2Name ，strSub2Marks，strSub2LabMarks，strSub3Name，strSub3Marks，strSub3LabMarks，strSub4Name，strSub4Marks，strSub4LabMarks，intGrandTotal，strRemarks，strAdmissionNo，JPCMstCombinations.intCombinationId，JPCMstCombinations.strCombinationName从JPCTsnTestRExamResult，JPCMstSection，JPCMstTestsRExam，JPCMstStudents，JPCMstAcademicYears，JPCMstCombinations其中JPCTsnTestRExamResult.intTestRExamId = JPCMstTestsRExam.intTestRExamId和JPCTsnTestRExamResult.intSectionId = JPCMstSection.intSectionId和JPCMstStudents.strRegno = JPCTsnTestRExamResult.strRegno和JPCTsnTestRExamResult.intAcademicId = JPCMstAcademicYears.intAcademicId和JPCTsnTestRExamResult.intAcademicId = + int.Parse（会话[ AcademicId]。 ToString（））+和JPCTsnTestRExamResult.intSectionId =+ sectid +和JPCTsnTestRExamResult.intTestRExamID = 10和JPCMstCombinations.intCombinationID = JPCMstStudents.intCombinationID和bSoftDelete = 0，（SqlConnection）Application.Get（JPC））; <登记/>
//选择JPCTsnTestRExamResult.strRegno，JPCTsnTestRExamResult.strStudentName，strFatherName，strMotherName，strMedium，strAcademicYear，strSectionName，strTestName，strFirstLangName，strFirstLangMarks，strSecondLangName，strSecondLangMarks，strSub1Name，strSub1Marks，strSub1LabMarks，strSub2Name，strSub2Marks，strSub2LabMarks， strSub3Name，strSub3Marks，strSub3LabMarks，strSub4Name，strSub4Marks，strSub 4LabMarks，intGrandTotal，strRemarks，strAdmissionNo，JPCMstCombinations.intCombinationId，JPCMstCombinations.strCombinationName从JPCTsnTestRExamResult，JPCMstSection，JPCMstTestsRExam，JPCMstStudents，JPCMstAcademicYears，JPCMstCombinations其中JPCTsnTestRExamResult.intTestRExamId = JPCMstTestsRExam.intTestRExamId和JPCTsnTestRExamResult.intSectionId = JPCMstSection.intSectionId和JPCMstStudents.strRegno = JPCTsnTestRExamResult。 strRegno和JPCTsnTestRExamResult.intAcademicId = JPCMstAcademicYears.intAcademicId和JPCMstCombinations.intCombinationID = JPCMstStudents.intCombinationID和JPCMstStudents.bSoftDelete = 0

ad.Fill（exmdt）;

doc.SetDataSource（ （DataTable）exmdt）;

CrystalReportViewer1.ReportSource = doc;

CrystalReportViewer1.DataBind（）;

}



但它是在c＃中尝试在vb.net中制作





问候，



AnilKumar

Dear saimm,

Just follow this code.



protected void Page_Load(object sender, EventArgs e)
{
int sectid;

CrystalDecisions.Shared.ConnectionInfo myconn = new CrystalDecisions.Shared.ConnectionInfo();
sectid = int.Parse(Session["SectId"].ToString());
ReportDocument doc = new ReportDocument();
string path;
path = Server.MapPath(Request.Path.Substring(0,Request.Path.LastIndexOf("/")) +"\\Reports\\");
doc.Load(path + "exammarkscard.rpt");

JPCIReports.ExammarkscardDataTable exmdt = new JPCIReports.ExammarkscardDataTable();
SqlDataAdapter ad = new SqlDataAdapter("select JPCTsnTestRExamResult.strRegno,JPCTsnTestRExamResult.strStudentName,strFatherName,strMotherName,strMedium,strAcademicYear,strSectionName,strTestName,strFirstLangName,strFirstLangMarks,strSecondLangName,strSecondLangMarks,strSub1Name,strSub1Marks,strSub1LabMarks,strSub2Name,strSub2Marks,strSub2LabMarks,strSub3Name,strSub3Marks,strSub3LabMarks,strSub4Name,strSub4Marks,strSub4LabMarks,intGrandTotal,strRemarks,strAdmissionNo,JPCMstCombinations.intCombinationId,JPCMstCombinations.strCombinationName from JPCTsnTestRExamResult,JPCMstSection,JPCMstTestsRExam,JPCMstStudents,JPCMstAcademicYears,JPCMstCombinations where JPCTsnTestRExamResult.intTestRExamId=JPCMstTestsRExam.intTestRExamId and JPCTsnTestRExamResult.intSectionId=JPCMstSection.intSectionId and JPCMstStudents.strRegno=JPCTsnTestRExamResult.strRegno and JPCTsnTestRExamResult.intAcademicId=JPCMstAcademicYears.intAcademicId and JPCTsnTestRExamResult.intAcademicId=" + int.Parse(Session["AcademicId"].ToString()) + " and JPCTsnTestRExamResult.intSectionId=" + sectid + " and JPCTsnTestRExamResult.intTestRExamID=10 and JPCMstCombinations.intCombinationID=JPCMstStudents.intCombinationID and bSoftDelete=0", (SqlConnection)Application.Get("JPC"));
// select JPCTsnTestRExamResult.strRegno,JPCTsnTestRExamResult.strStudentName,strFatherName,strMotherName,strMedium,strAcademicYear,strSectionName,strTestName,strFirstLangName,strFirstLangMarks,strSecondLangName,strSecondLangMarks,strSub1Name,strSub1Marks,strSub1LabMarks,strSub2Name,strSub2Marks,strSub2LabMarks,strSub3Name,strSub3Marks,strSub3LabMarks,strSub4Name,strSub4Marks,strSub4LabMarks,intGrandTotal,strRemarks,strAdmissionNo, JPCMstCombinations.intCombinationId,JPCMstCombinations.strCombinationName from JPCTsnTestRExamResult,JPCMstSection,JPCMstTestsRExam,JPCMstStudents,JPCMstAcademicYears,JPCMstCombinations where JPCTsnTestRExamResult.intTestRExamId=JPCMstTestsRExam.intTestRExamId and JPCTsnTestRExamResult.intSectionId=JPCMstSection.intSectionId and JPCMstStudents.strRegno=JPCTsnTestRExamResult.strRegno and JPCTsnTestRExamResult.intAcademicId=JPCMstAcademicYears.intAcademicId and JPCMstCombinations.intCombinationID=JPCMstStudents.intCombinationID and JPCMstStudents.bSoftDelete=0
ad.Fill(exmdt);
doc.SetDataSource((DataTable)exmdt);
CrystalReportViewer1.ReportSource = doc;
CrystalReportViewer1.DataBind();
}

But it is in c# try to make it in vb.net


Regards,

AnilKumar

这篇关于如何在使用Vb.net和VS 2005的CryStal报告中使用Sql查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！