Re: how to turn a datatabel on sql interrogation ? - C# Discussion Boards

Re: Debug Application Plug-in

CJ11-Nov-07 4:47

CJ1

1-Nov-07 4:47

Thanks, the article does not apply, but the forum looks interesting.

arraylist as datagrid source [modified]

The Onslaught31-Oct-07 8:20

The Onslaught

31-Oct-07 8:20

When I bind a Datagrid to an arraylist (the items are strings), only one column
appears and it only shows me the lengths of the strings

Can anyone help me?

Thanks
-- modified at 14:41 Wednesday 31st October, 2007

After reading this message you will realize that you have wasted 5 seconds of your life

Re: arraylist as datagrid source

eggsovereasy31-Oct-07 9:00

eggsovereasy

31-Oct-07 9:00

Use List<string> instead.

Re: arraylist as datagrid source

The Onslaught1-Nov-07 6:48

The Onslaught

1-Nov-07 6:48

Thanks, but I need to use the Arraylist

Have you tried binding an arraylist to a datagrid?

I am using Microsoft Visual Studio 7.1

Thanks for the reply

Guarantee MainForm Focus on Startup

Sukhjinder_K31-Oct-07 8:19

Sukhjinder_K

31-Oct-07 8:19

How Can I Guarantee that my Application, upon its startup, Always Comes to Front and Has Input Focus no matter which application is currently having the Focus.

My MainForm is BorderLess, Maximized

Thanks...

Re: Guarantee MainForm Focus on Startup

Judah Gabriel Himango31-Oct-07 8:19

Judah Gabriel Himango

31-Oct-07 8:19

Set the Topmost property to true.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: No, Not I - A poem by Holocaust escapee, chief rabbi, and Messiah-follower Daniel Zion
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

how to turn a datatabel on sql interrogation ?

eraydeniz31-Oct-07 8:04

eraydeniz

31-Oct-07 8:04

Hi,

My Table

Column A Column B Columns C

Apple Apple Apricot

Pear Grape Peach

Grape Apricot

Banana

turn a datatable for below table With SQL (ColumA+ColumnB+ColumnC)

Apple 2 Unit
Pear 1 Unit
Grape 2 Unit
Banana 1 Unit
Aoricot 1 Unit
Peach 1 Unit

I want to turn a datatable with SQL this table.
Help me please, Thanks..

Re: how to turn a datatabel on sql interrogation ?

pmarfleet31-Oct-07 8:20

pmarfleet

31-Oct-07 8:20

Write a query that:

1. Uses the UNION operator to concatenate the data in columns A, B & C into 1 column.
2. Uses the GROUP BY clause and COUNT aggregate function to count the instances of each fruit.

Hope this helps.

Paul Marfleet

why does my meesage box take attention twice?

gizmokaka31-Oct-07 6:39

gizmokaka

31-Oct-07 6:39

Hello to all.

I guess I don't really understand how things(especially threads).

I have a function that runs in a separate thread then the rest of my application.

in the end of the function I print to a messageBox info I need for debugging.

the problem is I get to the messageBox twice.

the function is:

private void checkProblematicValves()
        {
            int dCount = 0;
            int numMessagesLost = 0;
            if (valveCheckedListBox.InvokeRequired)
                {
                    checkProblematicValvesHendler d = new checkProblematicValvesHendler(checkProblematicValves);
                    valveCheckedListBox.Invoke(d);
                }    
            else
            {
                foreach (long key in messageArr.Keys)
                {
                    if (messageArr[key] != null)
                    {


                        doing some stuff here!!!!!!!!!!!!!!

                            
                    }
                }
            }
            MessageBox.Show(numMessagesLost.ToString());
        }

I get to this "MessageBox.Show(numMessagesLost.ToString());" line twice, once with a true value
that prints to messageBox and right after I return to the same spot and it prints 0;

Can any one explain to me how come????

thanks in advanced.

Re: why does my meesage box take attention twice?

gizmokaka31-Oct-07 6:49

gizmokaka

31-Oct-07 6:49

Sorry for the stupid question, I realized my problem Smile | :)

Re: why does my meesage box take attention twice?

Luc Pattyn31-Oct-07 7:05

Luc Pattyn

31-Oct-07 7:05

So you want to test MessageBox on every thread you run? Wink | ;)

Luc Pattyn [Forum Guidelines] [My Articles]

this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google

Semaphore-like sync mechanism beetween multiple computers

SGAYET31-Oct-07 6:31

SGAYET

31-Oct-07 6:31

Hello,

