RE: show SQL select data in textboxes - C# Discussion Boards

Mike Poz14-Jun-06 18:33

14-Jun-06 18:33

You can probably look here -> [TextRenderer.MeasureText]

It's new to the .NET 2.0 framework according to MSDN website. There are examples in VB and C# about 3/4 of the way down the page.

Hope this gets you off in the right direction.

Mike Poz

How to program Finger Scanner??

Claton14-Jun-06 16:44

Claton

14-Jun-06 16:44

Hello all,

I have just got this new HP Compaq nx6125 laptop which has a finger scanner which helps me to log into the computer. I was just thinking does anyone know how we can program the finger scanner to reconize the finger. In short how to i learn finger scanning programming...

I know its very hard... but if any one has any code or any directly i would really appreciate it a lot..

CH

Re: How to program Finger Scanner??

Judah Gabriel Himango14-Jun-06 16:48

Judah Gabriel Himango

14-Jun-06 16:48

I'm not sure where to begin, but I would say that C# probably isn't the right tool for the job. You're most likely going to have to work with device drivers in C, that'd be my suggestion of where to start looking, at least.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Goof around music jam with my brothers (with video)
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

from a textbox to another textbox...pls help

NoobNooberNoobest14-Jun-06 15:47

NoobNooberNoobest

14-Jun-06 15:47

hi! CP people!! Smile | :)

it's my first time to post a question here, but i tend to consult CP whenever i have programming problems.
my problem here is that i have two textboxes. one is read-only and the other one is not.
now, what i want to do here is to show what the user typed in the textbox which doesnt have the read-only property to the other textbox which is read-only.
i really don't know how to start the coding because it's only been a year since i'm learning C# .NET and my professor in C# doesnt help at all. i can assure you that is not a school project. i just want to learn from you guys rather than to consult my professor.
thanks in advance... Big Grin | :-D

Re: from a textbox to another textbox...pls help [modified]

Graham Nimbley14-Jun-06 16:09

Graham Nimbley

14-Jun-06 16:09

Hiya,

TextBox textBox1=new TextBox();
textBox1.KeyPress+=new KeyEventHandler(UpdateTextBox);
...
TextBox textBox2=new TextBox();
textBox2.ReadOnly=true;

...

private void UpdateTextBox(object sender,KeyEventArgs e)
{
    textBox2.Text=textBox1.Text;
}

Even if textboxes are read-only to the user, .net still can write to it in code.

Hope this will do!

Graham

Re: from a textbox to another textbox...pls help

NoobNooberNoobest14-Jun-06 16:40

NoobNooberNoobest

14-Jun-06 16:40

it helps logic wise. i tweak the codes a bit but thanks anyways.
Regards...;)

in land of the idiots, the imbecile is the king.

Re: from a textbox to another textbox...pls help

YogeshRT15-Jun-06 20:41

YogeshRT

15-Jun-06 20:41

well u can do like this

private void textBox1_TextChanged(object sender, System.EventArgs e)
{
textBox2.Text=textBox1.Text;
textBox2.ReadOnly=true;
}

it will help u

Yogesh_T

RE: show SQL select data in textboxes

Saamir14-Jun-06 14:16

Saamir

14-Jun-06 14:16

Hi there!
Please help, I am trying to show the data from an SQL select statement into textboxes.

Here is what I have so far:

SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=CB;Integrated Security=SSPI;");
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM tblCB WHERE CBID='"+ this.CBID.Text +"'", conn);

cmd.ExecuteNonQuery();
conn.Close();

sasa

Re: RE: show SQL select data in textboxes

Graham Nimbley14-Jun-06 16:22

Graham Nimbley

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();
}

Re: RE: show SQL select data in textboxes

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

Graham Nimbley

14-Jun-06 16:15

string input=....

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

Graham

Re: removing Quotation marks ("") when parsing

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

Graham Nimbley

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

Re: removing Quotation marks ("") when parsing

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

Graham Nimbley

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.

Embarrassed - Simple Form Question

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

mostafa_h

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

Re: Using Return Value ...

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

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