C# NOTLARIM

On August 26, 2020 By semt20In C SHARP, DevexpressLeave a comment

Devexpress kullanımında gridview kullanırken setgridvalue kullanmak yerine datatableda gerekli değişiklikleri yaptıktan sonra gridccontrolun datasourceunu datatablea eşitlemek daha sorunsuz olur. Sebebi gridview count kullanırken bazı değerleri setgridvalueda atmamakta ama filtreleyince atmakta.

C# SQL GET LOGICALREF

On July 30, 2020 By semt20In C SHARP, LOGO ERP, LOGO OBJECTS, SqlLeave a comment

        public string GET_LOGICALREF(string TABLENAME, string LOGICALREF, string WHEREFIELDNAME, string WHEREDATA) {
            SqlDatabase sqlSERVICEDB;
            sqlSERVICEDB = new SqlDatabase(M.CONSTR_BMS);
            DataTable DATA = sqlSERVICEDB.ExecuteDataSet(new SqlCommand("SELECT TOP 1 " + LOGICALREF + " FROM " + TABLENAME + " WHERE " + WHEREFIELDNAME + "='" + WHEREDATA + "' ORDER BY LOGICALREF DESC")).Tables[0];
            if (DATA.Rows.Count == 0) {
                return "";
            }
            return DATA.Rows[0][0].ToString();
        }

C++ NATIVE DLL C#DA ÇALIŞTIRMAK İÇİN

On June 15, 2020 By semt20In C SHARP, visual studioLeave a comment

Önce indir Dependency Walker ve dll içinde aç

c# tarafında bu şekilde tanımla

  public Login() {
            InitializeComponent();
            XAPI_Client_digits();
            // XAPI_Adjunct_start();
            //XAPI_Adjunct_stop();
            //XAPI_Client_answer();
            //XAPI_Client_bdp_answer();
            //XAPI_Client_bdp_intrude();
            //XAPI_Client_bdp_register();
            // XAPI_Client_callb();
            //XAPI_Client_clear();
            //XAPI_Client_conference();
            //XAPI_Client_deflect();
            //XAPI_Client_digits();
            //XAPI_Client_hold();
            //XAPI_Client_mailbox();
            //XAPI_Client_newcall();
            //XAPI_Client_record_start();
            //XAPI_Client_record_stop();
            //XAPI_Client_resume();
            //XAPI_Client_retrieve();
            //XAPI_Client_start();
            //XAPI_Client_start_Thread();
            //XAPI_Client_stop();
            //XAPI_Client_suspend();
            //XAPI_Client_transfer();
            //XAPI_Client_transfer_undo();
            //XAPI_Cmdr_start();
            //XAPI_Cmdr_stop();
            //XAPI_Stack_initialize();
            XAPI_Client_digits();
            string TEST = "";
        }
        [DllImport("XapiDll.dll", CharSet = CharSet.Unicode)]
        //[DllImport("XapiDll.dll", CharSet = CharSet.Unicode,CallingConvention =CallingConvention.Cdecl)]
        public static extern void XAPI_Client_digits();
       // public static extern void XAPI_Adjunct_start();
       // public static extern void XAPI_Adjunct_stop();
        //public static extern void XAPI_Client_answer();
        //public static extern void XAPI_Client_bdp_answer();
        //public static extern void XAPI_Client_bdp_intrude();
       // public static extern void XAPI_Client_bdp_register();
        //public static extern void XAPI_Client_callb();
        //public static extern void XAPI_Client_clear();
        //public static extern void XAPI_Client_conference();
        //public static extern void XAPI_Client_deflect();
        //public static extern void XAPI_Client_digits();
        //public static extern void XAPI_Client_hold();
        //public static extern void XAPI_Client_mailbox();
        //public static extern void XAPI_Client_newcall();
        //public static extern void XAPI_Client_record_start();
        //public static extern void XAPI_Client_record_stop();
        //public static extern void XAPI_Client_resume();
        //public static extern void XAPI_Client_retrieve();
        //public static extern void XAPI_Client_start();
        //public static extern void XAPI_Client_start_Thread();
        //public static extern void XAPI_Client_stop();
        //public static extern void XAPI_Client_suspend();
        //public static extern void XAPI_Client_transfer();
        //public static extern void XAPI_Client_transfer_undo();
        //public static extern void XAPI_Cmdr_start();
        //public static extern void XAPI_Cmdr_stop();
        //public static extern void XAPI_Stack_initialize();
      //  public static extern void XAPI_Stack_release();

