水晶报表数据源验证问题

aro 2005-03-29 03:19:11
要求是水晶报表的数据源没有从数据库取出,加载的时候老让我登陆数据库,怎么解决??
例:
我建了一个数据集Dataset1.xsd,加了一个表table1,有字段ID和Title
代码如下:
Dataset1 d1 = new Dataset1();
dataTable = d1.table1;
for(int i=0;i<3;i++)
{
dataRow = dataTable.NewRow();
dataRow["ID"] = i+1;
dataRow["Title"] = "AAAA";
dataTable.Rows.Add(dataRow);
}
CrystalReport1 cr1 = new CrystalReport1();
cr1.SetDataSource(d1.table1);
this.crystalReportViewer1.ReportSource = cr1;
this.crystalReportViewer1.RefreshReport();
怎么把数据库登陆验证环节去掉啊,因为我跟本没有从数据库取数据啊
...全文
155 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
nytony 2005-04-14
  • 打赏
  • 举报
回复
gz
silverseven 2005-04-06
  • 打赏
  • 举报
回复
this.lbl_Message.Visible=false;

if(!entryAreaInputCheck())
{
return;
}

string DataYearForm = "";
string DataYearTo = "";
string DataMonthForm = "";
string DataMonthTo = "";


//Get DateTime From Input
if(TxtFrom.Text.Trim()==""|| TxtTo.Text.Trim()=="")
{
if(TxtFrom.Text.Trim()==""&&TxtTo.Text.Trim()=="")
{
DataYearForm =DateTime.Now.Year.ToString();
DataMonthForm =DateTime.Now.Month.ToString();
DataYearTo =DateTime.Now.Year.ToString();
DataMonthTo =DateTime.Now.Month.ToString();
}
else if(TxtFrom.Text.Trim()==""&&TxtTo.Text.Trim()!="")
{
DataYearTo =TxtTo.Text.Trim().Substring(0,4);
DataMonthTo =TxtTo.Text.Trim().Substring(5,2);
}
else if(TxtTo.Text.Trim()==""&&TxtFrom.Text.Trim()!="")
{
DataYearForm =TxtFrom.Text.Trim().Substring(0,4);
DataMonthForm =TxtFrom.Text.Trim().Substring(5,2);
}
}
else
{
DataYearForm =TxtFrom.Text.Trim().Substring(0,4);
DataYearTo =TxtTo.Text.Trim().Substring(0,4);
DataMonthForm =TxtFrom.Text.Trim().Substring(5,2);
DataMonthTo =TxtTo.Text.Trim().Substring(5,2);
}


//Get Staff Name
string strUid =UserInfo.EmpNum;
string strForm ="";
string strTo ="";
int dayTo ;

if(TxtFrom.Text.Trim()==""|| TxtTo.Text.Trim()=="")
{
if(TxtFrom.Text.Trim()==""&& TxtTo.Text.Trim()=="")
{
dayTo = DateTime.DaysInMonth(int.Parse(DataYearTo),int.Parse(DataMonthTo));
strForm = DataYearForm+DataMonthForm.PadLeft(2,'0')+"01";
strTo = DataYearTo+DataMonthTo.PadLeft(2,'0')+dayTo.ToString();
}
else if(TxtFrom.Text.Trim()=="" && TxtTo.Text.Trim()!="")
{
dayTo = DateTime.DaysInMonth(int.Parse(DataYearTo),int.Parse(DataMonthTo));
strTo = DataYearTo+DataMonthTo.PadLeft(2,'0')+dayTo.ToString();
}
else if(TxtFrom.Text.Trim()!="" && TxtTo.Text.Trim()=="")
{
strForm = DataYearForm+DataMonthForm.PadLeft(2,'0')+"01";
}

}
else
{
//change the Month go to DateTime Type
dayTo = DateTime.DaysInMonth(int.Parse(DataYearTo),int.Parse(DataMonthTo));
strForm = DataYearForm+DataMonthForm.PadLeft(2,'0')+"01";
strTo = DataYearTo+DataMonthTo.PadLeft(2,'0')+dayTo.ToString();
}

//get DataSet
DataSet ds= new LeaveSystem.Logic.ReportLeavStaffDB().
GetReportLeavStaff(strUid,strForm,strTo,UserInfo.LangCode,UserInfo.WorkCmpy,UserInfo.WorkLocn);

if(ds.Tables[0].Rows.Count==0)
{
lbl_Message.Visible=true;
lbl_Message.Text = GetMessage("3004");
return;

}
for(int i=0;i<ds.Tables[0].Rows.Count;i++)
{
for(int j = i+1;j<ds.Tables[0].Rows.Count;j++)
{
if(ds.Tables[0].Rows[j]["LEAV_TYPE"].ToString()==ds.Tables[0].Rows[i]["LEAV_TYPE"].ToString())
{
ds.Tables[0].Rows[j]["LEAV_TYPE"]="";
}
}

string strstatcodeshow = ds.Tables[0].Rows[i]["STAT_CODE_SHOW"].ToString();

string strUid2 =ds.Tables[0].Rows[i]["EMP_NUM"].ToString();
string strformum =ds.Tables[0].Rows[i]["FORM_NUM"].ToString();
string strappname = new LeaveSystem.Logic.ReportLeavStaffDB().GetReportLeavstrAppname(strUid2, strformum);
//

ComLocalDiff Language = new ComLocalDiff(UserInfo.LangCode);
Language.SetMsgList("dsp_ReportLeavStaff");

switch(strstatcodeshow)
{
case "S":
ds.Tables[0].Rows[i]["STAT_CODE_SHOW"] = Language.GetMessageItem("2003")+strappname+Language.GetMessageItem("2004");
break;
case "N":
ds.Tables[0].Rows[i]["STAT_CODE_SHOW"] = Language.GetMessageItem("2005");
break;
case "C":
ds.Tables[0].Rows[i]["STAT_CODE_SHOW"] = Language.GetMessageItem("2006");
break;
case "A":
ds.Tables[0].Rows[i]["STAT_CODE_SHOW"] = Language.GetMessageItem("2007");
break;
case "R":
ds.Tables[0].Rows[i]["STAT_CODE_SHOW"] = Language.GetMessageItem("2008");
break;
case "X":
ds.Tables[0].Rows[i]["STAT_CODE_SHOW"] = Language.GetMessageItem("2009");
break;
case "D":
ds.Tables[0].Rows[i]["STAT_CODE_SHOW"] = Language.GetMessageItem("2006");
break;
case "V":
ds.Tables[0].Rows[i]["STAT_CODE_SHOW"] = Language.GetMessageItem("2010");
break;
default:
break;
}
}
DataTable dt = ds.Tables[0];

//Put DataSet into Crystal
ReportClass crReportDocument = getreportObject();
crReportDocument.SetDataSource(dt);
landlordh 2005-03-30
  • 打赏
  • 举报
回复
eg.
Dim d1 As New DataSet
Dim i As Integer
For i = 0 To 3
Dim dr As DataRow = d1.Tables(0).NewRow
dr(0) = i + 1
dr(1) = "dsfsdaf"
d1.Tables(0).Rows.Add(dr)
Next
Dim dry As New CrystalReport1
dry.SetDataSource(d1.Tables(0))
dry.Refresh()
crystalReportViewer1.ReportSource = dry

4,819

社区成员

发帖
与我相关
我的任务
社区描述
.NET技术 图表区
社区管理员
  • 图表区社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