|
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...
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
Probably your sql statement isn´t right.
For this case, the sql statement should be:
DELETE * FROM tblChild WHERE FilePath='C:\Eco\Oil.doc'
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
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
|
|
|
|
|
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 .
|
|
|
|
|
|
Please help me! how to open file *.* Ex: file.pdf; file.doc... Thank U
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
I'm assuming that you are forgetting to turn the write ability on for the current key....
Dim myKey as RegistryKey = Registry.LocalMachine.OpenSubKey("Software",True
The boolean value must be set to true when opening a sub-key because the default is read-only.
Hope this helps.
|
|
|
|
|
I am building a windows service. This service does a lot of things and runs inte the background but I need an interface for the user. This interface can't be loaded when logged of, but I want to load that when the user has logged on. Alternatively I would like create a notifyicon for the service. Is this possible? How do I do that?
thanks
--- neteject.com - Internet Solutions ---
|
|
|
|
|
This is entirely possible.
You will need to make use of the System.ServiceProcess.ServiceController class to interact with the service.
Create an application that uses this class of the .NET Framework. You will want to place the application for this server in the startup folder.
Hope this helps you get started.
|
|
|
|
|
Hello,
I wanted to know if it is possible to explicitly (implicitly?) lock an
xml file during a job (parsing, modifications, etc)
Thanks
Sumit Domyan
Software Developer
ANALEC INFOTECH
|
|
|
|
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/_webdav_lock.asp
Well.. later
|
|
|
|
|
Hey i have been trying to use this[^] code project article.
I want to use this article to show the progress of my uploading process.
Unfortunatley i am unable to get the progress bar to increase as i am using a separate class to upload my files which implements from an interface and i am having trouble incrementing the counter i which i have declared globally.
my code is below from using this article
<br />
Private Sub btnPublish_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPublish.Click<br />
<br />
Dim Progress As New ProgressWindow<br />
Progress.Text = "Work"<br />
System.Threading.ThreadPool.QueueUserWorkItem(New System.Threading.WaitCallback(AddressOf PublishingFiles), Progress)<br />
Progress.ShowDialog()<br />
<br />
End Sub<br />
<br />
Private Sub PublishingFiles(ByVal status As Object)<br />
<br />
Dim callback As ProgressCallback = CType(status, ProgressCallback)<br />
Try<br />
callback.Begin(0, 100)<br />
Dim i As Integer = 0<br />
While i < 100<br />
callback.SetText(String.Format("Performing op: {0}", i))<br />
callback.StepTo(i)<br />
If callback.IsAborting Then<br />
Return<br />
End If<br />
<br />
''''''''''''''MY CODE'''''''''''''''<br />
<br />
strPublisher = tbPublisher.Text<br />
strDateTime = tbDateTime.Text<br />
<br />
If cmboSelection.Text = "Network Location" Then<br />
<br />
Dim SMB As New SMBRepository<br />
<br />
With SMB<br />
strIntialFolder = strPathSMB + "\" + SMB.AddXMLDeclaration().attributes(0).text + "\"<br />
.CreateDirectory(strIntialFolder)<br />
.CreateFolderStructure(SMB.AddXMLDeclaration(), strIntialFolder, objRepository)<br />
.TransferDocumentIndex()<br />
End With<br />
<br />
ElseIf cmboSelection.Text = "FTP Transfer" Then<br />
<br />
Dim FTP As New FTPRepository<br />
<br />
With FTP<br />
strIntialFolder = FTP.AddXMLDeclaration().attributes(0).text<br />
.Connect()<br />
.CreateFolderStructure(FTP.AddXMLDeclaration(), strIntialFolder, objRepository) '<--- This is where the upload occurs<br />
.TransferDocumentIndex()<br />
.CloseConnection()<br />
End With<br />
<br />
End If<br />
<br />
For dblCount = 1 To 0 Step -0.05<br />
Me.Opacity = System.Math.Abs(dblCount)<br />
Next dblCount<br />
<br />
MsgBox("Folder Successfully Published", MsgBoxStyle.OKOnly)<br />
<br />
Progress.Hide()<br />
<br />
Me.Hide()<br />
<br />
''''''''''''END MY CODE'''''''''''''''<br />
<br />
System.Threading.Thread.Sleep(100)<br />
If callback.IsAborting Then<br />
Return<br />
End If<br />
<br />
'i = i + 1 <--- increments here<br />
End While<br />
Catch generatedExceptionVariable0 As System.Threading.ThreadAbortException<br />
Catch generatedExceptionVariable1 As System.Threading.ThreadInterruptedException<br />
Finally<br />
If Not (callback Is Nothing) Then<br />
callback.End()<br />
End If<br />
End Try<br />
<br />
End Sub<br />
Any help would be appreciated
thanks for your Time
Chris
|
|
|
|
|
Hello all
I hv a xml file, structure below.
Now i want to retrieve, a specific user node, suppose i want to know all values of "Sumit" user. Is there any solution. Can we write some query in xml?Thanks
<USERS>
<User>
<Username>Ankur</Username>
<Password>Ankur</Password>
<Status>y</Status>
</User>
<User>
<Username>Ahuja</Username>
<Password>Ahuja</Password>
<Status>n</Status>
</User>
<User>
<Username>Nitin</Username>
<Password>Nitin</Password>
<Status>n</Status>
</User>
<User>
<Username>Sumit</Username>
<Password>Sumit</Password>
<Status>y</Status>
</User>
</USERS>
Sumit Domyan
Software Developer
<b>ANALEC INFOTECH
|
|
|
|
|
This is possible using XPATH, a good article can be found here[^]
Hope this helps
Chris
|
|
|
|