![\"\"](\"https:\/\/www.mahmuttalhakoz.com\/blog\/wp-content\/uploads\/2012\/11\/mtk-grid-2-150x150.png\")
<\/a>\n\t\t\t<\/div><\/figure>\n\t\t<\/div>\n<\/p>\nResim 2’de ekledigimiz “BoundField” nesnelerinin “DataField” degerlerine veritabanindaki tablomuzdan gosterilmesini istediginiz sutun adlarini giriyoruz. Degistirilmesini istemediginiz nesnelerin (Id gibi) “ReadOnly” ozelligini “True” yapmayi unutmayin.<\/p>\n
Simdi veritabanindan verilerimizi cekiyoruz. Baglanti cumlelerini yazmiyorum.
\n
\npublic void GetAllTest()
\n{
\nConnectionControl();
\nSqlDataAdapter Da = new SqlDataAdapter(\"SELECT * FROM AllTests\",myConnection);
\nDataSet Ds = new DataSet();
\nDa.Fill(Ds);<\/p>\nGridView1.DataSource=Ds;
\nGridView1.DataBind();
\n}
\n<\/code><\/p>\n
GridView’e veriyi cektik. GridView’de kullanacagimiz olaylar;<\/p>\n
\n- onrowcancelingedit<\/li>\n
- onrowdeleting<\/li>\n
- onrowediting<\/li>\n
- onrowupdating<\/li>\n
- onselectedindexchanging<\/li>\n<\/ul>\n
Olaylar su sekilde kodlanacak;
\n
\n\/\/Edit Cancel
\n protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
\n {
\n GridView1.EditIndex = -1;
\n GetAllTest();
\n }
\n\/\/Delete
\n protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
\n {
\n ConnectionControl();<\/p>\n SqlCommand Cmd = new SqlCommand(\"DELETE FROM Users WHERE userID=@userId\", myConnection);
\n Cmd.Parameters.Add(\"@userId\",SqlDbType.Int).Value = Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[3].Text);
\n Cmd.ExecuteNonQuery();<\/p>\n
GetAllTest();
\n }
\n\/\/Edit
\n protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
\n {
\n GridView1.EditIndex = e.NewEditIndex;
\n GetAllTest();
\n }
\n\/\/Update
\n protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
\n {
\n TextBox adsoyad = new TextBox();
\n adsoyad = (TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0];
\n TextBox email = new TextBox();
\n email = (TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0];
\n CheckBox onay = new CheckBox();
\n onay = (CheckBox)GridView1.Rows[e.RowIndex].Cells[6].Controls[0];
\n bool durum=false;
\n if (onay.Checked) durum = true;
\n else durum = false;<\/p>\n
ConnectionControl();<\/p>\n
SqlCommand Cmd = new SqlCommand(\"UPDATE users SET adsoyad=@adsoyad,email=@email,status=@durum WHERE userID=@userId\", myConnection);
\n Cmd.Parameters.Add(\"@adsoyad\",SqlDbType.NVarChar).Value = adsoyad.Text;
\n Cmd.Parameters.Add(\"@email\",SqlDbType.NVarChar).Value = email.Text;
\n Cmd.Parameters.Add(\"@durum\",SqlDbType.Bit).Value = durum;
\n Cmd.Parameters.Add(\"@userId\",SqlDbType.Int).Value = Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[3].Text);
\n cmd.ExecuteNonQuery();<\/p>\n
DataSet Ds = new DataSet();
\n SqlDataAdapterDa = new SqlDataAdapter(SELECT * FROM AllTests, myConnection);
\n Da.Fill(Ds);
\n GridView1.EditIndex = -1;
\n GridView1.DataSource = Ds;
\n GridView1.DataBind();<\/p>\n
con.Close();
\n }
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"
Merhaba arkadaslar, GridView kullanimini kisaca inceleyecegiz. GridView’e veriyi cekmeden once[ … ]<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[78,80,21,77,73,76,75,74,68,69,70,71,72,79],"class_list":["post-152","post","type-post","status-publish","format-standard","hentry","category-csharp","tag-canceledit","tag-delete-ve-select-kullanimi","tag-gridview","tag-gridview-ile-edit","tag-gridview1_rowcancelingedit","tag-gridview1_rowdeleting","tag-gridview1_rowediting","tag-gridview1_rowupdating","tag-onrowcancelingedit","tag-onrowdeleting","tag-onrowediting","tag-onrowupdating","tag-onselectedindexchanging","tag-update"],"_links":{"self":[{"href":"https:\/\/www.mahmuttalhakoz.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mahmuttalhakoz.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mahmuttalhakoz.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mahmuttalhakoz.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mahmuttalhakoz.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=152"}],"version-history":[{"count":15,"href":"https:\/\/www.mahmuttalhakoz.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/152\/revisions"}],"predecessor-version":[{"id":170,"href":"https:\/\/www.mahmuttalhakoz.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/152\/revisions\/170"}],"wp:attachment":[{"href":"https:\/\/www.mahmuttalhakoz.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mahmuttalhakoz.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mahmuttalhakoz.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/www.mahmuttalhakoz.com\/blog\/wp-content\/uploads\/2012\/11\/mtk-grid-1-150x150.png\")
<\/a>\n\t\t\t<\/div>\n\t\t\t\t
<\/a>\n\t\t\t<\/div>\n\t\t\t\t