Re: Form_Load event problem - C# Discussion Boards

how to bind the result of the query to the textbox in c#

Anjani Poornima27-Aug-09 4:19

27-Aug-09 4:19

hello,

In my application i am having a textbox amount.

I like to bind my textbox with the result of the query i.e.

"select sum(amount) from tablename".

how i can bind the result of the query to the textbox in windows

application.

plz,help me in doiing this...

Thanks in advance

Re: how to bind the result of the query to the textbox in c#

Jeremy Likness27-Aug-09 6:21

Jeremy Likness

27-Aug-09 6:21

Using Windows Forms controls:

Beginning C# - Chapter 13: Using Windows Form Controls[^]

Jeremy Likness
Latest Article: Whats in Your Collection? Part 1 of 3: Interfaces
Blog: C#er : IMage

Re: how to bind the result of the query to the textbox in c#

Anjani Poornima27-Aug-09 20:30

Anjani Poornima

27-Aug-09 20:30

Sir,

i like to know how to bind the query to the textbox.

plz send me any link regarding this.

Re: how to bind the result of the query to the textbox in c#

Anjani Poornima27-Aug-09 22:15

Anjani Poornima

27-Aug-09 22:15

Thank you for sending the link which helps for getting the basics on

windows application.

and more over i got solution to my query also.

textbox1.Text=command.executescalr().tostring()
Smile | :)

Form_Load event problem

kanchoette27-Aug-09 4:01

kanchoette

27-Aug-09 4:01

Within my Form I am using

this.Load += new System.EventHandler(this.ItemForm_Load);

 private void ItemForm_Load(object sender, EventArgs e)
        {
            myDataSet.Merge(mainForm.newDataSet);           
        }

However, the merge does not take place. Placing a breakpoint in the debugger shows that the ItemForm_Load never gets hit.

Any pointers would be much appreciated.

Re: Form_Load event problem

DaveyM6927-Aug-09 4:04

DaveyM69

27-Aug-09 4:04

Where are you subscribing to the Load event? If it's after it's loaded it's never going to get called again. If it's not already there, put it in the constructor.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Re: Form_Load event problem

kanchoette27-Aug-09 4:22

kanchoette

27-Aug-09 4:22

Many thanks for your reply. I had my load subscription within

private void InitializeComponent()
{ 

}

Re: Form_Load event problem

Luc Pattyn27-Aug-09 7:31

Luc Pattyn

27-Aug-09 7:31

Hi,

InitializeComponent() is the one method created and maintained by Visual Studio; you should not edit this method (and, since VS8 or VS9 it normally is in a separate file,
based on C#3.0 partial classes, so you shouldn't even edit the entire myForm.designer.cs files

Having it in there, is technically as good as having it in the Form's constructor, so the problem must be elsewhere. With the little info you have provided, I can't help you any further though.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.

Re: Form_Load event problem

Mycroft Holmes27-Aug-09 14:46

Mycroft Holmes

27-Aug-09 14:46

I'm confused, why are you manually maintaining the form load event handler. If you double click on the forms title bar VS creates this in the Designer.cs as with any other event wiring. I only ever do this if I have multiple subscribers to a single event or I'm creating a custom event.

How to limit the number of simultaneously connected clients

Frozzeg27-Aug-09 3:59

Frozzeg

27-Aug-09 3:59

Adn can it be done before calling Socket.Accept() ?

Re: How to limit the number of simultaneously connected clients

harold aptroot27-Aug-09 4:02

harold aptroot

27-Aug-09 4:02

Just stop calling accept until the number of connections is below your threshold value again?

Re: How to limit the number of simultaneously connected clients

Frozzeg27-Aug-09 4:16

Frozzeg

27-Aug-09 4:16

or rather I need to limit the maximum number of connections that can make 1 client

p.s. sry for my english

Re: How to limit the number of simultaneously connected clients

Nagy Vilmos27-Aug-09 4:21

Nagy Vilmos

27-Aug-09 4:21

Based on needing to control the conections per client, you are going to need to establish who the connection is from. What is the clint that is connecting? Can you not manage your interface so that after accepting the connection they must send a message to establish the full session. That way they can [provide additional information so the server knows who is connecting.

Panic, Chaos, Destruction.
My work here is done.

Re: How to limit the number of simultaneously connected clients

harold aptroot27-Aug-09 4:30

harold aptroot

27-Aug-09 4:30

Why not just check the source IP? They could still try to spam halfopen connections, but they can't hope to get a connected TCP socket if they fake their source IP, so they won't spoof it if their goal is getting more connections.

Re: How to limit the number of simultaneously connected clients

Frozzeg27-Aug-09 5:23

Frozzeg

27-Aug-09 5:23

in Apache done that I need, Apache accepting first 300 connections and then he stop accepting new connection before i destroy old connections

i.e. it does not accept a new connection, and immediately disconnect, just an exception when i trying to do 301-th connection

Create txt file with date as name [Solved]

mostofmonty27-Aug-09 3:35

mostofmonty

27-Aug-09 3:35

I am very new to C#, and i just want to create a .txt file with the current date and time as the filename.

Here is the code i've put together from bits and pieces on the net, and it isnt working

string date = DateTime.Now.ToString("yyyyMMdd_hhmmss");
TextWriter tw = new StreamWriter("{0}.txt", date);

I have also tried

TextWriter tw = new StreamWriter(DateTime.Now.ToString("yyyyMMdd_hhmmss.txt"));

It creates the filename i want, but with the .pxp extension instead of the .txt

Any help would be greatly appreciated Smile | :)

modified on Thursday, August 27, 2009 10:24 AM

Re: Create txt file with date as name

Calla27-Aug-09 3:39

Calla

27-Aug-09 3:39

My guess is a typo in your code when it comes to the filename. If you choose the file to have a ".txt" extension i doubt anything in .NET makes it ".pxp" instead.. Smile | :)

