>My store procedure was contained:
>
>CREATE PROCEDURE [usp_showdepartment] @mHostCode CHAR AS
>SELECT * FROM Department WHERE HostCode = @mHostCode ORDER BY DepartmentName
>GO
>
>How to call it from vb.net code? .. I tried below codes but I got nothing
>
>Private Sub LoadDepartment()
>Dim mHostCode As String = UCase(HostCode.Text.Trim)
>Dim SQLDataAdapter As New SqlClient.SqlDataAdapter("usp_showdepartment", SQLConn1)
>Dim DSDepartment As New DataSet("Department")
>
>SQLDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure
>SQLDataAdapter.SelectCommand.Parameters.Add("@mHostCode", SqlDbType.Char)
>SQLDataAdapter.SelectCommand.Parameters("@mHostCode").Value = mHostCode
>
>DSDepartment.Clear()
>SQLDataAdapter.Fill(DSDepartment, "Department")
>
>Me.C1TrueDBGrid2.DataSource = DSDepartment.Tables("Department")
>
>end sub
>
>please advise ,.. many thanks in advance

Here is an example I used.

' Populates Grid...
        Dim daUser As New SqlDataAdapter
        Dim UserParam1 As New SqlParameter _
                ("@UserID", SqlDbType.Char, 25)

        UserParam1.Direction = ParameterDirection.Input
        UserParam1.Value = UserID

        daUser.SelectCommand = New SqlCommand
        daUser.SelectCommand.Connection = GetConnection()
        daUser.SelectCommand.CommandText = "GetUser"
        daUser.SelectCommand.CommandType = CommandType.StoredProcedure
        daUser.SelectCommand.Parameters.Add(UserParam1)

        Dim dsUser As New DataSet
        daUser.Fill(dsUser, "UserID")

I do not see where you are calling your stored procedure? Refer to my line:

daUser.SelectCommand.CommandText = "GetUser"      

Tom