C#

private void VtfGraphicalViewMode(Page page, float x, float y)
       {
           AddCaptionAndRectangle(page, "Vertical Forces Graph", x, y, CHAR_WIDTH, CHAR_HEIGHT);

           // Create a chart
           ceTe.DynamicPDF.PageElements.Charting.Chart chart =
               new ceTe.DynamicPDF.PageElements.Charting.Chart(x + 10, y + 25, CHAR_WIDTH - 25, CHAR_HEIGHT - 25, ceTe.DynamicPDF.Font.Helvetica, 10, RgbColor.Black);

           // Create a plot area
           ceTe.DynamicPDF.PageElements.Charting.PlotArea plotArea = chart.PrimaryPlotArea;

           // Create header title and add it to the chart
           ceTe.DynamicPDF.PageElements.Charting.Title headerTitle =
               new ceTe.DynamicPDF.PageElements.Charting.Title("Vertical Forces (VTF)");
           chart.HeaderTitles.Add(headerTitle);

           if (vtfGraph.Count > 0)
           {
               ceTe.DynamicPDF.PageElements.Charting.Series.IndexedLineSeries leftVTFLineSeries =
                   new ceTe.DynamicPDF.PageElements.Charting.Series.IndexedLineSeries("Left VTF");
               leftVTFLineSeries.Values.Add(vtfGraph.GetLeftVTF(0, 100));

               ceTe.DynamicPDF.PageElements.Charting.Series.IndexedLineSeries rightVTFLineSeries =
                   new ceTe.DynamicPDF.PageElements.Charting.Series.IndexedLineSeries("Right VTF");
               rightVTFLineSeries.Values.Add(vtfGraph.GetRightVTF(0, 100));
               ceTe.DynamicPDF.PageElements.Charting.Series.IndexedLineSeries totalVTFLineSeries =
                   new ceTe.DynamicPDF.PageElements.Charting.Series.IndexedLineSeries("Total VTF");
               totalVTFLineSeries.Values.Add(vtfGraph.GetTotalVTF(0, 100));

               // Add indexed line series to the plot area
               plotArea.Series.Add(leftVTFLineSeries);
               plotArea.Series.Add(rightVTFLineSeries);
               plotArea.Series.Add(totalVTFLineSeries);
           }
           page.Elements.Add(chart);
       }

      public void CheckItem( string itemcode)
        {
            string constring = @"Data Source=.;Initial Catalog=pos;User id = sa;password=123";
            SqlCommand objCmd = new SqlCommand();
            objCmd.Parameters.Clear();
            using (SqlConnection objCnn = new SqlConnection(constring))
            {
                objCnn.Open();
                using (objCmd = objCnn.CreateCommand())
                {
                    objCmd.CommandType = CommandType.Text;
                    objCmd.CommandText = "SELECT  * FROM Items where Item_Code=@Item_Code";
                    objCmd.Parameters.Add(new SqlParameter("@Item_Code", itemcode));
                  
                    SqlDataReader myreader = objCmd.ExecuteReader();
                    DataTable dt = new DataTable();
                    dt.Load(myreader);
                     decimal sumprice=0;
                    if (dt.Rows.Count <= 0)
                     
// here i want to add new item into datatable , after that bind the new item with items that i added before 

 
                    dt = objDT.NewRow();
                    dt.Columns.Add("", typeof(decimal));
                  
                    dataGridView1.DataSource = dt;

                   
 

                }
            }
        }

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