C# Discussion Boards - CodeProject

Re: RE: show SQL select data in textboxes

14-Jun-06 16:22

Replace:

spatwa wrote:
cmd.ExecuteNonQuery();

with:

using (SqlDataReader reader=cmd.ExecuteReader()) {
    if (reader.HasRows) {
        reader.Read();

        textBox.Text=reader.GetString(reader.GetOrdinal("ColumnName"));
    }

    reader.Close();
}

Saamir14-Jun-06 18:11

Saamir

14-Jun-06 18:11

Thanks a million Graham, I appreciate your help.

sasa

removing Quotation marks ("") when parsing

minnie mouse14-Jun-06 14:06

minnie mouse

14-Jun-06 14:06

just need a little more help with my beginners project, please.

I have a large file in the following CSV format

"71415","535","200","5364564","0","0","0","0","0","0","0","0","0"

I have used the code from this article by dave'O

http://www.codeproject.com/cs/database/DataSetFrmDelimTxt.asp

to place the data in a datagrid.

Just wondering , What is the easiest way to strip out all the quotation marks during the parsing ?
Confused | :confused:

Any help would be appreciated, thanks in advance.

Seem to be having problems as this character is used to denote a string.

Re: removing Quotation marks ("") when parsing

Graham Nimbley14-Jun-06 16:15

Re: removing Quotation marks ("") when parsing

14-Jun-06 16:15

string input=....

input=input.Replace('"','');

Graham

minnie mouse15-Jun-06 11:39

minnie mouse

15-Jun-06 11:39

Thanks for that, my quotation marks are now all gone.
Just a little confused though, does this mean that ' can be used to enclose a string , as well as " . Also does

input=input.Replace('"','');

insert a blank space, or does it remove the character alltogether ?

Thanks for the assistance with this. Smile | :)

Re: removing Quotation marks ("") when parsing [modified]

Graham Nimbley15-Jun-06 11:45

Re: removing Quotation marks ("") when parsing

15-Jun-06 11:45

' can only be used to store a single character of type char. E.g.

char testChar='s';

Regarding input=input.Replace('"','');

It takes in a string, returns a new string where all the occurances of the first parameter are replaced by the second parameter. So in this case '"' (representing double quote char) is replaced by '' (empty char).

Graham.

[Edit: Just noticing that it's quite hard to tell two single quotes '' from a double quote " with the default browser's font. D'Oh! | :doh:

]

-- modified at 17:46 Thursday 15th June, 2006

minnie mouse15-Jun-06 23:03

minnie mouse

15-Jun-06 23:03

Thanks,

" Persistance alone is omnipotent" (Calvin Cooolidge) Cool | :cool:

C# and hyper Terminal??

keroed_edmond14-Jun-06 13:44

keroed_edmond

14-Jun-06 13:44

is it possible for me to have hyper terminl running and i retrive any data that is recieved in the hyper termial port??????

or

is it possible for me to run hyper terminal from c# so i can access something through it???

kenny

URL collector [modified]

Bilal Farooq14-Jun-06 12:36

Bilal Farooq

14-Jun-06 12:36

Hi,

I want to make an application in C# for Windows XP, which could run in the background and log all the URL visited in any browser by any user.

Any ideas where to start?

Thanks

Code Monkey

-- modified at 18:36 Wednesday 14th June, 2006

Re: URL collector

Graham Nimbley14-Jun-06 16:29

Embarrassed - Simple Form Question

14-Jun-06 16:29

Oh, that could be tricky to implement. Sounds like you need to periodically monitor the processes on the system for any browsers that might start. Perhaps using Process.GetProcesses().

You would then need to hook into the browser some how, either using a plugin written for the browser, or hooking via the system using via P/Invoke and Win32.

Also this application sounds like it should be implemented as a Windows service, and using some sort of logging mechanism.

Good luck!

Graham.

Malcolm Smart14-Jun-06 10:49

Malcolm Smart

14-Jun-06 10:49

Hi
I have main form with a button, which when pressed, displays a second form. I don't want this form modal, so I use Show(). But, I only ever want one instance of this form. My confusion, and I am a real C# / .NET newbie, is when / where / how this is created / destroyed. Here's what I am doing...pseudoish

MainForm.OnClickEvent(...)
{
if secondform == null
secondform = new form(data_for_form_listbox)

secondform.show()
}

secondform.onCloseBUtton(....)
{
Close(); //or should this be hide();//I want the C++ equiv of EndDialog / CloseWindow which will actually delete the instance
}

On the 'secondform' I have a close button, which, calls - 'Close()'. Does that destroy the window? I want it destroyed so my OnClickEvent will create a new instance, so my second form can refresh its data (via the ctor).

I don't need code samples just a basic step by step of where I should create the second form / how I close it, (via teh second form), and should I destroy / recreate etc.

Does this make sense?

Regards

Rose | [Rose]

Angel

*********************************************
The sooner you fall behind, the longer you have to catch up.

Re: Embarrassed - Simple Form Question

donkaiser14-Jun-06 11:08

donkaiser

14-Jun-06 11:08

If i get your problem: you wanna open form2 from form1. and then close form2. using this.close(); is good. it will close form2 but not form1. the next time u call form2 again form form1 everything should be refreshed.

Donkaiser

Re: Embarrassed - Simple Form Question

kasik14-Jun-06 12:08

kasik

14-Jun-06 12:08

Angel1058 wrote:
'Close()'. Does that destroy the window?

If you mean will secondform be a null pointer after it's called, then no. Close() disposes the form and it's contents, and destroys it's window handle, but comparing secondform to null (like you're doing in your OnClickEvent() method) will return false.

You can use the IsDisposed property of the Form to check to see if the form has been disposed, and that should work (but you'd have to check if it's null first)...

if ( secondform == null || secondform.IsDisposed )
    secondform = new MyForm(data_for_form_listbox)

Hope that helps Smile | :)

“Accept that some days you are the pigeon, and some days you are the statue” -- David Brent

Cheers,
Will H

Re: Embarrassed - Simple Form Question

Malcolm Smart14-Jun-06 20:44

Malcolm Smart

14-Jun-06 20:44

secondform.IsDisposed

That's what I was missing - many thanks. Amazing, I've used MFC/VC++ for years and years and yet couldn't even successfully close and reopen a form in C#....doh.

Thanks again.

Regards

Rose | [Rose]

Angel

*********************************************
The sooner you fall behind, the longer you have to catch up.

Shape in VS2005

donkaiser14-Jun-06 10:47

donkaiser

14-Jun-06 10:47

Can we still drag and drop shape onto the form?
I want to draw 8 circles (names Circle) and each one is in an array (Circle #1 = Circle[0]).
How can we do that?

Thank you

Donkaiser

Using Return Value ... [modified]

mostafa_h14-Jun-06 10:16

14-Jun-06 10:16

hi there !
I wrote the following Function , Like this :

private int YourNo(int Number)
{
...
Number=(X+Y)*100;
return Number;
}

I want to use of this function(the value of Number parameter) in this Event :

private void calculate_Click((object sender, EventArgs e)<br />
{<br />
txtNumber.Text=....?<br />
}

in txtNumber.Text I want to put the value of returning function(Number).
How can i use it(Number parameter) ?
thanks a lot
regards,

s_mostafa_h

-- modified at 16:18 Wednesday 14th June, 2006

Elina Blank14-Jun-06 10:49

Elina Blank

14-Jun-06 10:49

Try this:
txtNumber.Text=YourNo(Number).ToString();

Sincerely,
Elina

Life is great!!!
Enjoy every moment of it! Blush | :O

mostafa_h14-Jun-06 11:12

14-Jun-06 11:12

hi !
it doesn't work . did you test it ?
Regards , Cool | :cool:

s_mostafa_h

Elina Blank14-Jun-06 11:17

Elina Blank

14-Jun-06 11:17

No sorry,
It was an idea Smile | :)

What error message you get?

Sincerely,
Elina

Life is great!!!
Enjoy every moment of it! Blush | :O

Guffa14-Jun-06 11:37

Guffa

14-Jun-06 11:37

The code that Elina suggested is basically correct. What you have to do is just substitute the "Number" with the value you want to send into the function.

What do you mean by "doesn't work", really? What happens? Do you get an error message?

What does the "..." in the function represent? Do you use the value of the parameter at all?

---
b { font-weight: normal; }

albCode14-Jun-06 22:46

albCode

14-Jun-06 22:46

private int YourNo(int Number)<br />
{<br />
int x = 10;<br />
int y = 5;<br />
Number=(X+Y)*100;<br />
return Number;<br />
}<br />
<br />
<br />
<br />
private void calculate_Click((object sender, EventArgs e)<br />
{<br />
txtNumber.Text= YourNo(Convert.ToInt32(txtNumber.Text)).ToString();<br />
}

mostafa_h23-Jun-06 4:35

23-Jun-06 4:35

hi there !
thnks for ur reply !

albCode wrote:
txtNumber.Text= YourNo(Convert.ToInt32(txtNumber.Text)).ToString();

Why "YourNo(Convert.ToInt32(txtNumber.Text))..." ? , I want to use of "Number Parameter " , when I clicked the button ,
Regards ,

s_mostafa_h

albCode23-Jun-06 4:41

albCode

23-Jun-06 4:41

mostafa_h wrote:
Why "YourNo(Convert.ToInt32(txtNumber.Text))..." ?

txtNumber.Text is parameter which u give in YourNo

mostafa_h23-Jun-06 9:07

23-Jun-06 9:07

but I want to use the return Value "Number" in Event .
txtNumber.Text= YourNo(Number).ToString();
but I have this Error message :
the name 'Number' doesn't exist in the current context .
Regards ,

s_mostafa_h

mostafa_h23-Jun-06 23:56