In my code below the textbox is getting populated with "adTitle" instead of the actual data.
A little help?
Dim _subdivision As String = ListSubDivision.SelectedVa
lue
Dim _lprice1 As Integer = listPrice.Text
Dim _lprice2 As Integer = _lprice1 / 1000000
Dim _furnished As String = ListFurnished.SelectedValu
e
Dim _adTitle As String = _subdivision & " " & "$" & _lprice2 & " " & "Million" & " " & _furnished
'txtAdTitle.Text = _adTitle
Dim dbCon As New System.Data.SqlClient.SqlC
onnection
Dim objCmd As New SqlClient.SqlCommand
dbCon.ConnectionString = System.Configuration.Confi
gurationMa
nager.AppS
ettings("s
trConPEP")
dbCon.Open()
Dim adapter As New SqlDataAdapter("SELECT dbo.adTitle('" & _adTitle & "') as adTitle", dbCon)
Dim dt As New DataTable()
adapter.Fill(dt)
dbCon.Close()
txtAdTitle.Text = "adTitle"
txtAdTitle.DataBind()
Start Free Trial
