How do I get an output Parameters value from a stored procedure

[CyberSoftHari]

I am trying to get an output Parameters value from a stored procedure using
sqlDataSource in asp.net 2.0. But I only get a null value for the
output Parameters. Can someone Point me to get value?

        SqlDataSource InsertDS = getSqlDataSource;
//-----------------parameters
        InsertDS.InsertParameters.Add("FirstName", FirstName);
        .......................................
//----------------This is an Output Param
        InsertDS.InsertParameters.Add("outQryStatus", strOutStatus);
        InsertDS.InsertCommand = "RegisterUser";
        try{
            intRowsAffected = InsertDS.Insert();
//-------------Trying to get and return
            return InsertDS.InsertParameters[7].DefaultValue.ToString();
//-----------------And also tyried 
           //return strOutStatus; //this also return null
        }
        catch ........Block
        ..........................................
 

Note: I am using it in my Webservice.cs.

[Plater]

It doesn't look like you're designating your parameter's direction as output.

For example:

SqlCommand sc = new SqlCommand("AddNewBillOfMaterialsConnections", dbcon);
sc.CommandType = CommandType.StoredProcedure;
 
sc.Parameters.Add("@PartID", SqlDbType.BigInt);
sc.Parameters["@PartID"].Value = PartID;
 
sc.Parameters.Add("@Notes", SqlDbType.VarChar);
sc.Parameters["@Notes"].Value = quoteReplace(Notes);
 
sc.Parameters.Add("@ModifiedDate", SqlDbType.DateTime);
sc.Parameters["@ModifiedDate"].Value = ModifiedDate;
 
//out
sc.Parameters.Add("@BOMConnectionID", SqlDbType.BigInt);
sc.Parameters["@BOMConnectionID"].Direction = ParameterDirection.Output;
 
sc.ExecuteNonQuery();
Int64 retval = (Int64)sc.Parameters["@BOMConnectionID"].Value;
sc.Dispose();
 

[CyberSoftHari]

Working fine with SqlCommand (i chang it in my code). How to do it in SqlDataSource?
Thank you.

[Plater]

I think you can do:
InsertDS.InsertParameters["paramName"].Direction = ParameterDirection.Output;

[CyberSoftHari]

Thank you plater, I feel SqlCommand is easer than SqlDataSource.
In SqlDS we need to use Different properties for Insert, Update, Delete and Select query commands.

[Plater]

The SqlDataSource's Insert/Update/Delete are just instances of the SqlCommand object. the difference is, they get called automatically with special setups to handle the data in your datasource.