Celiker BAHCECI

public class Ortak
{

public string scs(string c, string cs, string p1, string p2, string p3, string p4, string p5)
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[cs].ConnectionString))
{
using (SqlCommand comm = new SqlCommand(c, conn))
{
try
{
conn.Open();
if (p1 != null) comm.Parameters.Add("p1", SqlDbType.NVarChar).Value = p1;
if (p2 != null) comm.Parameters.Add("p2", SqlDbType.NVarChar).Value = p2;
if (p3 != null) comm.Parameters.Add("p3", SqlDbType.NVarChar).Value = p3;
if (p4 != null) comm.Parameters.Add("p4", SqlDbType.NVarChar).Value = p4;
if (p5 != null) comm.Parameters.Add("p5", SqlDbType.NVarChar).Value = p5;

if (c.ToLower().Contains("@p1") && p1 == null) comm.Parameters.Add("p1", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p2") && p2 == null) comm.Parameters.Add("p2", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p3") && p3 == null) comm.Parameters.Add("p3", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p4") && p4 == null) comm.Parameters.Add("p4", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p5") && p5 == null) comm.Parameters.Add("p5", SqlDbType.NVarChar).Value = "";

return comm.ExecuteScalar().ToString();
}
catch (Exception ex)
{
return null;
}
}
}
}
public int scn(string c, string cs, string p1, string p2, string p3, string p4, string p5)
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[cs].ConnectionString))
{
using (SqlCommand comm = new SqlCommand(c, conn))
{
try
{
conn.Open();
if (p1 != null) comm.Parameters.Add("p1", SqlDbType.NVarChar).Value = p1;
if (p2 != null) comm.Parameters.Add("p2", SqlDbType.NVarChar).Value = p2;
if (p3 != null) comm.Parameters.Add("p3", SqlDbType.NVarChar).Value = p3;
if (p4 != null) comm.Parameters.Add("p4", SqlDbType.NVarChar).Value = p4;
if (p5 != null) comm.Parameters.Add("p5", SqlDbType.NVarChar).Value = p5;

if (c.ToLower().Contains("@p1") && p1 == null) comm.Parameters.Add("p1", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p2") && p2 == null) comm.Parameters.Add("p2", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p3") && p3 == null) comm.Parameters.Add("p3", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p4") && p4 == null) comm.Parameters.Add("p4", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p5") && p5 == null) comm.Parameters.Add("p5", SqlDbType.NVarChar).Value = "";

return comm.ExecuteNonQuery();
}
catch (Exception ex)
{
return -1;
}
}
}
}
public DataTable sc(string c, string cs, string p1, string p2, string p3, string p4, string p5)
{
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[cs].ConnectionString))
{
using (SqlDataAdapter adap = new SqlDataAdapter(c, conn))
{
try
{
conn.Open();
if (p1 != null) adap.SelectCommand.Parameters.Add("p1", SqlDbType.NVarChar).Value = p1;
if (p2 != null) adap.SelectCommand.Parameters.Add("p2", SqlDbType.NVarChar).Value = p2;
if (p3 != null) adap.SelectCommand.Parameters.Add("p3", SqlDbType.NVarChar).Value = p3;
if (p4 != null) adap.SelectCommand.Parameters.Add("p4", SqlDbType.NVarChar).Value = p4;
if (p5 != null) adap.SelectCommand.Parameters.Add("p5", SqlDbType.NVarChar).Value = p5;

if (c.ToLower().Contains("@p1") && p1 == null) adap.SelectCommand.Parameters.Add("p1", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p2") && p2 == null) adap.SelectCommand.Parameters.Add("p2", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p3") && p3 == null) adap.SelectCommand.Parameters.Add("p3", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p4") && p4 == null) adap.SelectCommand.Parameters.Add("p4", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p5") && p5 == null) adap.SelectCommand.Parameters.Add("p5", SqlDbType.NVarChar).Value = "";

adap.Fill(dt);
}
catch (Exception ex)
{
}
}
}
return dt;
}
public static void Logla(string IP, string kim, string ne, string nasil)
{
if (ConfigurationManager.AppSettings["logla"] == "1")
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString))
{
using (SqlCommand comm = new SqlCommand("INSERT INTO Logs(IP,Kim,Ne,Nasil) values (@ip,@kim,@ne,@nasil)", conn))
{
try
{
conn.Open();
comm.Parameters.AddWithValue("@ip", (IP==null?HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]:""));
comm.Parameters.AddWithValue("@kim", kim);
comm.Parameters.AddWithValue("@ne", ne);
comm.Parameters.AddWithValue("@nasil", nasil);


comm.ExecuteNonQuery();

}
catch (Exception ex)
{

}
}
}
}
}
}

        public void treeviewdeGoster()

        {

            DataTable dt = sc("select * from BAKMAgaci where AnaMKA_ID=0", "ConnStr");

            TreeNode parent = new TreeNode();

            parent.Text = "Makina Agacımız";

            parent.Value = "-1";

            TreeView1.Nodes.Add(parent);

            for (int i = 0; i < dt.Rows.Count; i++)

            {

                TreeNode parent2 = new TreeNode();

                parent2.Text = dt.Rows[i]["Adi"].ToString();

                parent2.Value = dt.Rows[i]["MKA_ID"].ToString();

                parent.ChildNodes.Add(parent2);

                trvDoldur(ref parent2, Convert.ToInt16(dt.Rows[i]["MKA_ID"]));

            }

        }

        int ky = 1;

        void trvDoldur(ref TreeNode parent, int parentIdsi)

        {

            DataTable yedek;

            yedek = sc("select * from BAKMAgaci where AnaMKA_ID=" + parentIdsi, "ConnStr");

            for (int y = 0; y < yedek.Rows.Count; y++)

            {

                TreeNode child = new TreeNode();

                child.Text = yedek.Rows[y]["Adi"].ToString();

                child.Value = yedek.Rows[y]["MKA_ID"].ToString();

                parent.ChildNodes.Add(child);

                trvDoldur(ref child, Convert.ToInt16(yedek.Rows[y]["MKA_ID"]));

            }

            ky--;

        }

    }

Kullandıgınız control un adı ne ise ona eklemeyi unutmayınız, tabii ben burada master page kullanmıştım, o yüzden button un ismi bu şekilde,
sizin eklemek istediginiz çalışmayan ( not firing) kontrolun adını yanına bir linkbutton koyup ögrene bilirsiniz, browse ettiginizde üzerine geldiginizde javascript kodunu gösterecektir, onu revize edebilirsiniz. 
 Can alıcı nokta kontrolun adını databound oldugunda bilmek tıpkı ( benim imagebutton un adı  'ctl00$ContentPlaceHolder1$dtl_urunumuz$ctl00$btn_sepete' )