Re: Create txt file with date as name

OriginalGriff27-Aug-09 3:42

OriginalGriff

27-Aug-09 3:42

Try

string date = DateTime.Now.ToString("yyyyMMdd_hhmmss");
TextWriter tw = new StreamWriter(string.Format("{0}.txt", date));

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Re: Create txt file with date as name

mostofmonty27-Aug-09 3:49

mostofmonty

27-Aug-09 3:49

Thanks for such a hasty reply Big Grin | :-D

I've tried your code:

string date = DateTime.Now.ToString("yyyyMMdd_hhmmss");
TextWriter tw = new StreamWriter(string.Format("{0}.txt", date));

And in the editor (visual express) it underlines the 'date' in string.Format("{0}.txt", date) in red, with an error message below.

I warn you again, i am very green at C# :s

Re: Create txt file with date as name

OriginalGriff27-Aug-09 3:54

OriginalGriff

27-Aug-09 3:54

What's the error message?

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Re: Create txt file with date as name

mostofmonty27-Aug-09 3:59

mostofmonty

27-Aug-09 3:59

"A field initializer cannot reference the non-static field, method, or property"

Re: Create txt file with date as name

OriginalGriff27-Aug-09 4:11

OriginalGriff

27-Aug-09 4:11

Copy and paste your code - you have a spelling or wrong bracket error somewhere. The compiler seems to think your string is not a string! Not all of it! Just the relevant method or a section around the code!

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Re: Create txt file with date as name

mostofmonty27-Aug-09 4:24

mostofmonty

27-Aug-09 4:24

No need, it was indeed just a wrong bracket error, which i noticed once you suggested it.

Sods Law.

The code you gave me works perfectly Smile | :)

Very much appreciated Smile | :)

Re: Create txt file with date as name

musefan27-Aug-09 3:47

musefan

27-Aug-09 3:47

string fileName = DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".txt";

//don't forget to add the directory
fileName = Application.StartupPath + "\\" + fileName;

//Create the stream to the new file
StreamWriter sw = new StreamWriter(fileName);

//do something to file
sw.WriteLine("Some Data");

//dont forget to close the stream, look into try/catch for proper usage
sw.Close();

...hope this helps you

EDIT: Error with code block formatting???

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

Re: Create txt file with date as name

harold aptroot27-Aug-09 4:01

harold aptroot

27-Aug-09 4:01

musefan wrote:
Error with code block formatting???

Could it be that the colourer ignores the \\ and therefore sees a \" which means the string isn't closed?

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