August 29, 2008 02:58pm pdt

1. jpaulino 810,495
2. TheLearn... 726,583
3. Idle_Mind 429,341
4. Sancler 373,508
5. VBRocks 369,999
6. PaulHews 353,757
7. Dhaest 322,304
8. Fernando... 319,385
9. jaime_oliv... 312,069
10. jcoehoorn 260,456
11. emoreau 243,517
12. webtubbs 235,492
13. angelIII 191,312
14. vb_jonas 183,591
15. GreenGho... 166,611
16. rachitkohli 156,236
17. mlmcc 132,609
18. graye 126,480
19. armoghan 106,215
20. planocz 98,038
21. TimCottee 96,932
22. ZachSmith 93,895
23. AkisC 85,105
24. samtran0... 71,944
25. ee_rlee 71,420

1. TheLearn... 4,181,066
2. Idle_Mind 3,506,493
3. Sancler 2,354,988
4. Fernando... 2,069,835
5. jpaulino 1,159,862
6. RonaldBie... 1,159,695
7. emoreau 1,058,840
8. VBRocks 925,180
9. iboutchkine 814,529
10. Chaosian 674,034
11. angelIII 658,019
12. webtubbs 657,913
13. PaulHews 640,798
14. planocz 634,195
15. graye 618,360
16. Dhaest 602,499
17. arif_eqbal 596,164
18. gregoryyo... 585,515
19. jaime_oliv... 542,670
20. ZeonFlash 486,195
21. vbturbo 477,858
22. AlexFM 473,611
23. BriCrowe 435,117
24. ptakja 389,723
25. amyhxu 386,998

04.22.2008 at 05:48PM PDT, ID: 23345138

	[x] Attachment Details

how to display matching value from parent table in textbox in vb.net

Asked by harpreete_singh in Microsoft Visual Basic.Net, Visual Studio .NET 2005

Tags: Microsoft, Visual Basic, 2005 express edition

Hi,
I have two table in sql server 2005 express edition parent table "Person" having fields(personid,firstname,lastname,gnederid) and "Legnresp" child table having fields(legnresid,legnid,personid)
I want to show the related value which is present in parent table into a textbox which is related to child table when i select from combobox ,without using datagrid but textbox. I tried using datareader it doesn't work then command but still problem is not solved.
After getting value in textbox4.text, i have made delete button so that i can also delete the related record.
Its working when i used on delete cascade in sql server but i want to delete without using cascade.
First i want to show the same personid in textbox4 which it shows in textbox3 but from child table and delete it if i click on delete button.
Hope above make some sense.

Thanks
Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:

           
           
             Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
 
 
        'TextBox1.Text = (Me.ComboBox1.SelectedItem)
        Dim sqlconn As New SqlConnection("data source=TBPC25\SQLEXPRESS;Initial Catalog=RealEstate1;Integrated Security=True")
        sqlconn.Open()
 
        cmd = New SqlCommand("select firstname from person where firstname='" & ComboBox1.Text & "'", sqlconn)
        cmd2 = New SqlCommand("select personid from person where firstname='" & ComboBox1.Text & "'", sqlconn)
        cmd3 = New SqlCommand("select personid from legnresp person where personid='" & TextBox3.Text & "'", sqlconn)
        'cmd3 = New SqlCommand("select personid from person, legnresp where person.personid = legnresp.personid", sqlconn)
        'cmd3 = New SqlCommand("select person.personid from person inner join legnresp on person.personid = legnresp.personid", sqlconn)
        'Dim ra As Integer
 
        dr = cmd.ExecuteReader()
        If dr.read Then
            TextBox1.Text = Trim(dr(0))
 
        End If
        sqlconn.Close()
        sqlconn.Open()
 
        dr2 = cmd2.ExecuteReader
        If dr2.Read Then
            TextBox3.Text = Trim(dr2(0))
        End If
        sqlconn.Close()
 
        '        If dr3.Read Then
        'TextBox4.Text = Trim(dr3(0))
 
        ' End If
        sqlconn.Open()
 
 
 
        TextBox4.Text = cmd3.ExecuteNonQuery()
 
 
 
 
 
 
 
        sqlconn.Close()
 
 
    End Sub
 
 
 
 
 
 Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
 
        Dim sqlconn As New SqlConnection("data source=TBPC25\SQLEXPRESS;Initial Catalog=RealEstate1;Integrated Security=True")
        sqlconn.Open()
        Dim command As String
        'Dim command2 As String
        command = "delete from person where personid = '" & TextBox3.Text & " ' "
        ' command2 = "delete from legnresp where personid = '" & TextBox3.Text & " ' "
        'and person.personid=legnresp.personid"
        Dim dbcommand As SqlCommand = New SqlCommand(command, sqlconn)
        dbcommand.ExecuteNonQuery()
        MessageBox.Show("records have been deleted")
 
        sqlconn.Close()

           
         

Keywords: how to display matching value from pa…

	Title
1	DataGrid and ComboBox
2	populate combobox in a datagridview i…
3	problem with databound combobox not…
4	VB.Net ComboBox in a Datagrid
5	combobox in a vb.net datagrid
6	Asp.net datagrid edit column

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

how to display matching value from parent table in textbox in vb.net

Asked by harpreete_singh in Microsoft Visual Basic.Net, Visual Studio .NET 2005

Tags: Microsoft, Visual Basic, 2005 express edition

About this solution