Populating Treeview using DataTable [modified] - Visual Basic Discussion Boards

i simply want to paste the file in the folder named upload on server

is it necessary that their must be a page to get my file on server.

can u tell me how can i rename files on server
(this is an alternate of my application that i can upload files from third party tools and then rename the file as needed on server)

if i simply replace the protocol from http from ftp it gives me the error

an exception occured during a webclient request. the requested ftp command is not supported when using http proxy.

have any idea then please let me know

thanks

help everyone

eyes2007 wrote:
i simply want to paste the file in the folder named upload on server

is it necessary that their must be a page to get my file on server.

Yes, if you want to use the http protocol. You can't save a file using the http protocol, you can only send a request to the server that contains the file data, and the page on the server can recieve the file data and save it as a file on the server.

eyes2007 wrote:
f i simply replace the protocol from http from ftp it gives me the error

an exception occured during a webclient request. the requested ftp command is not supported when using http proxy.

You can't upload files to ftp when using a proxy. Try turning off the proxy, as suggested here:

http://www.vbforums.com/showthread.php?t=384411[^]

---
single minded; short sighted; long gone;

can you please provide me some more documentation or links or any thing else

thanks

help everyone

IS that possible to make Crystal reports without dataset or Database in .net 2005? IF posiible How ?can u please help?

Vv

What exactly do you mean with "make"? If you mean to create the template you can use xml/xsl files (see here: developerfusion[^] or see here: devarticles[^]) in order to drag and drop the content to its place in the report.

If you mean "bind the data to the report" with "make" it depends on what do you want to display in the report. If you have a table of some sort to display, i dont know any other way to bring the data to the report than using DataSets or a DataBase Connection. If you want to display static data (like a single name, a single date for instance, you can use the following piece of code to insert static text into prior defined fields in the report:

<br />
ReportDocument doc;<br />
doc = new ReportDocument();<br />
doc.Load(reportFileName);<br />
((CrystalDecisions.CrystalReports.Engine.TextObject)doc.ReportDefinition.Sections["YOUR_SECTION_NAME_WHERE_THE_FIELD_IS_LOCATED"].ReportObjects["FIELD_NAME_OF_THE_GIVEN_SECTION"]).Text = YOURNEWFIELDVALUE;<br />

I hope this helps, let me know if you still have issues...

Best regards

Trollpower

Any other way to create the report without dataset in VB.net 2005

Vv

You can always create a crystal report (or any other report engines) without any datasource (DB, dataset, mdb, xml, etc)

You can expose fields as parameters and set these parameters in your program.

hi, i have a little problem in populating my TreeView. i already populated all the Parent Node and its corresponding Child Node orderly. the problem is, when my form load where the treeview is place this is the output.

i attached the picture to be able to understand well because my english is not that good. sorry for that. but anyway the ordering of the Parent and Child Node is correct. what i want is all the child node of the specific parent node will under it.

this is my code

Dim DA As clsDataAccess
Dim DA2 As clsDataAccess
Dim DT As DataTable
Dim DT2 As DataTable

Dim i As Integer
Dim nRow As Integer
Dim nRow2 As Integer

Dim strParent As String
Dim strChild As String
Dim intParent As String
Try
DA = New clsDataAccess
DT = DA.ExecQuery("SELECT DISTINCT(tblMicromixParentNode.intParentNodeID), dbo.tblMicromixParentNode.vchrDescription AS " & _
"vchrParentDesc,dbo.tblMicromixParentNOde.intOrder FROM dbo.tblMicromixMenu INNER JOIN dbo.tblMicromixParentNode ON " & _
"dbo.tblMicromixMenu.intParentNodeID = dbo.tblMicromixParentNode.intParentNodeID ORDER BY intOrder ASC")

If DT.Rows.Count > 0 Then
Dim PNode As Windows.Forms.TreeNode
TV.Nodes.Clear()

For nRow = 0 To DT.Rows.Count - 1
intParent = DT.Rows(nRow).Item("intParentNodeID")
strParent = DT.Rows(nRow).Item("vchrParentDesc")

PNode = TV.Nodes.Add(strParent)

DA2 = New clsDataAccess
DT2 = DA2.ExecQuery("SELECT t1.*, t2.vchrDescription AS vchrFormDesc, " & _
" t2.vchrFormName AS vchrFormName FROM " & _
" tblMicromixMenu t1 INNER JOIN tblMicromixChildNode " & _
" t2 ON t1.intChildNodeID = t2.intChildNodeID " & _
" where t1.intAccessID=1 and t1.intParentNodeID=" & intParent & " and intShow=1")

If DT2.Rows.Count > 0 Then
Dim CNode As TreeNode

For nRow2 = 0 To DT2.Rows.Count - 1
strChild = DT2.Rows(nRow2).Item("vchrFormDesc")
CNode = TV.Nodes.Add(strChild)
Next
End If

PNode.EnsureVisible()
Next
End If

Catch ex As Exception
MsgBox(ex.ToString)
End Try

by the way i am using vb.net for that.

your reply will be really appreciated.

Thank You.

-- modified at 1:17 Tuesday 25th September, 2007

Don't block the drive way of all the newbies in programming. Smile | :)

It doesn't work because you didn't add your child nodes to any of the existing parent nodes at all. They're all children of the root.

You're using lousy variable names by the way. It's very difficult to figure out what the variable is used for just be glancing at it.

This section of code should be modified:

If DT2.Rows.Count > 0 Then
    Dim CNode As TreeNode
    For nRow2 = 0 To DT2.Rows.Count - 1
        strChild = DT2.Rows(nRow2).Item("vchrFormDesc")
        PNode.Nodes.Add(strChild)
    Next
End If

You add the children to the parent node you created above it, not to the root of the TreeView nodes collection.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

first of all thank u for the reply sir.

oh yes i see now. my code below is the same so i get an output that they become all Parent Node.

so my problem now is how can i add the child node in a specific parent node? because in vb6 they have Relative,Relationship and Text. which is the Relative is the Parent Node and the Relationship is the word "tvwChild".

how can i convert this line of code in VB6 to .Net
TreeView1.Nodes.Add(Relative,Relationship,Key,Text,Image)
where the Relationship should be "tvwChild"

Parent Node
For nRow = 0 To DT.Rows.Count - 1
intParent = DT.Rows(nRow).Item("intParentNodeID")
strParent = DT.Rows(nRow).Item("vchrParentDesc")
PNode = TV.Nodes.Add(strParent)

Child Node
If DT2.Rows.Count > 0 Then
Dim CNode As TreeNode
For nRow2 = 0 To DT2.Rows.Count - 1
strChild = DT2.Rows(nRow2).Item("vchrFormDesc")
CNode = TV.Nodes.Add(strChild)
Next
End If

sorry for my english.

Thank You.

Don't block the drive way of all the newbies in programming. Smile | :)

Did you understand the changes I made to your code in my last post?

You add a parent node to the root of the tree. Then you retrieve all the children of that node from the database and add those to the Nodes collection of the Parent you just added.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

oh yes sir i do understand that. i just explaining my previous code. Smile | :)

