Merging DataSet = NullRefException ? [modified] - Visual Basic Discussion Boards

Hi there,

I am newbie to Crystal Report in .NET 2005. I am trying to connect my report with both SQL as well Oracle Database based on the Report Type. If the Report type is SQL, I am taking the DSN Name as input, which inturn get the Server's name from the Registry, else "Oracle" the Server Information is taken from the TNSNAMES.ORA file.

The SQL connection works fine. But when I try to connect to Oracle, I am getting the Error message as,

"Database logon failed."

Stack Trace is

Database logon failed.
Exception occured at:
at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)

at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)

at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)

at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext)

at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToDisk(ExportFormatType formatType, String fileName)

at TestDBconnection.vbproj.PaceReportsFactory.Execute(IPaceReportInfo reportInfo) in F:\PROJECTS\PaceLite\Toolkit 9.0\Crystal Report\TestDBconnection\pacereportsfactory.vb:line 65

at AdvReportTestUtility.frmAdvTest.RunReport(String& report_path, String& report_type)

PaceReportsFactory & AdvReportTestUtility are some internal utility used in our company for testing reports.

Thanks in advance.

Regards,
Venkatesh Mookkan.
Software Engineer, India
My: Website | Yahoo Group | Blog Spot

Hi in my dataset i have like this records:

UID ID MNa PID PName URL
100 1 Admin 102 Page page1.aspx
100 1 Admin 103 User page2.aspx
100 2 Gen.M 137 Mate page8.aspx
100 2 Gen.M 106 Proj page6.aspx

Now I stored this dataset in my datatable:

Dim Dt as datatable=ds.tables(0)

Now I have to Add this datatable MNa Field in my arraylist...,
But the repeated name wont ocur...,
Means i have To Bind only:

Admin
Gen.M

Plz Help me...,

Regards,
Magi

I developed a new .NET component, you can use it in order to generate a random and unique code in your registration or login pages. It's a flexible components; it means you can set the properties what ever you want like Font Family, Char Size, File Width & Height, ... . For more information about this component and download it for free Click Here!

You've reinvented the CAPTCHA, for about the zillionth time. But, your implemention is weak, really weak. It can be OCR'd quite easily. Try it yourself...

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Hi,

I would like to use MS Word in my application.
I 've designed in WORD a Dot File,
which uses a merge function, is fill some fields in this document from SQl-server!

I want to use this document in my application,
so the user pushes a button that call's the document and fills it with the correct data out of sql-server!
Something like a merge you do in Word but then from out of my application just call the letter and data and merge them!
So i have a list of maybe 100 of the same pages but only different data on it from Sql-server!

How do i do this?

hi all,

i want to interface parallel port(LPT1 and also called as centronics port) in visual basics 6.0......

so for that inpout32.dll is required....n i had downloaded this from logix4u.net......

and copy this file into windows\system32 folder......and when i m register this dll into my system it gives me error as,"inpout32.dll was loaded, but DllRegisterServer entry point was not found. so this file cant be registered."

so please help me for successful interfacing of parallel port with VB 6.0

regards,
pulkit joshi

inpout32.dll is not a com dll, it's just a regular dll. I've used it in C# to good effect, I have no idea how you call native dll methods in VB6. Why are you using VB6 in 2007 ? It's been obsolete for 5 years and unsupported for almost as long.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Hi,

I'm having a problem merging datasets to another one. For some reason I keep getting a "Object reference not set to an instance of an object." error.

<br />
Public Shared Function ConvertToNewGenericBon(ByVal anyOrder As DataSet, ByVal anyProduct As DataSet) As NewGenericOrder<br />
        Dim tmp As New NewGenericOrder<br />
        For i As Integer = 0 To anyProduct.Tables.Count - 1<br />
            tmp.Product.Merge(anyProduct.Tables(i))<br />
        Next<br />
        For i As Integer = 0 To anyOrder.Tables.Count - 1<br />
            tmp._NewGenericOrder.Merge(anyOrder.Tables(i))<br />
        Next<br />
        tmp.AcceptChanges()<br />
        Return tmp<br />
    End Function

This is the code I use to merge the datasets. There is a relationship between Product ( = child ) and NewGenericOrder ( = parent ) ! The error occurs while going to the first loop for the second time. So it merges the first Product datatable into the tmp datatable, but not the second. If I comment the first loop and let him run the Order loop, it gives me the error when I'm trying to merge the first datatable. While debugging I can see none of the datatables in anyOrder or anyProduct are null so I don't really know whats causing the error.

