Category: C SHARP

VISUAL STUDIO C# DLL CLASS YORUM EKLEMEK

On By semt20In C SHARPLeave a comment
Önce dll projesinde debug project propertiesde build ekranında XML documantion filei tikle
ve methodların üzeirne bunu yazınca otomatik tanımlanır ///
ve gerekeni içine yaz
Ör:
 

burdaki para ayrı satır anlamındadır

      ///




        /// Aciklama: Önce ana projeye add devitem Progress Indicator ekle adını PROGRESSFORM yap
        /// Ornek Kod:BMS_DLL.DX.SPLASHSCREENBASLA(typeof(PROGRESSFORM), this, "test");
        ///

        public static void SPLASHSCREENBASLA(Type _PROGRESSFORM, Form _this, string _NEYAPILIYOR)
        {
            try
            {
                SplashScreenManager.ShowForm(_this, _PROGRESSFORM , true, true, false);
                SplashScreenManager.Default.SetWaitFormCaption(_NEYAPILIYOR);
                SplashScreenManager.Default.SetWaitFormDescription("");
            }
            catch { }
        }

VISUAL STUDIO C# SQL SERVER CONNECTION HELPER

On By semt20In C SHARPLeave a comment 
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
using DevExpress.XtraGrid;
using DevExpress.XtraGrid.Views.Grid;




namespace BMS_PDKS
{
    public class SQLHELPER
    {
        string baglanticumlesi = string.Format("Server={0}; Database={1}; User Id ={2};Password ={3}", CFG_TEMPLATE.CONFIG.LGDBSERVER, CFG_TEMPLATE.CONFIG.LGDBDATABASE, CFG_TEMPLATE.CONFIG.LGDBUSERNAME, CFG_TEMPLATE.CONFIG.LGDBPASSWORD);
        SqlConnection con;
        SqlDataAdapter adtr;
        public SqlConnection baglanti()
        {
            con = new SqlConnection(baglanticumlesi);
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
            }
            return con;
        }
        //public DataTable veri_getirme(string sqlcumle, DevExpress.XtraGrid.GridControl dtgrd)
        public DataTable GET_B_CAPIFIRM(GridControl dtgrdc,GridView dtgrdv)
        {
            DataTable dt = new DataTable();
            dtgrdv.Columns.Clear();
            try
            {
                using (adtr = new SqlDataAdapter("select * from B_CAPIFIRM", baglanti()))
                { adtr.Fill(dt); dtgrdc.DataSource = dt; }
            }
            catch (System.Exception ex) { MessageBox.Show(ex.Message); }
            return dt;
        }
        public DataTable GET_B_CAPIUSER(GridControl dtgrdc, GridView dtgrdv)
        {
            DataTable dt = new DataTable();
            dtgrdv.Columns.Clear();
            try
            {
                using (adtr = new SqlDataAdapter("select * from B_CAPIUSER", baglanti()))
                { adtr.Fill(dt); dtgrdc.DataSource = dt; }
            }
            catch (System.Exception ex) { MessageBox.Show(ex.Message); }
            return dt;
        }

    }
}

--


DAHA SONRA ANA FORMDA DEVEXPRESS GRIDVIEW YARAT VE ŞU ŞEKİLDE ÇAĞIR:


        SQLHELPER sqlhelper = new SQLHELPER();


        private void button1_Click(object sender, EventArgs e)
        {
            sqlhelper.GET_B_CAPIFIRM( gridControl1,gridView1);
        }
        private void button2_Click(object sender, EventArgs e)
        {
            sqlhelper.GET_B_CAPIUSER(gridControl1, gridView1);
        }

C# SQL E TARIH AKTARIM UYGUN FORMAT

On By semt20In C SHARP, SqlLeave a comment 
DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")




devexpress datetime component automove to next için
masktype 2 tane var ikisinde datetimeadvancingcaret yap

        public Form1()
        {
            InitializeComponent();
            Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;












ercanın kodlarda
            CultureInfo tr = new CultureInfo("tr-TR");

            Thread.CurrentThread.CurrentCulture = tr;

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

C# ASPXGRIDVIEW GET TOTAL SUMMARY

On By semt20In C SHARP, DevexpressLeave a comment 
protected void Buttonhepsiniode_Click(object sender, EventArgs e)
{
 
    //for (int i = 0; i < ASPxGridView2.VisibleRowCount; i++)
    //{
    //    var items = ASPxGridView2.GetRowValues(i, new string[] { "FISNO", "TL_BORC" }) as object[];
    //    // ASPxListBox1.Items.Add(rowValues[0].ToString());
    //    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CarringtonWebConnectionString1"].ConnectionString);
    //    con.Open();
    //    SqlCommand cmd = new SqlCommand("update ACIKHESAP set ODEME_DURUMU=2, ODENEN_TUTAR=" + items[1].ToString() + " where ID=" + items[0].ToString(), con);
    //    cmd.ExecuteNonQuery();
    //    Labeltesekkurler.Visible = true;
    //}
    Decimal SMTUTAR = Convert.ToDecimal(ASPxGridView2.GetTotalSummaryValue(ASPxGridView2.TotalSummary["TL_BORC"]));
    Global.TUTAR = null;
    Global.TUTAR = SMTUTAR.ToString();
    Server.Transfer("payment.aspx");
}

C# DEVEXPRESS ASPXGRIDVIEW SELECTED ROWS TOTAL

On By semt20In C SHARP, DevexpressLeave a comment 
protected void Button1_Click(object sender, EventArgs e)
{
    //List SelectedDebts = grid.GetSelectedFieldValues(new string[] { "FISNO", "TL_BORC" });
    //foreach (object debts in SelectedDebts)
    //{
    //    IList items = debts as IList;
    //    if (items == null) return;
    //    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CarringtonWebConnectionString1"].ConnectionString);
    //    con.Open();
    //    SqlCommand cmd = new SqlCommand("update ACIKHESAP set ODEME_DURUMU=1, ODENEN_TUTAR=" + items[1].ToString() + " where ID=" + items[0].ToString(), con);
    //    cmd.ExecuteNonQuery();
    //    Labeltesekkurler.Visible = true;
    //}
 
 
    //List SelectedDebts = grid.GetSelectedFieldValues(new string[] { "FISNO", "TL_BORC" });
    Decimal selectedTUTAR = 0;
    foreach (object value in ASPxGridView2.GetSelectedFieldValues("TL_BORC"))
    {
        {
            selectedTUTAR += Convert.ToDecimal(value);
        }
 
    }
 
    Global.TUTAR = null;
    Global.TUTAR = selectedTUTAR.ToString();
    Server.Transfer("payment.aspx");
 
}

c# devexpress windows form skin

On By semt20In C SHARP, DevexpressLeave a comment
new c# windows form NOT DEVEXPRESS

 

add reference devexpress.bonusskins
devexpres.utils
devexpress.utils ui

DELETE FORM1 AND ADD DEVEXPRESS ITEM FORM

PROGRAM.CS :

 

            DevExpress.UserSkins.BonusSkins.Register();
            DevExpress.LookAndFeel.UserLookAndFeel.Default.SetSkinStyle("McSkin");
            Application.EnableVisualStyles();
            Application.SetCompatibleTextRenderingDefault(false);
            Application.Run(new Form1());