Visual Basic

Re: how to turn off system error when i add daplicated ID unique?

4-Mar-06 2:51

i load datatable into a grid, the grid is added, edited. Now i put into the grid a new row with the same key as another row. I have used Rowchanged and Columnchanged Events. But after it messaged the error as i gave, it message a error message from System.
I want to turn of it. How can i do that? Please help me!

superdragon

Dave Kreskowiak4-Mar-06 9:59

Re: how to turn off system error when i add daplicated ID unique?

4-Mar-06 9:59

superdragon wrote:
I want to turn of it. How can i do that?

You can't! You're violating the unique value constraint on the Primary Key column of your table. You simply cannot do that and cannot turn off the error.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Paul Conrad4-Mar-06 12:23

Paul Conrad

4-Mar-06 12:23

Dave Kreskowiak wrote:
You can't! You're violating the unique value constraint on the Primary Key column of your table. You simply cannot do that and cannot turn off the error.

Dave is right. The whole idea of the Primary key having the unique value is to prevent duplication Smile | :)

PJC

no, i dont want to add duplicated ID Key

superdragon5-Mar-06 3:53

5-Mar-06 3:53

No, i dont wan to add duplicated ID Key, but i only want to message the Error as i want, after that i will edit it. But after my message is messaged, i receive system Error, i dont like that.

superdragon

Dave Kreskowiak5-Mar-06 7:39

5-Mar-06 7:39

Then what does this mean:
Now i put into the grid a new row with the same key as another row.
??????

Now we're really confused. How are you adding this new record? Why are you trying to add a new record with a duplicate key? If you don't want the message to come up, don't put the duplicate key in! It's that simple...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

superdragon5-Mar-06 12:23

5-Mar-06 12:23

I only want to catch error, because maybe someone can insert a new record into grid with the same key, and they dont know about english, they can not understand what the system error message means.

superdragon

Dave Kreskowiak5-Mar-06 16:26

5-Mar-06 16:26

Your users should not be generating their own Primary Key's. They should not even be able to enter a Primary Key at all! These should be generated by the database itself.

Like I said, handle the error by not letting it happen in the first place. Don't give the user the opportunity to make the error come up.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

-- modified at 22:45 Sunday 5th March, 2006

superdragon6-Mar-06 0:11

6-Mar-06 0:11

I thank you very much, now i have solved it, i used ExtraGrid Event(invalidrow), and i could catch it easy.

superdragon

Dave Kreskowiak6-Mar-06 2:10

Writing TSR using Visual Basic 6.0

6-Mar-06 2:10

[shakes head back and forth slowly and Sigh | :sigh:

]

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

system tools

besah4-Mar-06 2:31

besah

4-Mar-06 2:31

Hello all,

i do have file contain defrag.bat.
how can i write the code in vb.net to trigger the event of
that file??in other words,i am trying to call the system tools from my
.Net application..

please somebody help me... Confused | :confused:

besah

Re: system tools

The Man from U.N.C.L.E.4-Mar-06 5:17

The Man from U.N.C.L.E.

4-Mar-06 5:17

The System.Diagnostics namespace has a Process class you can launch external programs with. You pass in the name of an executable file or a filename with an extension associated with an executable application.

System.Diagnostics.Process.Start("c:\...\defrag.bat")

This code returns a Process object:

An overloaded Process.Start method takes a ProcessStartInfo parameter that let's you set process initialization values such as the WindowStyle.

You can also do all of this through the IDE by dragging a Process component unto your form from the Components area of the Toolbar.

Here is a good search start piont for more info http://www.google.com/search?complete=1&hl=en&q=system.diagnostics.process.start[^]

If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)

Dev Prasad4-Mar-06 1:21

Dev Prasad

4-Mar-06 1:21

Dear sir/madam

I would like to write terminate stay resident program using visual basic 6.0 is that possible. If that is posible, could you pls guide on this. Is there any URL on "tutorial for writing TSR program using visual basic 6.0".
or any thing that helps me better.

Thank You

Have A Nice Day
Dev Prasad

Re: Writing TSR using Visual Basic 6.0

Dave Kreskowiak4-Mar-06 9:58

crystal report error"query engine error"

4-Mar-06 9:58

Dev Prasad wrote:
terminate stay resident

There's no such thing anymore. That was a term used for certain types of DOS applications.

What exactly are you trying to do? You might be looking at a windows service application, but VB6 can't create one of these without using other software and/or hacks to get it to work.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

illusionFinder3-Mar-06 23:19

illusionFinder

3-Mar-06 23:19

hi there
I get a query engine error :\\pcname\...\temp....rpt
when i try to view my report does anyone know why and the schema is correct

thanks

-- modified at 9:21 Saturday 4th March, 2006

Treeview Problem

pankajgarg123-Mar-06 22:43

3-Mar-06 22:43

Hi ,
I am using VB.net.I earlier asked the question about selecting the concerned treenode when the combobox item is selected.I was replied to apply the recursion.

Now for selecting any node , we use
Treeview1.selectednode = Treeview1.node(0)
But how I will select the jhdb nodes programically and the following path is placed in combobox.
c:\abc\def\ghi\jhdb

Thank You

Re: Treeview Problem

Dave Kreskowiak4-Mar-06 9:55

4-Mar-06 9:55

TreeView can only have a single Node selected at any one time. So, the code you posted is how you do it.

Are you asking how to get data from each child node and populate a combobox with that?

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

TreeView Problem

pankajgarg123-Mar-06 22:33

3-Mar-06 22:33

Hi,
I am using vb.net . I want to know programically whether the particular node is already expanded or not .
The e.node.expand() does not return any value.

Re: TreeView Problem

Dave Kreskowiak4-Mar-06 9:51

4-Mar-06 9:51

It's IsExpanded that will return the status of the node. Expand will actually expand the node, not return its status.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

ComboBox Problem

pankajgarg123-Mar-06 22:29

3-Mar-06 22:29

HI, i'm using vb.net and I need to get event when I click a combobox down button

Thank You

Re: ComboBox Problem

Dave Kreskowiak4-Mar-06 9:50

ListView Problem in vb.net

4-Mar-06 9:50

Have you looked at the DropDown[^] event?

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

pankajgarg123-Mar-06 22:25

Re: ListView Problem in vb.net

3-Mar-06 22:25

Hi,
I want to get the name and fullpath of the item of listview on which it is clicked.

Dave Kreskowiak4-Mar-06 9:48

Re: ListView Problem in vb.net

4-Mar-06 9:48

You'll have to store that information in the Tag property of each ListViewItem object you add. Then just retrieve it later when the item is clicked on.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

toxcct15-Mar-06 21:41

toxcct

15-Mar-06 21:41

stop spamming the message boards. read the msdn, and stop ask stupid question that are already written black on white on the docs Unsure | :~

Treeview Problem in vb.net

pankajgarg123-Mar-06 22:17