C# Discussion Boards - CodeProject

User-Informations on DB or in RAM?

29-May-09 23:52

Hey. Here's not a place to advertise your website. People learn things here. Stop spamming.

"I hope you live a life you're proud of. If you find that you're not, I hope you have the strength to start all over again."
- I wish I knew who is this quote from

Re: hi

Mohammad Dayyan29-May-09 23:56

Mohammad Dayyan

29-May-09 23:56

Hi hamed.
Are you OK ?
What would you want to ask ?

hamed02129-May-09 23:40

hamed021

29-May-09 23:40

load()
function load()
{
window.open('http://www.baziran.com')
}

softwarejaeger29-May-09 22:48

softwarejaeger

29-May-09 22:48

Hello,

i have a little decision-problem Smile | :)

I create a new server-application which works together with client-applications. The Server-Application must manage the users, which are signed in and are online. So... how should i save this informations? Is it better to store it in the RAM (i make a List<onlineusers> where the Classes with the UserInformations are in there), or should i better save them in a DB, where i have the passwords and so on too? My Problem is, i don't know how many users will use this client-application! There could be 100 users or 10 000 users!

But this wouldn't be the problem, the big problem is, that this server only exchange user-informations, and so if i have maybe 10 000 users and a lot of users asking for informations about other users i could get in trouble if i have the data in the RAM (maybe not enough RAM?) and if i have it in a DB i have a very big HardDisk IO! The TCP-Connections at last i MUST store in the RAM of course, so anytime i need informations in the RAM about my Users...

So, has somebody any idea which technique i should use to get the best performance out of it?

Many Thanks Smile | :)

Re: User-Informations on DB or in RAM?

Manas Bhardwaj29-May-09 23:30

Manas Bhardwaj

29-May-09 23:30

softwarejaeger wrote:
There could be 100 users or 10 000 users!

Well, first you need decide or collect information about the scope of your application.
Every application is designed according to certain breakpoints keeping in mind.

softwarejaeger wrote:
So, has somebody any idea which technique i should use to get the best performance out of it?

In any case, SQL Server is quite fast and if you say that your user base can grow upto 10000, it would be wise to use the standard approach and let SQL Server do what it does the best. Smile | :)

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Receive emails using POP3

alisolution29-May-09 22:47

alisolution

29-May-09 22:47

hi,
i want to receive all emails from my account.
just like i Retrieve From,To,Subject,Body in DataTable
Is it Possible ? in Codes.

Re: Receive emails using POP3

Nicholas Butler29-May-09 23:15

Re: Receive emails using POP3

29-May-09 23:15

Yes, it's possible.

http://www.faqs.org/rfcs/rfc1939.html[^]

Nick

----------------------------------
Be excellent to each other Smile | :)

Mycroft Holmes30-May-09 0:11

Mycroft Holmes

30-May-09 0:11

Where do you get these things?

Category: Standards Track                                       May 1996

Never underestimate the power of human stupidity
RAH

How to display a column value from database to label

Mads11529-May-09 21:23

Mads115

29-May-09 21:23

HI
In my windows application i am creating a registration form..
after registration i want to display the register number in Label Cntrl from database(MSSQL2005)...
i tried this but not working

SqlConnection con = new SqlConnection("server=AAB;database=ab;uid=sa;pwd=pass");
con.Open();

SqlCommand cmd = new SqlCommand("insert into myTable values ('"+textBox1.Text+"') ", con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
label1.Text= dr["id"].ToString();
}
dr.Close();

Thankx in advance

Re: How to display a column value from database to label [modified]

Prasanth MS29-May-09 21:56

Prasanth MS

29-May-09 21:56

Problem I traced is
1) The SQL Command is "INSERT" instead of select command. Insert Command insert data into tables and return the number of records inserted.

2) DataReader returns object. You have to convert the same into the data type you want eg. code
{
object obj = dr.read();
Convert.ToString(obj);
}

SO YOUR REQUIRED CODE SHALL BE LIKE FOLLOWS
----
SqlConnection con = new SqlConnection("server=AAB;database=ab;uid=sa;pwd=pass");
con.Open();

SqlCommand cmd = new SqlCommand("SELECT * FROM myTable", con);
SqlDataReader dr = cmd.ExecuteReader();

while (!dr.IsDbNull())
{
Object obj = dr.Read();
label1.Text= obj.ToSring();
}
dr.Close();

---

try and reply.

modified on Saturday, May 30, 2009 4:09 AM

Re: How to display a column value from database to label

Mads11529-May-09 22:28

Mads115

29-May-09 22:28

Thank you Prasanth it works Smile | :)

print job

hassannikoo29-May-09 21:13

hassannikoo

29-May-09 21:13