the code is working now. thank you very much.
i wish you are open again when i have a difficulties in my code.

Thank You.

Don't block the drive way of all the newbies in programming. Smile | :)

I have a Windows VB.Net Application with MSFoxPro Database, third party controls within it. With all the granted permissions for assemblies and strong name for dll.
I install my App in one system and copy the shortcut key in the other syatem within the LAN. Now if i click on shortcut key it has to fetch the data from the system where I have installed.
Can anyone PLS help me in this.
Very Urgent.

Rekha

skandaapriya wrote:
Now if i click on shortcut key it has to fetch the data from the system where I have installed.
Can anyone PLS help me in this.

what???
what do you want? fetch the data from the machine where your app is installed to the machine where you put the shortcut??? Sniff | :^)

Paras Kaneriya
The difference between genius and stupidity is that genius has its limits.

You need Client/Server programming. You should write different codes which should run on clients and the server.
Your application should be installed on all machines!

if i am gettin it correctly then you want to fetch your database to all the lan connected system where ever you have installed your executable file
well this is server client application...
if this is the case,
then i know the procedure for sql and excess , i hope same logic should work.
In the connection string where you are giving path of your database in coding, jst add the ip adress of server like "//ipaddress of server computer/path of database".
and from server computer you have to share the database file.
try this out, may it helps you....

This is easy. In your code, you have to build the fully qualified path to the folder where the database is. You can do this with something like:

Dim fullPath As String = Path.Combine(Application.StartupPath, "database.mdb")

Or, if the database file is in a subdirectory of the StartupPath:

Dim fullPath As String = Path.Combine(Application.StartupPath, "subfolder\database.mdb")

Other than that, you haven't said what the problem is, nor mentioned any error messages you're getting, so it's very hard to help you.

BTW, mentioning "urgent" in your post tends to get people to ignore you.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

hi guys

i want to get domain servers date and time through my vb.net application,

how can i do that ?
thanks in advance

hello

Any machine that starts up and is part of the same domain automatically gets it's date/time synced with the domain controller it logs into the domain with. You get the date/time from the workstation, not the domain controller.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

thanks

but what if some one has changed the local system time and because of that my application logic

will not work according to its functionality thats why in my vb.net i am getting the domain

system time .

hello

Rather you should use UDT.Now() Smile | :)

Paras Kaneriya
The difference between genius and stupidity is that genius has its limits.

The local domain workstations resync their time with the server every once in a while.

If you're worried about people rolling back the clock because you're giving them a timed trial software, you are simply at the mercy of the clock. There is no way around it that's 100% foolproof.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

I am developing a program that will keep in inventory of items that we have plus I want to be able to write an order for each person individually. I am trying to use a Listview control, but I want to just be able to scroll across and in each row and column edit the quantity to order for each person. But the labeledit property only applies to the first column. I have done a lot of searching and all I can find are program that will do this in C and I can't really even get those to work right for me. Does anyone have a suggestion?

Any suggestions would be appreciated.

B.

Scrap the ListView and go with the DataGridView. It's designed to do exactly what you described.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Wrong tool
The listview is really not designed for inline editing or large datasets.

Use the datagridview.