C#

karthareket.kk_no

//C# Form

private void KKTahsilat()
        {
            sql = "SELECT bnisim_ad, kk_adi, cr_adi, DATE_FORMAT(kk_odemetarih,'%d.%m.%Y') AS islemtarih, DATE_FORMAT(bh_tarih,'%d.%m.%Y') AS vadetarih, bh_tutar,bh_tutarbirim, kk_taksitsay, bh_slipdetay as taksit, 
bh_tur, kk_belgeno, kk_tutar FROM tbodeme2017,tbkasa2017, (tbbankahareket2017, tbkredikart2017) LEFT JOIN tbbankakredikartiplan ON (kk_planid=bkp_id) 
LEFT JOIN tbbankakredikartiplantaksit ON (bkpt_planid=bkp_id AND bkpt_taksit=bh_slipdetay), tbcari,tbbankaisim,tbbanka,tbbankakredikarti 
where od_izahat=kk_izahat AND od_satisno=bh_islemno AND ka_islemad=kk_izahat AND ka_stno=bh_islemno AND tbkredikart2017.kk_no=bh_islemno AND cr_no=tbkredikart2017.kk_musno AND bn_bankano = bnisim_id AND bkredikart2017.kk_bankano = bn_id AND tbkredikart2017.kk_posid = tbbankakredikarti.kk_no AND bh_tur LIKE 'Kredi Kartı Tahsilat' ";

            response = veri.exportDataXML(login, sql);

            XmlDocument xmlcari = new XmlDocument();
            xmlcari.LoadXml(response);
            XmlNodeList isim = xmlcari.SelectNodes("table/rows/row");

            kkTahsilat = 0;
            foreach (XmlNode node in isim)
            {
                kkTahsilat += XmlConvert.ToDouble(node.ChildNodes[5].InnerText);
            }

        }


//Service Reference
namespace Livella_Cek.webservis {
    
    
    [System.CodeDom.Compiler.GeneratedCodeAttribute("System.ServiceModel", "4.0.0.0")]
    [System.ServiceModel.ServiceContractAttribute(Namespace="urn:WebticariService", ConfigurationName="webservis.WebticariServicePortType")]
    public interface WebticariServicePortType {
[System.ServiceModel.OperationContractAttribute(Action="urn:WebticariService#exportDataXML", ReplyAction="*")]
        [System.ServiceModel.XmlSerializerFormatAttribute(Style=System.ServiceModel.OperationFormatStyle.Rpc, SupportFaults=true, Use=System.ServiceModel.OperationFormatUse.Encoded)]
        [return: System.ServiceModel.MessageParameterAttribute(Name="return")]
        string exportDataXML(string token, string query);
}
public string exportDataXML(string token, string query) {
            return base.Channel.exportDataXML(token, query);
        }
}

Hi good day to all, I'am using a panel that have scrollbar in vertical. I want to display a new value of scroll bar when i end scrolling and I use this code

        private void panel1_Scroll(object sender, ScrollEventArgs e)
        {
            if (e.Type == ScrollEventType.EndScroll)
            {
                MessageBox.Show(e.NewValue.ToString());
            }

        }
but it does not work, but when i use a single vertical scroll bar and use it this code :
        
     private void hScrollBar1_Scroll(object sender, ScrollEventArgs e)
        {
            if (e.Type == ScrollEventType.EndScroll)
            {
                MessageBox.Show(e.NewValue.ToString());
            }
        }
it will work, I thought i can use the same code but it fails, Is their any way to do that?

Thank you in advance

using(MemoryStream mstream = new MemoryStream(File.ReadAllBytes(filepath)))
{
    if (useDecryption)
    {
        mstream = decryptor(mstream);
        mstream.Position = 0;
    }
    
    if (useDecompression)
    {
        mstream = decompressor(mstream);
        mstream.Position = 0;
    }

    result = (T) dcs.ReadObject(mstream)   
}

MemoryStream mstream = new MemoryStream(File.ReadAllBytes(filepath));

if (useDecryption)
{
    mstream = decryptor(mstream);
    mstream.Position = 0;
}

if (useDecompression)
{
    mstream = decompressor(mstream);
    mstream.Position = 0;
}

result = (T) dcs.ReadObject(mstream);