C# Discussion Boards - CodeProject

15-Jul-09 2:51

musefan wrote:
System.Text.StringBuilder sb = new System.Text.StringBuilder(length);

ftfy.
I improved the performance a bit.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

hi..

mjawadkhatri15-Jul-09 1:52

mjawadkhatri

15-Jul-09 1:52

Hi.
this is my coding

string MyString;
MyString = "Select * from timemgmt";
if (radioin.Checked == true)
{
cn = new OdbcConnection("Driver={Microsoft ODBC for Oracle};Server=orcl;UID=it;PWD=cr;");

cmd = new OdbcCommand(MyString, cn);
cn.Open();
cmd.CommandText = "insert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
cmd.ExecuteNonQuery();
cn.Close();

textbox1.text = employe ID
label19.text = System Date
label18.text = System Time

i want to do Accept employee ID in one time in a day 2nd time user give same Id in a same date not accepted
plzz give me some hints

thanks in Advance

Jawad Khatri

Tom Deketelaere15-Jul-09 1:55

15-Jul-09 1:55

0) 'hi' = bad subject
1)

mjawadkhatri wrote:
cmd.CommandText = "insert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";

Use parameters (odbcparameter). (read up on sql-injunctions)

2) use the 'code block' tags to post code

3) Your question: One way to do it would be to do a select from the user + date first. If the select returns 0 rows --> insert else --> don't insert

Luc Pattyn15-Jul-09 2:05

15-Jul-09 2:05

I can't think of any more hints, those are the ones I would have given also. Big Grin | :-D

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

musefan15-Jul-09 2:09

musefan

15-Jul-09 2:09

You could try recommending a book, not the one that book stores want you to buy thou Big Grin | :-D

Life goes very fast. Tomorrow, today is already yesterday.

Luc Pattyn15-Jul-09 2:14

15-Jul-09 2:14

Nah. I only do that when a very basic question is getting asked; anyway, feel free to visit a decent book store, I could recommend the Stanford University Bookstore on the Palo Alto campus, it is quite impressive (I think it looks like an Amazon warehouse).

FYI: I added a book thread[^] on my personal CP blog for your convenience.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

musefan15-Jul-09 2:22

musefan

15-Jul-09 2:22

That's a bit far for me, but thanks none the less. I went to a book store the other day and could not even find a computer section! I'll try a different one next time...

Some good advise in your thread Smile | :)

Life goes very fast. Tomorrow, today is already yesterday.

Luc Pattyn15-Jul-09 2:25

15-Jul-09 2:25

musefan wrote:
That's a bit far for me

Same here, but I do visit it on every opportunity, which is once in ten years or so.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

musefan15-Jul-09 2:31

musefan

15-Jul-09 2:31

Well I shall keep it in mind if I am ever in the area Smile | :)

Life goes very fast. Tomorrow, today is already yesterday.

Tom Deketelaere15-Jul-09 2:32

15-Jul-09 2:32

Well for once I was first Poke tongue | ;-P

Christian Graus15-Jul-09 2:48

Christian Graus

15-Jul-09 2:48

I love when they post code that is a disaster, we try to help, and they never answer anyone who replies.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Tom Deketelaere15-Jul-09 2:53

15-Jul-09 2:53

Christian Graus wrote:
we try to help, and they never answer anyone who replies.

I know

I think in all the answers I gave to questions (which is compared to you almost nothing but hey I try Poke tongue | ;-P

) I might have gotten an answer back like twice or so.

Luc Pattyn15-Jul-09 2:53

15-Jul-09 2:53

Smart people walk away from disasters, for some reason we feel attracted to them?? Big Grin | :-D

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Tom Deketelaere15-Jul-09 3:04

15-Jul-09 3:04

It's the same as seeing an accident on the road.

For some reason you can't resist to look.

Automatic Email Sender

dev sheoran15-Jul-09 1:41

dev sheoran

15-Jul-09 1:41

Hi All,

I have to develop an application using C#. Application requirements is given below:

1.Automatically send job alerts to all the registered job seekers based on some criteria like
work experience,Skills etc.
2.There are about 9 lac registered users and will increase in future.
3.Once the application started will send email to all the users and after completing the
email sending to all users it will stop/pause for some time say 3 hours and after that
it will automatically started . This process will keep on repeating until administrator
stop the application.
4.Application will run on the same server where database is running.

Please suggest me how to develop the application so that it consume minimum resources of the server?

Should I develop an application or a windows service? Which will be the best solution?

Please give suggestion keeping in mind that server resources should be consumed minimum?

Please Help.

Thanks & Regards,
Dev

Not Active15-Jul-09 2:25

Not Active

15-Jul-09 2:25

dev sheoran wrote:
windows service

Yes

only two letters away from being an asset

Manas Bhardwaj15-Jul-09 2:29

Manas Bhardwaj

15-Jul-09 2:29

Need to speed up my typing speed Smile | :)

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

Manas Bhardwaj15-Jul-09 2:38

Manas Bhardwaj

15-Jul-09 2:38

Mark Nischalke wrote:
dev sheoran wrote:
windows service

Yes

No, I wont do that.
I'll need to keep polling for checking when to start the next batch as he wants to do this every 3 hrs.

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

Not Active15-Jul-09 2:45

Not Active

15-Jul-09 2:45

Manas Bhardwaj wrote:
I'll need to keep polling

Ever heard of a timer?

only two letters away from being an asset

dev sheoran15-Jul-09 2:43

dev sheoran

15-Jul-09 2:43

I am new to C# and never developed a windows service.Please give any reference to the windows service which send emails. It will be help full for me.

Thanks,
Dev

Christian Graus15-Jul-09 2:50

Christian Graus

15-Jul-09 2:50

You're asking for the source code to your project ? How about you buy some books, or use google, or even search this site for articles ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Manas Bhardwaj15-Jul-09 2:29

Manas Bhardwaj

15-Jul-09 2:29

You could create a Console Application which can be scheduled to run after every 3 hours. Admin may disable the task if he wants.

You need to come up with a logic which will get the users to whom you want send the email. This will be a stored procedure returing you the user details and probably also the email content.

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