HI
I changed table name as *"Bill"* but still the problem remains constant. On Wed, Feb 25, 2009 at 2:33 AM, Jackie <[email protected]> wrote: > Hi Vanitha, > > Your query is "Select * from Bill" but you are setting the datasource for > table "Products" (in code: rptDoc.SetDataSource(ds. >> >> Tables["*product*"])), so can you try changing it to "Bill". The error I >> think is bcoz the dataset doesn't have the products table. > > > * > Jasmin* > > > On Wed, Feb 25, 2009 at 6:44 AM, vanitha palanisamy > <[email protected]>wrote: > >> Hi, >> >> my code is >> >> protected void Page_Load(object sender, EventArgs e) >> { >> >> DataSet1 ds = new DataSet1(); >> string strConn = >> ConfigurationManager.ConnectionStrings["BillDtsConnectionString"].ConnectionString; >> SqlConnection conn = new SqlConnection(strConn); >> string str = "select * from bill"; >> SqlDataAdapter da = new SqlDataAdapter(str, conn); >> da.Fill(ds, "Bill"); >> >> ReportDocument rptDoc = new ReportDocument(); >> >> rptDoc.Load(Server.MapPath("CrystalReport1.rpt")); >> rptDoc.SetDataSource(ds.Tables["product"]); >> CrystalReportViewer1.ReportSource = rptDoc; >> CrystalReportViewer1.DataBind(); >> } >> >> When i run this code am getting error as >> >> Logon failed. Details: crdb_adoplus : Object reference not set to an >> instance of an object. Error in File C:\DOCUME~1\AS\LOCALS~1\Temp\ >> >> CrystalReport1 {786134AC-53BE-4210-9505-FC7F13188C03}.rpt: Unable to >> connect: incorrect log on parameters. >> >> Can u say how to clear this one? >> >> >> >> >> >> >> On Tue, Feb 24, 2009 at 9:01 PM, Manikandan .C <[email protected]>wrote: >> >>> Dear Vanitha >>> >>> Are you created a object of Crystal report? >>> >>> Then set file Properties of Crystal report object like as Database, etc >>> >>> Manikandan.C >>> >>> >>> On 2/25/09, vanitha palanisamy <[email protected]> wrote: >>>> >>>> Hi folks, >>>> >>>> >>>> >>>> Am using crystal report in asp.net.Am <http://asp.net.am/> dynamically >>>> creating dataset for crystal report. >>>> >>>> But when i run the report am getting error as >>>> >>>> >>>> >>>> Logon failed. Details: crdb_adoplus : Object reference not set to an >>>> instance of an object. Error in File >>>> C:\DOCUME~1\AS\LOCALS~1\Temp\CrystalReport1 >>>> {786134AC-53BE-4210-9505-FC7F13188C03}.rpt: Unable to connect: incorrect >>>> log >>>> on parameters. >>>> >>>> >>>> >>>> Could anyone help? >>>> >>> >>> >> >
