Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
<WebMethod()> _ Public Function GetFare(ByVal clntid As String) As String Dim tripfr As String = Nothing Dim constring As String = Nothing constring = System.Configuration.ConfigurationManager.ConnectionStrings("WS").ConnectionString.ToString Dim mycon As New SqlConnection(constring) Dim strquery As String = Nothing strquery = "select fare from schedules where clntid = '" & clntid & "'" Try mycon.Open() Dim mycmd As New SqlCommand(strquery, mycon) Dim myreader As SqlDataReader = Nothing myreader = mycmd.ExecuteReader() While myreader.Read tripnm = myreader.Item(0) End While Catch soapex As SoapException Finally End Try Return tripfr End Function Client Application to Consume: Private Sub Sh_Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Sh_Button1.Click Dim callService As New MDC.myMDCService Dim tripfr As String = Nothing tripfr = callService.GetRecord(textbox1.Text) /////// -- Error Here. MessageBox.Show(tripfr) End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|reading excel file in .net||2||31|
|How to reference a column by name when iterating through a GridView ?||1||32|
|vb.net deleting excel sheet in workbook||11||31|
|Aspx calendar pop up control||3||27|