Any idea to create a synchronisation beetween processes running on 2 (or more) computers, as a semaphore IPC ?

Someone suggests me :
- locking record in an SQL database
- file on a shared filesystem

What else ?

Thanxs

/SGA

Re: Semaphore-like sync mechanism beetween multiple computers

led mike31-Oct-07 7:16

led mike

31-Oct-07 7:16

SGAYET wrote:
create a synchronisation beetween processes running on 2 (or more) computers

synchronize what? Perhaps I'm wrong but that seems significant to me.

Re: Semaphore-like sync mechanism beetween multiple computers

SGAYET4-Nov-07 21:21

SGAYET

4-Nov-07 21:21

I need a mutual exclusion beetween processes running on different computers.

Explanation :
I have a program querying web services. It is running on 2 computers for load balancing and fault tolerance. The 2 processes are doing the same things, so i need to ensure anything done by one is not redo by the second.

Thanxs

Re: Semaphore-like sync mechanism beetween multiple computers

led mike5-Nov-07 6:33

led mike

5-Nov-07 6:33

Wow. That is not an explanation.

"doing the same thing"
"querying web services"

What things, why, when, how? How does the process know what to do?

SGAYET wrote:
It is running on 2 computers for load balancing

What is doing the balancing?

Is there a way to access a Form's object by a method?

humblepgmr31-Oct-07 6:25

humblepgmr

31-Oct-07 6:25

Not sure how to word the subject.
Perhaps this will be clear.

Formname.setObject("Object_name").Value = "True"

Any thoughts?

Re: Is there a way to access a Form's object by a method?

pmarfleet31-Oct-07 7:15

pmarfleet

31-Oct-07 7:15

Define your own public properties for the Form if you want to access data you are storing within an instance of the Form from another class.

Paul Marfleet

Re: Is there a way to access a Form's object by a method?

humblepgmr1-Nov-07 6:15

humblepgmr

1-Nov-07 6:15

I can do that.. But assuming I got into the Forms init method and I defined a function that accesses the objects' by name, I still don't know how to do that.

Any advice would be much appreciated.

Thanks.

Re: Is there a way to access a Form's object by a method?

pmarfleet1-Nov-07 6:27

pmarfleet

1-Nov-07 6:27

I don't understand what you mean by 'objects'. Are you referring to controls hosted by the form? Or are you talking more generally about accessing the values of class-level object variables based on the name of the variable? If it is the latter, there is no built-in way of doing this. You could easily achieve this behaviour however by storing the objects within a Hashtable.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Bind data into textbox

zafax_31-Oct-07 6:10

zafax_

31-Oct-07 6:10

hi guys, im trying to bind data into a texbox1 and textbox2.

thats when i enter an item code number and quantity into textbox1 and press enter key, following codes details will appear on to textbox2.
here the sample seen in text box2
======================
|code no : 6089 |
|name : DVD CD |
|quantity: 2 |
|price : $12.50 |
=======================
i have created database in SQL

Can anyone help me to go through this binding data into textbox1 and textbox2?

thanks in great!!

so much of happy ending...

Re: Bind data into textbox

Drew McGhie31-Oct-07 10:04

Drew McGhie

31-Oct-07 10:04

Does this data need to be editable, or is it just displaying information based on the (i'm assuming unique) code?

Re: Bind data into textbox

zafax_31-Oct-07 10:14

zafax_

31-Oct-07 10:14

its just displaying information on testbox2 when a code number on textbox1 has entered.

testbox1
_____
|6077|
|____|

textbox2
________
|CLOTHES|
|_______|

so much of happy ending...

Re: Bind data into textbox

Drew McGhie31-Oct-07 10:58

Drew McGhie

31-Oct-07 10:58

2 ways to do it. You can either pull the entire datatable worth of information and databind the table using a bindingsource(look up the bindingsource control), or you could make a call to the db every time you enter something and get that information.

Conceptually its pretty easy, you have a db full of information, and something you're using as the key to look stuff up. Hopefully you'll be able to figure out how to apply the SQL queries/form interaction.

How to lookup an IP address from a MAC address

r-mo31-Oct-07 5:49

r-mo

31-Oct-07 5:49

Hi,

How would I go about finding a devices IP address given its hardware address?

I have a group of thin clients and they are given IP addresses by DHCP, I'm writing a little program to start a secure shell and that needs the clients IP address and all I have is the MAC.

Hope someone can help

Stephen

Re: How to lookup an IP address from a MAC address

led mike31-Oct-07 6:00

led mike

31-Oct-07 6:00

Your program runs on the client or the server?
What does "start a shell" mean?

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