My doubt is
Am using Microsoft SQLSERVER as the back end with Visual Web Developer Express Edition as the front end.
In one of the Forms,I do have the DropDownList which contains the names of the Employees.
When I click each name from the dropdownlist..the corresponding datas of that Employee should appear in my form
eg: when I click Tom Alex,his address,job,city etc should appear on the form.
For this i gave the code in the SelectedIndexedchanged. and in the property window I set the AutoPostBack=True
My problem is that...When I click any names from the DropDownList..its index value is 0
ie suppose I have a list of names in the dropdownlist like Arun,krishna,Shabin,Binnesh.
so when I click on Arun..its index value is 0..ie is ok.
but when i click on Krishna...its index value should be 1....but here its index value is 0
likewise when i click Shabin or binesh...its index vallue is 0.
since its index value is 0 always...when i click kris,shabin,binnesh..always pops up mine...
So anyone..can u help me to let me know where am wrong...I recently studied ASP.NET...but am not too deep.
I know this problem is very easy ...i will attach the code below.
it would be great if u could help me out.
Code to Connect to SQL SERVER
---------------------------
Private Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
With cnn
cnn.Open("DSN=Telephone;uid=sa;pswd=sa;")
End With
sql = "SELECT * FROM Emps ORDER BY Emp_Name"
rs = cnn.Execute(sql)
Txt_EmpName.Focus()
Dp3.Items.Clear()
If rs.EOF Then
MsgBox("Database is Empty", , "Telephone")
Else
Call loadme()
End If
'Dp2.Visible = False
End Sub
Private Sub loadme()
Dim cnn As New ADODB.Connection
Dim rsLoadme As New ADODB.Recordset
cnn.Open("DSN=Telephone;uid=sa;pswd=sa;")
rsLoadme.Open("Select Emp_Id,Emp_Name + ' ' +Emp_Surname as Name FROM Emps", cnn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockReadOnly)
Do While Not rsLoadme.EOF
Dp3.Items.Add(rsLoadme.Fields("Name").Value)
'rsLoadme.MoveNext()
Loop
End Sub
My Code in The DropDownList
---------------------------
Private Sub Dp3_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles Dp3.SelectedIndexChanged
Dim cnn As New ADODB.Connection
Dim rsSelect As New ADODB.Recordset
With cnn
cnn.Open("DSN=Telephone;uid=sa;pswd=sa;")
End With
'value = instance.SelectedItem
'instance.SelectedIndex = value
If Dp3.SelectedIndex > -1 Then
sqlSelect = "SELECT Title,Address1,Address2,Address3,City FROM Emps WHERE Emp_NS='" & Trim(Dp3.Text) & "'"
rsSelect = cnn.Execute(sqlSelect)
Dp1.Text = rsSelect.Fields("Title").Value
Txt_Address1.Text = rsSelect.Fields("Address1").Value
Txt_Address2.Text = rsSelect.Fields("Address2").Value
Txt_Address3.Text = rsSelect.Fields("Address3").Value
Txt_City.Text = rsSelect.Fields("City").Value
Dp3.Dispose()
End If
Note:
I have done all the coding in the Code Behind and not on the HTML PAge with the ASP syntax.
Am new to ASP.NET......any help would be greatly appreciatable.
Thanks so much