C# SQL TABLE SCRIPT GENERATOR

On November 14, 2019November 21, 2019 By semt20In C SHARP, Devexpress, Sql, visual studioLeave a comment

using System;

namespace SQL_HELPER_APP
{
    public partial class SQLTABLESCRIPT : DevExpress.XtraEditors.XtraForm
    {
        public SQLTABLESCRIPT()
        {
            InitializeComponent();
        }
        private void simpleButton1_Click(object sender, EventArgs e)
        {
            memoEdit1.Text = "";
            string IMAGEFIELD = "0";
            memoEdit1.Text += "CREATE TABLE [dbo].[" + textEdit1.Text + "](" + Environment.NewLine;
            memoEdit1.Text += "[" + textEdit2.Text + "] [INT] IDENTITY(1,1) NOT NULL," + Environment.NewLine;
            for (int i = 0; i < gridView1.RowCount; i++)
            {
                string NAME = "[" + gridView1.GetRowCellValue(i, "NAME").ToString() + "]";
                string TYPE = "[" + gridView1.GetRowCellValue(i, "TYPE").ToString() + "]";
                string LENGTH = gridView1.GetRowCellValue(i, "LENGTH").ToString();
                string ISNULL = gridView1.GetRowCellValue(i, "ISNULL").ToString();
                ISNULL = ISNULL == "True" ? " NULL," : ",";
                if (IMAGEFIELD == "0")
                {
                    IMAGEFIELD = TYPE == "[Image]" ? "1" : "0";
                }
                switch (TYPE)
                {
                    case "[Datetimeoffset]": TYPE = "[DATETIMEOFFSET](7)"; break;
                    case "[Decimal]": TYPE = "[DECIMAL](18, 0)"; break;
                    case "[Nchar]": TYPE = "[NCHAR](10)"; break;
                    case "[Numeric]": TYPE = "[NUMERIC](18, 0)"; break;
                    case "[Nvarchar]": TYPE = "[NVARCHAR](50)"; break;
                    case "[Nvarchar(max)]": TYPE = "[NVARCHAR](MAX)"; break;
                    case "[Time]": TYPE = "[TIME](7)"; break;
                    case "[Varbinary]": TYPE = "[VARBINARY](50)"; break;
                    case "[Varbinary(max)]": TYPE = "[VARBINARY](MAX)"; break;
                    case "[Varchar]": TYPE = "[VARCHAR](255)"; break;
                    case "[Varchar(max)]": TYPE = "[VARCHAR](MAX)"; break;
                    default: break;
                }
                memoEdit1.Text += NAME + " " + TYPE + ISNULL;
                memoEdit1.Text += Environment.NewLine;
            }
            memoEdit1.Text += "CONSTRAINT [PK_" + textEdit1.Text + "] PRIMARY KEY CLUSTERED " + Environment.NewLine;
            memoEdit1.Text += "(" + Environment.NewLine;
            memoEdit1.Text += "[" + textEdit2.Text + "] ASC" + Environment.NewLine;
            memoEdit1.Text += ")WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]" + Environment.NewLine;
            memoEdit1.Text += IMAGEFIELD == "1" ? ") ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]" + Environment.NewLine : ") ON [PRIMARY] " + Environment.NewLine;
        }
        private void repositoryItemButtonEdit1_Click(object sender, EventArgs e)
        {
            gridView1.DeleteSelectedRows();
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SQL_HELPER_APP
{
    public class FIELDS
    {
        public string NAME { get; set; } = string.Empty;
        public string TYPE { get; set; } = "Varchar";
        public string LENGTH { get; set; } = "255";
        public bool ISNULL { get; set; } =true;
    }
}

       this.repositoryItemComboBoxTYPE.Items.AddRange(new object[] {
            "Bigint",
            "Binary",
            "Bit",
            "Char",
            "Cursor",
            "Date",
            "Datetime",
            "Datetime2",
            "Datetimeoffset",
            "Decimal",
            "Float",
            "Image",
            "Int",
            "Money",
            "Nchar",
            "Ntext",
            "Numeric",
            "Nvarchar",
            "Nvarchar(max)",
            "Real",
            "Smalldatetime",
            "Smallint",
            "Smallmoney",
            "Sql_variant",
            "Text",
            "Time",
            "Timestamp",
            "Tinyint",
            "Uniqueidentifier",
            "Varbinary",
            "Varbinary(max)",
            "Varchar",
            "Varchar(max)",
            "Xml"});
            this.repositoryItemComboBoxTYPE.Name = "repositoryItemComboBoxTYPE";

DEVEXPRESS RUNTIME HIDDEN EXPORT TO XLS

On November 11, 2019August 20, 2021 By semt20In C SHARPLeave a comment

private void simpleButton1_Click_1(object sender, EventArgs e)
        {
            //XLWorkbook wb = new XLWorkbook();
            //DataTable dt = BMS_DLL.SQL.SELECT("select * from BMS_MS_RECORDS");
            //wb.Worksheets.Add(dt, "WorksheetName");
            //wb.SaveAs(@"HelloWorld.xls");
            DataTableToExcel(BMS_DLL.SQL.SELECT("select * from BMS_MS_RECORDS"), "HelloWorld.xls");




        }
        public void DataTableToExcel(DataTable dt, string PATH)
        {
            GridControl GC = new GridControl();
            GridView GV = new GridView();
            GC.ViewCollection.Add(GV);
            GC.MainView = GV;
            GC.BindingContext = new BindingContext();
            GC.DataSource = dt;
            GV.PopulateColumns();
            GC.ForceInitialize();
            GV.ExportToXls(PATH);
        }

C# BIR FORMDAN AÇIK BAŞKA BIR FORMA BILGI AKTARIMI

On October 16, 2019August 20, 2021 By semt20In C SHARPLeave a comment

ÖNCELİKLE AKTARILACAK OLAN FORMDAKI CONTROLLERIN MODIFY PRIVATEDEN PUBLICE DEGISTIRILMELI.

public partial class MAINFORM : Form
    {
         SECONDFORM SF;
     }

      public MAINFORM()
{

}

        private void simpleButton1_Click(object sender, EventArgs e)
        {

            gb_UC_CONTAINER.Controls.Clear();
            UCP = new SICILLERHAREKET(M, CFG, C);
            gb_UC_CONTAINER.Controls.Add(UCP);
            UCP.Dock = DockStyle.Fill;
        }



 private void sle_PROJELER_EditValueChanged(object sender, EventArgs e)
{
  SF.te_PROJE.Text = (string)sle_PROJELER.EditValue;
}

C# ile SQLE Resim Kaydetmek

On September 13, 2019December 19, 2019 By semt20In C SHARPLeave a comment

resim kaydetmek için
SQL TURU VARBINARY(MAX)

c#
BM_PERSON.IMAGEDATA = DATA TURU BYTE[]
pe_GB1_IMAGE = PICTUREEDIT DEVEXPRESS COMPONENT
set = PI.BM_PERSON.IMAGEDATA = (byte[])pe_GB1_IMAGE.EditValue;
get = pe_GB1_IMAGE.EditValue = PI.BM_PERSON.IMAGEDATA;

SQL KAYDEDERKEN DIKKAT
if (B.IMAGEDATA != null)
com.Parameters.AddWithValue(“@IMAGEDATA”, B.IMAGEDATA);
else
com.Parameters.AddWithValue(“@IMAGEDATA”, System.Data.SqlTypes.SqlBinary.Null);

C# SQL SERVER IN ADAPTASYONU

On September 12, 2019August 20, 2021 By semt20In C SHARPLeave a comment

                    string PERSONREFS = string.Empty;
                    if (F.PERSONREFS != null && F.PERSONREFS.Length > 0)
                        for (int i = 0; i < F.PERSONREFS.Length; i++)
                        {
                            PERSONREFS += "'" + F.PERSONREFS[i] + "'";
                            if (i != F.PERSONREFS.Length - 1)
                                PERSONREFS += ", ";
                        }
                    else
                        PERSONREFS = "-1";

C# WCF (SVC) WEB SERVISLERINI IISDE CALISTIRMAK ICIN YAPILMASI GEREKENLER

On July 26, 2019December 19, 2019 By semt20In C SHARPLeave a comment

WINDOWS 10: TURN WINDOWS FEATURE ON OFF
.NET FRAMEWORK 4.7 ADVANCED SETTINGS- WCF SERVICES-HTTP ACTIVATION SEC VE OK DE

SONRA WEBCONFIGDE.

YAP:

C# INSERT COMMAND WITH SCOPE IDENTITY

On July 2, 2019August 20, 2021 By semt20In C SHARPLeave a comment

        private void CREATE_NEW_LIST()
        {
            SqlCommand COM = null;
            SqlTransaction TRANSACTION = null;
            SqlConnection CON = new SqlConnection(CONSTR_LG);
            if (CON.State != ConnectionState.Open)
                CON.Open();
            TRANSACTION = CON.BeginTransaction();




            COM = INSERT_INTO_BM_PNTAWARDFICHE(int.Parse(le_CAPIFIRM.EditValue.ToString()), int.Parse(textEditYIL.Text), int.Parse(comboBoxEditAY.Text));
            COM.Connection = CON;
            COM.Transaction = TRANSACTION;
             int LOGICALREF = int.Parse(COM.ExecuteScalar().ToString());
           // YUKARIDA EXECUTE SCALAR OLDUGU ICIN GEREK YOK BUNA: COM.ExecuteNonQuery();

            COM = UTILITIES.DELETE_PNTAWARDLINES(int.Parse(le_CAPIFIRM.EditValue.ToString()),  int.Parse(textEditYIL.Text), int.Parse(comboBoxEditAY.Text));
            COM.Connection = CON;
            COM.Transaction = TRANSACTION;
            COM.ExecuteNonQuery();




   TRANSACTION.Commit();
          }

        public static SqlCommand INSERT_INTO_BM_PNTAWARDFICHE(int FIRMNR, int YEAR, int MONTH)
        {
            try
            {
                return new SqlCommand("INSERT INTO BM_PNTAWARDFICHE(FIRMNR, YEAR, MONTH, FOOD, TRANSPORTATION, OBIM, KASA, FOOD_B, TRANSPORTATION_B, OBIM_B, KASA_B, CREATEDBY, CREATEDDATE, MODIFIEDBY, MODIFIEDDATE) VALUES ('" + FIRMNR + "', " + YEAR + ", " + MONTH + ", 0, 0,0, 0, 0, 0, 0, 0, 99, '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "', 0, 0) select  SCOPE_IDENTITY() ");
            }
            catch { return null; }
        }

        public static string CONSTR_LG = string.Format("Data Source={0};Initial Catalog={1};User Id={2};Password={3};MultipleActiveResultSets=True;", BMS_DLL.CFGICERIK.LGDBSERVER, BMS_DLL.CFGICERIK.LGDBDATABASE, BMS_DLL.CFGICERIK.LGDBUSERNAME, BMS_DLL.CFGICERIK.LGDBPASSWORD);

Blog of Sem

Tag: c#