osman hömek / not defteri

ASPxGridView gridAtanmisIsler_grid = sender as ASPxGridView;
DateTime start = startDate.Date;
DateTime finish = finishdate.Date;

BinaryOperator op1 = new BinaryOperator(”EKLENME_TARIHI”, start, BinaryOperatorType.GreaterOrEqual);
BinaryOperator op2 = new BinaryOperator(”EKLENME_TARIHI”, finish, BinaryOperatorType.LessOrEqual);
GroupOperator op = new GroupOperator(GroupOperatorType.And, new CriteriaOperator[] { op1, op2 });

gridAtanmisIsler_grid.FilterExpression = op.ToString();

<asp:DropDownList ID=”ActiveLayerName” runat=”server”></asp:DropDownList> 

Böyle bir nesneniz var diyelimBu nesne ESRI nesnesi de olabilir 

    var activeLayerClientId = “<%=ActiveLayerName.ClientID%>”;    var objActiveLayerName = document.getElementById(activeLayerClientId); 

objActiveLayerName değişkeni ile varolan dropdown nesnesi object türünden elinizde oluyor.

static void runsql(string sql, OracleConnection dbconn){

OracleTransaction tran;tran = dbconn.BeginTransaction();

OracleCommand cmd = new OracleCommand();cmd.Connection = dbconn;

{

long rows = cmd.ExecuteNonQuery();tran.Commit();

Console.WriteLine(“islem tamamlandi {0}”, rows + ” satir guncellendi”);}

catch (Exception etc){

Console.WriteLine(“islem tamamlanamadi”);Console.WriteLine(etc.Message.ToString());}

        string filename = @”c:\osman.py”;
System.Diagnostics.Process prc = new System.Diagnostics.Process();
prc.StartInfo.FileName = filename;
prc.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;
prc.Start();
prc.WaitForExit();
prc.Close();

        DataTable LayerDatatable = new DataTable();

DataColumn LayerDataColumn_ID = new DataColumn();
LayerDataColumn_ID.ColumnName = “ID”;
LayerDatatable.Columns.Add(LayerDataColumn_ID);

DataColumn LayerDataColumn_PARENTID = new DataColumn();
LayerDataColumn_PARENTID.ColumnName = “PARENTID”;
LayerDatatable.Columns.Add(LayerDataColumn_PARENTID);

DataColumn LayerDataColumn_LAYERNAME = new DataColumn();
LayerDataColumn_LAYERNAME.ColumnName = “LAYERNAME”;
LayerDatatable.Columns.Add(LayerDataColumn_LAYERNAME);

DataColumn LayerDataColumn_SEMBOLOGY = new DataColumn();
LayerDataColumn_SEMBOLOGY.ColumnName = “SEMBOLOGY”;
LayerDatatable.Columns.Add(LayerDataColumn_SEMBOLOGY);

DataRow LayerDataRow = LayerDatatable.NewRow();
LayerDataRow[”ID”] = “1″;
LayerDataRow[”PARENTID”] = “0″;
LayerDataRow[”LAYERNAME”] = “Harita”;
LayerDataRow[”SEMBOLOGY”] = “”;
LayerDatatable.Rows.Add(LayerDataRow);
LayerDatatable.AcceptChanges();

string[] LayerNames = GetQueryLayers();
int TreeNodeId = 1;
for (int i = 0; i < LayerNames.Length; i++)
{
TreeNodeId = i + 2;
LayerDataRow = LayerDatatable.NewRow();
LayerDataRow[”ID”] = TreeNodeId.ToString();
LayerDataRow[”PARENTID”] = “1″;
LayerDataRow[”LAYERNAME”] = LayerNames[i].ToString();
LayerDataRow[”SEMBOLOGY”] = “”;
LayerDatatable.Rows.Add(LayerDataRow);
LayerDatatable.AcceptChanges();
}

tree için hazırlanmış manual datatable yapısı

Page.RegisterStartupScript
Kod sayfanin en sonuna eklenir

private void Button1_Click(object sender, System.EventArgs e) {
string strScript=”";
if(!this.IsStartupScriptRegistered(”Baslangic”))
{
strScript = “<script language=’JavaScript’>”;
strScript += “alert(’alooo’)”;
strScript += “</script>”;
this.RegisterStartupScript(”startup_js”, strScript);
}
}

Page.RegisterClientScriptBlock metodu
Sayfanin basinda HTML etikietinin altina eklenir

private void addJsBlock()
{
string strScript=”";
strScript = “<script language=’JavaScript’>”;
strScript += “function mesaj(){”;
strScript += “alert(’alooo’)}”;
strScript += “</script>”;

// Script in daha önce eklenip eklenmedigi kontrolu
if(!this.IsClientScriptBlockRegistered(”ScriptBlok”))
{
this.RegisterClientScriptBlock(”ScriptBlok”, strScript);
// Fonksiyon un button uzerine eklenmesi
this.Button1.Attributes.Add(”onclick”, “javascript:mesaj();”);
}
}

private void Page_Load(object sender, System.EventArgs e)
{
this.addJsBlock();
}

System.Web.HttpContext.Current.Server.HtmlEncode(strValue);

Label Label1= (Label)Repeater1.Controls[Repeater1.Controls.Count - 1].FindControl(”Label1″);

Eğer asp.net 2.0 da gridview yerine repeater kullanılıyorsa, footer içerisinde koyulan Label1 isimli label a yukarıdaki kod aracılığı ile ulaşılmak zorundadır!

    public ArrayList distinctArray(string[] ARR)
{
int i, j, k;
System.Collections.ArrayList arr = new System.Collections.ArrayList();

for (k = 0; k < ARR.Length; k++)
{
arr.Add(ARR[k].ToString());
}

for (i = 0; i < arr.Count - 1; i++)
{
for (j = i + 1; j < arr.Count; j++)
{
if (arr[i].Equals(arr[j]))
{
arr.RemoveAt(j);
j = j - 1;
}
}
}
return arr;
}

hadi bu da lazım olur:

protected void Button1_Click(object sender, EventArgs e)
{
int k;

string[] ARR= {”1″,”1″,”3″,”4″,”5″,”3″,”4″,”5″,”6″,”3″,”4″,”5″,”7″,”3″,”3″,”3″};
System.Collections.ArrayList newArr = new System.Collections.ArrayList();

newArr = distinctArray(ARR);

for (k = 0; k < newArr.Count; k++)
{
Label1.Text += newArr[k].ToString();
}
}