hi i want to code a project that can view all available printers (physical or not) or network printers and can show all print jobs and any information that can be show like number of copies users name printer name and .. i search for it but some cases the program info wrong information please help me any information can be helpful thanks a lot HN Smile | :)

Re: print job

I Believe In GOD30-May-09 5:26

I Believe In GOD

30-May-09 5:26

public static ArrayList EnumPrinters()<br />
        {<br />
            ArrayList ArrPrinters = new ArrayList();<br />
            ObjectQuery oQuery = new ObjectQuery("SELECT * FROM Win32_Printer");<br />
            ManagementObjectSearcher oSearcher = new ManagementObjectSearcher(oQuery);<br />
            ManagementObjectCollection oReturnCollection = oSearcher.Get();<br />
            foreach (ManagementObject oReturn in oReturnCollection)<br />
            {<br />
                if (oReturn["Name"] != null)<br />
                {<br />
                    ArrPrinters.Add(oReturn["Name"].ToString().Trim());<br />
                }<br />
            }<br />
            return ArrPrinters;<br />
        }

I know nothing , I know nothing ...

Image Encrypton

saadtahir29-May-09 21:01

saadtahir

29-May-09 21:01

hi ..
is there any way to encrpt a image n .docx file using c#
thnks

Re: Image Encrypton

Manas Bhardwaj29-May-09 23:33

Manas Bhardwaj

29-May-09 23:33

Here is an example for this on MSDN[^]

You could have saved a lot of time by using Google. Wink | ;)

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Image Encrypton

saadtahir30-May-09 18:56

saadtahir

30-May-09 18:56

yeah i m using google bt nt getting the rite stuff...

Re: Image Encrypton

Rajesh R Subramanian30-May-09 0:19

Rajesh R Subramanian

30-May-09 0:19

Encrypting the docx file as a whole does not look like an idea to you? (Unless of course you are willing to write your own app to display the encrypted docx file).

Search Google for C# AES.

It is a crappy thing, but it's life -^ Carlo Pallini

IPC

Hamed Musavi29-May-09 20:07

29-May-09 20:07

Hi.

I have a windows service. I want to write an (C# .net) application that users run to communicate with the service. There is no restriction on .net version but security is important. What solution do you suggest?

I did a bit of research and found out named pipes and LRPC are good choices among other technologies. However it looks like in .net we'd better use WCF which, for IPC, supports named pipes. But WCF seems to have a steep learning curve. So I decided to ask you before I start to learn it.

Thank you very much for you help in advanced.

"I hope you live a life you're proud of. If you find that you're not, I hope you have the strength to start all over again."
- I wish I knew who is this quote from

Nicholas Butler29-May-09 23:21

29-May-09 23:21

I used WCF for exactly this purpose. There is a learning curve - mostly because of the number of configurable options exposed. I recommend "Programming WCF Services" by Juval Lowy - it's on Safari.

Nick

----------------------------------
Be excellent to each other Smile | :)

Hamed Musavi29-May-09 23:32

29-May-09 23:32

Nick Butler wrote:
I recommend "Programming WCF Services" by Juval Lowy

Thanks. I found it here[^].

Thank you so much for your great help. I'll start reading in a few minutes. Smile | :)

"I hope you live a life you're proud of. If you find that you're not, I hope you have the strength to start all over again."
- I wish I knew who is this quote from

Hamed Musavi29-May-09 23:42

29-May-09 23:42

By the way, How was the performance? Does it support only named pipes for IPC?

I think there must be these information in the book but I can't wait to know them! Sorry. Blush | :O

"I hope you live a life you're proud of. If you find that you're not, I hope you have the strength to start all over again."
- I wish I knew who is this quote from

Nicholas Butler30-May-09 1:25

30-May-09 1:25

Performance was fine. It supports everything from named pipes to https.

You need the ABCs: Address, Binding, Contract. You can mostly mix and match these - I think I used a tcp binding as I needed to support remote access.

Nick

----------------------------------
Be excellent to each other Smile | :)

Hamed Musavi30-May-09 4:08

30-May-09 4:08

Thank you so much Nick. Your help is really appreciated. And thank you again for the book recommendation. It's a nice book. I hope to be ready to code the communication part within a few weeks (or less maybe.)

Thanks for all the help. Rose | [Rose]

"I hope you live a life you're proud of. If you find that you're not, I hope you have the strength to start all over again."
- I wish I knew who is this quote from

Hamed Musavi30-May-09 23:43

30-May-09 23:43

Hi. I just wanted to thank you again for the book recommendation. What a nice book. I enjoy reading every line. Such books can't be found easily these days. It has been kind of you. Thank you very much. Smile | :)

"I hope you live a life you're proud of. If you find that you're not, I hope you have the strength to start all over again."
- I wish I knew who is this quote from

Nicholas Butler30-May-09 23:45