cmd = new OleDbCommand();



SqlStr+= "INSERT INTO suspended_event([group_name], [orig_event], [version], [event_type], [service_id], [channel_name], [database_id], [org_id], [site_code], [user_id], [xml_data], [event_status], [error_text], [msgs_code], [responsibility_id], [row_added_ts], [csi_logicalid], [csi_component], [csi_task], [csi_referenceid], [csi_confirmation], [csi_authorizationid], [csi_creationdatetime], [csi_bodid], [csi_responsibility_id], [csi_portreference], [atch_set_id], [business_entity_id], [event_desc], [build_nbr], [successful_cnt], [failed_cnt], [not_processed_cnt], [corrected_cnt]) ";

SqlStr+= "Values( @group_name, @orig_event, @version, @event_type, @service_id, @channel_name, @database_id, @org_id, @site_code, @user_id, @xml_data, @event_status, @error_text, @msgs_code, @responsibility_id, @row_added_ts, @csi_logicalid, @csi_component, @csi_task, @csi_referenceid, @csi_confirmation, @csi_authorizationid, @csi_creationdatetime, @csi_bodid, @csi_responsibility_id, @csi_portreference, @atch_set_id, @business_entity_id, @event_desc, @build_nbr, @successful_cnt, @failed_cnt, @not_processed_cnt, @corrected_cnt)";

cmd.Parameters.Clear();

cmd.Transaction = tran;


cmd.Parameters.Add("@group_name",OleDbType.VarChar ,32).Value = GroupName;

cmd.Parameters.Add("@orig_event",OleDbType.VarChar ).Value = OriginatingEvent;

cmd.Parameters.Add("@version",OleDbType.VarChar).V alue = VersionIdentifier;

cmd.Parameters.Add("@event_type",OleDbType.VarChar ).Value = EventType;

cmd.Parameters.Add("@service_id",OleDbType.VarChar ).Value = CalledService;

cmd.Parameters.Add("@channel_name",OleDbType.VarCh ar).Value = AddressURI ;

cmd.Parameters.Add("@database_id",OleDbType.VarCha r).Value = OriginatingDatabase;

cmd.Parameters.Add("@org_id",OleDbType.VarChar).Va lue = OrganizationID;

cmd.Parameters.Add("@site_code",OleDbType.VarChar) .Value = SiteCode;

cmd.Parameters.Add("@user_id",OleDbType.VarChar).V alue = UserID;

cmd.Parameters.Add("@xml_data",OleDbType.VarChar). Value = XMLData;

cmd.Parameters.Add("@event_status",OleDbType.VarCh ar).Value = "Error";

cmd.Parameters.Add("@error_text",OleDbType.VarChar ).Value = ErrorText;

cmd.Parameters.Add("@msgs_code",OleDbType.VarChar) .Value = MessageCode;

cmd.Parameters.Add("@responsibility_id",OleDbType. VarChar).Value = ResponsibilityID;

cmd.Parameters.Add("@row_added_ts",OleDbType.Char) .Value = RowAddedTimeStamp;

cmd.Parameters.Add("@csi_logicalid",OleDbType.VarC har).Value = LogicalID;

cmd.Parameters.Add("@csi_component",OleDbType.VarC har).Value = Component;

cmd.Parameters.Add("@csi_task",OleDbType.VarChar). Value = Task;

cmd.Parameters.Add("@csi_referenceid",OleDbType.Va rChar).Value = ReferenceID;

cmd.Parameters.Add("@csi_confirmation",OleDbType.V arChar).Value = Confirmation;

cmd.Parameters.Add("@csi_authorizationid",OleDbTyp e.VarChar).Value = AuthorizationID;

cmd.Parameters.Add("@csi_creationdatetime",OleDbTy pe.VarChar).Value = CreationDateTime;

cmd.Parameters.Add("@csi_bodid",OleDbType.VarChar) .Value = BODID;

cmd.Parameters.Add("@csi_responsibility_id",OleDbT ype.VarChar).Value = CSIResponsibilityID;

cmd.Parameters.Add("@csi_portreference",OleDbType. VarChar).Value = PortReference;

cmd.Parameters.Add("@atch_set_id",OleDbType.VarCha r).Value = "";

cmd.Parameters.Add("@business_entity_id",OleDbType .VarChar).Value = BusinessEntityID;

cmd.Parameters.Add("@event_desc",OleDbType.VarChar ).Value = EventDescription;

cmd.Parameters.Add("@build_nbr",OleDbType.VarChar) .Value = BuildNumber;

cmd.Parameters.Add("@successful_cnt",OleDbType.Int eger).Value = SuccessActionCount;

cmd.Parameters.Add("@failed_cnt",OleDbType.Integer ).Value = FailuresActionCount;

cmd.Parameters.Add("@not_processed_cnt",OleDbType. Integer).Value = NotProcessedActionCount;

cmd.Parameters.Add("@corrected_cnt",OleDbType.Inte ger).Value = CorrectedActionCount;

cmd.CommandText = SqlStr;

cmd.Connection = m_Conn;

int IsSuccess = cmd.ExecuteNonQuery();





why does this doesnot work to me, it gives me an error of "should declare the variable @groupname"?



help..pls

Rgds,
Venkat.