|
I have the following subroutine to load a listbox of database tables:
Private Sub DisplayDatabaseTbls(ByVal tblTables As DataTable)
lstTbls.Items.Clear()
For Each row As DataRow In tblTables.Rows
lstTbls.Sorted = True
lstTbls.DataSource = tblTables
lstTbls.ValueMember = "Table_Name"
lstTbls.DisplayMember = "Table_Name"
Next
End Sub
This works just fine until I deside to select a differnt database, then I get the error:
Items collection cannot be modifed when the datasource property is set.
I understand it will not let me repopulate the listbox while it is bound to a datasource.
What I want to know is how I can disconnect the datasource, and clear the listbox. In VB6 all you had to do was Listbox1.Clear.
Thanks is advance
Quecumber256
|
|
|
|
|
Have you tried lstTbls.DataSource = Nothing?
To me that looks to be the opposite of lstTbls.DataSource = someDataSource
|
|
|
|
|
Luc,
That did it. All I did was place lstTbls.DataSource = Nothing at the top of the subroutine. So whenever I changed databases it will disconnect the datasource, then clear the list box, and reconnect the datasource and repopulate the listbox.
Thanks this helped a bunch.
Quecumber256
|
|
|
|
|
What is software self check?
How can wirte software self check in VB.net?
plz....thz....
|
|
|
|
|
phowarso wrote: What is software self check?
A general checkup on the validity of the software, I guess.
phowarso wrote: How can wirte software self check in VB.net?
Depends on what you need. Sometimes it's enough to simply compute a hash from the files that you have, other times you'd might want to check the availability of the database and the validity of the backupfiles.
What part of your software has healthconcerns?
I are Troll 
|
|
|
|
|
how can read the sector (eg: sector number 150 to 200) on a CD directly in VB.net?
please help me...thz....
|
|
|
|
|
Read up on CreateFile[^]. I think the section you're interested in is about half way down, under "Physical Disks and Volumes". There is no ".NET way" to do this. You have to P/Invoke the Win32 functions directly to accomplish this.
There an article here [^]on CP about it, but it's not written very well.
and a quick Google for "read disk sectors vb.net" comes up with these[^].
|
|
|
|
|
|
If you know the coordinance of the top-left and the bottom-right, then it's down to basic maths to calculate the coordinance that the mouse is pointing to.
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
One thing to be aware of is that a map is a projection of a three dimensional curved surface onto a two dimensional plane, and there are different ways of handling that projection. So in order to convert the mouse position to a latitude/longitude on the map you need to know the projection in use for this particular map.
In this case, it's not really a map, it's a satellite photograph. I have no idea how the maths works for mapping a 2D digital photograph back to the corresponding real-world position on the surface of a sphere. In fact the world is an oblate spheroid, I think, not a perfect sphere but you could probably make things easy by assuming a sphere and still be close enough for most practical purposes unless you're planning to write your own cruise missile guidance system.
|
|
|
|
|
David Skelly wrote: unless you're planning to write your own cruise missile guidance system.
Well actually..... 
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Hi All,
I want to develop an application in which it will show list of IP address of all working System in LAN and when i select any IP address from list and want to show message box on selected IP address's System then it will show message box.
I am able to get all IP Address of all working system. but not able to send message on selected IP address's System.
So my question is that, how i send message at selected IP Address system?
I don't know much about Network and Socket Programming.
Please guide me what i need to do for this task and what is the best way to achieve them.
If you all have any reference book then please revert me back name of the book.
Regards
Dharmchand Dhingra
|
|
|
|
|
dcdhingra wrote: So my question is that, how i send message at selected IP Address system?
I don't know much about Network and Socket Programming.
Is there an application on that system that can receive and display the message? Or should it display it without installing extra software?
If you're "just" going to send a short notification, then take a look at the "NET SEND" command - it might do the trick without much trouble. There's a CodeProject-article here[^].
I are Troll 
|
|
|
|
|
Thanks for quick response.
I think Code project article will help me.
Currently i am studying that article and what output will come will tell you within tomorrow or few day's.
Thanks once again.
Regards
Dharmchand Dhingra
|
|
|
|
|
Hi,
Thanks a lot.
I have done my task which i want. The code project article which you gave me link of that article help a lot to solve this problem.
Once again Thanks a lot.
Regards
Dharmchand Dhingra
|
|
|
|
|
You're welcome, and thanks for the feedback 
I are Troll
|
|
|
|
|
Without some piece of software running on the remote system listening for the messasge and knows what to do with it (like showing it in a messagebox), you can't show anything on the remote workstation.
You can use the "NET SEND" command (Start -> Run -> CMD -> NET SEND /?) to send to a user, not an IP address.
How do you have your code setup? What are you doing to try and send this message?
|
|
|
|
|
Thanks for quick response.
I already tried Net Send command but it is not working in Window 7 and Vista.
I need to create that type of application(Means Net Send). which will Work on All Windows OS.
Regards
Dharmchand Dhingra
|
|
|
|
|
It doesn't work on Vista and Win7 probably because there is a firewall running on those machines that are blocking the incomming requests or the services that listen for those messages are not running.
If you still want to go further and create your own, Google for "vb.net TCP/IP chat" for examples.
|
|
|
|
|
Trying to generate a report from a datatable. using SQL to populate a datatable. previously the table was simply displayed to the user, now I want the user to be able to generate a report after viewing the information without a new database query, i simply want to pass the current Datatable to crystal reports.
Public Sub printVisits()
Dim _row As Row
Dim newRow As DataRow
Dim printVisitSelection As DataTable = New DataTable("VisitData")
printVisitSelection.Columns.Add("No", System.Type.GetType("System.String"))
printVisitSelection.Columns.Add("Date", System.Type.GetType("System.String"))
printVisitSelection.Columns.Add("LastName", System.Type.GetType("System.String"))
printVisitSelection.Columns.Add("FirstName", System.Type.GetType("System.String"))
printVisitSelection.Columns.Add("VisitType", System.Type.GetType("System.String"))
For Each _row In fgVisits.Rows
'newRow = New DataRow
newRow = printVisitSelection.NewRow()
newRow("No") = _row(1).ToString
newRow("Date") = _row(2).ToString
newRow("LastName") = _row(3).ToString
newRow("FirstName") = _row(4).ToString
newRow("VisitType") = _row(5).ToString
printVisitSelection.Rows.Add(newRow)
Next
End Sub
|
|
|
|
|
You need to use a Typed DataSet.
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
I have need to determine which user created a particular file on the server, therefore I was wondering if anyone knew of away of reading the Details properties of a file. ie if you right click a file and select Properties there is a tab called Details. One of the properties here is called 'Owner'
I have already tried the Microsoft Developer Support OLE File Property Reader COM Object but not have any luck there.
Any help gratefully received.
Thanks
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
This article[^] may help you.
txtspeak is the realm of 9 year old children, not developers. Christian Graus
|
|
|
|
|
If anyone is interested, I found this code snippet that returns the information I need, in particular the file owner :
Sub Main()
Dim arrHeaders(35)
Dim shell As New Shell32.Shell
Dim objFolder As Shell32.Folder
objFolder = shell.NameSpace("\\PDMHH01\RMSage\GroupRM\SageSP")
For i = 0 To 34
arrHeaders(i) = objFolder.GetDetailsOf(objFolder.Items, i)
Next
For Each strFileName In objFolder.Items
For i = 0 To 34
Console.WriteLine(i & vbTab & arrHeaders(i) & ": " & bjFolder.GetDetailsOf(strFileName, i))
Next
Next
Console.ReadKey()
End Sub
Point to note, you do need to reference in the \Windows\System32 folder
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Hi there,
I'm pretty new to this but what I'm after is a method of getting the Last modified date from a file, then renaming the file to that data/time stamp.. If there are any duplicates then appending _1, _2 etc to them....
I've been looking for the correct file.getX and have found the
file.getattributes, for hidden /readonly etc.. but can't find the correct one for file Properties, specifically modified time.
Can anyone help...
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
