C# Discussion Boards - CodeProject

GA-BOYZ12-Nov-04 11:33

12-Nov-04 11:33

Hi,

I have an application that works with SQL for database.
Inside the application, I have a datagrid that shows the necessary information that I wanted.
The amount data I have is 100,000 records.
And I am trying to improve the performance when user opening the datagrid.

This is the big picture of what I've got.
When the form is being loaded, I create a thread with normal priority, and then load the all the database to the dataset.
From that dataset, I used dataview to view the data into datagrid, since I am doing search or filter based on user input.
The database table it self doesn't have so many columns, total there are 15 columns, and I only retreive 6 of them.

Is there anyway I could improve the performace of this process, when the user open the form or datagrid?

Thank you very much in advance Smile | :)

Re: Datagrid and DataView

Skynyrd12-Nov-04 11:52

Skynyrd

12-Nov-04 11:52

Maybe u shouldn't be loading all 100,000 records into ur dataset and filtering from there.

Howbout using the user input to generate a SqlCommand and fetching only the data the user wnats from the sql database?

The downside to this is that it will create a connection to ur DB everytime the user specifies some new filtering criteria, but the cost of loading and having in memory 100,000 records of which maybe only 1% are relevant to the user is a much higher price to pay.

const int problem...!

QzRz12-Nov-04 8:58

QzRz

12-Nov-04 8:58

Hi...

I have some values, like 0x800, 0x985 and 0x5FGH!
i have made a code that looks like this...

private const int WHATEVER = 0x800;
private const int SOMETHING = 0x985;
private const int PEPSI = 0x5FGH;

But if I want to add them to one 'const int'!

I have thought of doing this...
private const int[] ALL = {0x800, 0x985, 0x5FGH};

