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