Database

DECLARE @xml XML

SET @xml = '<DataSet>
  <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
      <xs:complexType>
        <xs:choice minOccurs="0" maxOccurs="unbounded">
          <xs:element name="T">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="ID" type="xs:int" minOccurs="0" />
                <xs:element name="NodeGroup" type="xs:string" minOccurs="0" />
                <xs:element name="NodeCount" type="xs:int" minOccurs="0" />
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:choice>
      </xs:complexType>
    </xs:element>
  </xs:schema>
  <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
    <NewDataSet>
      <T diffgr:id="T1" msdata:rowOrder="0">
        <ID>648</ID>
        <NodeGroup>Moustord</NodeGroup>
        <NodeCount>5</NodeCount>
      </T>
      <T diffgr:id="T2" msdata:rowOrder="1">
        <ID>646</ID>
        <NodeGroup>Shell</NodeGroup>
        <NodeCount>9</NodeCount>
      </T>
      <T diffgr:id="T3" msdata:rowOrder="2">
        <ID>647</ID>
        <NodeGroup>Suze</NodeGroup>
        <NodeCount>4</NodeCount>
      </T>
    </NewDataSet>
  </diffgr:diffgram>
</DataSet>'

 
;WITH XMLNAMESPACES( 
        'http://www.w3.org/2001/XMLSchema' AS ns,
        'urn:schemas-microsoft-com:xml-diffgram-v1' AS diffgr )
SELECT 
        fd.c.value('(ID/text())[1]', 'INT') 'a',
        fd.c.value('(NodeGroup/text())[1]', 'nvarchar(255)') 'b',
        fd.c.value('(NodeCount/text())[1]', 'INT') 'c'
        
FROM @xml.nodes('ns:DataSet/diffgr:diffgram/NewDataSet/T') fd(c)

sql_command.Parameters.AddWithValue("param_is_channel_created", MySqlDbType.Bit).Direction = ParameterDirection.Output;

sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
sql_command = new MySqlCommand("sp_delete_channel", sql_connection);
sql_command.CommandType = CommandType.StoredProcedure;
sql_connection.Open();
                                        
sql_command.Parameters.AddWithValue("param_channel_id", channel_id).MySqlDbType = MySqlDbType.Int32;
int result_row = sql_command.ExecuteNonQuery();

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_delete_channel`(IN param_channel_id int, IN param_volow_member_id int, OUT param_is_channel_created bit)
BEGIN
    DELETE FROM member_posts WHERE member_channel_id = param_channel_id;
    DELETE FROM member_channels WHERE member_channel_id = param_channel_id;
 
    IF NOT EXISTS (SELECT member_channel_id FROM member_channels WHERE volow_member_id = param_volow_member_id) THEN
    BEGIN
        UPDATE volow_members SET is_channel_created = FALSE;
 
        SET param_is_channel_created = FALSE;
    END;
    ELSE SET param_is_channel_created = TRUE;
    END IF;
END

Dan_K wrote:

I tried in my own way which works fine now. My BackgroundWorker thread creates a new thread and the created thread rather calls SqlConnection.Open(). When the cancel button is clicked, the BackgroundWorker thread aborts the thread opening the connection.

Dan_K wrote:

It works fine although I don't know if there could be any related problems.

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

select compatibility_level from sys.databases where name=db_name()

update outMortgageAsset
set        
	OpeningBalance  = z.OpeningBalance 
	, ClosingBalance  = z.ClosingBalance 
	, AvgBalance      = z.AvgBalance  
from outMortgageAsset b  
join       
	(
		select            
			GroupID      = a.GroupID
			, MonthDate      = k.MonthDate
			, OpeningBalance  = sum(k.OpeningBalance)
			, ClosingBalance  = sum(k.ClosingBalance)
			, AvgBalance      = sum(k.AvgBalance)   
		from EIRGroupAccountsToBeTotaled a   
		join          
		(           
			select                
				monthdate       = b.ForecastMonth
				, accountid       = b.AccountID
				, OpeningBalance  = isnull(b.CurrentBalance, 0.0) 
				, ClosingBalance  = isnull(c.CurrentBalance, 0.0)
				, AvgBalance      = (isnull(c.CurrentBalance, 0.0) 
										+ isnull(b.CurrentBalance, 0.0)) / 2.00000000    
			from EIRAccountBalancePerPeriod b    
			left join EIRAccountBalancePerPeriod c     
				on b.ForecastMonth = c.ForecastMonth - 1     
				and c.AccountID = b.AccountID     
			union all    
			select               
				ForecastMonth - 1 
				, AccountID
				, OpeningBalance  = 0
				, ClosingBalance  = isnull(CurrentBalance, 0.0) 
				, AvgBalance      = (CurrentBalance) / 2.00000000
			from EIRAccountBalancePerPeriod a    
			where ForecastMonth =               
				(
					select min(ForecastMonth) 
					from EIRAccountBalancePerPeriod z 
					where z.AccountID = a.AccountID
				)       
		) k
        on a.accountid = k.accountid
		group by a.GroupID, k.MonthDate
	) z 
    on b.GroupID = z.GroupID      
		and fm = z.MonthDate