Dim sqlConn as new sqlClient.Connection(your connection string here) Dim sqlCmd as new sqlClient.sqlCommand() sqlCmd.Connection = sqlConn sqlCmd.CommandType = CommandType.StoredProcedure sqlCmd.CommandText = "your stored procedure name here" Dim spParameter As New SqlClient.SqlParameter() With spParameter .ParameterName = "your parameter name e.g. @CompanyId" .Size = Size .SqlDbType = e.g. NVarChar (SqlDbType) .Direction = e.g. Input (System.Data.ParameterDirection) .IsNullable = True/False .Value = Your input value End With sqlCmd..Parameters.Add(spParameter) sqlCmd.Execute to retrieve return values : sqlCmd.UpdatedRowSource = UpdateRowSource.OutputParameters Dim myCompanyId = sqlCmd.Parameters.Item("CompanyId").Value Steve Jowett

very Simple --Query without parameter create proc procedure_name as Select * from table_name --conditional query create proc procedure_name as begin Select * from table_name End Rakesh Jha

http://www.databasejournal.com/features/mssql/article.php/1459181[^]

Hi saravuth, you came from the same country like me too. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemtextencodingclasstopic.asp[^]