cmd = new ADODB.Command
{
ActiveConnection = cn,
NamedParameters = true,
CommandText = "Select dbo.Work_Order.Part_ID as PartNumber from dbo.Work_Order Where Base_id = @WorkOrder and Sub_ID = '0'",
CommandType = ADODB.CommandTypeEnum.adCmdText
};
cmd.Parameters.Append(cmd.CreateParameter("WorkOrder", ADODB.DataTypeEnum.adVarWChar,ADODB.ParameterDirectionEnum.adParamInput, 10));
rs = new ADODB.Recordset();
rs.Open(cmd);