However if I make a for each that loops the rows in the datatables and then use .ImportRow, like the code below I don't get any errors.

Public Shared Function ConvertToNewGenericBon(ByVal anyOrder As DataSet, ByVal anyProduct As DataSet) As NewGenericOrder<br />
        Dim tmp As New NewGenericOrder<br />
        For i As Integer = 0 To anyOrder.Tables.Count - 1<br />
            For Each dr As DataRow In anyOrder.Tables(i).Rows<br />
                tmp._NewGenericOrder.ImportRow(dr)<br />
            Next<br />
        Next<br />
        For i As Integer = 0 To anyProduct.Tables.Count - 1<br />
            For Each dr As DataRow In anyProduct.Tables(i).Rows<br />
                tmp.Product.ImportRow(dr)<br />
            Next<br />
        Next<br />
            tmp.AcceptChanges()<br />
            Return tmp<br />
    End Function

Any ideas ?

Tnx in advance !

-- modified at 4:57 Friday 2nd November, 2007

Hi All! I'm struck Please help me in accessing Call Stack in Visual Basic6. I need to write it to a text file to find the order of execution of functions in the exe.

Thanks in advance.

Don't Quit

Outside of the IDE Debugger, there is no call stack or stack trace available in VB6.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Hi all,
I have old windows applications written using VS2003 on my pc. I also have VS2005, SQL2005, Crystal reports and many other programs installed.
My case is that when ever i open any old windows application on my pc, i find all the controls taking big width and located far away from the seen screen infront of me especially if a control is anchored right (I find it with a position 1200 which is outside my form)
Each time i open the design i have to retyrn back the controls to their initial position and that is distroying my design.
Any ideas, though i have SP1 installed.
Please this is embarresing me with clients.

Hi Everyone;
In installing an application that uses SQL server 2000 on the Server and like 10 Client Machines is it a must i instal client tools on the client machines?

"The reason why 5% of Americans are rich and 95% are struggling is because the 5% took action and the 95% thought of the action "

I never do

Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'

hi all

Can anyone tell me ,hw to create setup of application which has cryastal reports.By using simple setup method .application is running fine but crystal report can't executing.wt is reason.is there any other method to bind crystal report with our application.

poonam

How can i manipulate my vb.net 2003 code that has datasets , datatables and datarows present into vb.net 2005. Can you please give me a idea.

Thank You Beforehand

What exactly are you wanting to do?

Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'

hi Kendo

Try again, Explain in Detail, when you say manipulate, you dont say anything and Added vb2005.

Explain what you want to do

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

I am working on a web service that is from an old VB.Net book and it uses datasets, dataTables to store the data but i am using express web developer creating a ASP web service and coding in VB.Net. But when i enter the VB.net code with the dataset etc it is throwing up errors sayiny that they are not defined, but they are . Sorry about other message was rather tired.

Ok got it working just changed the datasets to data.datasets and so on. Big Grin | :-D

cool

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Good!

Now add this statement....

Imports System.Data

and you don't have to change all "datasets" to "data.datasets"

colgateas900197

Thank You all for your help

i've been searching the net trying to find a crc calculator that i can run from within my program to check data comming from a machine (3rd party). using HPMBCALC i've managed to determine the properties required (assuming the output is correct)

POLY 8005 (coefficients 16,15,2,0)
Init Value 0
Final Xor 0
Bit Reflected FALSE
Check Input string 123456789 or hex 31 32 33 34 35 36 37 38 39
Check Output Hex FE E8

i would really like to use my own implementation but would settle for a 3rd party dll (if i could find one).

i know vb has a problem with unsigned integers but that this can be compensated for by using a lookup table.

Any help would be greatly appreciated

tnx in advance

try to type 'CRC' in the CP article search engine: a bit of magician may happen!
Big Grin | :-D

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

Hi!

I just started using .net 2.0 I am trying to do exactly what was in this link
http://download.microsoft.com/download/8/3/6/836dd5f8-fa92-499f-8219-0d326f13bf18/hilo_data_final.wmv

I have about 100000 records but it is slow. takes about 12-20 seconds for each activity. can anyone guide me how could i speed up the response time?

thanks