Category: visual studio

VS 2017 WINDOWS SERVICE PROJECT SETUP

On By semt20In visual studioLeave a comment
  1. Right click on the setup project in your Solution Explorer.
  2. Select View > Custom Actions. (In VS2008 it might be View > Editor > Custom Actions)
  3. Right-click on the Install action in the Custom Actions tree and select ‘Add Custom Action…’
  4. In the “Select Item in Project” dialog, select Application Folder and click OK.
  5. Click OK to select “Primary output from…” option. A new node should be created.
  6. Repeat steps 4 – 5 for commit, rollback and uninstall actions.

C# BAŞKA FORMDAN BİLGİ ALMAK

On By semt20In C SHARP, visual studioLeave a comment 
        private void SICILLIST()
        {
            using (SICILLERBORDRO siciller = new SICILLERBORDRO(lbl_FIRMNR.Text))
            {
                if (siciller.ShowDialog() == DialogResult.OK)
                {
                    be_SICILNO.EditValue = siciller.VALUES[0].ToString();
                    be_ADSOYAD.EditValue = siciller.VALUES[1].ToString();
                }
            }
        }


        private void be_SICILNO_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            SICILLIST();
        }

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Linq;
using System.Threading.Tasks;
using System.Windows.Forms;
using DevExpress.XtraEditors;
using System.Data.SqlClient;

namespace BMS_INSAAT_MODULU.FORM
{
    public partial class SICILLERBORDRO : DevExpress.XtraEditors.XtraForm
    {
        public object[] VALUES { get; set; }

        public SICILLERBORDRO(string FIRMANR)
        {
            InitializeComponent();
            BMS_DLL.CFGGETSET.AYARLARIYUKLE(); 
            gridControl1.DataSource = BMS_DLL.SQL.SELECT2("select LOGICALREF ID, CODE SICILNO,NAME+' '+SURNAME ADSOYAD from BM_PERSON WHERE FIRMNR=" + FIRMANR, new SqlConnection(string.Format(@"Server={0}; Database={1}; User Id ={2};Password ={3}", BMS_DLL.CFGICERIK.BMSDBSERVER, BMS_DLL.CFGICERIK.BMSDBDATABASE, BMS_DLL.CFGICERIK.BMSDBUSERNAME, BMS_DLL.CFGICERIK.BMSDBPASSWORD)));
        }
        private object[] GET_SELECTED_ITEMS(int ROWHANLE)
        {
            try
            {
                return new object[] { ((string)this.gridView1.GetRowCellValue(ROWHANLE, "SICILNO")), ((string)this.gridView1.GetRowCellValue(ROWHANLE, "ADSOYAD")) };
            }
            catch
            {
                return null;
            }
        }

        private void gridView1_DoubleClick(object sender, EventArgs e)
        {
            this.VALUES = this.GET_SELECTED_ITEMS(this.gridView1.FocusedRowHandle);
            if (this.VALUES != null)
            {
                base.DialogResult = DialogResult.OK;
                base.Close();
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            BMS_DLL.DX.DXGRIDEXCELEKAYDET(gridView1, true);
        }
    }
}

C# SQL TABLE SCRIPT GENERATOR

On 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";

visual studio react native java jdk ayarla

On By semt20In TOOLS, visual studioLeave a comment
vscode file – preferencies – settings
workplace settings yaz java.home edit de

{
“java.home”:“C:\\Program Files\\AdoptOpenJDK\\jdk-11.0.3.7-hotspot”
}

sonra user settingse java.home yaz onada edit de

{
“editor.suggestSelection”: “first”,
“vsintellicode.modify.editor.suggestSelection”: “automaticallyOverrodeDefaultValue”,
“java.home”:“C:\\Program Files\\AdoptOpenJDK\\jdk-11.0.3.7-hotspot”
}

https://nodejs.org/en/download/ indir ve kur

cmd

npm install -g expo-cli

npm install -g react-native-cli

npm install -g create-react-native-app

react-native init projectNameHere

cd projectNameHere

react-native run-android

F:\masaustussd\react native\projectNameHere\android\ klasorunun icine local.properties isminde dosya YARAT ve icine sdk.dir = C:\\Users\\Pnp\\AppData\\Local\\Android\\sdk

devexpress splash screen

On By semt20In C SHARP, Devexpress, visual studioLeave a comment 
            SplashScreenManager.ShowForm(this, typeof(PROGRESSFORM), true, true, false);
            SplashScreenManager.Default.SetWaitFormCaption("LÜTFEN BEKLEYİN.");
            SplashScreenManager.Default.SetWaitFormDescription("");




------İŞLEMLER

            SplashScreenManager.CloseForm(false);
            MessageBox.Show("TAMAMLANDI", "", MessageBoxButtons.OK, MessageBoxIcon.Information);