Skip to Content
0
Former Member
Jul 23, 2008 at 05:48 PM

Database Login prompt

135 Views

Hi I am using Cystal Reports 2008 with Visual Studio 2008 web express and SQL server 2005. While calling crystal reports from my asp.net application I get database login prompt which I want to get rid off. Can someone help me in this. I have created file DSN and given all username pws infomation in that. My code in aspx file is as follows

protected void Page_Load(object sender, EventArgs e)

{

ArrayList arrayList = new ArrayList();

arrayList.Add(Session["BLNumber"]);

ParameterFields parameterFields = CrystalReportViewer1.ParameterFieldInfo;

SetCurrentValuesForParameterField(parameterFields, arrayList);

}

private void SetCurrentValuesForParameterField(CrystalDecisions.Shared.ParameterFields parameterFields, ArrayList arrayList)

{

ParameterValues currentParameterValues = new ParameterValues();

foreach (object submittedValue in arrayList)

{

ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue();

parameterDiscreteValue.Value = submittedValue.ToString();

currentParameterValues.Add(parameterDiscreteValue);

}

ParameterField parameterField = parameterFields[PARAMETER_FIELD_NAME];

parameterField.CurrentValues = currentParameterValues;

//DatabaseLogon_RD() ;

}