|
hello
guys i would like to ask you again if ever you have an idea on how i my going to generate a childnode which is unbound i'm using a datareader to get the parentnode for my treeview and its working my only problem is that i dont know how am i going to generate a child node...okey i have three table in my sqlbase one is for the divisions,2nd is the department and the 3rd is the sections...okey to clarify this the divisions will hold as parentnode and i already got it,,,while department will be the childnode of the divisions,,after that the sections will be also the child of the department and that's my problem the childnode can fix my problem coz i'm already 2 days stock here...please help me...okey heres my code for divisions(parentnode)...
Dim myconnection As New SqlConnection(My.Settings.sampleConnectionString)
Dim cmdjol As String = "select description from dbo.employee_divisions"
Dim cmd As New SqlCommand(cmdjol, myconnection)
cmd.Parameters.Add("@description", SqlDbType.VarChar, 50, ParameterDirection.Input).Value = Divisions.divname.Text
myconnection.Open()
Dim mydatareader As SqlDataReader = cmd.ExecuteReader()
Try
While mydatareader.Read()
TreeView1.Nodes.Add(mydatareader.GetString(0))
TreeView1.ShowPlusMinus = True
TreeView1.ShowRootLines = True
End While
Finally
mydatareader.Close()
myconnection.close()
End Try
can you add for my childnode(department and sections)
thnaks in advance...
|
|
|
|
|
HI,
I AM CREATING A PARENT NODE THEN CHILD FROM DATABASE.
FOR THAT I HAVE USED 2 DATASET AND 2 SQL STATEMENTS.
'***************Adding Root Node**********************
TreeView1.Nodes.Add("PARENT")
'*********************End*****************************
'***************Adding Child Node*********************
For i = 0 To ds1.Tables(0).Rows.Count - 1
Dim ndNodes As TreeNodeCollection, ndNode As TreeNode
ndNodes = Me.TreeView1.Nodes
For Each ndNode In ndNodes
ndNode.Nodes.Add("" & ds1.Tables(0).Rows(i)(0) & " " & ds1.Tables(0).Rows(i)(1) & "")
Next
'******************End*****************************
'***************Adding Sub Child Node**************
Dim temp1 As String = ds1.Tables(0).Rows(i)(0)
Dim sql2 As String = "SELECT a,b,c FROM xyz"
adpt2 = New OleDbDataAdapter(sql2, conn)
adpt2.Fill(ds2, "TPSAT")
For j = 0 To ds2.Tables(0).Rows.Count - 1
Dim ndNodes1 As TreeNodeCollection
ndNodes1 = Me.TreeView1.Nodes(0).Nodes
ndNode = Me.TreeView1.Nodes(0).LastNode
ndNode.Nodes.Add("" & ds2.Tables(0).Rows(j)(0) & " " & ds2.Tables(0).Rows(j)(1) & "")
'***************************************end*****************************************************************
|
|
|
|
|
HI,
I AM CREATING A PARENT NODE THEN CHILD FROM DATABASE.
FOR THAT I HAVE USED 2 DATASET AND 2 SQL STATEMENTS.
'***************Adding Root Node**********************
TreeView1.Nodes.Add("PARENT")
'*********************End*****************************
'***************Adding Child Node*********************
For i = 0 To ds1.Tables(0).Rows.Count - 1
Dim ndNodes As TreeNodeCollection, ndNode As TreeNode
ndNodes = Me.TreeView1.Nodes
For Each ndNode In ndNodes
ndNode.Nodes.Add("" & ds1.Tables(0).Rows(i)(0) & " " & ds1.Tables(0).Rows(i)(1) & "")
Next
'******************End*****************************
'***************Adding Sub Child Node**************
Dim temp1 As String = ds1.Tables(0).Rows(i)(0)
Dim sql2 As String = "SELECT a,b,c FROM xyz"
adpt2 = New OleDbDataAdapter(sql2, conn)
adpt2.Fill(ds2, "TPSAT")
For j = 0 To ds2.Tables(0).Rows.Count - 1
Dim ndNodes1 As TreeNodeCollection
ndNodes1 = Me.TreeView1.Nodes(0).Nodes
ndNode = Me.TreeView1.Nodes(0).LastNode
ndNode.Nodes.Add("" & ds2.Tables(0).Rows(j)(0) & " " & ds2.Tables(0).Rows(j)(1) & "")
'***************************************end*****************************************************************
mamatharaghu
|
|
|
|
|
hi
see this
this is more perfect which u want
da = New SqlDataAdapter("select divisions from divisions", con)
da.Fill(ds, "Personals")
For i = 0 To ds.Tables(0).Rows.Count - 1
TreeView1.Nodes.Add(ds.Tables(0).Rows(i)(0))
Next
da1 = New SqlDataAdapter("select * from dept", con)
da1.Fill(ds1, "dept")
q = Me.TreeView1.Nodes
For Each p In q
For i = 0 To ds.Tables(0).Rows.Count - 1
p.Nodes.Add(ds1.Tables(0).Rows(i)(0))
Next
Next
da2 = New SqlDataAdapter("select * from sections", con)
da2.Fill(ds2, "sections")
Dim j As Integer
For j = 0 To ds.Tables(0).Rows.Count - 1
For i = 0 To ds2.Tables(0).Rows.Count - 1
q1 = Me.TreeView1.Nodes(j).Nodes
p = Me.TreeView1.Nodes(j).Nodes(i)
For Each p In q1
p.Nodes.Add(ds2.Tables(0).Rows(i)(0))
Next
Next
Next
mamatharaghu
|
|
|
|
|
I would like to be able to receive and send SMS in VB.NET. Please respond with sample or example of how i could accomplish this. I would especially love tutorials which i could read to acquire information/knowledge.
What do i have so far? Well i know you can access through COM Ports via cell phones. I also know that AT and MSCOM in .NET should have all the functions that handle this request.
I have been trying to read to see if i could find out exactly how but to no avail. Hence i now seek your assistance.
Looking forward to lots of response.
Martin Luther King, Jr. - "A man who won't die for something is not fit to live."
|
|
|
|
|
Hi all,
can anyone show me how to use windows management interface(WMI) using VB.Net
to check the disk quota and send the notification to the user if
the disk is almost run out of space.I am using windows XP.
I do have look some articles regarding this but failed to get any source codes.
Hope that anyone can guide me regarding the WMI...
Thanks a lot in advance.
besah
|
|
|
|
|
Here is an example of the type of thing that I need to do using Visual Basic Express:
Let's say that you are ordering a vehicle. First you pick the vehicle type:
Sedan
Sport Utility
Mini Van
Pickup Truck
Then, depending on which you selected, you get a list of exterior colors. Different colors are offered for each different vehicle type.
Then you are offered;
Leather seats
Cloth seats
Then you select an engine size. Different engines are offered for each different vehicle type.
Then you select a transmission, etc.
I prefer to use RadioBoxes with one of the RadioBoxes preselected as a default. Then I would like to have a Button1 labeled "Next" and a Button2 labeled "Back".
Where can I get a sample program that does this type of thing?
I tried to program it, but, the Button1_Click event or RadioButton1_checked_changed subroutines didn't work out because they caused me to get "lost". I need control to return to my next line of code after the user makes his selection.
|
|
|
|
|
Hi,
I'm working on a project involving image processing and analysis.I have implemented various edge detection algorithms.I cannot fully understand how to perform non-maximum supression and hysteresis ridge tracking in canny edge detection.if someone knows about websites that explains it detail please specify or if any has implemented the algorithm please post the source code.It's urgent!!
signing off is preci
|
|
|
|
|
Is there a way to get ‘Window Form Designer Generated Code’ of a VB.Net 2005 form
Thank you
Chatura Dilan
|
|
|
|
|
Under the Project menu, click on Show All Files. You'll find the Designer generated code file in the Solution Explorer window. You might have to click the little "plus" sign next to the form you want to see the designer code for.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thank you![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
Chatura Dilan
|
|
|
|
|
For all you forum members out there who have criticised me for being intolerant, have a gander at this guy's response[^] to valid help provided by a respected member of The Code Project.
It is further evidence why I, and some other forum members, post the reponses we do.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once 
-- modified at 19:34 Monday 27th March, 2006
-- updated link
|
|
|
|
|
Yes you are right, it shows that guy’s idiotic and iniquitous features. He doesn’t even know how to be grateful to Dave about answering his question.
Chatura Dilan
|
|
|
|
|
Chatura Dilan wrote: idiotic
<blink>FeRtoll Software.net
------------
E-Mail me
WebPage
|
|
|
|
|
Dear Fertoll,
If at first you don't succeed, try, try again. Then quit. There's no point in being a damn fool about it. - W. C. Fields
In order to succeed you must fail, so that you know what not to do the next time. - Anthony J. D'Angelo
The most important single ingredient in the formula of success is knowing how to get along with people. –
Theodore Roosevelt
Chatura Dilan
|
|
|
|
|
|
Hi,
Any of you know how to send ftp commands and quote site commands? can you give me an example of how to do it from vb.net?
Thank you
-- modified at 18:49 Monday 27th March, 2006
|
|
|
|
|
please some body help me.i nees to ocx file
(msscommlib.ocx) ,i'm using vb.net 2003
please some body help me .........
123
|
|
|
|
|
What?? You haven't asked a question. What are you having a problem with?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Have installed Crystal Reports 7.0 on a Windows Server 2003 machine.
My application is coded in VB6 using web classes.
I get the reports to display in the web browser, but get an error when trying to export in the activexviewer of 'Export Failed - The report was not exported.' This error message is displayed using all 4 export types (Crystal Report, Rich Text, Word Document, and Excel 5.0).
Is there anything special that needs to be setup on a Windows Server 2003 machine to do exports?
Are there any special permissions that need to be set?
Bea
|
|
|
|
|
How can I broadcast the video of my webcam with only vb.net code?
Because I try to broadcast video with WMEncoderLib.dll and WMPREVIEWLib.dll but they need windows media encoder, but I have to share out this software and so I'm searching for another way.
thanks very much
|
|
|
|
|
tnky wrote: but they need windows media encoder, but I have to share out this software and so I'm searching for another way.
I doubt there is one. Those libraries exist to make that sort of stuff possible. You could bypass them, but not trivially, and certainly not in VB.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
but, for example, how does msn messenger works? It doesn't need windows media encoder to make a videoconference...
|
|
|
|
|
i want to know how to convert string to color. because i want to save a color in the textfile to view it next time and the color is invalid like this:
Dim clrColor as Color
Dim rdrColor as streamreader = new streamreader(blabla)
clrColor = rdrColor.ReadLine
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
|
|
|
|
|
Use the Color.FromName method.
---
b { font-weight: normal; }
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
