|
Sorry Mazdak ,
but in my application i ahve to use all theis data in the same time so i have to load all data to the dataset
Mhmoud Rawas
------------
Software Eng.
|
|
|
|
|
What is your application doing with all this data? Is it disconnected? (e.g. it grabs a quantity of data then stores it locally while the PC is taken out into the field) Or is it always going to be connected? (e.g. an office computer on a LAN)
For 80K+ rows on one table joined to another in a dataset it a little excessive. If you must pull all this data on to the client then have you considered using a data reader to pull the data across? You won't have the storage issues because the only data being stored is the row being worked on. Of course this will only work for a foward only view of the data.
Have you considered not pulling the data to the client machine at all? Why not use a stored procedure to process the data on the server? That way you reduce network traffic also and since all the processing is done on the database server it should be much faster than processing it on the client.
EuroCPian Spring 2004 Get Together[^]
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar
"Get in touch with your Inner Capitalist - I wish you much success!" -- Christopher Duncan, Lounge 9-Feb-2004
|
|
|
|
|
Dear Colin Angus Mackay,
Thank you for your replay first of all the application needs all this data in the client side for drawing, it is an application which deal with Maps and this data is a map data (vector map).
The problem which I have is somehow strange when I use fill all the data in one dataset I have the problem but when I have tried to divide the data on multiple datasets I had a better performance for the application why? I don't know.. in the tow cases I am using the same connection and the same data adaptor for data filling and I don't think that it is a problem of using data adaptor instead of using data reader, so if you have any other note could you please send it to me and I will be thankful for that
Best Regards
Mhmoud Rawas
------------
Software Eng.
|
|
|
|
|
Does matter what it's used for, loading all of it in a DataSet loads the entire data set into memory. Speed should be your last concern.
You don't need to load all of it into memory at once. Even applications like MapPoint don't need to load the entire map (topographical, politcal, whatever) with all its information into memory. Only the view is. Games are designed no differently. Entire worlds (maps) aren't loaded into memory at once. You'd get horrible fps! Besides, your drawing routines can't draw all those rows of data simultaneously - even with SMP.
Read-in your data in chunks - only a few rows at a time. There's no way you can speed-up the look-ups or decrease memory consumption to the point where anything graphical has any decent fps with this many records.
You'd be wise to pick up a book on games programming as well (even though this might not pertain to games). The concept of world/view is what you need. Only draw the data that's visible. There are other books that cover this sort of thing, too, but you'll probably find more books out there about programming games than anything else.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Hii
i would like to know how to display Hindi or Chinese messages in my application.
i would also like to know how to display Menu items in some other language.
|
|
|
|
|
You must install characters in your development andd end user machine.
Mazy
You're face to face,
With the man who sold the world - David Bowie
|
|
|
|
|
Can u pls give me an example.
i mean when i write the code in the coding window it's always in english.
|
|
|
|
|
Anonymous wrote:
Can u pls give me an example.
i mean when i write the code in the coding window it's always in english.
Have you install those language i your machine? If yes, then simply choose the language from taskbar when you are in coding window. How do you type them in MS Word? And after that you have to SAVE AS it as Unicode Encoding, UTF-8 .
Mazy
You're face to face,
With the man who sold the world - David Bowie
|
|
|
|
|
First, as Mazdak said, you have to have the fonts (not characters) installed on your system. Many of the OpenType fonts like Arial, Verdana, and Times already have the full Unicode character set supported (at least at the time of their release).
You can further write your applications in your native language (known as the neutral language - the resources that are compiled into your primary assembly) and have other languages - not just text but layouts and other settings as well - in satellite assemblies. In you look in the .NET Framework SDK documentation, there's an entire section didicated to localizing applications, including some examples (though most of this can be done in the VS.NET designer if you like that sort of thing - just see the Localized and Language properties of the Form that's open in the designer).
See Developing World-ready Applications[^] in the .NET Framework SDK for more information, especially the section, Resources in Applications[^].
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Hello, i used to develop my Web applications using the well know way.. Data layer, dataprovider class, bussiness layer, interface layer.. the dataprovider class is like this:
public class DataProvider
{
public void AddItem(Item item)
{
// SQL COMMANDS
}
public Item GetItem(int itemID)
{
// SQL Commands
return item;
}
}
the bussiness layer would look like this:
public class Item
{
int _itemID;
int _itemName;
int _blahBlah;
// properties
}
public class Items
{
public void AddNew(Item item)
{
DataProvider.AddItem(item);
}
public Item Get(int itemID)
{
Item item = DataProvider.GetItem(itemID);
return item;
}
}
well,, that was nice and lovely.. everything was ok,, until i had to do a windows Forms application... which i am not familiar with 
the app i'm doing is kinda complicated.. its for a school. and i have to take care of students, subjects, administrators.. and so on therefore, if i use the old way i used to use in my web application.. i think i will have problems,, coz i will use alot of DataGrids..
Simply, i don't know what to do at all
i know about DataSet, but i don't know how to use it and n-tier application,, how to design the classes to deal with DataSets. should i do the old way but return datasets instead of particular objects "like Item for example", what the #$#$ should i do.. i'm really lost... Can u please help me
i just need to know how to design the layers.. just hints.. or main concept for designing classes that deals with DataSet...
thanx
|
|
|
|
|
|
i saw a sample in MSDN, it wasn't helpful.. i need suggestions
|
|
|
|
|
download thr trial al oloero, or llblgen and check out the samples. They use Collections or ArrayLists as "dataset" and classes that represent a table in the databases.
|
|
|
|
|
DataSets are like disconnected-recordsets, but they can track relationships, enforce constrains, and contains different Types. The best way to understand these is read the documentation for the DataSet class and its members. There's also a section on ADO.NET with DataSets in the .NET Framework SDK that you should read. Don't just look at one example on MSDN and call it quits.
When you create a strongly-typed DataSet, you can refer to tables and columns by name. Strongly-typed DataSets also perform better before columns (when identitied by name) are faster to resolve (fewer look-ups are required, and indexes are cached).
You can easily bind these to controls in Windows Forms and ASP.NET controls. You could use this logic in both environments.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
not sure if this is the best forum for this...
i am trying to figure out how to set the "application icon" for my C# winforms project, (ie the icon you see from explorer, etc)
at one point it was the same as the main form's icon, but no longer...
i cannot find anywhere in VS.net to set this, i am pretty sure there is a compiler flag i can use,something like /w32icon but i would like to remain in VS.net if possible
Thanks for any help
|
|
|
|
|
|
msdn claims there is a general property page under "common" properties....
perhaps this is not included in VS.net 2002?
i suppose i can compile from commandline for release builds... just kind of a big nuisance
|
|
|
|
|
Verdant123 wrote:
i am trying to figure out how to set the "application icon" for my C# winforms project, (ie the icon you see from explorer, etc)
Try right clicking on the project and selecting "Properties". The option should appear in the window that opens up.
- Nick Parker
My Blog
|
|
|
|
|
thanks!
i was being dunce and looking at the solution properties... now i have my purdy icon 
|
|
|
|
|
How do I declare a string array and give it a value? This is what I have, what do I need to change? It says I need a "]" after the one.
public string[] strGeoq = new string[30];
strAnimalsq[1] = "Blah Blah Blah";
|
|
|
|
|
public string [] sValue = new string[10];
sValue[1]="your value";
|
|
|
|
|
I just tried with, with the space between string and the brackets; it didn't work.
|
|
|
|
|
Eric Houser wrote:
public string[] strGeoq = new string[30];
strAnimalsq[1] = "Blah Blah Blah";
Is this your sig or the error code?
leppie::AllocCPArticle("Zee blog");
Seen on my Campus BBS: Linux is free...coz no-one wants to pay for it.
|
|
|
|
|
Eric Houser wrote:
public string[] strGeoq = new string[30];
strAnimalsq[1] = "Blah Blah Blah";
Assuming this is your code as it is now
class Test
{
public Test()
{
}
public string[] strGeoq = new string[30];
strGeoq[1] = "Blah Blah Blah";
}
It can't be done that way, it would have to be something like this
class Test
{
public Test()
{
}
public string[] strGeoq = new string[30];
public void Init()
{
strGeoq[1] = "Blah Blah Blah";
}
}
or
class Test
{
public Test()
{
}
public string[] strGeoq = {"Blah, Blah, Blah", "Another Blah", etc"};
}
Michael
But you know when the truth is told,
That you can get what you want or you can just get old,
Your're going to kick off before you even get halfway through.
When will you realise... Vienna waits for you? - "The Stranger," Billy Joel
|
|
|
|
|
ok i have this case and try almost everething and dont work ..
C++ Dll:
typedef BYTE *CCSTR;
CCSTR __stdcall Example(CCSTR data)
{
//do somthing
}
C#:
[DllImport("test.dll",CharSet=CharSet.Auto,
CallingConvention=CallingConvention.StdCall)]
static public extern string Example([MarshalAs(UnmanagedType.LPStr)] string Data) ;
if someone have idea what can be wrong that will be very cool
10x in advance
PS: Sry about my bad english
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
