Click here to Skip to main content
13,141,747 members (65,956 online)
   

C#

 
GeneralRe: Understanding the steps in creating a GUI project named DisplayQuotes in Visual Studios IDE, C# programming Pin
Luc Pattyn18-Aug-17 4:30
professionalLuc Pattyn18-Aug-17 4:30 
GeneralRe: Understanding the steps in creating a GUI project named DisplayQuotes in Visual Studios IDE, C# programming Pin
Member 1336452018-Aug-17 7:24
memberMember 1336452018-Aug-17 7:24 
GeneralRe: Understanding the steps in creating a GUI project named DisplayQuotes in Visual Studios IDE, C# programming Pin
Richard Deeming18-Aug-17 7:33
mvpRichard Deeming18-Aug-17 7:33 
QuestionXML MySql error Pin
Rıza Berkay Ayçelebi14-Aug-17 1:34
memberRıza Berkay Ayçelebi14-Aug-17 1:34 
C# codes is exist below.I am trying to query like in below the codes.I am creating queries via web service using xml.You can see below the codes
karthareket.kk_no
colum name when I run this codes visual studio give an error.You can see error below.May you help me?

error picture here

//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);
        }
}

AnswerRe: XML MySql error Pin
Richard MacCutchan14-Aug-17 6:04
protectorRichard MacCutchan14-Aug-17 6:04 
GeneralRe: XML MySql error Pin
Rıza Berkay Ayçelebi14-Aug-17 18:41
memberRıza Berkay Ayçelebi14-Aug-17 18:41 
GeneralRe: XML MySql error Pin
Richard MacCutchan14-Aug-17 21:29
protectorRichard MacCutchan14-Aug-17 21:29 
AnswerRe: XML MySql error Pin
Pete O'Hanlon15-Aug-17 0:24
protectorPete O'Hanlon15-Aug-17 0:24 
GeneralRe: XML MySql error Pin
jschell16-Aug-17 6:31
memberjschell16-Aug-17 6:31 
QuestionHow to create a virtual disk storage software in c # Pin
Nguyễn Mạnh Sơn13-Aug-17 4:24
memberNguyễn Mạnh Sơn13-Aug-17 4:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy |
Web03 | 2.8.170915.1 | Last Updated 20 Sep 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid