osman hömek / not defteri

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using ESRI.ArcGIS.ADF.Web.DataSources;

namespace ArcGisFilter
{
public class QueryFilter
{
private int m_Resource_Index;
private ESRI.ArcGIS.ADF.Web.UI.WebControls.Map m_Map;
private string m_Field_List;
private string m_Where_Condition;
private string m_Layer_Name;

public int Resource_Index
{
get { return Resource_Index; }
set { m_Resource_Index = value; }
}

public ESRI.ArcGIS.ADF.Web.UI.WebControls.Map Map
{
get { return Map; }
set { m_Map = value; }
}

public string Field_List
{
get { return Field_List; }
set { m_Field_List = value; }
}

public string Where_Condition
{
get { return Where_Condition; }
set { m_Where_Condition = value; }
}

public string Layer_Name
{
get { return Layer_Name; }
set { m_Layer_Name = value; }
}

public System.Data.DataTable Run_Query()
{
IMapFunctionality mf = (IMapFunctionality)m_Map.GetFunctionality(m_Resource_Index);
IGISResource gisresource = mf.Resource;
IQueryFunctionality qfunc = (IQueryFunctionality)gisresource.CreateFunctionality(typeof(IQueryFunctionality), null);

ESRI.ArcGIS.ADF.StringCollection strcollection = new ESRI.ArcGIS.ADF.StringCollection(m_Field_List, ‘,’);
ESRI.ArcGIS.ADF.Web.QueryFilter qfilter = new ESRI.ArcGIS.ADF.Web.QueryFilter();
qfilter.SubFields = strcollection;
qfilter.WhereClause = m_Where_Condition;

string[] lids;
string[] lnames;
qfunc.GetQueryableLayers(null, out lids, out lnames);

int layer_index = 0;
for (int i = 0; i < lnames.Length; i++)
{
if (lnames[i] == m_Layer_Name)
{
layer_index = i;
break;
}
}
System.Data.DataTable datatable = qfunc.Query(null, lids[layer_index], qfilter);
return datatable;
}
}
}

ArcGisFilter.QueryFilter qf = new ArcGisFilter.QueryFilter();
qf.Field_List = “AD, IL_KODU”;
qf.Layer_Name = “SDE.tr_sehir”;
qf.Where_Condition = ” AD = ‘TRABZON’”;
qf.Map = Map1;
qf.Resource_Index = 0;

GridView2.DataSource = qf.Run_Query();
GridView2.DataBind();

http://econym.googlepages.com/index.htm

C:\Inetpub\wwwroot\aspnet_client\ESRI\WebADF\JavaScript

dizini altındaki JS leri görünce insanın iştahı kabarıyor. Kurcalamakta büyük fayda var!

    public void mapSourceTrans(int layerIndex, bool status)
{
IMapResource mapresource_trans = MapResourceManager1.GetResource(layerIndex);
mapresource_trans.DisplaySettings.Visible = true;
if(status)
mapresource_trans.DisplaySettings.Transparency = 0.0F; //actik
else
mapresource_trans.DisplaySettings.Transparency = 100.0F; //kapattik
}

transparent değeri 100 ise layer görünmez olur!

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

IMP kullanici_adi/parola@SSID file=c:\yedek.dmp fromuser=from_user_name touser=to_user_name

bu komut direkt komut satırında (run command/cmd) satırından çalıştırılmalıdır

buradaki [select_sql] cümleciği ana sql cümleciğidir

içerisinde tüm where ve order işlenmiş haldedir

select * from
(select a.*, ROWNUM RNUM from ([select_sql]) a where ROWNUM<=maxRowIndex)
where
RNUM>=minRowIndex

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!

create or replace
FUNCTION onh_udf(geleind in number)
return varchar2
is
retval varchar2(500);
cursor c1 is select AD FROM tabloX WHERE tabloID=gelenid;
begin
retval := ”;

FOR current_rec in c1
LOOP
retval := retval || ‘,’ || current_rec.ad;
END LOOP;

return retval;
end onh_udf;

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