C# Database Operations (SQL) - Inserting Records & Listing in Datagridview
14,2bin14,2 bin izleme
Yayın tarihi 23 ağu 202023 ağu 2020
{"pages":{"search":{"query":"videoid:13368291794686933392","originalQuery":"","serpid":"1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","reqid":"1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","parentReqid":"","serpItems":[{"id":"13368291794686933392-0-0","type":"videoSnippet","props":{"videoId":"13368291794686933392"},"curPage":0}],"filters":{},"serpFooter":{"linksGroups":[{"type":"geo","links":[{"label":"Columbus","title":"Columbus","url":"//yandex.com.tr/tune/geo/","logNode":{"name":"region"},"target":"_self","a11yLabel":"Bölgeniz Columbus","needRetpath":true}]},{"type":"help","links":[{"label":"Bize ulaşın","url":"https://yandex.com.tr/support/video/troubleshooting.html","logNode":{"name":"feedback"},"needRetpath":true},{"label":"Yardım","url":"https://yandex.com.tr/support/video/","logNode":{"name":"help"},"needRetpath":true}]},{"type":"settings","links":[{"label":"Ayarlar","url":"https://yandex.com.tr/tune/search/","target":"_self","logNode":{"name":"settings"},"needRetpath":true}]},{"type":"company","links":[{"label":"Şirket hakkında","url":"//yandex.com.tr/company/","logNode":{"name":"about"},"target":"_blank"},{"label":"Kullanım lisansı","url":"//yandex.com.tr/legal/termsofuse/","logNode":{"name":"license"},"target":"_blank"},{"label":"Gizlilik Politikası","url":"//yandex.com.tr/legal/confidential/","logNode":{"name":"confidential"},"target":"_blank"}],"a11yHidden":true}],"hasExtralinks":true},"currentPage":0,"prevPageToLoad":-1,"nextPageToLoad":1,"isTranslationsFilterEnabled":false,"isTranslationsDistributionEnabled":false,"isTranslationsDistributionOnboardingEnabled":false,"isFeedbackModalVisible":false,"viewerData":{},"prevention":{},"hasNextPage":false,"rightSerpItems":[{"type":"direct","id":"search-list-right","props":{"advRsyaActivateParams":{"pcodeParams":{"blockId":"R-I-8843654-1","renderTo":"search-list-right-0-R-I-8843654-1","pageNumber":0,"grab":"dHZpZGVvaWQ6MTMzNjgyOTE3OTQ2ODY5MzMzOTIK","darkTheme":false,"lazyLoad":false,"extParams":{"reqid":"1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","ui":"desktop","yuid":"4772846701758761886"}}},"isAdult":false,"position":0,"placement":"search-list-right"},"curPage":0}],"quasarData":{"title":""},"isAdultQuery":false,"errorList":[],"layout":"list","retpath":"https%3A%2F%2Fyandex.com.tr%2Fvideo%2Fpreview%2F13368291794686933392"},"main":{"_isInitial":true,"snippets":[],"serpFooter":{"linksGroups":[]},"isLoggedIn":false,"tags":[]}},"internal":{"nonce":"0140734622094578357313","expFlags":{"video_depot_viewer":1,"video_instream_player_yaru_loader":1,"video_skeleton_doc_update":1,"velocity_delay_drawer":1,"video_instream_disable_hosts":"dzen.ru,ok.ru,vk.com,video.mail.ru","video_search_toggle_with_text":1,"video_single_vh_unmute":1,"video_update_d2d_after_clickout":1,"video_viewer_desktop_hide_tabs":1,"velocity_disable_suspense":1,"video_viewer_desktop_smart_layout":1,"dark_theme_desktop":"cookie","video_instream_player_config":{"vmapScenarioId":119,"category":2,"impId":7,"partnerId":2216089},"video_font_yandex_sans":1,"video_adv_new_show_rules":1,"video_resource_loader":1,"video_nohost_full_filter_onboarding_enable":1,"video_skeleton_direct_under_player_update":1,"video_instream_player_config_porno":{"vmapScenarioId":119,"category":3,"impId":4,"partnerId":1988486},"video_vh_player_js":0,"video_dzc":0,"video_masthead_ratio":"180,4","video_searchdata_scheme":1,"video_single_vh_iframe":1,"velocity_delay_metrika":1,"video_viewer_channel_link_mode":2,"video_viewer_desktop_visible_header":1,"video_partner_label":1,"video_direct_render_in_viewport":1,"video_skeleton_instream_update":1,"video_resource_loader_load_timeout":6000,"int_tr":1,"video_viewer_catch_sandbox_early_inits":1,"mmui_extended_escape_scheme":"searchdata.clips.0.authorname","tabs_order_version":"search,images,video,newstr,maps,translate,tr_ecom","spok":"id","video_suggest_use_serp":1,"video_search_grid_direct_repeat":6,"video_direct_config_desktop_search":"search-grid-row:R-I-48058-718:R-I-474674-109,search-grid-head:R-I-2120168-7","init_meta":{"ask-user-purchase-history":1,"use-src-videoquickp":1,"enable-begemot":1,"enable_masthead":1,"use-src-videop":1,"use-src-videoquickp_misspell":1,"enable_blackbox_multisession":1,"begemot-enable-cancelled-misspell-rtmr":1,"enable_video_iron_fetcher":1,"use-related-only":1,"ask-yandex-io-devices":1,"use-images-device-setup":1,"use-src-imagesp":1,"images-apphost-collections-front":1,"enable_aab_apphost":1,"graph-is-video-search":1,"use-src-imagesp_misspell":1,"use-src-imagesultrap":1,"use-video-apphost-pre-templates":1,"use-src-videop_misspell":1,"use-video-apphost-post-templates":1,"use-src-imagesquickp":1,"enable_video_carousels":"1","restrict-max-docs":"1000","use-images-region-setup":1,"use-post-auto2":1,"use-images-settings-setup":1,"use-src-ugc_favorites":1,"video_vitrina_disable":"0","use-images-user-setup":1,"use-video-pre-search-data":1,"begemot-no-suggest-history":1},"video_depot_viewer_masthead_ssr_only":1,"video_skeleton_direct_organic_update":1,"video_blender":1,"video_search_grid_enable":0,"video_viewer_desktop_fix_d2d_scroll":1,"video_depot_viewer_legacy_counters":1,"video_search_grid_direct_start":3,"video_instream_players_yaru_enable":1,"video_adv_new_show_rules_docs_count":1,"beauty_header_futuris_tab":9,"video_related_suggest_enable":1,"video_redirect_plug":2,"video_disable_serp_dzc":1,"video_direct_pos_id":"R-I-48058-73","dark_theme_desktop_default_pref":"system","video_search_toggle_enable":1,"video_viewer_desktop_blocks":1,"velocity_split_hydration":4,"video_duration_counter_new_format":1,"video_force_grid_on_premordie":1,"video_morda_header_nav":1,"video_nohost_full_filter":1,"video_baobab_blockstat":1,"video_thumb_poster_full":1,"video_scrollpages":2,"video_serp_desktop_block_design":1,"video_nohost_youtube_filter":0,"video_direct_pos":5,"video_viewer_host_link_mode":1,"video_direct_viewport_margin_desktop":700},"slots":["1368470,0,72;1357196,0,32;1361200,0,88;1371012,0,45;1365606,0,32;1367919,0,65;1370283,0,68;1152684,0,9;1363592,0,90;1362866,0,32;1358739,0,97;1002672,0,34;1369313,0,24;1363393,0,4;1365915,0,16;1353334,0,13;1368342,0,66;1361073,0,18;1359313,0,21;1357973,0,10;1361643,0,35;1353282,0,21;1365470,0,68;1362837,0,16;1360766,0,23;805351,0,81;1369346,0,66;1357212,0,15;90498,0,19;151171,0,84;1281084,0,24;1364340,0,10;287509,0,32;86180,0,72;785125,0,67"],"isYandexNet":false,"platform":"desktop","isEnLogo":true,"retpath":"https%3A%2F%2Fyandex.com.tr%2Fvideo%2Fpreview%2F13368291794686933392","mordaUrl":"//yandex.com.tr/","videoSearchUrl":"https://yandex.com.tr/video/search?text=C%23+Database+Operations+%28SQL%29+-+Inserting+Records+%26+Listing+in+Datagridview","settingsUrl":"https://yandex.com.tr/tune/search/","helpUrl":"https://yandex.com.tr/support/video/","legalUrl":"//legal.yandex.com.tr/termsofuse/","feedbackUrl":"https://yandex.com.tr/support/video/troubleshooting.html","basename":"/video","currentPageName":"previewShort","isYandexApp":false,"isYandexAppAndroid":false,"isYandexAppIos":false,"isAnyYaBro":false,"isAndroid":false,"isHamster":false,"serpid":"1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","backUrl":"//ya.ru","url":"https://yandex.com.tr/video/preview/13368291794686933392?","isIntegrationTest":false,"isEndToEndTest":false,"shouldDropLogs":false,"seo":{"url":"https://yandex.com.tr/video/preview/13368291794686933392","title":"C# Database Operations (SQL) - Inserting Records & Listing in Datagridview","description":"#CSharpTutorial #SqlTutorial #ComputerProgramming #CSharpAutomation #SoftwareCourse #Tutorial #Datab...","image":"http://avatars.mds.yandex.net/get-vthumb/2456245/4f7c93ab55335aa136471d213dc50e82/800x450","imageSecureUrl":"https://avatars.mds.yandex.net/get-vthumb/2456245/4f7c93ab55335aa136471d213dc50e82/800x450","video":"https://video-preview.s3.yandex.net/jJuDLwEAAAA.mp4","videoType":"video/mp4","imageWidth":800,"imageHeight":450,"type":"video"},"isEmbedded":false,"isPumpkin":false,"quasarCsrfToken":"yfa212a904065c307b06968d8537ec7c5","reportFeedbackBaseProps":{"initEmail":"","metaFields":{"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","userTestids":"1368470,1357196,1361200,1371012,1365606,1367919,1370283,1152684,1363592,1362866,1358739,1002672,1369313,1363393,1365915,1353334,1368342,1361073,1359313,1357973,1361643,1353282,1365470,1362837,1360766,805351,1369346,1357212,90498,151171,1281084,1364340,287509,86180,785125","queryText":"","reqid":"1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","userRegionName":"","userRegionId":"function() {\n return this._region.id;\n }","yandexuid":"4772846701758761886","uid":"0","isChildAccount":false}},"userTestids":"191768,238743,246500,253288,265553,270072,277807,274239,294077,278842,331010,338398,378416,359879,415420,644350,652605,645301,679708,689693,690449,696466,696473,722746,740796,776165,771230,781521,790415,801982,851450,886706,883477,900639,931367,937268,969063,935488,945314,989988,982463,991363,990185,1015567,1011895,1035320,1033956,1035241,1036046,1087297,1060131,1099741,1071879,1078818,1077703,1116602,1045814,1131637,1144233,1151726,1152703,1156933,1174275,1173000,1167408,1202006,1194718,1221235,1228280,1239596,1227266,1226860,1246754,1281110,1276447,1289213,1316370,1313283,1321224,1300570,1320679,1352408,1342688,1344637,1341968,1345362,1364920,1365535,1299604,1362866,1358739,1002672,90498","regionId":20815,"isYaRu":false,"shouldUnmountSearchPageInViewer":false,"videoGlobalContext":{"platform":"desktop","isPumpkin":false,"language":"tr","user_time":{"epoch":"1758761899","tz":"America/Louisville","to_iso":"2025-09-24T20:58:19-0400","__is_plain":1},"isQuasarEnabled":false,"isHermione":false,"shouldStubImages":true,"enableVideoPreviewInHermione":false,"reqid":"1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","tld":"com.tr","isEmbedded":false,"shouldShowMainPageButtonInViewer":false,"shouldDailyClickoutDzenInSerp":false,"shouldDailyClickoutDzenInViewer":false,"shouldDisableWebp":false,"removeLinkPrefix":"/video","shouldUseHighresPreview":true,"shouldCutSnippetTitle":true,"shouldShowPlusBadge":true,"reportFeedbackBaseProps":{"initEmail":"","metaFields":{"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","userTestids":"1368470,1357196,1361200,1371012,1365606,1367919,1370283,1152684,1363592,1362866,1358739,1002672,1369313,1363393,1365915,1353334,1368342,1361073,1359313,1357973,1361643,1353282,1365470,1362837,1360766,805351,1369346,1357212,90498,151171,1281084,1364340,287509,86180,785125","queryText":"","reqid":"1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","userRegionName":"","userRegionId":"function() {\n return this._region.id;\n }","yandexuid":"4772846701758761886","uid":"0","isChildAccount":false}},"deviceDetect":{"OSFamily":"Unknown","isTV":0,"x64":0,"GoogleToolBarVersion":"","MultiTouch":0,"BrowserBase":"","YandexBarVersion":"","isTablet":0,"YandexBar":0,"hasWebOmni":0,"isTouch":0,"hasYandexCamera":0,"isMobile":0,"DeviceKeyboard":"","device":"desktop","TurboAppPlatformVersion":"","historySupport":0,"BrowserShellVersion":"","DeviceVendor":"","isBrowser":0,"hasFlash":0,"MailRuSputnikVersion":"","isSameSiteSupported":0,"BrowserBaseVersion":"","BrowserVersionRaw":"","hasWebVert":0,"DeviceId":"","error":"","MailRuAgent":0,"ScreenWidth":0,"inAppBrowser":0,"hasHTML5":0,"isEmulator":0,"J2ME":0,"MailRuAgentVersion":"","BrowserEngineVersionRaw":"537.36","isRobot":1,"__is_plain":1,"BrowserEngineVersion":"0537.0036","BrowserName":"Unknown","DeviceModel":"","BrowserEngine":"WebKit","DeviceName":"","OSVersionRaw":"","OSName":"","GoogleToolBar":0,"ScreenSize":"","isTurboApp":0,"MailRuSputnik":0,"YaBuildName":"","isWAP":0,"PreferMobile":0,"DesktopMode":0,"BrowserVersion":"","BitsPerPixel":0,"BrowserShell":"","YaGUI":"","isBeta":0,"OSVersion":"","ScreenHeight":0},"nonce":"0140734622094578357313","disableDoc2DocHostLink":false,"shouldHideChannelLink":false,"disableChannelLink":false,"enableSlowBufferingAlert":false,"enableSlowBufferingAlertDedup":false,"userConnectionRtt":159,"visibleHeader":true,"hideTabs":true,"animated":false,"isServiceLikeViewer":false,"isDoc2DocScrollFix":true,"smartDesktopLayout":true,"enableVIImprovements":false,"isAdvDisabled":false,"shouldShowVideoPlaylistPane":false,"isVideoTranslationSupported":false,"isSummaryDisabled":false,"isSummaryOnlineEnabled":false,"isPlainHeader":false,"shouldRenderBroSummaryApiContainer":false,"shouldDropLogs":false,"shouldUseBeacon":false,"hasAdBlock":false,"isVerificationMarkDisabled":false,"shouldPlayNonStopForExternal":false,"forceSlowBufferingAlert":false,"rknWarnHosts":[""],"postInstreamScreenDuration":2000,"minVideoDurationForInstream":120,"isInstreamEnabledInTesting":false,"useSendBeacon":false,"isFinalHeartbeatDisabledInNoJsApi":false,"wildcard":true,"isAdvUnderPlayerRedesign":false,"disableEarlyEventsInD2d":false,"isDoc2DocInstantLoadEnabled":false,"disableEarlyEventsUnsubscribe":false,"showDebugRelatedURL":false,"shouldUseBetaErrorLogging":false,"shouldForceDarkTheme":false,"shouldShowMetaUnderPlayer":false,"isStickyPlayerDisabled":false,"isHeaderRedesign":false},"shouldShowAdvId":false,"isAdultQuery":false,"showSensitive":false,"shouldReplaceHref":false},"user":{"tld":"com.tr","isEuDomain":false,"login":"","passportId":"","isLoggedIn":false,"locationName":"Columbus","isFamily":false,"yandexuid":"4772846701758761886","ugcCsrfToken":"","family":1,"isChild":false},"config":{"skinMode":"system","skin":"light","version":"releases-frontend-video-v1.1677.0__788609c2008fc890171906004a33ed01cf98a527","isGridSupported":false,"advConfig":{"under-player":{"regular":{"default":"R-I-48058-725","mail":"R-A-13411721-6"},"adult":{"default":"R-I-474674-114","mail":"R-A-13426421-6"}},"under-player-lite":{"regular":{"default":"R-I-48058-728"},"adult":{"default":"R-I-474674-103"}},"under-player-old":{"regular":{"default":"R-I-48058-725","mail":"R-A-13411721-6"},"adult":{"default":"R-I-474674-114","mail":"R-A-13426421-6"}},"video-list":{"regular":{"default":"R-I-48058-708","mail":"R-A-13411721-2"},"adult":{"default":"R-I-474674-101","mail":"R-A-13426421-2"}},"search-list":{"regular":{"default":"R-I-48058-715","mail":"R-A-13411721-3"},"adult":{"default":"R-I-474674-108","mail":"R-A-13426421-3"}},"search-grid-row":{"regular":{"default":"R-I-48058-718","mail":"R-A-13411721-4"},"adult":{"default":"R-I-474674-109","mail":"R-A-13426421-4"}},"search-grid-head":{"regular":{"default":"R-I-2120168-7"}},"search-list-right":{"regular":{"default":"R-I-8843654-1"}},"before-player-old":{"regular":{"default":"R-I-2120168-1"}},"before-player":{"regular":{"default":"R-I-2120168-1"}}},"isSkinInitedOnClient":false},"counters":{"params":{"useBeacon":false,"clickHost":"yandex.com.tr/clck","pid":197},"dict":{"viewer":"2921","user":"538","info":"1275","sources":"1500","select":"775","close":"486","open":"842","source":"186","link":"513","click":"882","tech":"690","player":"1242","change":"719","summary":"3410","init":"1309","item":"22","button":"440","shown":"3780","copy":"1276","text":"232","load":"1724","fallback":"2010","channel":"1345","hide":"1656"}},"clips":{"items":{"13368291794686933392":{"videoId":"13368291794686933392","docid":"34-2-12-Z309F6F8AA4FA94AF","description":"#CSharpTutorial #SqlTutorial #ComputerProgramming #CSharpAutomation #SoftwareCourse #Tutorial #Database...","preview":{"posterSrc":"//avatars.mds.yandex.net/get-vthumb/2456245/4f7c93ab55335aa136471d213dc50e82/564x318_1","videoSrc":"https://video-preview.s3.yandex.net/jJuDLwEAAAA.mp4","videoType":"video/mp4"},"target":"_self","position":"0","reqid":"1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","summary":{"isFull":true,"fullTextUrl":"/video/result?ask_summarization=1&numdoc=1&noreask=1&nomisspell=1&parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&text=videoid:13368291794686933392","teaser":[{"list":{"type":"unordered","items":["Bu video, bir eğitim içeriği olup, izleyicilere C# ve SQL bağlantısı konusunda dördüncü dersi sunmaktadır.","Videoda, SQL Server'da \"üyeler\" adlı bir tablo oluşturma, C# Visual Studio'da Windows Form Application projesi oluşturma ve bu form üzerinde üye kayıt formu tasarımı anlatılmaktadır. Eğitmen, form üzerinde \"kaydet\" ve \"listele\" butonları ekleyerek, kullanıcıların ad-soyad, kullanıcı adı, şifre ve e-posta bilgilerini kaydetme ve Data Grid View nesnesi üzerinden listeleme işlemlerini adım adım göstermektedir. Video sonunda, bir sonraki derste arama butonu ekleme, güncelleme ve silme işlemlerinin yapılacağı belirtilmektedir."]},"endTime":831,"title":"C# ve SQL Bağlantısı Dersi: Üye Kayıt Formu Oluşturma","beginTime":0}],"fullResult":[{"index":0,"title":"C# ve SQL Bağlantısı Dersi Tanıtımı","list":{"type":"unordered","items":["Bu ders, C# ve SQL bağlantısı serisinin dördüncü bölümüdür.","Dersde C# form ekranında üye kayıt formu oluşturulacak ve eklenen üyeleri görüntülemek için DataGridview nesnesi kullanılacaktır.","Önceki derslere erişim için belirtilen kartlardan ulaşılabilir."]},"beginTime":7,"endTime":41,"href":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&t=7&ask_summarization=1"},{"index":1,"title":"SQL Server'da Tablo Oluşturma","list":{"type":"unordered","items":["SQL Server'da \"create database kayıt\" komutuyla yeni bir veritabanı oluşturuluyor.","\"create table üyeler\" komutuyla üyeler tablosu oluşturuluyor ve id (integer, primary key, identity), ad_soyad (nvarchar 50), kullanıcı_adı (nvarchar 50), şifre (char 50) ve email (char 50) sütunları ekleniyor.","Tabloya bir varsayılan değer eklendiği için, eklenen değerler otomatik olarak sıralanacaktır."]},"beginTime":41,"endTime":178,"href":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&t=41&ask_summarization=1"},{"index":2,"title":"Visual Studio'da Form Uygulaması Oluşturma","list":{"type":"unordered","items":["Visual Studio'da yeni bir Windows Form Application projesi oluşturuluyor ve proje adı \"kullanıcı listeleme\" olarak belirleniyor.","Form tasarımı oluşturuluyor ve listeleme butonu ekleniyor.","Kullanıcı kaydetmek için yeşil arka planlı \"kaydet\" butonu ekleniyor."]},"beginTime":178,"endTime":334,"href":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&t=178&ask_summarization=1"},{"index":3,"title":"Veritabanı Bağlantısı ve Kayıt Ekleme","list":{"type":"unordered","items":["Kod kısmında \"using System.Data.SqlClient\" kütüphanesi ekleniyor.","Veritabanına bağlantı için \"Add New Data Source\" seçeneği kullanılarak SQL Server'a eklenen tablolar projeye import ediliyor.","Bağlantı dizesi oluşturuluyor ve SQL Connection nesnesi ile bağlantı kuruluyor."]},"beginTime":334,"endTime":442,"href":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&t=334&ask_summarization=1"},{"index":4,"title":"Kayıt Ekleme İşlemi","list":{"type":"unordered","items":["Kaydet butonuna tıklandığında try-catch bloğu içinde kayıt ekleme işlemi yapılıyor.","Bağlantı kapalıysa \"baglan.Open()\" ile açılıyor.","\"INSERT INTO üyeler\" sorgusu kullanılarak textboxlardan alınan değerler veritabanına ekleniyor."]},"beginTime":442,"endTime":627,"href":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&t=442&ask_summarization=1"},{"index":5,"title":"Verileri Listeleme","list":{"type":"unordered","items":["\"kayıtları_getir\" adlı fonksiyon tanımlanarak verileri listeleme işlemi yapılıyor.","\"SELECT * FROM üyeler\" sorgusu kullanılarak veriler getiriliyor.","DataAdapter ve DataTable nesneleri kullanılarak veriler DataGridview'e dolduruluyor."]},"beginTime":627,"endTime":707,"href":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&t=627&ask_summarization=1"},{"index":6,"title":"Uygulamanın Test Edilmesi","list":{"type":"unordered","items":["Uygulama çalıştırılarak ad soyad, kullanıcı adı, şifre ve email adresi bilgileri giriliyor.","Kaydet butonuna tıklandığında veriler veritabanına ekleniyor.","Listele butonuna tıklandığında eklenen veriler DataGridview'da görüntüleniyor."]},"beginTime":707,"endTime":757,"href":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&t=707&ask_summarization=1"}],"linkTemplate":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&t=%%timestamp%%&ask_summarization=1"},"isAdultDoc":false,"relatedParams":{"text":"C# Database Operations (SQL) - Inserting Records & Listing in Datagridview","related_orig_text":"","related_porno":false,"related_short":true,"related_less_3m_off":true,"client":"d2d","no_cnt":1,"related_src":"serp","related":"{\"porno\":false,\"vfp\":1,\"orig_text\":\"\",\"url\":\"http:\\/\\/www.youtube.com\\/watch?v=bDekJXuoMq8\",\"src\":\"serp\",\"rvb\":\"EhYKFDEzMzY4MjkxNzk0Njg2OTMzMzkyGhYKFDEzMzY4MjkxNzk0Njg2OTMzMzkyWhQxMzM2ODI5MTc5NDY4NjkzMzM5MmrgBBIBMBgAIkUaMQAKKmhodm1qYWxwdWdyemZ2cWRoaFVDQm1qVjFyd1AyWDV2eE1ybFh5VGtzdxICABIqEMIPDxoPPxO_BoIEJAGABCsqiwEQARp4gQYFCvr_AgD1CAD9DAL-AAwA-_r3AAAA8gD5DQUC_wDzAAAH_gAAAAH8-P__AAAA_fj3Avv-AAAG8gkAAwAAABzwAgH6AAAADAH5Awj_AQHtCAL6AgAAAAX6Cvz_AAAAFwb9__7__wAKAAABAAAAAPvz-_kAAAAAIAAtVsrWOzgTQAlITlACKoQCEAAa8AFWDw_-AMwqAcsR5QDPH_gAge0c_yQT5gDA8goAwRzwANcHCgD97xP_5RoR_5QEJAHuAt3-QC_2APn7Iv8rEvwBGBD3ASLY9QE6DPAA6RP1_-QBNv4mz-0BQgYOAUcY8v7xExUA3wTu_9TX7AD6FhkC7jAXA0gO7fv4-Bz_9BkJ_vH2BALy9v7-7Qf2AuwJAQQMEN7_LCQH_f37-wc7EOX_CgAIBR_cLvsZC_j4wPkI_MgI7gD18_UG_PcM_RAKGgIFChEKFuf2AvMn8fY15_D-ARj7-CLp-Afx8f_04goF_eYMEPjbI_0EDPwC5_j_BPkgAC1BWiU7OBNACUhhUAIqcxAAGmAC5wA8-ALY3v8kFsXn6v_YyNAONqwL_-XV_7Qy5_Dg__OdJvD_SgcUFZgAAAAS_Mn-IAAcf8LC5y_KQvPnmiAe_GUL2jm0KR382eVoFtEIx9rWNUAA5ee4Czjd2EVO8wggAC3flxA7OBNACUhvUAIwCTgBSgBgAGgA\"}","related_url":"http://www.youtube.com/watch?v=bDekJXuoMq8","parent-reqid":"1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","related_vfp":1,"relatedVideo":"yes"},"cwidth":1280,"cheight":720,"cratio":1.77777,"dups":["13368291794686933392"],"episode":0,"season":0,"isEmbedOnly":false,"greenHost":"YouTube","hasTranslation":true,"contentTypeId":null}},"dups":{"13368291794686933392":{"videoId":"13368291794686933392","title":"C# Database Operations (SQL) - Inserting Records & Listing in Datagridview","cleanTitle":"C# Database Operations (SQL) - Inserting Records & Listing in Datagridview","host":{"title":"YouTube","href":"http://www.youtube.com/live/bDekJXuoMq8","playerUri":"\u003ciframe src=\"//www.youtube.com/embed/bDekJXuoMq8?enablejsapi=1&wmode=opaque\" frameborder=\"0\" scrolling=\"no\" allowfullscreen=\"1\" allow=\"autoplay; fullscreen; accelerometer; gyroscope; picture-in-picture\" aria-label=\"Video\">\u003c/iframe>","playerId":"youtube","providerName":"youtube.com","sourceHost":"www.youtube.com","name":"youtube.com","secondPart":{"type":"CHANNEL","id":"d3d3LnlvdXR1YmUuY29tO1VDQm1qVjFyd1AyWDV2eE1ybFh5VGtzdw==","name":"Aykut Şahin","isVerified":false,"subscribersCount":0,"url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDQm1qVjFyd1AyWDV2eE1ybFh5VGtzdw%3D%3D&how=tm&text=Aykut+%C5%9Eahin","origUrl":"http://www.youtube.com/@aykutsahiin","a11yText":"Aykut Şahin. "},"faviconUrl":"//favicon.yandex.net/favicon/v2/http%3A%2F%2Fyoutube.com?color=255%2C255%2C255%2C0&size=32&stub=1"},"duration":{"value":831,"text":"13:51","a11yText":"Süre 13 dakika 51 saniye"},"views":{"text":"14,2bin","shouldShowInSnippet":true,"a11yText":"14,2 bin izleme"},"date":"23 ağu 2020","modifyTime":1598140800000,"isExternal":false,"shouldShowQuasar":false,"player":{"embedUrl":"https://www.youtube.com/embed/bDekJXuoMq8?autoplay=1&enablejsapi=1&wmode=opaque","playerId":"youtube","videoUrl":"http://www.youtube.com/watch?v=bDekJXuoMq8","reqid":"1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","duration":831},"parentClipId":"13368291794686933392","href":"/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","rawHref":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","isEmbedOnly":false,"shouldPlayInstreamPreroll":false}}},"viewer":{"_isInitial":false,"clips":{"items":{"13368291794686933392":{"videoId":"13368291794686933392","docid":"34-2-12-Z309F6F8AA4FA94AF","description":"#CSharpTutorial #SqlTutorial #ComputerProgramming #CSharpAutomation #SoftwareCourse #Tutorial #Database...","preview":{"posterSrc":"//avatars.mds.yandex.net/get-vthumb/2456245/4f7c93ab55335aa136471d213dc50e82/564x318_1","videoSrc":"https://video-preview.s3.yandex.net/jJuDLwEAAAA.mp4","videoType":"video/mp4"},"target":"_self","position":"0","reqid":"1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","summary":{"isFull":true,"fullTextUrl":"/video/result?ask_summarization=1&numdoc=1&noreask=1&nomisspell=1&parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&text=videoid:13368291794686933392","teaser":[{"list":{"type":"unordered","items":["Bu video, bir eğitim içeriği olup, izleyicilere C# ve SQL bağlantısı konusunda dördüncü dersi sunmaktadır.","Videoda, SQL Server'da \"üyeler\" adlı bir tablo oluşturma, C# Visual Studio'da Windows Form Application projesi oluşturma ve bu form üzerinde üye kayıt formu tasarımı anlatılmaktadır. Eğitmen, form üzerinde \"kaydet\" ve \"listele\" butonları ekleyerek, kullanıcıların ad-soyad, kullanıcı adı, şifre ve e-posta bilgilerini kaydetme ve Data Grid View nesnesi üzerinden listeleme işlemlerini adım adım göstermektedir. Video sonunda, bir sonraki derste arama butonu ekleme, güncelleme ve silme işlemlerinin yapılacağı belirtilmektedir."]},"endTime":831,"title":"C# ve SQL Bağlantısı Dersi: Üye Kayıt Formu Oluşturma","beginTime":0}],"fullResult":[{"index":0,"title":"C# ve SQL Bağlantısı Dersi Tanıtımı","list":{"type":"unordered","items":["Bu ders, C# ve SQL bağlantısı serisinin dördüncü bölümüdür.","Dersde C# form ekranında üye kayıt formu oluşturulacak ve eklenen üyeleri görüntülemek için DataGridview nesnesi kullanılacaktır.","Önceki derslere erişim için belirtilen kartlardan ulaşılabilir."]},"beginTime":7,"endTime":41,"href":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&t=7&ask_summarization=1"},{"index":1,"title":"SQL Server'da Tablo Oluşturma","list":{"type":"unordered","items":["SQL Server'da \"create database kayıt\" komutuyla yeni bir veritabanı oluşturuluyor.","\"create table üyeler\" komutuyla üyeler tablosu oluşturuluyor ve id (integer, primary key, identity), ad_soyad (nvarchar 50), kullanıcı_adı (nvarchar 50), şifre (char 50) ve email (char 50) sütunları ekleniyor.","Tabloya bir varsayılan değer eklendiği için, eklenen değerler otomatik olarak sıralanacaktır."]},"beginTime":41,"endTime":178,"href":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&t=41&ask_summarization=1"},{"index":2,"title":"Visual Studio'da Form Uygulaması Oluşturma","list":{"type":"unordered","items":["Visual Studio'da yeni bir Windows Form Application projesi oluşturuluyor ve proje adı \"kullanıcı listeleme\" olarak belirleniyor.","Form tasarımı oluşturuluyor ve listeleme butonu ekleniyor.","Kullanıcı kaydetmek için yeşil arka planlı \"kaydet\" butonu ekleniyor."]},"beginTime":178,"endTime":334,"href":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&t=178&ask_summarization=1"},{"index":3,"title":"Veritabanı Bağlantısı ve Kayıt Ekleme","list":{"type":"unordered","items":["Kod kısmında \"using System.Data.SqlClient\" kütüphanesi ekleniyor.","Veritabanına bağlantı için \"Add New Data Source\" seçeneği kullanılarak SQL Server'a eklenen tablolar projeye import ediliyor.","Bağlantı dizesi oluşturuluyor ve SQL Connection nesnesi ile bağlantı kuruluyor."]},"beginTime":334,"endTime":442,"href":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&t=334&ask_summarization=1"},{"index":4,"title":"Kayıt Ekleme İşlemi","list":{"type":"unordered","items":["Kaydet butonuna tıklandığında try-catch bloğu içinde kayıt ekleme işlemi yapılıyor.","Bağlantı kapalıysa \"baglan.Open()\" ile açılıyor.","\"INSERT INTO üyeler\" sorgusu kullanılarak textboxlardan alınan değerler veritabanına ekleniyor."]},"beginTime":442,"endTime":627,"href":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&t=442&ask_summarization=1"},{"index":5,"title":"Verileri Listeleme","list":{"type":"unordered","items":["\"kayıtları_getir\" adlı fonksiyon tanımlanarak verileri listeleme işlemi yapılıyor.","\"SELECT * FROM üyeler\" sorgusu kullanılarak veriler getiriliyor.","DataAdapter ve DataTable nesneleri kullanılarak veriler DataGridview'e dolduruluyor."]},"beginTime":627,"endTime":707,"href":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&t=627&ask_summarization=1"},{"index":6,"title":"Uygulamanın Test Edilmesi","list":{"type":"unordered","items":["Uygulama çalıştırılarak ad soyad, kullanıcı adı, şifre ve email adresi bilgileri giriliyor.","Kaydet butonuna tıklandığında veriler veritabanına ekleniyor.","Listele butonuna tıklandığında eklenen veriler DataGridview'da görüntüleniyor."]},"beginTime":707,"endTime":757,"href":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&t=707&ask_summarization=1"}],"linkTemplate":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL&t=%%timestamp%%&ask_summarization=1"},"isAdultDoc":false,"relatedParams":{"text":"C# Database Operations (SQL) - Inserting Records & Listing in Datagridview","related_orig_text":"","related_porno":false,"related_short":true,"related_less_3m_off":true,"client":"d2d","no_cnt":1,"related_src":"serp","related":"{\"porno\":false,\"vfp\":1,\"orig_text\":\"\",\"url\":\"http:\\/\\/www.youtube.com\\/watch?v=bDekJXuoMq8\",\"src\":\"serp\",\"rvb\":\"EhYKFDEzMzY4MjkxNzk0Njg2OTMzMzkyGhYKFDEzMzY4MjkxNzk0Njg2OTMzMzkyWhQxMzM2ODI5MTc5NDY4NjkzMzM5MmrgBBIBMBgAIkUaMQAKKmhodm1qYWxwdWdyemZ2cWRoaFVDQm1qVjFyd1AyWDV2eE1ybFh5VGtzdxICABIqEMIPDxoPPxO_BoIEJAGABCsqiwEQARp4gQYFCvr_AgD1CAD9DAL-AAwA-_r3AAAA8gD5DQUC_wDzAAAH_gAAAAH8-P__AAAA_fj3Avv-AAAG8gkAAwAAABzwAgH6AAAADAH5Awj_AQHtCAL6AgAAAAX6Cvz_AAAAFwb9__7__wAKAAABAAAAAPvz-_kAAAAAIAAtVsrWOzgTQAlITlACKoQCEAAa8AFWDw_-AMwqAcsR5QDPH_gAge0c_yQT5gDA8goAwRzwANcHCgD97xP_5RoR_5QEJAHuAt3-QC_2APn7Iv8rEvwBGBD3ASLY9QE6DPAA6RP1_-QBNv4mz-0BQgYOAUcY8v7xExUA3wTu_9TX7AD6FhkC7jAXA0gO7fv4-Bz_9BkJ_vH2BALy9v7-7Qf2AuwJAQQMEN7_LCQH_f37-wc7EOX_CgAIBR_cLvsZC_j4wPkI_MgI7gD18_UG_PcM_RAKGgIFChEKFuf2AvMn8fY15_D-ARj7-CLp-Afx8f_04goF_eYMEPjbI_0EDPwC5_j_BPkgAC1BWiU7OBNACUhhUAIqcxAAGmAC5wA8-ALY3v8kFsXn6v_YyNAONqwL_-XV_7Qy5_Dg__OdJvD_SgcUFZgAAAAS_Mn-IAAcf8LC5y_KQvPnmiAe_GUL2jm0KR382eVoFtEIx9rWNUAA5ee4Czjd2EVO8wggAC3flxA7OBNACUhvUAIwCTgBSgBgAGgA\"}","related_url":"http://www.youtube.com/watch?v=bDekJXuoMq8","parent-reqid":"1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","related_vfp":1,"relatedVideo":"yes"},"cwidth":1280,"cheight":720,"cratio":1.77777,"dups":["13368291794686933392"],"episode":0,"season":0,"isEmbedOnly":false,"greenHost":"YouTube","hasTranslation":true,"contentTypeId":null}},"dups":{"13368291794686933392":{"videoId":"13368291794686933392","title":"C# Database Operations (SQL) - Inserting Records & Listing in Datagridview","cleanTitle":"C# Database Operations (SQL) - Inserting Records & Listing in Datagridview","host":{"title":"YouTube","href":"http://www.youtube.com/live/bDekJXuoMq8","playerUri":"\u003ciframe src=\"//www.youtube.com/embed/bDekJXuoMq8?enablejsapi=1&wmode=opaque\" frameborder=\"0\" scrolling=\"no\" allowfullscreen=\"1\" allow=\"autoplay; fullscreen; accelerometer; gyroscope; picture-in-picture\" aria-label=\"Video\">\u003c/iframe>","playerId":"youtube","providerName":"youtube.com","sourceHost":"www.youtube.com","name":"youtube.com","secondPart":{"type":"CHANNEL","id":"d3d3LnlvdXR1YmUuY29tO1VDQm1qVjFyd1AyWDV2eE1ybFh5VGtzdw==","name":"Aykut Şahin","isVerified":false,"subscribersCount":0,"url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDQm1qVjFyd1AyWDV2eE1ybFh5VGtzdw%3D%3D&how=tm&text=Aykut+%C5%9Eahin","origUrl":"http://www.youtube.com/@aykutsahiin","a11yText":"Aykut Şahin. "},"faviconUrl":"//favicon.yandex.net/favicon/v2/http%3A%2F%2Fyoutube.com?color=255%2C255%2C255%2C0&size=32&stub=1"},"duration":{"value":831,"text":"13:51","a11yText":"Süre 13 dakika 51 saniye"},"views":{"text":"14,2bin","shouldShowInSnippet":true,"a11yText":"14,2 bin izleme"},"date":"23 ağu 2020","modifyTime":1598140800000,"isExternal":false,"shouldShowQuasar":false,"player":{"embedUrl":"https://www.youtube.com/embed/bDekJXuoMq8?autoplay=1&enablejsapi=1&wmode=opaque","playerId":"youtube","videoUrl":"http://www.youtube.com/watch?v=bDekJXuoMq8","reqid":"1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","duration":831},"parentClipId":"13368291794686933392","href":"/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","rawHref":"/video/preview/13368291794686933392?parent-reqid=1758761899547309-3014073462209457835-balancer-l7leveler-kubr-yp-klg-313-BAL","isEmbedOnly":false,"shouldPlayInstreamPreroll":false}},"loadingStatus":"None"},"internal":{"videoId":"13368291794686933392","sandboxEventPrefix":"sandbox:","sandboxVersion":"0x586eab788cc","isHermione":false,"isEmbedded":false,"from":"yavideo","service":"ya-video","hbPeriod":30,"table":"video_tech","isInstreamDisabled":true,"nonce":"0140734622094578357313","errorList":[],"isAdultAdv":false,"isImportantCommonAdv":false,"shouldShowAdvId":false,"advConfig":{"under-player":{"regular":{"default":"R-I-48058-725","mail":"R-A-13411721-6"},"adult":{"default":"R-I-474674-114","mail":"R-A-13426421-6"}},"under-player-lite":{"regular":{"default":"R-I-48058-728"},"adult":{"default":"R-I-474674-103"}},"under-player-old":{"regular":{"default":"R-I-48058-725","mail":"R-A-13411721-6"},"adult":{"default":"R-I-474674-114","mail":"R-A-13426421-6"}},"video-list":{"regular":{"default":"R-I-48058-708","mail":"R-A-13411721-2"},"adult":{"default":"R-I-474674-101","mail":"R-A-13426421-2"}},"search-list":{"regular":{"default":"R-I-48058-715","mail":"R-A-13411721-3"},"adult":{"default":"R-I-474674-108","mail":"R-A-13426421-3"}},"search-grid-row":{"regular":{"default":"R-I-48058-718","mail":"R-A-13411721-4"},"adult":{"default":"R-I-474674-109","mail":"R-A-13426421-4"}},"search-grid-head":{"regular":{"default":"R-I-2120168-7"}},"search-list-right":{"regular":{"default":"R-I-8843654-1"}},"before-player-old":{"regular":{"default":"R-I-2120168-1"}},"before-player":{"regular":{"default":"R-I-2120168-1"}}},"shouldValidateSandbox":false,"sandboxInitTimeout":15000,"isSSROnlyMastheadEnabled":true,"queryUriEscaped":"videoid%3A13368291794686933392","filterMode":1,"isUserChild":false,"advInstreamConfig":{"regular":{"default":{"category":"2","impId":"7","partnerId":"2216089","vmapScenarioId":"119"}},"adult":{"default":{"category":"3","impId":"4","partnerId":"1988486","vmapScenarioId":"119"}}}},"playbackQueue":{"currentIndex":0,"items":[{"type":"VIDEO","videoId":"13368291794686933392","source":"serp","selectEvent":"click"}]},"related":{"items":[],"pages":[],"loadingStatus":"None","nextPageNum":0,"ncrnd":0},"playlist":{"items":{}}}}