|
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.
|
|
|
|
|
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.
|
|
|
|
|
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!
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
|
|
|
|
|
Write a proc that returns only the current page of results, I assume you're not showing 100000 records ?
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 )
|
|
|
|
|
No I am not returning all the records.
exec sp_executesql N'SELECT Asset.*
FROM Asset
WHERE (AssetGroupId = @AssetGroupId)',N'@AssetGroupId int',@AssetGroupId=147
is the sql that runs which obviously is a very simple query. ran in sql takes less than a second.
please advise it takes about 20-30 seconds to load up a page when i change a AssetGroupId dropdown list
|
|
|
|
|
So, how many records does the SQL return ? How are you showing them ? If you're getting 10000 records and then using a paged control, odds are high that all 100000 are in viewstate, hence the delay
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 )
|
|
|
|
|
I'm reading data from a file and the date is formatted as YYYYMMDD. What I need to to is calculations such date one minus date two = 30 days. Needless to say if I format the days as integer and subtact them I don't get the proper answer (eg 20070101 - 20060101) Jan 06 to Jan 07 isn't 10,000 days. Does anyone have any suggestions or better yet some related reading material. Thanks.
George
|
|
|
|
|
Read MSDN on the DateTime class, it holds all you need and more.
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Use the DateTime.ParseExact method to parse the string into a DateTime Value. Then you can do calculations on it.
---
"Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things."
-- Douglas Adams
|
|
|
|
|
Any Good reading on the DateTime.ParseExact method. Something with examples if possible. I did a google search with less than impressive results. Thanks.
George
|
|
|
|