but that does not work Frown | :(

Can anyone tell me if it this is possible, and how to do it the right way..?

Thanks...!

QzRz

Re: const int problem...!

Colin Angus Mackay12-Nov-04 9:20

Colin Angus Mackay

12-Nov-04 9:20

Try:
private readonly int[] ALL = {0x800, 0x985, 0x5F};

And, by the way, 0x5FGH is not a valid hex number.

Do you want to know more?

Re: const int problem...!

QzRz12-Nov-04 9:38

QzRz

12-Nov-04 9:38

Thanks...!

That solved anothor problem... Big Grin | :-D

so thanks again...!

QzRz

Re: const int problem...!

Roger Alsing13-Nov-04 3:33

Roger Alsing

13-Nov-04 3:33

well thats not really the same thing..

when applying readonly to an array in c# , you are only guarranteed that no one assigns a new array to your variable , there is nothing thats stops you from changing the values in the array..

eg:

private readonly int[] ALL = {0x800, 0x985, 0x5F};
..
..
..
All=new int[] {1,2,3,4}; // wont work
All[0]=666; //<-- will work !!!

//Roger

Re: const int problem...!

Colin Angus Mackay13-Nov-04 3:38

Colin Angus Mackay

13-Nov-04 3:38

So, what is the answer then?

Do you want to know more?

Re: const int problem...!

Skynyrd13-Nov-04 4:44

Skynyrd

13-Nov-04 4:44

The answer is, if u want 4 ints to be constant, then declare all 4 ints seperately as const.

Another option, is to create an enum with all const variables as its members. Thayt would ensure the readonly property of all the variables.

private enum Constants:int
{
WHATEVER = 0x0001,
SOMETHING = 0x0003,
PEPSI = 0x0005
}

Re: const int problem...!

Kofi Nimoh13-Nov-04 4:33

Kofi Nimoh

13-Nov-04 4:33

You want to bit mask them - mind you the actual values of your consts then becomes pertinent, but you end up with something like this:

private const int WHATEVER = 0x0001;
private const int SOMETHING = 0x0002;
private const int PEPSI = 0x0004;

then for 'all'

private const int ALL = (WHATEVER | SOMETHING | PEPSI);

That help?

Re: const int problem...!

Skynyrd13-Nov-04 4:58

Skynyrd

13-Nov-04 4:58

private const int ALL = (WHATEVER | SOMETHING | PEPSI)

That code is creating a new const ALL=7.

if what ur trying is to create an array:

private const int[] ALL=new int[3] {WHATEVER, SOMETHING, PEPSI}

that wont work either because int is a valuetype and therefore the array will contain the values of the consts, but not the consts themselves.

Re: const int problem...!

Kofi Nimoh13-Nov-04 5:03

Kofi Nimoh

13-Nov-04 5:03

I know it's creating a new const. That's exactly what the original message asks for:

> But if I want to add them to one 'const int'!

That's the exact question. I think the array was a red herring, no?...

Kofi
www.activepeermentoring.com

Re: const int problem...!

Skynyrd13-Nov-04 5:19

Skynyrd

13-Nov-04 5:19

Yes, of course u are creating a new const, but ur creating a const with its value = WHATEVER + SOMETHING + PEPSI.

I dont think thats what u were looking for, because if it were, then I really dont understand why all the fuzz...it would be as simple as:

private const int ALL = WHATEVER + SOMETHING + PEPSI

Again...if u want consts, then declare consts seperately...there is no way to declare an array of consts....the closest thing to that is creating an enum as i've posted before.

Server keeps client objects alive!

Judah Gabriel Himango12-Nov-04 8:32

Judah Gabriel Himango

12-Nov-04 8:32

This is a really odd problem I just discovered with our thin client app.

We have a client/server solution that utilizes .NET remoting. Basically, the client will occassionally ask for data from the server, the server will read data from a database and return it to the client. All that works well:

// on the client, ask the server for some big data
Blob[] serverObj.GetBigBlobs(); // where serverObj is a MarshalByRefObject published on the server

// on the server, handle the client request
public Blob[] GetBigBlobs()
{
   return new Blob[] {...};
}

Pretty simple example. But what I soon discovered is that when the client calls the GetBigBlobs method, the server memory shoots up (expected) but never releases the memory until the client is disconnected (unexpected), even if I force a garbage collection using GC.Collect().

So my question is, why is the server memory not being released right away? The server method creates and returns the huge Blob[], but never uses it again nor references it; so why is the garbage collector hanging onto it? The only thing that pops into my head is that the server does hold a reference to an MarshalByRefObject published by the client, but nothing else -- that shouldn't cause problems right?

Any remotely useful information on my blog will be removed immediately.

There are 10 kinds of people in the world. Those who have heard of the ubiquitous, overused, worn-out-like-an-old-shoe binary "joke" and those who haven't.
Judah Himango

call card telephony solution!

manasrahfantom12-Nov-04 8:16

manasrahfantom

12-Nov-04 8:16

hi everyone

i need an urget urgent urgent help

well what i need help in is, that i want to develop a call card solution , let me exaplin simply, my customer will buy a card, then dial a number, this number asks him to insert the pin code, the authentication is done, then the system will give him a tone and he will dial is number!

ofcourse using .NET

well thats its!

so is there anyone can lead me to anything to start with, any link or code or tutorial and wwillllll be realllyyyy thankfulllll

Kind Regards
Mahmoud Manasrah

Re: call card telephony solution!

Colin Angus Mackay12-Nov-04 9:27

Colin Angus Mackay

12-Nov-04 9:27

manasrahfantom wrote:
i need an urget urgent urgent help

So, why is it so urgent?

manasrahfantom wrote:
so is there anyone can lead me to anything to start with

Start where? There are so many areas you could start with. You are not being very specific. (I also notice you posted this in the VB.NET forum also - so you are not even being specific with the language)

I suggest you work out all the different areas that you will need to know about and then, when you have a better idea of what you are having problems with, you can come back and ask specific questions about a certain area of .NET.

Asking for help at this level marks you out as someone who has not got the slightest idea and that you are in way, way over your head.

Do you want to know more?

Re: call card telephony solution!

Michael P Butler12-Nov-04 9:37

Michael P Butler

12-Nov-04 9:37

First you need to define your hardware platform. Any decent telephone pabx will allow you to implement your requirements.

Secondly. Telephony programming is a pain to do in .NET unless the API supports it.

Michael

CP Blog [^]

Active Directory LDAP Query Problem

Adam °Wimsatt12-Nov-04 8:02

Adam °Wimsatt

12-Nov-04 8:02

The purpose of the troubled app is to return information about a list of users from Active Directory. It should return user's full name and email address. The number of users does not exceed 1000 people. The results return in less than 1 minute when ran from a regular desktop PC, but when I try running the app on a server it times out. The server is a beast of a machine in all aspects (network, processor, memory) when compared to the desktop pc. So why would it run so much slower on the server?

"...practice safe hex when IM'ing"
--Shawn L. Morrissey, Managing Editor, MSDN Online ( MSDN Flash; Volume 8, Number 20, 10/4/2004)

Flicker-free control resizing ???

TheSebaster12-Nov-04 7:22

TheSebaster

12-Nov-04 7:22

I made a simple control with 2 multiline textbox inside.
I droped a few control on a form and I resize them all when
form resize. How could I remove flicking? When it's resizing,
all text inside the control is repainted.
Thank you and sory for my poor english.

Re: Flicker-free control resizing ???

ACorbs12-Nov-04 19:40

ACorbs

12-Nov-04 19:40

this.SetStyle(System.Windows.Forms.ControlStyles.DoubleBuffer, true);
this.SetStyle(System.Windows.Forms.ControlStyles.AllPaintingInWmPaint, true);

this.UpdateStyles();

Re: Flicker-free control resizing ???

TyronX22-Dec-04 10:54

TyronX

22-Dec-04 10:54

I have the same problem and there doesn't seem to be any kind of solution for this available.

Double Buffering with that SetStyle thingy didn't work.

Create application setup

Member 87345212-Nov-04 6:51

Member 873452

12-Nov-04 6:51

I want to install DotNetFramwork befor my application automatically in my setup because as you know the DotNetFramwork must be installed for C# programs

Re: Create application setup

MoustafaS12-Nov-04 12:27

MoustafaS

12-Nov-04 12:27

Do u want to do it by your C# program or what there is no way for that cuz that program won't start the only way for this is the pc that the program will be on it to have the .NET framework installed or In the README file give them instructions to download it and give them the link to the direct download

ByMindOnlyYouCanDoIt

Command Parameter Issue

RB@Emphasys12-Nov-04 5:48

RB@Emphasys

12-Nov-04 5:48

So Im calling a sproc with various required parameters. It returns a value through one of its parameters, so, I added the following to lines to my command object setup;

oCommand.Parameters.Add(new SqlParameter("@Return_ValueMsg", SqlDbType.VarChar, 255));
oCommand.Parameters["@Return_ValueMsg"].Direction = ParameterDirection.ReturnValue;

But...., I keep getting this exception when I try to execute the command,
{"Procedure 'glpImportJEFromProcurement' expects parameter '@Return_ValueMsg', which was not supplied." }

Any Idea's?

Thanks,
Ryan

Re: Command Parameter Issue

Richard Deeming12-Nov-04 6:27

Richard Deeming

12-Nov-04 6:27

ParameterDirection.ReturnValue is for the integer value returned from the stored procedure via the RETURN statement. Use ParameterDirection.Output instead.

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Re: Command Parameter Issue

RB@Emphasys12-Nov-04 7:54

RB@Emphasys

12-Nov-04 7:54

ahh thanks!, i just have been staring at this too long.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.