C# Discussion Boards - CodeProject

how to add new node existing treeview control and bind data from table?

Ashish Kumar Vyas1-Jul-08 4:35

1-Jul-08 4:35

I want to add new node in existing treeview control and after that I wanna bind data from table to this node dynamically.
I m using c#.net

Access Insert issue

kruegersck1-Jul-08 3:53

kruegersck

1-Jul-08 3:53

I am trying to insert a record into an Access 2007 DB. I am having an issue with a Memo field. I have tried double quotes, single quotes. I am at a loss on how to load this sentence: This is a Test

If anybody has any ideas or sample code I would really appreciate.

Re: Access Insert issue

led mike1-Jul-08 4:58

led mike

1-Jul-08 4:58

Have you looked at the Samples that come with Access? Have you looked for information on the Access Developer site[^]?

led mike

Re: Access Insert issue

kruegersck1-Jul-08 5:04

kruegersck

1-Jul-08 5:04

Do they examples of doing this using C#?

Re: Access Insert issue

led mike1-Jul-08 7:32

led mike

1-Jul-08 7:32

kruegersck wrote:
Do they examples of doing this using C#?

kruegersck wrote:
I still get an error on my Insert Command stating: Syntax error in INSERT INTO statement.

If you have any intention of becoming a capable software developer I suggest you stop typing questions into forums and start researching and reading your own information. It is as valuable a skill and activity of a developer as any other, period.

led mike

Re: Access Insert issue

Guffa1-Jul-08 5:16

Guffa

1-Jul-08 5:16

An insert query for that is rather simple. Example:

insert into someTable (aMemoField) values ('This is a test...')

When you do it from code you should use a parameterised query, though. Then you don't have to worry about apostrophes and correctly escaping strings (which is rather crucial to protect against SQL injection attacks).

Despite everything, the person most likely to be fooling you next is yourself.

Re: Access Insert issue

kruegersck1-Jul-08 5:45

kruegersck

1-Jul-08 5:45

Here is my updated Code utlizing a parameterised query. I still get an error on my Insert Command stating: Syntax error in INSERT INTO statement.

The first field is a key and is a long int
The second field is a Text Field 255 long

Here is the code that does the insert. Please let me know of any issues. I can't find any:

string commandText = "INSERT INTO Contact_Notes (Contact_ID,Note) VALUES(@Contact_ID,@Note)";
string strConcat = "**** " + g_ProfName + " " + DateTime.Now.ToString() + " **** " + txtNewNote.Text;
conProspect.Open();
OleDbCommand cmd = new OleDbCommand(commandText,conProspect);
cmd.Parameters.Add("@Contact_ID", lngContactId);
cmd.Parameters.Add("@Note", strConcat);
cmd.ExecuteNonQuery();
conProspect.Close();
cmd.Dispose();

As always thanks for all the help

Re: Access Insert issue

kruegersck1-Jul-08 5:48

kruegersck

1-Jul-08 5:48

If I remove the Note field. It works just fine...

Re: Access Insert issue

Guffa2-Jul-08 2:53

Guffa

2-Jul-08 2:53

Note is a reserved keyword in the JET database driver. Change the name of the field, or if that is not practically possible, put brackets around the name in the query: [Note].

Despite everything, the person most likely to be fooling you next is yourself.

html to pdf

laziale1-Jul-08 3:41

laziale

1-Jul-08 3:41

any way how I can do that?? I want to convert html to pdf, what is the way to do this. How should I start? Thx ahead

Re: html to pdf

BoneSoft1-Jul-08 4:16

BoneSoft

1-Jul-08 4:16

There are only two options that I'm aware of... The first is to get one of the open source PDF APIs, build your own HTML parser, and with those two in hand build a converter yourself. Option two is buy a package that does it for you. There are a few out there, though it's not really easy to get past the specialty acts and find a tool that does just that. I have used ExpertPDF[^] and it's a decent product, and not too expensive. Good luck.

