コード例 #1
0
ファイル: Default.aspx.cs プロジェクト: yasin4134/yasincoder
    protected void GridView1_RowDeleting1(object sender, GridViewDeleteEventArgs e)
    {
        DataBase.fieldnameandvalue[] pCreteria = new DataBase.fieldnameandvalue[3];
        string userid = GridView1.DataKeys[e.RowIndex].Value.ToString();

        DataBase.Service           db            = new DataBase.Service();
        DataBase.fieldnameandvalue pCreteriaItem = new DataBase.fieldnameandvalue();
        pCreteriaItem.fieldname = GridView1.DataKeyNames[0].ToString();
        pCreteriaItem.value     = userid;
        pCreteria[0]            = pCreteriaItem;

        db.Sil("Customers", pCreteria);
    }
コード例 #2
0
ファイル: Default.aspx.cs プロジェクト: yasin4134/yasincoder
    protected void GridView1_RowUpdating2(object sender, GridViewUpdateEventArgs e)
    {
        DataBase.fieldnameandvalue[] pCreteria          = new DataBase.fieldnameandvalue[3];
        DataBase.fieldnameandvalue[] pFieldNameAndValue = new DataBase.fieldnameandvalue[4];
        DataBase.fieldnameandvalue[] pFieldCountry      = new DataBase.fieldnameandvalue[4];

        string userid = GridView1.DataKeys[e.RowIndex].Value.ToString();

        DataBase.Service           db            = new DataBase.Service();
        DataBase.fieldnameandvalue pCreteriaItem = new DataBase.fieldnameandvalue();
        pCreteriaItem.fieldname = GridView1.DataKeyNames[0].ToString();
        pCreteriaItem.value     = userid;
        pCreteria[0]            = pCreteriaItem;

        GridViewRow row = GridView1.Rows[e.RowIndex];
        //Label lblID = (Label)row.FindControl("lblID");

        string textName = e.NewValues["Name"].ToString();// row.Cells[2].Text.ToString();

        DataBase.fieldnameandvalue pItem = new DataBase.fieldnameandvalue();
        pItem.fieldname       = "Name";
        pItem.value           = textName;
        pFieldNameAndValue[0] = pItem;

        string textName1 = e.NewValues["Country"].ToString();// row.Cells[2].Text.ToString();

        DataBase.fieldnameandvalue pItem1 = new DataBase.fieldnameandvalue();
        pItem1.fieldname      = "Country";
        pItem1.value          = textName1;
        pFieldNameAndValue[1] = pItem1;

        //string textadd = ((TextBox)(row.Cells[1].Controls[0])).Text;//row.Cells[3].Text.ToString();
        //pItem = new DataBase.fieldnameandvalue();
        //pItem.fieldname = "Country";
        //pItem.value = textadd;
        //pFieldNameAndValue[0] = pItem;

        db.Guncelle("Customers", pCreteria, pFieldNameAndValue);
        Page_Load(sender, e);
    }
コード例 #3
0
ファイル: Default.aspx.cs プロジェクト: yasin4134/yasincoder
    protected void Button1_Click1(object sender, EventArgs e)
    {
        DataBase.Service             db = new DataBase.Service();
        DataBase.fieldnameandvalue[] lstFieldNameAndValue = new DataBase.fieldnameandvalue[3];
        DataBase.fieldnameandvalue   vFieldNameAndValue   = null;

        vFieldNameAndValue           = new DataBase.fieldnameandvalue();
        vFieldNameAndValue.fieldname = "ID";
        vFieldNameAndValue.value     = Guid.NewGuid().ToString();
        lstFieldNameAndValue[0]      = vFieldNameAndValue;

        vFieldNameAndValue           = new DataBase.fieldnameandvalue();
        vFieldNameAndValue.fieldname = "Name";
        vFieldNameAndValue.value     = TextBox1.Text;
        lstFieldNameAndValue[1]      = vFieldNameAndValue;

        vFieldNameAndValue           = new DataBase.fieldnameandvalue();
        vFieldNameAndValue.fieldname = "Country";
        vFieldNameAndValue.value     = TextBox2.Text;
        lstFieldNameAndValue[2]      = vFieldNameAndValue;

        db.Ekle("Customers", lstFieldNameAndValue);
    }