private void gridView1_PopupMenuShowing(object sender, DevExpress.XtraGrid.Views.Grid.PopupMenuShowingEventArgs e)
{
if (e.MenuType == GridMenuType.Column)
{
GridViewColumnMenu menu = e.Menu as GridViewColumnMenu;
if (menu.Column != null)
{
var myMenu = new DXMenuCheckItem("Sola - Kolon Sabitle/Geri Al", menu.Column.Fixed == FixedStyle.Left, default, new EventHandler(FreezeUnfreezeColumnLeft_Click));
myMenu.Image = global::MYAPP.Properties.Resources.Left; //LEFT ARROW ICON FOR myMenu.Image = Left.png
myMenu.BeginGroup = true;
myMenu.Enabled = true;
myMenu.Tag = menu.Column;
e.Menu.Items.Add(myMenu);
var myMenu2 = new DXMenuCheckItem("Sağa - Kolon Sabitle/Geri Al", menu.Column.Fixed == FixedStyle.Right, default, new EventHandler(FreezeUnfreezeColumnRight_Click));
myMenu2.Image = global::MYAPP.Properties.Resources.Right; //RIGHT ARROW ICON FOR myMenu2.Image = Right.png
myMenu2.BeginGroup = false;
myMenu2.Enabled = true;
myMenu2.Tag = menu.Column;
e.Menu.Items.Add(myMenu2);
}
}
}
private void FreezeUnfreezeColumnLeft_Click(object sender, EventArgs e)
{
DXMenuCheckItem item = sender as DXMenuCheckItem;
GridColumn info = (GridColumn)item.Tag;
if (info is null)
return;
if (info.Fixed == FixedStyle.Left)
{
info.Fixed = FixedStyle.None;
}
else
{
info.Fixed = FixedStyle.Left;
}
}
private void FreezeUnfreezeColumnRight_Click(object sender, EventArgs e)
{
DXMenuCheckItem item = sender as DXMenuCheckItem;
GridColumn info = (GridColumn)item.Tag;
if (info is null)
return;
if (info.Fixed == FixedStyle.Right)
{
info.Fixed = FixedStyle.None;
}
else
{
info.Fixed = FixedStyle.Right;
}
}
Tag: image
C# ile SQLE Resim Kaydetmek
resim kaydetmek için
SQL TURU VARBINARY(MAX)
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);