Visit BoneSoft.com for code generation tools (XML & XSD -> C#, VB, etc...) and some free developer tools as well.

Re: html to pdf

Thomas Stockwell2-Jul-08 2:29

Thomas Stockwell

2-Jul-08 2:29

You can always install a pdf printer driver such as doPDF.

Regards,
Thomas Stockwell

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

Visit my homepage Oracle Studios

Discounted or Free Software for Students:
DreamSpark - downloads.channel8.msdn.com
MSDN Academic Alliance - www.msdnaa.com

Weird Socket behaviour after using NetworkStream

__DanC__1-Jul-08 3:28

__DanC__

1-Jul-08 3:28

I have a client / server system which uses sockets to send a receive messages. The messages are then processed on the server and a response sent back. This all works as expected most of the time but in the case of one particular message, it requires an arbitrary amount of data to follow it so I attach a NetworkStream to the Socket (specifying false to 'ownsSocket' so as not to close the socket early). Now this also works fine but some time after using the NetworkStream I get a message received twice in a single Receive call. The client has not sent it twice but it was received twice. This may happen for the message after I use the NetworkStream or after 100 successful messages after, there seems to be no pattern to it.

Now this also seems to happen less and less the more debug messages I add to the application making it very hard to find the problem.

The NetworkStream is closed and disposes after use.

Does anyone have any idea what could be causing this? Could it just be coincidence that it seems to only happen after I use a NetworkStream?

Re: Weird Socket behaviour after using NetworkStream

leppie1-Jul-08 3:32

leppie

1-Jul-08 3:32

__DanC__ wrote:
The NetworkStream is closed and disposes after use.

Try without closing the NetworkStream.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Re: Weird Socket behaviour after using NetworkStream

__DanC__1-Jul-08 3:42

__DanC__

1-Jul-08 3:42

Just tried that but it didn't make any difference.

Re: Weird Socket behaviour after using NetworkStream

leppie1-Jul-08 4:13

leppie

1-Jul-08 4:13

Client maybe closing the connection?

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

hotkey work but i still want to send the HotKey to the current activated application [modified]

troiszyzy1-Jul-08 2:57

troiszyzy

1-Jul-08 2:57

Hello,
I use hotkey for activate my form with the NotifyIcon.
It work but i still want to send the HotKey to the current activated application also.

I use '²' key on my french keyboard (only akey simultanous).

code:
protected override void WndProc(ref Message m){
base.WndProc(ref m);
if (m.Msg == WM_HOTKEY){
if (contextMenuStrip_fenetre.Visible)
{
this.ferme_fenetre();
}
else
{
this.affiche_fenetre();
}
}
}

public void RegisterGlobalHotKey(Keys hotkey, int modifiers)
{
String atomName = AppDomain.GetCurrentThreadId().ToString("X8");
GlobalAddAtom(atomName);
RegisterHotKey(this.Handle, hotKeyId, modifiers, (int)hotkey);

modified on Tuesday, July 1, 2008 2:35 PM

does anyone have an idea?

troiszyzy1-Jul-08 8:46

troiszyzy

1-Jul-08 8:46

Please..

Re: hotkey work but i still want to send the HotKey to the current activated application

Michael90001-Jul-08 10:26

Michael9000

1-Jul-08 10:26

If I understand correctly, these articles migth help you...

Sending keypresses to a window[^]

Finding specific windows[^]

\Michael

Re: hotkey work but i still want to send the HotKey to the current activated application

troiszyzy1-Jul-08 23:57

troiszyzy

1-Jul-08 23:57

Thanks,
I have read totally articles, there are very interesting.

But, it doesn't match my feature.

( My hotkey is '²' )

exemple:
I am under a text editor, and i am writing a document.
and, I want to press the char '²'.
The Char isn't send to the text editor.
The Char is send to my owm app that catch it ( by hotkey system).

Conclusion:
so, I don't know activited/focused application before hotkey,so i can't get his handle, so i can't send it a message with the char.
I want when i press the char, I want that these 2 application recive the char.

How CAN I do

Re: hotkey work but i still want to send the HotKey to the current activated application

Michael90003-Jul-08 1:47

Michael9000

3-Jul-08 1:47

troiszyzy wrote:
so, I don't know activited/focused application before hotkey,so i can't get his handle

/// <summary>
/// The GetForegroundWindow function. Returns a handle to the foreground window.
/// </summary>
[DllImport("user32.dll", SetLastError = true)]
internal static extern IntPtr GetForegroundWindow();

private void myMethod()
{
    IntPtr h = GetForegroundWindow();

    // do something with the handle
    string str = h.ToString();
}

Windows API question?

Mohammad Dayyan1-Jul-08 2:21

Mohammad Dayyan

1-Jul-08 2:21

Hi there.
I want to know which window is enable right now(Window name)
And which keys pressed on enable window.

except http://www.codeproject.com/KB/system/globalsystemhook.aspx[^]

Can you help me ?

Freshman

Re: Windows API question?

DaveyM691-Jul-08 3:23

DaveyM69

1-Jul-08 3:23

GetForegroundWindow in user32.dll - check out www.pinvoke.net[^]

Dave

Re: Windows API question?

Mohammad Dayyan1-Jul-08 4:58

Mohammad Dayyan

1-Jul-08 4:58

Thank you my friend.

Freshman

Rank Checker

D i x y1-Jul-08 2:12

D i x y

1-Jul-08 2:12

Hello Friends
I want to make a windows application that can check any website rank according to the keyword on any of the search engines like Google, Yahoo, and MSN.

Can any one help me how can i start..

i got a link that is of web application i tried it to convert into C# windows application but i am unable to do that..

http://www.codeproject.com/KB/aspnet/search_engine_rank_check.aspx

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