20";display:block;height:0;overflow:hidden}.clearfix:after{clear:both}.tie-container,#tie-wrapper{height:100%;min-height:650px}.tie-container{position:relative;overflow:hidden}#tie-wrapper{background:#fff;position:relative;z-index:108;height:100%;margin:0 auto}.container-wrapper{background:#fff;border:1px solid rgba(0,0,0,.1);border-radius:2px;padding:30px}#content{margin-top:30px}@media (max-width:991px){#content{margin-top:15px}}.site-content{-ms-word-wrap:break-word;word-wrap:break-word}.theme-header{background:#fff;position:relative;z-index:999}.theme-header:after{content:"";display:table;clear:both}.theme-header.has-shadow{box-shadow:0 0 10px 5px rgba(0,0,0,.1)}.logo-row{position:relative}#logo{margin-top:40px;margin-bottom:40px;display:block;float:left}#logo a{display:inline-block}#logo.text-logo a{color:var(--brand-color)}.logo-text{font-size:50px;line-height:50px;font-weight:700}@media (max-width:670px){.logo-text{font-size:30px}}@media (max-width:991px){#theme-header.has-normal-width-logo #logo{margin:14px 0!important;text-align:left;line-height:1}}@media (max-width:991px){#theme-header.mobile-header-default:not(.header-layout-1) #logo{-webkit-flex-grow:10;-ms-flex-positive:10;flex-grow:10}}.components{float:right}.components>li{position:relative;float:right;list-style:none}.components>li.social-icons-item{margin:0}.components>li>a{display:block;position:relative;width:30px;text-align:center;line-height:inherit;font-size:16px}.components .search-bar{width:auto;border:solid rgba(0,0,0,.1);border-width:0 1px;margin-left:10px}.components #search{position:relative;background:0 0}.components #search-input{border:0;margin-bottom:0;line-height:inherit;width:100%;background:0 0;padding:0 25px 0 10px;border-radius:0;box-sizing:border-box;font-size:inherit}.components #search-submit{position:absolute;right:0;top:0;width:40px;line-height:inherit;color:#777;background:0 0;font-size:15px;padding:0}@media (max-width:991px){.logo-container{border-width:0;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-flex-flow:row nowrap;-ms-flex-flow:row nowrap;flex-flow:row nowrap;-webkit-align-items:center;-ms-flex-align:center;align-items:center;-webkit-justify-content:space-between;-ms-flex-pack:justify;justify-content:space-between}}.mobile-header-components{display:none;z-index:10;height:30px;line-height:30px;-webkit-flex-wrap:nowrap;-ms-flex-wrap:nowrap;flex-wrap:nowrap;-webkit-flex:1 1 0%;-ms-flex:1 1 0%;flex:1 1 0%}.mobile-header-components .components{float:none;display:-webkit-flex!important;display:-ms-flexbox!important;display:flex!important;-webkit-justify-content:stretch;-ms-flex-pack:stretch;justify-content:stretch}.mobile-header-components .components li.custom-menu-link{display:inline-block;float:none}.mobile-header-components .components li.custom-menu-link>a{width:20px;padding-bottom:15px}.mobile-header-components [class^=tie-icon-]{font-size:18px;width:20px;height:20px;vertical-align:middle}.mobile-header-components .tie-mobile-menu-icon{font-size:20px}.mobile-header-components .nav-icon{display:inline-block;width:20px;height:2px;background-color:var(--base-color);position:relative;top:-4px}.mobile-header-components .nav-icon:before,.mobile-header-components .nav-icon:after{position:absolute;right:0;background-color:var(--base-color);content:'';display:block;width:100%;height:100%;-webkit-transform:translateZ(0);transform:translateZ(0);-webkit-backface-visibility:hidden;backface-visibility:hidden}.mobile-header-components .nav-icon:before{-webkit-transform:translateY(-7px);-ms-transform:translateY(-7px);transform:translateY(-7px)}.mobile-header-components .nav-icon:after{-webkit-transform:translateY(7px);-ms-transform:translateY(7px);transform:translateY(7px)}#mobile-header-components-area_1 .components li.custom-menu-link>a{margin-right:15px}#mobile-header-components-area_2 .components{-webkit-flex-direction:row-reverse;-ms-flex-direction:row-reverse;flex-direction:row-reverse}#mobile-header-components-area_2 .components li.custom-menu-link>a{margin-left:15px}@media (max-width:991px){.logo-container:before,.logo-container:after{height:1px}#tie-body #mobile-container,.mobile-header-components{display:block}#slide-sidebar-widgets{display:none}}.top-nav{background-color:#fff;position:relative;z-index:10;line-height:35px;border:1px solid rgba(0,0,0,.1);border-width:1px 0;color:var(--base-color)}.main-nav-below.top-nav-above .top-nav{border-top-width:0}.top-nav a:not(.button):not(:hover){color:var(--base-color)}.topbar-wrapper{display:-webkit-flex;display:-ms-flexbox;display:flex;min-height:35px}.top-nav .tie-alignleft,.top-nav .tie-alignright{-webkit-flex-grow:1;-ms-flex-positive:1;flex-grow:1;position:relative}.top-nav.has-breaking-news .tie-alignleft{-webkit-flex:1 0 100px;-ms-flex:1 0 100px;flex:1 0 100px}.top-nav.has-breaking-news .tie-alignright{-webkit-flex-grow:0;-ms-flex-positive:0;flex-grow:0;z-index:1}.topbar-today-date{float:left;padding-right:15px;font-size:12px;-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0}.topbar-today-date:before{font-size:13px;content:"\f017"}@media (max-width:991px){.topbar-today-date,.theme-header .components{display:none}}.breaking{display:none}.main-nav-wrapper{position:relative;z-index:4}.main-nav{background-color:var(--main-nav-background);color:var(--main-nav-primary-color);position:relative;border:1px solid var(--main-nav-main-border-color);border-width:1px 0}.main-menu-wrapper{border:0 solid var(--main-nav-main-border-color);position:relative}@media (min-width:992px){.header-menu{float:left}.header-menu .menu li{display:block;float:left}.header-menu .menu a{display:block;position:relative}.header-menu .menu ul{box-shadow:0 2px 5px rgba(0,0,0,.1)}.header-menu .menu ul li{position:relative}.header-menu .menu ul a{border-width:0 0 1px}#main-nav{z-index:9;line-height:60px}#main-nav .search-bar{border-color:var(--main-nav-main-border-color)}.main-menu .menu>li>a{padding:0 14px;font-size:13px;font-weight:600}.main-menu .menu>li>.menu-sub-content{border-top:2px solid var(--main-nav-primary-color)}.main-menu .menu ul{line-height:20px;z-index:1}.main-menu .menu-sub-content{background:var(--main-nav-background);display:none;padding:15px;width:230px;position:absolute;box-shadow:0 2px 2px rgba(0,0,0,.15)}.main-menu .menu-sub-content a{width:200px}.main-nav .menu a,.main-nav .components li a{color:var(--main-nav-text-color)}.main-nav-dark{--main-nav-background:#1f2024;--main-nav-secondry-background:rgba(0,0,0,.2);--main-nav-primary-color:var(--brand-color);--main-nav-contrast-primary-color:var(--bright-color);--main-nav-text-color:#fff;--main-nav-secondry-text-color:rgba(225,255,255,.5);--main-nav-main-border-color:rgba(255,255,255,.07);--main-nav-secondry-border-color:rgba(255,255,255,.04)}.main-nav-dark .main-nav,.main-nav-dark .main-nav ul.cats-horizontal li a{border-width:0}}@media (min-width:992px){.mega-menu>a:before{content:'';position:absolute;right:12px;margin-top:2px;top:50%;bottom:auto;-webkit-transform:translateY(-50%);-ms-transform:translateY(-50%);transform:translateY(-50%);width:0;height:0;border:4px solid transparent;border-top:4px solid #fff}.menu .mega-menu:not(.is-icon-only)>a{padding-right:25px}}@media (min-width:992px){.main-nav-boxed .main-nav{border-width:0}.main-nav-boxed .main-menu-wrapper{float:left;width:100%;background-color:var(--main-nav-background)}.main-nav-boxed .main-menu-wrapper .search-bar{border-right-width:0}}.main-nav-boxed .main-nav:not(.fixed-nav){background:0 0!important}@media only screen and (min-width:992px) and (max-width:1100px){.main-nav .menu>li:not(.is-icon-only)>a{padding-left:7px;padding-right:7px}.main-nav .menu>li:not(.is-icon-only)>a:before{display:none}}@media (max-width:991px){#tie-wrapper header#theme-header{box-shadow:none;background:0 0!important}.logo-container{border-width:0;box-shadow:0 3px 7px 0 rgba(0,0,0,.1)}.logo-container{background-color:#fff}.header-layout-3 .main-nav-wrapper{display:none}.main-menu-wrapper .tie-alignleft{width:100%}}.main-nav-dark .main-nav input{color:#ccc}@media (max-width:767px){.magazine1:not(.has-builder):not(.error404) .main-content,.magazine1:not(.has-builder):not(.error404) .sidebar{padding-left:0;padding-right:0}}input{border:1px solid rgba(0,0,0,.1);color:var(--base-color);font-size:13px;outline:none;padding:5px;line-height:23px;border-radius:2px;max-width:100%;background-color:transparent}input:not([type=checkbox]):not([type=radio]){-webkit-appearance:none;-moz-appearance:none;appearance:none;outline:none}@media (max-width:767px){input:not([type=submit]){font-size:16px!important}}.button,[type=submit]{width:auto;position:relative;background-color:var(--brand-color);color:var(--bright-color);padding:7px 15px;margin:0;font-weight:400;font-size:13px;display:inline-block;text-align:center;line-height:21px;border:none;text-decoration:none;vertical-align:middle;border-radius:2px;-webkit-appearance:none;-moz-appearance:none;appearance:none}@media (min-width:992px){.sidebar-right .main-content{float:left}.sidebar-right .sidebar{float:right}.sidebar-right.magazine1 .main-content{padding-right:3px}}.post-thumb{position:relative;height:100%;display:block;-webkit-backface-visibility:hidden;backface-visibility:hidden;-webkit-transform:rotate(0);-ms-transform:rotate(0);transform:rotate(0)}.post-thumb img{width:100%;display:block}.post-thumb .post-cat-wrap{position:absolute;bottom:10px;margin:0;right:10px}.post-meta{margin:10px 0 8px;font-size:12px;overflow:hidden}.post-meta,.post-meta a:not(:hover){color:#666}.post-meta .meta-item{margin-right:8px;display:inline-block}.post-meta .meta-item.tie-icon:before{padding-right:3px}.post-meta .meta-item.date:before{content:"\f017"}.post-meta .meta-item.meta-comment:before{content:"\f086"}.post-meta .tie-alignright .meta-item:last-child{margin:0!important}@media (max-width:767px){.entry-header .post-meta>span,.entry-header .post-meta>div,.main-content .post-meta>span,.main-content .post-meta>div{float:left}}.post-cat-wrap{position:relative;z-index:3;margin-bottom:5px;font-weight:400;font-family:inherit!important;line-height:0;display:block}.post-cat{display:inline-block;background:var(--brand-color);color:var(--bright-color);padding:0 10px;font-size:12px;line-height:1.85em;margin-right:4px;position:relative;white-space:nowrap;word-wrap:normal;letter-spacing:0;border-radius:4px}.post-cat:first-child:last-child{margin:0}#breadcrumb{margin:50px 0 0}#breadcrumb,#breadcrumb a:not(:hover){color:#666}#breadcrumb .delimiter{margin:0 3px;font-style:normal}.entry-header-outer #breadcrumb{margin:0 0 20px;padding:0}@media (max-width:767px){.single-post #breadcrumb .current,.single-post #breadcrumb em:last-of-type{display:none}}.social-icons-item{float:right;margin-left:6px;position:relative}.social-icons-item .social-link span{color:var(--base-color);line-height:unset}.social-icons-widget .social-icons-item .social-link{width:24px;height:24px;line-height:24px;padding:0;display:block;text-align:center;border-radius:2px}.top-nav .components>li.social-icons-item .social-link:not(:hover) span{color:var(--base-color)}.social-icons-item .facebook-social-icon{background-color:#4080ff!important}.social-icons-item .facebook-social-icon span{color:#4080ff}.social-icons-item .twitter-social-icon{background-color:#40bff5!important}.social-icons-item .twitter-social-icon span{color:#40bff5}.social-icons-item .pinterest-social-icon{background-color:#e13138!important}.social-icons-item .pinterest-social-icon span{color:#e13138}.social-icons-item .instagram-social-icon{background-color:#c13584!important}.social-icons-item .instagram-social-icon span{color:#c13584}.social-icons-item .youtube-social-icon{background-color:#ef4e41!important}.social-icons-item .youtube-social-icon span{color:#ef4e41}.social-icons-item .twitch-social-icon{background-color:#6441a5!important}.social-icons-item .twitch-social-icon span{color:#6441a5}.social-icons-item .rss-social-icon{background-color:#faa33d!important}.social-icons-item .rss-social-icon span{color:#faa33d}.social-icons-item .steam-social-icon{background-color:#111!important}.social-icons-item .steam-social-icon span{color:#111}.social-icons-item .tumblr-social-icon{background-color:#35465c!important}.social-icons-item .tumblr-social-icon span{color:#35465c}.social-icons-item .buymeacoffee-social-icon{background-color:#fd0!important}.social-icons-item .buymeacoffee-social-icon span{color:#fd0}ul:not(.solid-social-icons) .social-icons-item a:not(:hover){background-color:transparent!important}.solid-social-icons .social-link{background-color:var(--base-color)}.dark-skin .solid-social-icons .social-link{background-color:#27292d;border-color:#27292d}.solid-social-icons .social-link span{color:#fff!important}.entry-header{padding:30px 30px 0;margin-bottom:20px}@media (max-width:991px){.entry-header{padding:20px 20px 0}}@media (max-width:767px){.container-wrapper{padding:20px 15px}}.tabs{max-height:75px;width:100%;padding:0;border:1px solid rgba(0,0,0,.1);border-width:0 0 1px;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-flex-flow:row wrap;-ms-flex-flow:row wrap;flex-flow:row wrap}.tabs li{display:inline-block;position:relative;padding:0!important}.tabs a{background:rgba(0,0,0,.02);display:block;text-align:center;border:1px solid rgba(0,0,0,.1);border-width:0 1px 1px 0;font-size:15px}.tabs a:not(:hover){color:var(--base-color)}.tabs>li>a{line-height:65px;padding:0 15px;border-bottom-color:transparent}.tab-content{padding:30px;display:none}.tab-content{position:relative}@media (max-width:767px){.tab-content{padding:20px}}.tab-content-elements li{opacity:0}.tab-content:not(.is-not-active):first-of-type{display:block}.tab-content:not(.is-not-active):first-of-type .tab-content-elements li{opacity:1}.tabs-container-wrapper{padding:0!important}.normal-side .tabs{display:-webkit-flex;display:-ms-flexbox;display:flex}.normal-side .tabs li{-webkit-flex-grow:1;-ms-flex-positive:1;flex-grow:1}.normal-side .tabs a{overflow:hidden;text-overflow:ellipsis;white-space:nowrap;padding:0 10px!important}.normal-side .tabs li:last-child a{border-right-width:0}@media (max-width:320px){.normal-side .tabs{max-height:none;border-bottom:0}.normal-side .tabs li{display:block;width:100%;float:none}.normal-side .tabs a{border-bottom-color:rgba(0,0,0,.1);border-width:0 0 1px}}.block-head-1 .the-global-title{position:relative;font-size:17px;padding:0 0 15px;border-bottom:2px solid rgba(0,0,0,.1);margin-bottom:20px}.block-head-1 .the-global-title:after{content:"";background:#2c2f34;width:40px;height:2px;position:absolute;bottom:-2px;left:0}.block-head-1 .the-global-title:before{content:"";width:0;height:0;position:absolute;bottom:-5px;left:0;border-left:0;border-right:5px solid transparent;border-top:5px solid #2c2f34}.block-head-1 .dark-skin .widget-title:after{background:#fff}.block-head-1 .dark-skin .widget-title:before{border-top-color:#fff}.block-head-1 .dark-skin .the-global-title{color:#fff;border-bottom-color:rgba(255,255,255,.1)}.side-aside{position:fixed;top:0;z-index:111;visibility:hidden;width:350px;max-width:100%;height:100%;background:#131416;background-repeat:no-repeat;background-position:center top;background-size:cover;overflow-y:auto}@media (min-width:992px){.side-aside{right:0;-webkit-transform:translate(350px,0);-ms-transform:translate(350px,0);transform:translate(350px,0)}}.site-footer .widget-title-icon{display:none}.dark-skin{--lazyload-loading-color:#161717}.dark-skin{background-color:#1f2024;color:#fff}.dark-skin input:not([type=submit]){color:#ccc}.dark-skin a:not(:hover){color:#fff}.dark-skin .post-meta{color:#ccc!important}.dark-skin input:not([type=submit]){border-color:rgba(255,255,255,.1)}.dark-skin .container-wrapper{background-color:#1f2024;border-color:rgba(255,255,255,.1)}.dark-skin .widget a:not(:hover),.dark-skin .widget-title{color:#fff}.dark-skin .widget-title-icon{color:#ccc}.sidebar .container-wrapper{margin-bottom:30px}@media (max-width:991px){.sidebar .container-wrapper{margin-bottom:15px}}@media (max-width:991px){.has-sidebar .sidebar{margin-top:15px}}.widget-title{position:relative}.widget-title .the-subtitle{font-size:15px;min-height:15px}.widget-title-icon{position:absolute;right:0;top:1px;color:#b9bec3;font-size:15px}.widget-title-icon:before{content:"\f08d"}.post-widget-body{padding-left:125px}.post-widget-body .post-title{font-size:14px;line-height:1.4;margin-bottom:5px}.post-widget-thumbnail{float:left;margin-right:15px;position:relative}.post-widget-thumbnail img.tie-small-image{width:110px}.widget li{padding:6px 0}.widget li:first-child{padding-top:0}.widget li:last-child{padding-bottom:0;border-bottom:0}.widget li:after{clear:both;display:table;content:""}.widget .post-meta{margin:2px 0 0;font-size:11px;line-height:17px}.posts-list .widget-title-icon:before{content:"\f0f6"}.posts-list-big-first .posts-list-items li:first-child{padding-bottom:20px}.posts-list-big-first li:first-child .post-widget-thumbnail{width:100%;margin-right:0;margin-bottom:10px}.posts-list-big-first li:first-child .post-widget-thumbnail a{min-height:40px}.posts-list-big-first li:first-child .post-widget-body{padding-left:0}.posts-list-big-first li:first-child .post-title{font-size:18px}@media (max-width:991px){.posts-list-big-first .posts-list-items{overflow:hidden}.posts-list-big-first li{width:48%;float:left}.posts-list-big-first li:nth-child(2){padding-top:0}.posts-list-big-first li:nth-child(2n){float:right}.posts-list-big-first li:nth-child(2n+1){clear:both}.posts-list-big-first li:nth-child(2),.posts-list-big-first li:nth-child(3){float:right;clear:none}}@media (max-width:670px){.posts-list-big-first li{width:100%}.posts-list-big-first li:nth-child(2){padding-top:12px}}form.search-form{overflow:auto;position:relative;width:100%;margin-top:10px}.search-field{float:left;width:73%;padding:8px 15px}.search-submit[type=submit]{float:right;padding:10px 5px;margin-left:2%;width:25%}.login-widget .widget-title-icon:before{content:"\f023"}.login-widget form input[type=text],.login-widget form input[type=password]{width:100%;float:none;margin-bottom:15px}.login-widget .pass-container{position:relative}.login-widget .pass-container input[type=password]{padding-right:70px}.login-widget .forget-text{position:absolute;right:10px;line-height:37px;top:0;font-size:12px}.login-widget .forget-text:not(:hover){color:#666}.login-widget .rememberme{display:block;margin-bottom:15px}.widget_tag_cloud .widget-title-icon:before{content:"\f02c"}li.widget-post-list{padding:7px 0;position:relative}.social-statistics-widget .widget-title-icon:before{content:"\f164"}.social-statistics-widget ul{overflow:hidden}.social-statistics-widget li{float:left;width:50%;margin-left:0;padding:10px 5px 0;border-bottom:0}.social-statistics-widget li:last-child{margin-bottom:0}.social-statistics-widget .followers-num{font-weight:600}.social-statistics-widget .followers-name{font-size:11px}.social-statistics-widget a{display:block;padding:10px;position:relative;overflow:hidden;border-radius:2px}.social-statistics-widget a span.counter-icon{float:left;color:#fff;background-color:#2c2f34;width:30px;height:30px;line-height:30px;text-align:center;font-size:18px;border-radius:2px}.social-statistics-widget .followers{float:left;margin-left:10px;line-height:15px}.social-statistics-widget .followers .followers-num,.social-statistics-widget .followers .followers-name{color:#fff;display:block;white-space:nowrap;word-wrap:normal}.social-statistics-widget .followers .followers-name{opacity:.8}.two-cols{margin-left:-5px;margin-right:-5px}.two-cols li:nth-last-child(-n+2){margin-bottom:0}.two-cols li:nth-child(2n+1){clear:both}@media (min-width:1050px){.two-cols li:nth-child(odd):last-child{width:100%}}.transparent-icons li a span.counter-icon{background-color:transparent}@media only screen and (min-width:992px) and (max-width:1050px){.two-cols.transparent-icons li{width:100%}}@media only screen and (min-width:768px) and (max-width:991px){.two-cols.transparent-icons{margin-left:-5px;margin-right:-5px}.two-cols.transparent-icons li{width:25%;padding-left:5px;padding-right:5px}.two-cols.transparent-icons li:before{left:55px}.two-cols.transparent-icons li:nth-child(-n+4){padding-top:0}.two-cols.transparent-icons li:nth-child(-n+4):before{top:0;height:100%}.two-cols.transparent-icons li:nth-child(2n+1){clear:none}.two-cols.transparent-icons li:nth-child(4n+1){clear:both}.two-cols.transparent-icons li .followers span{float:none;line-height:inherit}}.widget_tie-buymeacoffee-widget .widget-title-icon:before{content:"\f2ac"}.social-icons-widget ul{margin:0 -3px}.social-icons-widget .social-icons-item{float:left;margin:3px;border-bottom:0;padding:0}.social-icons-widget .social-icons-item .social-link{width:40px;height:40px;line-height:40px;font-size:18px}@media (max-width:479px){.social-icons-widget .social-icons-item{float:none;display:inline-block}}.widget-posts-list-container{position:relative}@media (min-width:992px){.mega-menu .mega-menu-block{left:0;width:100%;padding:30px}.mega-menu .mega-menu-block a{width:auto}.main-menu .mega-cat-wrapper{overflow:hidden;height:auto;clear:both}.main-menu .mega-ajax-content{min-height:200px;position:relative}.main-menu .mega-cat .mega-menu-content{clear:both}.main-menu .mega-cat .mega-menu-block{padding:0}.main-menu .mega-cat-content{padding:30px}.main-menu .mega-cat-sub-exists{width:80%;float:left}.main-menu .horizontal-posts{width:100%}.main-menu ul.mega-cat-sub-categories{overflow:hidden;box-shadow:none}.main-menu .cats-horizontal{margin:30px 30px -10px}.main-menu .cats-horizontal li{line-height:20px;margin-right:7px}.main-menu .cats-horizontal li a{border:1px solid var(--main-nav-secondry-border-color);background:var(--main-nav-secondry-background);border-radius:2px;padding:1px 10px;width:auto}.main-nav .mega-menu.mega-cat .cats-horizontal li a.is-active{color:var(--main-nav-contrast-primary-color);background:var(--main-nav-primary-color);border-color:var(--main-nav-primary-color)}.main-menu .cats-vertical{background:var(--main-nav-secondry-background);width:20%;float:left;padding:30px 0 0 20px;padding-bottom:1500px;margin-bottom:-1500px}.main-menu .cats-vertical li{width:100%}.main-menu .cats-vertical li:last-child{margin-bottom:50px}.main-menu .cats-vertical li a{display:block;border-top:0;width:100%;padding:8px 10px}.main-menu .cats-vertical li a.is-active{background:var(--main-nav-background)}}@media (min-width:992px){.theme-header .logo-row>div{height:auto!important}.header-layout-3 .stream-item-top-wrapper{float:right}}.breaking{float:left;width:100%;height:35px;line-height:35px;display:block!important}.breaking-title{padding:0 10px;display:block;float:left;color:#fff;font-size:12px;position:relative}.breaking-title span{position:relative;z-index:1}.breaking-title span.breaking-icon{display:none}@media (max-width:600px){.breaking-title span.breaking-icon{display:inline-block}.breaking-title .breaking-title-text{display:none}}.breaking-title:before{content:"";background:#f05555;width:100%;height:100%;position:absolute;left:0;top:0;z-index:0}.breaking-news{display:none}#mobile-container{display:none;padding:10px 30px 30px}#mobile-menu{margin-bottom:20px;position:relative;padding-top:15px}#mobile-social-icons{margin-bottom:15px}#mobile-social-icons ul{text-align:center;overflow:hidden}#mobile-social-icons ul .social-icons-item{float:none;display:inline-block}#mobile-social-icons .social-icons-item{margin:0}#mobile-social-icons .social-icons-item .social-link{background:0 0;border:none}#mobile-search .search-form{overflow:hidden}#mobile-search .search-form:after{position:absolute;content:"\f002";font-family:'tiefonticon';top:4px;right:10px;line-height:30px;width:30px;font-size:16px;border-radius:50%;text-align:center;color:#fff}#mobile-search .search-field{background-color:rgba(0,0,0,.05);border-color:rgba(255,255,255,.1);color:#fff;width:100%;border-radius:50px;padding:7px 45px 7px 20px}#mobile-search .search-submit{background:0 0;font-size:0;width:35px;height:38px;position:absolute;top:0;right:5px;z-index:1}#mobile-search input::-webkit-input-placeholder{color:rgba(255,255,255,.6)}#mobile-search input::-moz-placeholder{color:rgba(255,255,255,.6)}#mobile-search input:-moz-placeholder{color:rgba(255,255,255,.6)}#mobile-search input:-ms-input-placeholder{color:rgba(255,255,255,.6)}#tie-wrapper:after{position:absolute;z-index:1000;top:-10%;left:-50%;width:0;height:0;background:rgba(0,0,0,.2);content:'';opacity:0}@media (max-width:991px){.side-aside.appear-from-left{left:0;-webkit-transform:translate(-100%,0);-ms-transform:translate(-100%,0);transform:translate(-100%,0)}.side-aside.is-fullwidth{width:100%}}.is-desktop .side-aside .has-custom-scroll{padding:50px 0 0}.side-aside.dark-skin .container-wrapper{border-radius:0;border:0;background:0 0;box-shadow:none}.side-aside:after{position:absolute;top:0;left:0;width:100%;height:100%;background:rgba(0,0,0,.2);content:'';opacity:1}.side-aside .container-wrapper{padding:30px!important}a.remove{position:absolute;top:0;right:0;display:block;speak:never;-webkit-font-smoothing:antialiased;-moz-osx-font-smoothing:grayscale;width:20px;height:20px;display:block;line-height:20px;text-align:center;font-size:15px}a.remove:before{content:"\e117";font-family:'tiefonticon';color:#e74c3c}a.remove.big-btn{width:25px;height:25px;line-height:25px;font-size:22px}a.remove.light-btn:not(:hover):before{color:#fff}.side-aside a.remove{z-index:1;top:15px;left:50%;right:auto;-webkit-transform:translateX(-50%);-ms-transform:translateX(-50%);transform:translateX(-50%)}.tie-popup a.remove{-webkit-transform:scale(.2);-ms-transform:scale(.2);transform:scale(.2);opacity:0;top:15px;right:15px;z-index:1}.theiaStickySidebar:after{content:"";display:table;clear:both}.side-aside,.has-custom-scroll{overflow-x:hidden;scrollbar-width:thin}.side-aside::-webkit-scrollbar,.has-custom-scroll::-webkit-scrollbar{width:5px}.side-aside::-webkit-scrollbar-track,.has-custom-scroll::-webkit-scrollbar-track{background:0 0}.side-aside::-webkit-scrollbar-thumb,.has-custom-scroll::-webkit-scrollbar-thumb{border-radius:20px;background:rgba(0,0,0,.2)}.dark-skin .has-custom-scroll::-webkit-scrollbar-thumb{background:#000}.tie-popup{position:fixed;z-index:99999;left:0;top:0;height:100%;width:100%;background-color:rgba(0,0,0,.9);display:none;-webkit-perspective:600px;perspective:600px}.tie-popup-container{position:relative;z-index:100;width:90%;max-width:420px;margin:10em auto 0;border-radius:2px;box-shadow:0 0 20px rgba(0,0,0,.2);will-change:transform,opacity;-webkit-transform:scale(.5);-ms-transform:scale(.5);transform:scale(.5);opacity:0}.tie-popup-container .login-submit{padding-top:15px;padding-bottom:15px}.tie-popup-container .container-wrapper{padding:60px;background-color:#fff!important;border-radius:5px}@media (max-width:479px){.tie-popup-container .container-wrapper{padding:30px}}.pop-up-live-search{will-change:transform,opacity;-webkit-transform:scale(.7);-ms-transform:scale(.7);transform:scale(.7);opacity:0}.tie-popup-search-wrap::-webkit-input-placeholder{color:#fff}.tie-popup-search-wrap::-moz-placeholder{color:#fff}.tie-popup-search-wrap:-moz-placeholder{color:#fff}.tie-popup-search-wrap:-ms-input-placeholder{color:#fff}.tie-popup-search-wrap form{position:relative;height:80px;margin-bottom:20px}.popup-search-wrap-inner{position:relative;padding:80px 15px 0;margin:0 auto;max-width:800px}input.tie-popup-search-input{width:100%;height:80px;line-height:80px;background:rgba(0,0,0,.7)!important;font-weight:500;font-size:22px;border:0;padding-right:80px;padding-left:30px;color:#fff}button.tie-popup-search-submit{font-size:28px;color:#666;position:absolute;right:10px;top:20px;background:0 0!important}#tie-popup-search-mobile .popup-search-wrap-inner{padding-top:50px}#tie-popup-search-mobile input.tie-popup-search-input{height:50px;line-height:1;padding-left:20px;padding-right:50px}#tie-popup-search-mobile button.tie-popup-search-submit{font-size:16px;top:9px;right:0}#autocomplete-suggestions{overflow:auto;padding:20px;color:#eee;position:absolute;display:none;width:370px;z-index:9999}.tie-icon-buymeacoffee:before{content:"\e90c"}.tie-icon-facebook:before{content:"\f09a"}.tie-icon-search:before{content:"\f002"}.tie-icon-author:before{content:"\f007"}.tie-icon-search:before{content:"\f002"}.tie-icon-home:before{content:"\f015"}.tie-icon-tags:before{content:"\f02c"}.tie-icon-bookmark:before{content:"\f02e"}.tie-icon-random:before{content:"\f074"}.tie-icon-phone:before{content:"\f095"}.tie-icon-twitter:before{content:"\f099"}.tie-icon-feed:before{content:"\f09e"}.tie-icon-navicon:before{content:"\f0c9"}.tie-icon-pinterest:before{content:"\f0d2"}.tie-icon-envelope:before{content:"\f0e0"}.tie-icon-linkedin:before{content:"\f0e1"}.tie-icon-bolt:before{content:"\f0e7"}.tie-icon-youtube:before{content:"\f16a"}.tie-icon-instagram:before{content:"\f16d"}.tie-icon-tumblr:before{content:"\f173"}.tie-icon-vk:before{content:"\f189"}.tie-icon-reddit:before{content:"\f1a1"}.tie-icon-steam:before{content:"\f1b6"}.tie-icon-paper-plane:before{content:"\f1d8"}.tie-icon-twitch:before{content:"\f1e8"}.tie-icon-whatsapp:before{content:"\f232"}.tie-icon-odnoklassniki:before{content:"\f263"}.tie-icon-get-pocket:before{content:"\f265"}.tie-icon-facebook:before{content:"\f09a"}.tie-icon-fire:before{content:"\e900"}.fas,.fab{-moz-osx-font-smoothing:grayscale;-webkit-font-smoothing:antialiased;display:inline-block;font-style:normal;font-variant:normal;text-rendering:auto;line-height:1}.fa-android:before{content:"\f17b"}.fa-code:before{content:"\f121"}.fa-critical-role:before{content:"\f6c9"}.fa-galactic-senate:before{content:"\f50d"}.fa-gamepad:before{content:"\f11b"}.fa-penny-arcade:before{content:"\f704"}.fa-php:before{content:"\f457"}.fa-vr-cardboard:before{content:"\f729"}.fab{font-family:'Font Awesome 5 Brands';font-weight:400}.fas{font-family:'Font Awesome 5 Free';font-weight:900}.post-content.container-wrapper{padding:0}.entry-header{font-size:45px;line-height:1.2}@media (max-width:767px){.entry-header{font-size:28px}}.entry-header .entry-title{margin-bottom:15px}@media (max-width:767px){.entry-header .entry-title{font-size:28px}}.entry-header .post-cat{margin-bottom:6px}.entry-header .post-meta{overflow:inherit;font-size:12px;margin-top:5px;margin-bottom:0;line-height:24px}.entry-header .post-meta .meta-item{margin-right:12px}.entry-header .post-meta,.entry-header .post-meta a:not(:hover){color:#333}.entry-header .post-meta .meta-author{margin:0}.entry-header .post-meta .meta-author a{font-weight:600}.entry-header .post-meta .author-meta+.date:before{content:"22";color:#ccc;margin:0 3px 0 5px;display:inline-block}.entry-header .post-meta .tie-alignright{display:inline}@media (max-width:767px){.entry-header .post-meta{margin-bottom:-8px}.entry-header .post-meta .tie-alignright{float:none}.entry-header .post-meta .meta-item,.entry-header .post-meta .tie-alignright .meta-item:last-child{margin-bottom:8px!important}.entry-header .post-meta>span,.entry-header .post-meta>div{float:initial!important}.entry-header .post-meta .meta-author a{font-weight:400}.entry-header .meta-author-avatar img{width:20px;height:20px}}.meta-author-avatar img{width:30px;height:30px;margin-right:3px;margin-top:-5px;vertical-align:middle;border-radius:50%}.post-layout-1 .entry-header-outer{padding:30px 30px 20px}@media (max-width:767px){.post-layout-1 .entry-header-outer{padding:20px}}.post-layout-1 .entry-header{padding:0;margin:0}.featured-area{position:relative;margin-bottom:30px;line-height:1}@media (max-width:767px){.featured-area{margin-bottom:20px}}.featured-area img{width:100%}.single-featured-image{position:relative;margin:0;line-height:0}.post-bottom-meta-title{float:left;padding:0 6px;margin:5px 5px 0 0;background:#2c2f34;border:1px solid rgba(0,0,0,.1);border-radius:2px}.post-bottom-meta-title{color:#fff}.post-tags-modern .post-bottom-meta-title{display:none}.share-buttons{padding:18px 28px;line-height:0}@media (max-width:767px){.share-buttons{padding:15px}}@media (min-width:768px){.share-buttons-top{padding-bottom:0}}.entry-header-outer+.share-buttons-top{padding-top:0}.post-layout-1 .share-buttons-top{padding-bottom:18px}.share-buttons-mobile{position:fixed;bottom:0;z-index:999999;width:100%;background:0 0;border:0 none;padding:0}.share-buttons-mobile .share-links a{margin:0;border-radius:0;width:1%;display:table-cell;opacity:1!important}.share-buttons-mobile .share-links a .share-btn-icon{margin:0 auto;float:none}@media (min-width:768px){.share-buttons-mobile{display:none}}.mobile-share-buttons-spacer{height:40px}@media (min-width:768px){.mobile-share-buttons-spacer{display:none}}.share-links a{color:#fff}.share-links{overflow:hidden;position:relative}.share-links .share-btn-icon{font-size:15px}.share-links a{display:inline-block;margin:2px;height:40px;overflow:hidden;position:relative;border-radius:2px;width:40px}.share-links a,.share-links a:before{background-color:#444}.share-links a .share-btn-icon{width:40px;height:40px;float:left;display:block;text-align:center;line-height:40px}.share-links a.facebook-share-btn,.share-links a.facebook-share-btn:before{background:#4080ff}.share-links a.twitter-share-btn,.share-links a.twitter-share-btn:before{background:#40bff5}.share-links a.linkedin-share-btn,.share-links a.linkedin-share-btn:before{background:#238cc8}.share-links a.pinterest-share-btn,.share-links a.pinterest-share-btn:before{background:#e13138}.share-links a.reddit-share-btn,.share-links a.reddit-share-btn:before{background:#ff4500}.share-links a.tumblr-share-btn,.share-links a.tumblr-share-btn:before{background:#35465c}.share-links a.vk-share-btn,.share-links a.vk-share-btn:before{background:#45668e}.share-links a.odnoklassniki-share-btn,.share-links a.odnoklassniki-share-btn:before{background:#ee8208}.share-links a.pocket-share-btn,.share-links a.pocket-share-btn:before{background:#ef4056}.share-links a.whatsapp-share-btn,.share-links a.whatsapp-share-btn:before{background:#43d854}.share-links a.telegram-share-btn,.share-links a.telegram-share-btn:before{background:#08c}.share-links a.viber-share-btn,.share-links a.viber-share-btn:before{background:#773ead}@media (min-width:768px){a.whatsapp-share-btn,a.telegram-share-btn,a.viber-share-btn{display:none!important}}#related-posts .related-item{position:relative;float:left;width:33.333%;padding:0 15px;margin-bottom:20px}@media (max-width:767px){#related-posts .related-item{padding:0 8px}}#related-posts .related-item .post-thumb{margin-bottom:10px}#related-posts .related-item .post-title{font-size:14px;line-height:19px}#related-posts .related-item .post-meta{margin:4px 0 0}.has-sidebar .site-content #related-posts .related-item:nth-child(3n+1){clear:both}@media (max-width:767px){#related-posts .related-item{width:50%!important;clear:none!important}}#related-posts.has-extra-post .related-item:last-child{clear:none!important;display:none}@media only screen and (min-width:320px) and (max-width:767px){#related-posts.has-extra-post .related-item:last-child{display:block}}#cancel-comment-reply-link{float:right;line-height:18px}#reading-position-indicator{display:block;height:5px;position:fixed;bottom:0;left:0;background:var(--brand-color);box-shadow:0 0 10px rgba(0,136,255,.7);width:0;z-index:9999;max-width:100%}#check-also-box{position:fixed;background-color:#fff;z-index:999;bottom:15px;right:-1px;-webkit-transform:translatex(100%);-ms-transform:translatex(100%);transform:translatex(100%);width:340px;padding:30px;border:1px solid rgba(0,0,0,.1);border-radius:2px;border-top-right-radius:0;border-bottom-right-radius:0}#check-also-box .has-first-big-post .post-widget-body{clear:both}#check-also-box .posts-list-big-first li{padding-bottom:0}#check-also-box .posts-list-big-first li .post-title{font-size:18px;line-height:1.3em}@media (max-width:991px){#check-also-box{display:none}}#post-extra-info{display:none}#main-nav .main-menu>ul>li>a{text-transform:uppercase}.tie-cat-25{background-color:#9b59b6!important;color:#fff!important}.tie-cat-25:after{border-top-color:#9b59b6!important}@media (max-width:991px){.side-aside.dark-skin{background:#2f88d6;background:-webkit-linear-gradient(135deg,#5933a2,#2f88d6);background:-moz-linear-gradient(135deg,#5933a2,#2f88d6);background:-o-linear-gradient(135deg,#5933a2,#2f88d6);background:linear-gradient(135deg,#2f88d6,#5933a2)}}.lazyload{opacity:0}#amp-mobile-version-switcher{left:0;position:absolute;width:100%;z-index:100}#amp-mobile-version-switcher>a{background-color:#444;border:0;color:#eaeaea;display:block;font-family:-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif;font-size:16px;font-weight:600;padding:15px 0;text-align:center;-webkit-text-decoration:none;text-decoration:none}:root{--wpforms-field-border-radius:3px;--wpforms-field-background-color:#fff;--wpforms-field-border-color:rgba(0,0,0,.25);--wpforms-field-text-color:rgba(0,0,0,.7);--wpforms-label-color:rgba(0,0,0,.85);--wpforms-label-sublabel-color:rgba(0,0,0,.55);--wpforms-label-error-color:#d63637;--wpforms-button-border-radius:3px;--wpforms-button-background-color:#066aab;--wpforms-button-text-color:#fff;--wpforms-field-size-input-height:43px;--wpforms-field-size-input-spacing:15px;--wpforms-field-size-font-size:16px;--wpforms-field-size-line-height:19px;--wpforms-field-size-padding-h:14px;--wpforms-field-size-checkbox-size:16px;--wpforms-field-size-sublabel-spacing:5px;--wpforms-field-size-icon-size:1;--wpforms-label-size-font-size:16px;--wpforms-label-size-line-height:19px;--wpforms-label-size-sublabel-font-size:14px;--wpforms-label-size-sublabel-line-height:17px;--wpforms-button-size-font-size:17px;--wpforms-button-size-height:41px;--wpforms-button-size-padding-h:15px;--wpforms-button-size-margin-top:10px}
ASP.NET Access Veritabanı Bağlantısı (Select – Insert – Update -Delete) – Web Tasarım & Programlama - REDRA
Bu yazımızda ASP.NET Web Form ‘ da Access veritabanı bağlantısı yaparak Select – Insert – Update ve Delete sorgularının nasıl çalıştırılabileceğini gösteren bir örnek oluşturacağız.Örneğimizde verileri görüntülemek için GridView kontrolünden faydalanacağız. Verileri Ekleme, Güncelleme ve Silme işlemleri için ise TextBox kontrollerini kullanacağız. Ayrıca DataGrid üzerinde listelenen kayıtlardan seçili olan kaydın ilgili TextBox’ lara aktarılmasını da sağlayacağız.
Sayfamızda kullanacağımız veritabanı dosyamız dbOkul.accdb ve Tablomuz Ogrenci tablosu olacaktır. Ogrenci tablosuna ait alanları alttaki resimden görebilirsiniz.
Şimdi bu veritabanı dosyasını Websitemize dahil edelim. Bunun için ilk olarak Solution Explorer penceresinde Web Site üstünde sağ tıklayarak App_Data Klasörünü ekliyoruz. Daha sonra oluşturmuş olduğumuz Access veritabanı dosyamızı sürükle-bırak ya da Kopyala-Yapıştır yöntemiyle bu klasöre taşıyoruz.
Veritabanı dosyamız eklendikten sonra Solution Explorer pencersinin görünümü aşağıdaki gibi olacaktır.
Şimdi sayfamızı tasarlayabiliriz. Sayfamızın tasarımı aşağıdaki gibi olacaktır.
GridView kontrolünü biçimlendirmek için aşağıdaki yöntemi kullanabilirsiniz. GridView üstüne tıkladıktan sonra sağ üst köşedeki açılır pencere simgesine tıklayarak buradan AutoFormat ile istenen Format seçilebilir.
Sayfa tasarımına ait kodlarımız şu şekilde oluşacaktır.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
<% @ Page Language = “C#” AutoEventWireup = “true” CodeFile = “Default.aspx.cs” Inherits = “_Default” %>
<!DOCTYPE html>
<html xmlns = “http://www.w3.org/1999/xhtml” >
<head runat = “server” >
<title> </title>
<style type =”text/css”>
.auto-style1 {
width : 100% ;
}
.auto-style2 {
width : 72px ;
}
.auto-style3 {
width : 219px ;
}
</style>
</head>
<body>
<form id = “form1” runat = “server” >
<div>
<table class = “auto-style1” >
<tr>
<td class = “auto-style2” > No </td>
<td class = “auto-style3” >
<asp:TextBox ID = “TextBox1” runat = “server” > </asp:TextBox>
</td>
<td rowspan = “4” >
<asp:GridView ID = “GridView1” runat = “server”
AutoGenerateColumns = “False” CellPadding = “4” ForeColor = “#333333”
GridLines = “None” Height = “315px” Width = “578px” AutoGenerateSelectButton = “True” OnSelectedIndexChanged = “GridView1_SelectedIndexChanged” >
<AlternatingRowStyle BackColor = “White” />
<Columns>
<asp:BoundField DataField = “numara” HeaderText = “NUMARA” />
<asp:BoundField DataField = “ad” HeaderText = “AD” />
<asp:BoundField DataField = “soyad” HeaderText = “SOYAD” />
<asp:BoundField DataField = “puan” HeaderText = “PUAN” />
</Columns>
<EditRowStyle BackColor = “#7C6F57” />
<FooterStyle BackColor = “#1C5E55” Font-Bold = “True” ForeColor = “White” />
<HeaderStyle BackColor = “#1C5E55” Font-Bold = “True” ForeColor = “White” />
<PagerStyle BackColor = “#666666” ForeColor = “White” HorizontalAlign = “Center” />
<RowStyle BackColor = “#E3EAEB” />
<SelectedRowStyle BackColor = “#C5BBAF” Font-Bold = “True” ForeColor = “#333333” />
<SortedAscendingCellStyle BackColor = “#F8FAFA” />
<SortedAscendingHeaderStyle BackColor = “#246B61” />
<SortedDescendingCellStyle BackColor = “#D4DFE1” />
<SortedDescendingHeaderStyle BackColor = “#15524A” />
</asp:GridView>
</td>
</tr>
<tr>
<td class = “auto-style2” > Ad </td>
<td class = “auto-style3” >
<asp:TextBox ID = “TextBox2” runat = “server” > </asp:TextBox>
</td>
</tr>
<tr>
<td class = “auto-style2” > Soyad </td>
<td class = “auto-style3” >
<asp:TextBox ID = “TextBox3” runat = “server” > </asp:TextBox>
</td>
</tr>
<tr>
<td class = “auto-style2” > Puan </td>
<td class = “auto-style3” >
<asp:TextBox ID = “TextBox4” runat = “server” > </asp:TextBox>
</td>
</tr>
<tr>
<td class = “auto-style2” > </td>
<td class = “auto-style3” >
<asp:Button ID = “Button1” runat = “server” Text = “EKLE” OnClick = “Button1_Click” />
<asp:Button ID = “Button2” runat = “server” Text = “SİL” OnClick = “Button2_Click” />
<asp:Button ID = “Button3” runat = “server” Text = “GÜNCELLE” OnClick = “Button3_Click” />
</td>
<td> www.yazilimkodlama.com </td>
</tr>
</table>
</div>
</form>
</body>
</html>
Şimdi kodlarımızı yazmaya başlayacağız. Veritabanına bağlantı sağlamak için gerekli ConnectionString cümlesini WebConfig içinde yazarak başlayacağız. Bağlantı cümlesinin neden WebConfig içinde olması gerektiği, ne gibi faydalar sağlayacağı konusunu daha önce paylaşmıştık.
< configuration >
< connectionStrings >
< add name = “baglanti” connectionString = “Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|dbOkul.accdb” providerName = “System.Data.OleDb” / >
< / connectionStrings >
< system . web >
< compilation debug = “true” targetFramework = “4.5.2” / >
< httpRuntime targetFramework = “4.5.2” / >
< / system . web >
< / configuration >
Şimdi C# kontollerine geçiyoruz. Aşağıdaki kütüphanelerin projemiz için gerekli olduğunu belirtelim.
using System ;
using System . Collections . Generic ;
using System . Configuration ;
using System . Data ;
using System . Data . OleDb ;
using System . Linq ;
using System . Web ;
using System . Web . UI ;
using System . Web . UI . WebControls ;
Daha sonra Global olarak Bağlantımızı ve diğer veritabanı nesnelerimizi oluşturalım.
OleDbConnection con = new OleDbConnection ( ConfigurationManager . ConnectionStrings [ “baglanti” ] . ConnectionString ) ;
OleDbDataAdapter da ;
OleDbCommand komut ;
DataTable dt ;
Form yüklendiğinde GridView içine verilerimizin çekilmesini sağlayalım. Bunun için kodlarımızı Page_Load olayına yazmamız gerektiğini belirtelim.
protected void Page_Load ( object sender , EventArgs e )
{
string sorgu = “SELECT *FROM Ogrenci” ;
da = new OleDbDataAdapter ( sorgu , con ) ;
dt = new DataTable ( ) ;
con . Open ( ) ;
da . Fill ( dt ) ;
con . Close ( ) ;
GridView1 . DataSource = dt ;
GridView1 . DataBind ( ) ;
//www.yazilimkodlama.com
}
Şimdide TextBox’ lara girilen verilenin veritabanına kaydedilmesini ve GridView içinde görüntülenmesini sağlayacak kodlarımızı oluşturalım. Bunun için Ekle butonuna çift tıklayarak Button1_Click olayını kullanacağız.
protected void Button1_Click ( object sender , EventArgs e ) //Ekle
{
string sorgu = “INSERT INTO ogrenci (numara,ad,soyad,puan) VALUES (@num,@ad,@soyad,@puan)” ;
komut = new OleDbCommand ( sorgu , con ) ;
komut . Parameters . AddWithValue ( “@num” , TextBox1 . Text ) ;
komut . Parameters . AddWithValue ( “@ad” , TextBox2 . Text ) ;
komut . Parameters . AddWithValue ( “@soyad” , TextBox3 . Text ) ;
komut . Parameters . AddWithValue ( “@puan” , TextBox4 . Text ) ;
con . Open ( ) ;
komut . ExecuteNonQuery ( ) ;
con . Close ( ) ;
Response . Redirect ( “default.aspx” ) ;
}
Sırada Sil butonu için yazacağımız kodlar bulunmakta. Öğrenci numarasına göre seçilen kaydın silinmesini sağlayacak kodları aşağıdaki gibi oluşturalım. Burada şunu belirtelim. Sil ve Güncelle buttonlarının çalışabilmesi GridView üstünde seçilen kaydın TextBoxlara aktarımını sağlayacağız. Kodlarımızın devamında bu işlemin nasıl gerçekleştirildiğini göreceksiniz.
protected void Button2_Click ( object sender , EventArgs e ) //Sil
{
string sql = “Delete From ogrenci Where numara=@num” ;
komut = new OleDbCommand ( sql , con ) ;
komut . Parameters . AddWithValue ( “@num” , TextBox1 . Text ) ;
con . Open ( ) ;
komut . ExecuteNonQuery ( ) ;
con . Close ( ) ;
Response . Redirect ( “default.aspx” ) ;
}
Öğrenci numarasına göre ad,soyad ve puan bilgisinin güncellenmesini sağlayacak kodlarımız.
protected void Button3_Click ( object sender , EventArgs e ) //Güncelle
{
string sql = “Update ogrenci Set ad=@ad,soyad=@soyad,puan=@puan Where numara=@no” ;
komut = new OleDbCommand ( sql , con ) ;
komut . Parameters . AddWithValue ( “@ad” , TextBox2 . Text ) ;
komut . Parameters . AddWithValue ( “@soyad” , TextBox3 . Text ) ;
komut . Parameters . AddWithValue ( “@puan” , TextBox4 . Text ) ;
komut . Parameters . AddWithValue ( “@no” , TextBox1 . Text ) ;
con . Open ( ) ;
komut . ExecuteNonQuery ( ) ;
con . Close ( ) ;
Response . Redirect ( “default.aspx” ) ;
}
Son olarak GridView kontrolünde seçilen satırdaki bilgileri TextBox’ lara çekeceğiz bunun için GridView içinde her satırın soluna SelectButton eklememiz gerekiyor. Ekleme işlemini GridView üzerine tıkladıktan sonra Properties penceresine geçerek AutoGenerateSelectButton özelliğini True yaparak basit bir şekilde gerçekleştirebilirsiniz.
Şimdi de GridView üstünde her seçim yapıldığında TextBox’ lara aktarımı sağlayacak kodlarımızı yazalım. Burada Türkçe karakter sorununu ortadan kaldırmak için HttpUtility.HtmlDecode(……) şeklinde bir kullanım yapacağız.
protected void GridView1_SelectedIndexChanged ( object sender , EventArgs e ) //Seçileni Getir
{
TextBox1 . Text = HttpUtility . HtmlDecode ( GridView1 . SelectedRow . Cells [ 1 ] . Text ) ;
TextBox2 . Text = HttpUtility . HtmlDecode ( GridView1 . SelectedRow . Cells [ 2 ] . Text ) ;
TextBox3 . Text = HttpUtility . HtmlDecode ( GridView1 . SelectedRow . Cells [ 3 ] . Text ) ;
TextBox4 . Text = HttpUtility . HtmlDecode ( GridView1 . SelectedRow . Cells [ 4 ] . Text ) ;
}
Kodlarımızıda tamamlamış oluyoruz. Kodlarımızın tamamı ve ekran çıktısı şu şekilde oluşacaktır.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
using System ;
using System . Collections . Generic ;
using System . Configuration ;
using System . Data ;
using System . Data . OleDb ;
using System . Linq ;
using System . Web ;
using System . Web . UI ;
using System . Web . UI . WebControls ;
public partial class _Default : System . Web . UI . Page
{
OleDbConnection con = new OleDbConnection ( ConfigurationManager . ConnectionStrings [ “baglanti” ] . ConnectionString ) ;
OleDbDataAdapter da ;
OleDbCommand komut ;
DataTable dt ;
protected void Page_Load ( object sender , EventArgs e )
{
string sorgu = “SELECT *FROM Ogrenci” ;
da = new OleDbDataAdapter ( sorgu , con ) ;
dt = new DataTable ( ) ;
con . Open ( ) ;
da . Fill ( dt ) ;
con . Close ( ) ;
GridView1 . DataSource = dt ;
GridView1 . DataBind ( ) ;
//www.yazilimkodlama.com
}
protected void Button1_Click ( object sender , EventArgs e ) //Ekle
{
string sorgu = “INSERT INTO ogrenci (numara,ad,soyad,puan) VALUES (@num,@ad,@soyad,@puan)” ;
komut = new OleDbCommand ( sorgu , con ) ;
komut . Parameters . AddWithValue ( “@num” , TextBox1 . Text ) ;
komut . Parameters . AddWithValue ( “@ad” , TextBox2 . Text ) ;
komut . Parameters . AddWithValue ( “@soyad” , TextBox3 . Text ) ;
komut . Parameters . AddWithValue ( “@puan” , TextBox4 . Text ) ;
con . Open ( ) ;
komut . ExecuteNonQuery ( ) ;
con . Close ( ) ;
Response . Redirect ( “default.aspx” ) ;
}
protected void Button2_Click ( object sender , EventArgs e ) //Sil
{
string sql = “Delete From ogrenci Where numara=@num” ;
komut = new OleDbCommand ( sql , con ) ;
komut . Parameters . AddWithValue ( “@num” , TextBox1 . Text ) ;
con . Open ( ) ;
komut . ExecuteNonQuery ( ) ;
con . Close ( ) ;
Response . Redirect ( “default.aspx” ) ;
}
protected void GridView1_SelectedIndexChanged ( object sender , EventArgs e ) //Seçileni Getir
{
TextBox1 . Text = HttpUtility . HtmlDecode ( GridView1 . SelectedRow . Cells [ 1 ] . Text ) ;
TextBox2 . Text = HttpUtility . HtmlDecode ( GridView1 . SelectedRow . Cells [ 2 ] . Text ) ;
TextBox3 . Text = HttpUtility . HtmlDecode ( GridView1 . SelectedRow . Cells [ 3 ] . Text ) ;
TextBox4 . Text = HttpUtility . HtmlDecode ( GridView1 . SelectedRow . Cells [ 4 ] . Text ) ;
}
protected void Button3_Click ( object sender , EventArgs e ) //Güncelle
{
string sql = “Update ogrenci Set ad=@ad,soyad=@soyad,puan=@puan Where numara=@no” ;
komut = new OleDbCommand ( sql , con ) ;
komut . Parameters . AddWithValue ( “@ad” , TextBox2 . Text ) ;
komut . Parameters . AddWithValue ( “@soyad” , TextBox3 . Text ) ;
komut . Parameters . AddWithValue ( “@puan” , TextBox4 . Text ) ;
komut . Parameters . AddWithValue ( “@no” , TextBox1 . Text ) ;
con . Open ( ) ;
komut . ExecuteNonQuery ( ) ;
con . Close ( ) ;
Response . Redirect ( “default.aspx” ) ;
}
}
Örneği indirmek BURAYA tıklayın.
Başa dön tuşu