Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
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.
Sub GetData() Dim ds As New DataSet Using da As New SqlClient.SqlDataAdapter("rsp_cc_clienttype", objConn) Dim myComm1 As New SqlCommand("rsp_cc_clienttype", objConn) myComm1.Parameters.Add("@startdate", SqlDbType.SmallDateTime, 6).Value = sdate myComm1.Parameters.Add("@enddate", SqlDbType.SmallDateTime, 6).Value = edate myComm1.CommandType = CommandType.StoredProcedure da.Fill(ds) myComm1.ExecuteNonQuery() 'fill clients With ddClient .Items.Clear() .DataSource = ds.Tables(0) .DataValueField = "clientid" .DataTextField = "clientname" .DataBind() End With If objConn.State <> ConnectionState.Closed Then objConn.Close() End If 'End Try End Using End Sub
Join the community of 500,000 technology professionals and ask your questions.