Visual Basic

Delete all sub item in child table

4-Nov-04 1:03

So long as the target machine has the appropriate version of the .NET Framework installed, this will work. Once the component is registered, it works just like any other COM component.

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

Mekong River3-Nov-04 17:08

3-Nov-04 17:08

Hi, My database has two table:

1. tblMain<br />
2. tblChild

tblMain is the main table and tblChild is the child table which has relationship (one to many) from tblMain to tblChild.

In VB.Net I use COM ADO 2.0 to access my access database. In this project, one item in tblMain can have many item in tblChild. The problem that i face is I want to delete one item from tblChild, but it delete all item that relate to tblMain. Example: in tblMain I have the reocrd as befow.

SubjID (Primary key)    SubjName
s001                    Computer
s002                    Mathematic
s003                    Economic

and tblChild have the following field and data:

SubjID (Foreign Key)    FilePath
s001                    C:\VB.doc
s001                    C:\Doc\VBdotNet.doc
s002                    D:\Prog\Algo.txt
s003                    C:\Eco\SoutEas.doc
s003                    C:\Eco\Elect.txt
s003                    C:\Eco\Oil.doc

And then I want to delete

s003                    C:\Eco\Oil.doc

But I after I delete my tblChild table remain only:

SubjID (Foreign Key)    FilePath
s001                    C:\VB.doc
s001                    C:\Doc\VBdotNet.doc
s002                    D:\Prog\Algo.txt

The record:

s003                    C:\Eco\SoutEas.doc
s003                    C:\Eco\Elect.txt

Also delete too, I don't know why??? Can any one told me to solve this prblem... Cry | :((

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Anonymous4-Nov-04 4:03

Anonymous

4-Nov-04 4:03

Probably your sql statement isn´t right.
For this case, the sql statement should be:

DELETE * FROM tblChild WHERE FilePath='C:\Eco\Oil.doc'

Mekong River4-Nov-04 13:45

4-Nov-04 13:45

Now I have an idea but did not try yet. I will do this:

DELETE * FROM tblChild WHERE tblChild.SubjID='s003' AND tblChild.FilePath='C:\Eco\Oil.doc'

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Anonymous5-Nov-04 0:57

Anonymous

5-Nov-04 0:57

That´s right. But if you let me give you an advice: You could put an PK field in tblChild and work with that field. I don´t know if this would make things easier but...

Good luck.

Mekong River5-Nov-04 3:14

how to call datagrid_currentCellChanged event on a button Click

5-Nov-04 3:14

Thank you very much for your advice. May be I need to try with this way, I really worry because the deadline of my project is comming soon. Cry | :((

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Jeevan anjna3-Nov-04 16:31

Jeevan anjna

3-Nov-04 16:31

I have a grid suppose it have Three row and one column
and three row have "Hi"
when I changed first row means Hi to "Hello"
and come on Second row then Grid_currentCellChanged Event fire its ok But the Problem is that

" when I changed Second row again "Hi to Hello
and withOut Any Other Click I click a button "Save"
And Again Fill The Datagrid Then InSecond row the Changes
no perform Even not in Data Base."

So what Should I do.

SoftWare Engineer

tic tac toe

Tow Jam3-Nov-04 15:52

Tow Jam

3-Nov-04 15:52

i've been trying to figure out how to make a tic tac toe game using control arrays , but no luck , it's not as easy it was in VB 6 . Please help me .

Re: tic tac toe

Dave Kreskowiak3-Nov-04 17:24

3-Nov-04 17:24

Control Array's don't exist in the .NET Framework. But, they can be simulated. Check out Creating Control Arrays in Visual Basic .NET and Visual C# .NET[^] on MSDN.

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

open file *.*

pht99993-Nov-04 15:25

pht9999

3-Nov-04 15:25

Please help me! how to open file *.* Ex: file.pdf; file.doc... Thank U Rose | [Rose]

Re: open file *.*

Dave Kreskowiak3-Nov-04 17:22

3-Nov-04 17:22

You're going to have to further explain what you mean by "opening file *.*"... Are you trying to launch the application that handles these files or what?

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

Re: open file *.*

Mekong River3-Nov-04 21:06

Problem while create subkey in registry

3-Nov-04 21:06

In this case you have to annalyse an extension of the file that you are open and write the code open it in the correct way. Example:

1. To open word document see this information.[^]
2. To open excel spread sheet see this information.[^]
3. To open acrobat read file (pdf) see this information.[^]
4. To open text file see this information.[^]
...
For more file support try to check website for more information.

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Mekong River3-Nov-04 14:35

3-Nov-04 14:35

Hi, I have read the article about working with windows registry from vb.net[^], I have a problem when I try to create the new subkey. I already use imports microsoft.win32 name space at the general declaration place but it is notworking. Can any one help me???

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Dave Kreskowiak3-Nov-04 17:21

3-Nov-04 17:21

No one can help you if you don't post the code that's not working!

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

Mekong River3-Nov-04 17:49

3-Nov-04 17:49

This is the code from article:

' Creating a Subkey<br />
Dim regKey As RegistryKey<br />
regKey = Registry.LocalMachine.OpenSubKey("SOFTWARE", True)<br />
regKey.CreateSubKey("MyApp")<br />
regKey.Close()

but when I try to do it in my application at this line

regKey = Registry.LocalMachine.OpenSubKey("SOFTWARE", True)

the Localmachine subitem from Registry is not display. When I force to try to type it, it display a an error (blue wavey line under the code). Do you have any idea???

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Dave Kreskowiak4-Nov-04 1:07

4-Nov-04 1:07

Did you import the Microsoft.Win32 namespace at the top of your code?

Imports Microsoft.Win32

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

Mekong River4-Nov-04 2:34

4-Nov-04 2:34

Yes I did. But it still not display the member in the drop down list for me.

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Dave Kreskowiak4-Nov-04 3:33

4-Nov-04 3:33

Then you did something else, though I have no idea what it is. All that's required is to add the Imports statement at the top of your code and declare a variable as RegistryKey. You'll have to post the code your using, including the Imports section, and the code around where your having the problem.

Imports Microsoft.Win32
.
.
Public Class myForm
    .
    .
    Private Sub myMethod(some parameters...)
        ' Creating a Subkey
        Dim regKey As RegistryKey
        regKey = Registry.LocalMachine.OpenSubKey("SOFTWARE", True)
        regKey.CreateSubKey("MyApp")
        regKey.Close()
    End Sub
End Class

There is nothing to this... If you get the little squiggly line under RegistryKey it means that the Microsoft.Win32 namespace has not been imported.

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