1-) C# RMOS - gridview lookupedit ile il e göre ilçe veya ülkeye göre il seçme
kaynak : https://documentation.devexpress.com/WindowsForms/DevExpress.XtraGrid.Views.Base.ColumnView.ShownEditor.event
private void Form1_Load(object sender, EventArgs e)
{
// pdfViewer1.DocumentFilePath = "a.pdf";
gridControl1.DataSource = RHVeritabani.MyGetDataTable(@"select * from personel
join ilce on ilce.ilce_id =personel.personel_ilce_id
join il on ilce.ilce_il_id=il.il_id");
repositoryItemLookUpEdit1.DataSource = RHVeritabani.MyGetDataTable("select * from il");
repositoryItemLookUpEdit1.DisplayMember = "il_ad";
repositoryItemLookUpEdit1.ValueMember = "il_id";
repositoryItemLookUpEdit2.DataSource = RHVeritabani.MyGetDataTable("select * from ilce");
repositoryItemLookUpEdit2.DisplayMember = "ilce_ad";
repositoryItemLookUpEdit2.ValueMember = "ilce_id";
}
private void repositoryItemLookUpEdit1_EditValueChanged(object sender, EventArgs e)
{
this.gridView1.PostEditor();
this.gridView1.SetFocusedRowCellValue("ilce_ad", null);
this.gridView1.SetFocusedRowCellValue("ilce_id", null);
ad = (sender as LookUpEdit).EditValue.ToString(); // seçili item
}
string ad = "";
private void gridView1_ShownEditor(object sender, EventArgs e)
{
ColumnView view = (ColumnView)sender;
if (view.FocusedColumn.FieldName == "ilce_ad")
{
LookUpEdit editor = (LookUpEdit)view.ActiveEditor;
//string countryCode = Convert.ToString(view.GetFocusedRowCellValue("il_id"));
editor.Properties.DataSource = RHVeritabani.MyGetDataTable("select ilce_ad,ilce_id from ilce where ilce_il_id=" + ad);
}
}
------------------------------------table----------------------
CREATE TABLE [dbo].[il](
[il_id] [int] IDENTITY(1,1) NOT NULL,
[il_ad] [nvarchar](50) NULL,
CONSTRAINT [PK_iller] PRIMARY KEY CLUSTERED
(
[il_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
-----
CREATE TABLE [dbo].[ilce](
[ilce_id] [int] IDENTITY(1,1) NOT NULL,
[ilce_ad] [nvarchar](50) NULL,
[ilce_il_id] [int] NULL,
CONSTRAINT [PK_ilce] PRIMARY KEY CLUSTERED
(
[ilce_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
-------
CREATE TABLE [dbo].[personel](
[personel_id] [int] IDENTITY(1,1) NOT NULL,
[personel_ad] [nvarchar](50) NULL,
[personel_ilce_id] [int] NULL,
CONSTRAINT [PK_personel] PRIMARY KEY CLUSTERED
(
[personel_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO