Exactly when does DropDownClosing for the AutoCompleteBox fire?

With ASP.NET 2.0, SqlCommand.Parameters.Add is depreciated and will no
longer work.  It is being replaced with Parameters.AddWithValue.  Can
anyone post an example of how to construct an OUTPUT parameter in .NET

There’s only one Add method that’s obsoleted, the method that accepts a string for the parameter  name and an object for the value.  As you noted, you should call AddWithValue instead for this scenario.All other Add methods are still available.  However, there was an issue in recent releases of Visual Studio that prevented the Add methods from showing up in Intellisense drop-downs.  You should be able to escape out of the Intellisense drop-downs and manually type “Add.(“.To handle output  parameters, you could use code like.//C#SqlParameter p = cmd.Parameters.Add(“@MyParam”, SqlDbType.Int);p.Direction = ParameterDirection.Output; ‘VB.NETDim p As SqlParameter = cmd.Parameters.Add(“@foo”, SqlDbType.Int)p.Direction = ParameterDirection.Output I hope this information proves helpful.David SceppaADO.NET Program ManagerMicrosoft

I am not an experienced programmer and have convert a VB.NET2003 program to see the …deprecated…use… in the underlined area of code. Please show me how to convert this snippet. The .Add() is the problem areas.Thank You,TonyPublicSharedFunction AddVendor(ByVal Vendor As Vendor) AsIntegerDim conPayables As SqlConnection = GetPayablesConnection()Dim cmdInsertVendors AsNew SqlCommand(“usp_InsertVendors10”, conPayables)cmdInsertVendors.CommandType = CommandType.StoredProcedureWith cmdInsertVendors.Parameters.Add(“@VendorName”, Vendor.Name)If Vendor.Address1 = “”Then.Add(“@VendorAddress1”, DBNull.Value)Else.Add(“@VendorAddress1”, Vendor.Address1)EndIfIf Vendor.Address2 = “”Then.Add(“@VendorAddress2”, DBNull.Value)Else.Add(“@VendorAddress2”, Vendor.Address2)EndIf.Add(“@VendorCity”, Vendor.City).Add(“@VendorState”, Vendor.State).Add(“@VendorZipCode”, Vendor.ZipCode)EndWith

Hello there ,I’m not sure if you’re familiar with asp.net 2.0 anyway see the sample code below  I hope it helps// create a new parameterparam = comm.CreateParameter();param.ParameterName = “@OutPutValue”;param.Direction = ParameterDirection.Output;param.DbType = DbType.Int32;comm.Parameters.Add(param);// execute the stored procedure and save the results in a DataTableDataTable table = GenericDataAccess.ExecuteSelectCommand(comm);// get the valueint MyOutPutValue= Int32.Parse(comm.Parameters[“@OutPutValue”].Value.ToString());ThanksTerry AmusaSenior Software Developer