static int LineNumber([System.Runtime.CompilerServices.CallerLineNumber] int lineNumber = 0)
{
MessageBox.Show(lineNumber.ToString());
return lineNumber;
}
Category: C SHARP
C# TXT DOSYASINDAN OKUMAK VE YAZMAK
private void dbconnect_yukle()
{
try
{
StreamReader reader = new StreamReader("dbConnect.txt");
te_SERVER.Text = reader.ReadLine();
te_DATABASE.Text = reader.ReadLine();
te_USERNAME.Text = reader.ReadLine();
te_PASSWORD.Text = reader.ReadLine();
te_FOLDERPATH.Text = reader.ReadLine();
te_NAMESPACE.Text = reader.ReadLine();
reader.Close();
}
catch (Exception e)
{
MessageBox.Show("HATA:" + e.Message);
}
}
private void dbconnect_kaydet()
{
string[] lines = { te_SERVER.Text, te_DATABASE.Text, te_USERNAME.Text, te_PASSWORD.Text, te_FOLDERPATH.Text, te_NAMESPACE.Text };
using (StreamWriter outputFile = new StreamWriter("dbConnect.txt"))
{
foreach (string line in lines)
outputFile.WriteLine(line);
}
}
DEVEXPRESS GRIDVIEW REPORISTORY DELETE BUTTON
private void repositoryItemButtonEditSIL_Click(object sender, EventArgs e)
{
gridView1.DeleteSelectedRows();
}
gridcontrol must be editable
gridView1.DeleteRow(gridView1.FocusedRowHandle);
IMAGE TYPE DATABASE SAVE IMAGE AND LOAD IMAGE WITH C#
//LOAD
try { pe_BACKGROUND.Image = Image.FromStream(new MemoryStream(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "BACKGROUND") as byte[] ?? null)); } catch (Exception) { pe_BACKGROUND.Image = null; }
//SAVE
public byte[] imageToByteArray(System.Drawing.Image imageIn)
{
MemoryStream ms = new MemoryStream();
imageIn.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
return ms.ToArray();
}
USERS.BACKGROUND = imageToByteArray(pe_BACKGROUND.Image);
c# form açıksa tekrar açmasın focus yapsın
foreach (Form FORM in Application.OpenForms)
{
if (FORM.GetType() == typeof(FORM_USER_GROUPS))
{
FORM.BringToFront();
return;
}
}
FORM_USER_GROUPS F = new FORM_USER_GROUPS(CFG);
F.StartPosition = FormStartPosition.CenterScreen;
F.Show();
C# BAŞKA FORMDAN BİLGİ ALMAK
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
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
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
Ö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;
}
Blog of Sem 