Dex Code Lab
Dex Code Lab
  • Видео 22
  • Просмотров 58 512
String Comparison Performance C#
how to compare strings case insensitive. This video contains tutorial that will help you comapre string comparsion in c# using three different techniques. The result is compared using benchmark library and is also shown and explained in the video.
Please like the video and subscribe my channel for more helpful programming tutorials.
Просмотров: 26

Видео

Fixing 'Microsoft.ACE.OLEDB.12.0' Provider Issue
Просмотров 118Месяц назад
In this video, I will show you how to fix the "'Microsoft.ACE.OLEDB.12.0' provider is not registered on local machine" error. This error commonly occurs when trying to Import or Export data from Access database or Excel file to a SQL Server. Follow the steps in this video to resolve this issue quickly and easily. Steps Covered: Downloading the necessary Microsoft Access Database Engine. Install...
How to Import data from Microsoft Excel into Microsoft SQL Server
Просмотров 90Месяц назад
In this video, we'll have a look at how to import data from Excel into SQL Server. 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. ruclips.net/video/byYkPzdESeI/видео.html
How to Export Data from SQL Server to Excel | Export Table Records to Excel
Просмотров 59Месяц назад
In this video you will learn how to export SQL server table records to a Excel sheet. Visit the following link if you are getting this error "The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on local machine" ruclips.net/video/byYkPzdESeI/видео.html How to export data from SQL Server to Microsoft Excel ruclips.net/video/PgREGRUEdCw/видео.html
Sql Server 'Saving changes is not permitted'
Просмотров 11Месяц назад
SQL Server Management Studio (SSMS) Saving changes is not permitted. Thr changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.
How to enable CORS in .NET Core Web API (Blocked by CORS Policy. No 'Access-Control-Allow-Origin')
Просмотров 3613 месяца назад
What is CORS? How to enable CORS in ASP .NET Core? How to enable CORS in ASP .NET Core Web API? What is the concept of Same-Origin Policy? Why is CORS necessary in Web APIs? Explain the concept of Same-Origin Policy and how CORS mitigates its limitations. How does CORS work? How does the browser handle CORS requests? How do you handle CORS in a microservices architecture? What are the differenc...
Change Layout of ASP Net Core MVC Web Application
Просмотров 4924 месяца назад
In this video we are going to understand how we can change layout page in ASP .Net Core MVC Web Application. Layout page is the master page containing common HTML of all pages throughtout the application. Layout page mostly includes Navigation Controls, Header, Footer and reference to stylesheets and script files. I will demonstrate you how you can build a project from scratch and take a new th...
How to install PostgreSQL on Windows 11 | Table Creation using pgAdmin 2024
Просмотров 3804 месяца назад
00:00 Introduction 00:18 Download PostgreSQL 00:54 Install PostgreSQL 02:24 Open pgAdmin 02:55 Create database in PostgreSQL using pgAdmin 03:15 Create table in PostgresSQL using pgAdmin 04:34 Inset data in table 05:05 Retrieve data form PostgreSQL database In this video I am going to demonstrate that how to download and install PostgreSQL in windows 11 machine step by step. We will go through ...
Import Excel Data to SQL Server Database using ASP .Net Core Web API and Entity Framework
Просмотров 1,6 тыс.5 месяцев назад
In this tutorial I have created ASP .Net Core Web Web API to uploaded excel file to the server and then insert the content of excel file to Microsoft SQL Server Database. ExcelDataReader nuget package is used to read the excel file. 00:00 - Introduction 00:21 - Create Project 01:30 - Install nuget packages 02:22 - Database Connectivity and Models 05:34 - Run Migration 06:41 - Create Controller ...
How to Import Data from Excel File to Database Table Using ASP.NET Core and Entity Framework
Просмотров 10 тыс.10 месяцев назад
Import Data from Excel File to Database Table Using ASP.NET Core 7 and Entity Framework 0:00 - Introduction 1:45 - Installing Packages 3:32 - Database Configuration 8:44 - Running Migrations 12:22 - Creating View and Uploading File 17:21 - Installing 'ExcelDataReader' Package 18:48 - Insert Data in Database 22:44 - Showing Success Message/Alert BuyMeCoffee www.buymeacoffee.com/techieboy8080 Git...
Uploading, Reading and Displaying Excel File using ASP .Net Core
Просмотров 8 тыс.Год назад
Uploading, Reading and Displaying Excel File using ASP .Net Core 0:00 - Introduction 0:16 - Create Project 1:22 - Create a View 4:46 - Upload File 7:52 - Read Excel File 10:12 - Displaying Data in View 12:08 - no data is available for encoding 1252. for information on defining a custom encoding, see the documentation for the encoding.registerprovider method 13:09 - Final output BuyMeCoffee www....
The term 'add-migration' is not recognized as the name of a cmdlet
Просмотров 6 тыс.2 года назад
If you get this type of error during migration like add-migration migration_name is not recognized as the name of cmdlet. You can easily solved that problem by using this package. Microsoft.EntityFrameworkCore.Tools add-migration : The term 'add-migration' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was incl...
Unable to load DLL SQLite.Interop.dll
Просмотров 16 тыс.3 года назад
Trying to connect SQLite database with a c# .Net application in Visual Studios 2019 with the following error System.DllNotFoundException: 'Unable to load DLL 'SQLite.Interop.dll': The specific module could not be found. (Exception from HRESULT: 0x8007007E)' System.BadImageFormatException: 'An attempt was made to load a program with an incorrect format.'
DevExpress Winforms Accordion Control
Просмотров 3,3 тыс.3 года назад
DevExpress Winforms Accordion Control Accordion Control is a modern NavBar (Navigation Bar) Control of Dev Express. It has some advanced features than of NavBar. Please like and subscribe to DexCodeLab for more informative videos
DevExpress WinForms: Wait Form and Splash Screen Manager
Просмотров 6 тыс.3 года назад
DevExpress WinForms: Wait Form and Splash Screen Manager
Navigate from one screen to another in Flutter
Просмотров 923 года назад
Navigate from one screen to another in Flutter
How to hide Camtasia from taskbar while screen recording
Просмотров 1,8 тыс.3 года назад
How to hide Camtasia from taskbar while screen recording
DevExpress LookUpEditControl Populate a LookUpEdit Control from SQL Server Database
Просмотров 4,4 тыс.4 года назад
DevExpress LookUpEditControl Populate a LookUpEdit Control from SQL Server Database
How to Change the Theme of Android Studio
Просмотров 214 года назад
How to Change the Theme of Android Studio
2 - Structure of Android Project - Android Kotlin Tutorial for Beginners - Dex Code Lab
Просмотров 204 года назад
2 - Structure of Android Project - Android Kotlin Tutorial for Beginners - Dex Code Lab
1 - Creating Project in Android Studio - Android Kotlin Tutorial for Beginners - Dex Code Lab
Просмотров 474 года назад
1 - Creating Project in Android Studio - Android Kotlin Tutorial for Beginners - Dex Code Lab

Комментарии

  • @yuanlinpan5619
    @yuanlinpan5619 18 дней назад

    Every time I hit enter, a window just pop out asking if I want to allow this app to make changes to my device rather than install the database engine directly. And if I clicked "yes", another error message will show up said "You cannnot install the 32 bit version of Microsoft Access DatabaseEngine 2016 because you currently have 64-bit Office products installed.If you want to install 32-bit Microsoft Access Database Engine 2016, youwill first need to remove the 64-bit installation of Office products. Afteruninstalling the following product(s),rerun setup in order to install32-bit version of Microsoft Access Database Engine 2016:Microsoft Access database engine 2016 (English), Office 16 Click-to-RunExtensibility Component" Is there any way to solve this? Many thanks.

    • @dexcodelab
      @dexcodelab 17 дней назад

      Download the 32-bit version and install it using quiet in command prompt, please check the complete video for the process.

  • @CyberCopgyan
    @CyberCopgyan 2 месяца назад

    Thanku bro this solution is best one

  • @namessis
    @namessis 2 месяца назад

    Amazing thanks for your labor and solution. !!! We are excitedly waiting for content.

    • @dexcodelab
      @dexcodelab 2 месяца назад

      Thankyou for liking the content, will try to upload more helpful content in future

  • @randnas
    @randnas 3 месяца назад

    How can I import data with more than one file to more than one table??

    • @dexcodelab
      @dexcodelab 3 месяца назад

      First make the html input tag to select multiple files. Second convert IFormFile to List<IFormFile> files. Then loop through files and perform import operation on each file.

  • @juliuszhu9123
    @juliuszhu9123 3 месяца назад

    nice job! thanks for doing this.

  • @Kirubelzerihun-jj1ek
    @Kirubelzerihun-jj1ek 3 месяца назад

    thank you it worked

  • @pamodpeiris154
    @pamodpeiris154 4 месяца назад

    Very good explanation. Short and clear.

    • @dexcodelab
      @dexcodelab 4 месяца назад

      Glad you liked it

  • @hieuang79
    @hieuang79 4 месяца назад

    Thank you very much!

    • @dexcodelab
      @dexcodelab 4 месяца назад

      You're welcome sir

  • @pitchapornkeenaphn1639
    @pitchapornkeenaphn1639 4 месяца назад

    Thank you so much

    • @dexcodelab
      @dexcodelab 4 месяца назад

      You're welcome sir

  • @informer9261
    @informer9261 4 месяца назад

    Please make an video of. Net core web api, entity frame work sql server

    • @dexcodelab
      @dexcodelab 4 месяца назад

      Sir you want web api tutorial? Ok i will try to create a small web api crud tutorial.

  • @myti1617
    @myti1617 5 месяцев назад

    that was perfect

  • @bipinlal1724
    @bipinlal1724 6 месяцев назад

    Very good video, really understood. data can be saved very 👍👍👍👍

  • @olegpogorelov5223
    @olegpogorelov5223 6 месяцев назад

    Thank you very much! Finally, thanks to your video tutorial, I understood this topic!)

    • @dexcodelab
      @dexcodelab 6 месяцев назад

      You're welcome. Glad it helped!

  • @Sameyo_Rei
    @Sameyo_Rei 6 месяцев назад

    how to change it to Net core web APi

    • @dexcodelab
      @dexcodelab 6 месяцев назад

      Sure, i will try to make a video for this

    • @Sameyo_Rei
      @Sameyo_Rei 6 месяцев назад

      @@dexcodelab thank you

    • @dexcodelab
      @dexcodelab 5 месяцев назад

      welcome sir, New video with API is uploaded

  • @user-gm9kv9cw8j
    @user-gm9kv9cw8j 8 месяцев назад

    Please make video for bulk insert from excel to sql server like 1m row insert at one click

    • @dexcodelab
      @dexcodelab 5 месяцев назад

      That sounds good! I'll keep it in mind for future content.

  • @ekremozafsar2875
    @ekremozafsar2875 8 месяцев назад

    Thank u man keep going!

  • @hoangheo2505
    @hoangheo2505 9 месяцев назад

    thanks you for tutorial ^^

    • @dexcodelab
      @dexcodelab 9 месяцев назад

      You're welcome 😊

  • @sunnyafran415
    @sunnyafran415 9 месяцев назад

    I can't add import excel file to datagridview then save to database at the same project, you have uploaded two different tutorials ,please give a tutorial import excel file display DataGridView and save to database in same project without migration, please it's urgent.

    • @dexcodelab
      @dexcodelab 9 месяцев назад

      Sorry, i have a busy schedule these days, once i will find time i will do it. Do you want it done with db first approach?

  • @braveexcel6122
    @braveexcel6122 9 месяцев назад

    thank you so much

    • @dexcodelab
      @dexcodelab 9 месяцев назад

      You're welcome! 😊

  • @sunnyafran415
    @sunnyafran415 9 месяцев назад

    is it possible this excel file display gridview and store database (without EF and migration)

    • @dexcodelab
      @dexcodelab 9 месяцев назад

      Yes you can do it by using ADO.NET (you will be writing sql queries in this case)

    • @sunnyafran415
      @sunnyafran415 9 месяцев назад

      If you have time could you please add feature to save to database without EF and without migration (dynamic excel file not static like this tutorial). Please!

    • @dexcodelab
      @dexcodelab 4 месяца назад

      Ok sir I will try

  • @sunnyafran415
    @sunnyafran415 9 месяцев назад

    Is it possible to do a project without entity framework and without migration? It would be very helpful if possible. Please in details..

    • @dexcodelab
      @dexcodelab 9 месяцев назад

      You can use ADO.NET and write sql queries in your c# code to insert data in database.

  • @bruhmanbruhmanzz
    @bruhmanbruhmanzz 10 месяцев назад

    Can you do a video about export excel file from db?

    • @dexcodelab
      @dexcodelab 9 месяцев назад

      I don't promise but i will try

  • @tharun4939
    @tharun4939 10 месяцев назад

    I am getting an error can you please help me with that error 🙏

    • @dexcodelab
      @dexcodelab 10 месяцев назад

      Where are you getting the error?

    • @tharun4939
      @tharun4939 10 месяцев назад

      @@dexcodelab during the database app user creation

    • @dexcodelab
      @dexcodelab 10 месяцев назад

      Can you please share the exact error?

  • @tharun4939
    @tharun4939 10 месяцев назад

    Is it with the validation too

    • @dexcodelab
      @dexcodelab 10 месяцев назад

      Validation of?

    • @tharun4939
      @tharun4939 10 месяцев назад

      @@dexcodelab SQL data types

    • @dexcodelab
      @dexcodelab 10 месяцев назад

      Can you please share the exact error?

  • @raziuddinmohd
    @raziuddinmohd 10 месяцев назад

    Nice explanation..very useful

  • @brunomasullo
    @brunomasullo 10 месяцев назад

    Congratulations! This video is very good...however my "xlsx" file is very large and for some reason the function reader.GetValue().ToString(); returns null. Do you know how to solve this problem?

    • @dexcodelab
      @dexcodelab 10 месяцев назад

      Thanks for liking my video, if you have multiple sheets in excel file then try moving the target data on first sheet or delete all other sheets.

  • @Mosca_Tube
    @Mosca_Tube 11 месяцев назад

    i love the music

  • @KevinMoralesP
    @KevinMoralesP 11 месяцев назад

    This code allow to save on database?

    • @dexcodelab
      @dexcodelab 11 месяцев назад

      No sir, it only reads the excel file and display it.

    • @KevinMoralesP
      @KevinMoralesP 11 месяцев назад

      @@dexcodelab Thanks!, if You have time could You add feature to save into database using EF Netcore 7?, 🙃

    • @dexcodelab
      @dexcodelab 11 месяцев назад

      @@KevinMoralesP Sure Sir, It will be uploaded soon

    • @dexcodelab
      @dexcodelab 11 месяцев назад

      @@KevinMoralesP I have created and uploaded the tutorial you requested. I hope you will find it helpful.

    • @KevinMoralesP
      @KevinMoralesP 11 месяцев назад

      @@dexcodelab thanks so much!!! I Will see now

  • @7kusanagi673
    @7kusanagi673 11 месяцев назад

    if i have looping. can i show the data that currently process to the caption section ?

    • @dexcodelab
      @dexcodelab 11 месяцев назад

      Yes you can change the caption in loop, but these changes will not reflect on UI if you are not using any background threading mechanism. To relect changes you have to use threads and update ui properly.

  • @Romanceenmelodias
    @Romanceenmelodias Год назад

    I will really appreciate is you write down the link to download the Solution Explorer, thank you.

    • @dexcodelab
      @dexcodelab Год назад

      Noted sir, from now on I'll try to upload solution as well.

  • @A-Studio7
    @A-Studio7 Год назад

    Thanks for help

  • @beliz7256
    @beliz7256 Год назад

    i still get the same problem

    • @dexcodelab
      @dexcodelab Год назад

      That's sad, for migration it is the only library needed

  • @fernandoreyes7335
    @fernandoreyes7335 Год назад

    Thanks

  • @codyomeara
    @codyomeara Год назад

    During development mine works fine, however when I publish the project then setup and run it, the published project runs into this error. Any ideas?

    • @dexcodelab
      @dexcodelab Год назад

      You might have missed the dll, copy all dlls to the published directory

  • @krishnalive2501
    @krishnalive2501 Год назад

    How can i hide ID(First Column) from this SearchLookUpEdit Popup?

    • @dexcodelab
      @dexcodelab 10 месяцев назад

      In the properties find the item properties

  • @zachb4436
    @zachb4436 2 года назад

    I cant downgrade my .net to 4.6, i need to keep it at 4.7.2 Any workaround on the second error, loading the program in an incorrect format?

    • @dexcodelab
      @dexcodelab 10 месяцев назад

      I recently used it with 4.8 it worked.. you get the same issue?

  • @damonuga666
    @damonuga666 2 года назад

    YOU JUST SAVE ME A FEW HOURS OF LIFE!!!! THANK YOU SO FCKN MUCH. I ALREADY SPEND ABOUT 5HOURS ......TO FIX IT... FINAALLYYY

  • @leomotaisilva
    @leomotaisilva 2 года назад

    Brabo!

  • @jordanalbarracin3119
    @jordanalbarracin3119 2 года назад

    Gracias

  • @cambodeeritnews5629
    @cambodeeritnews5629 2 года назад

    this video help me so much when i load form in vb not c# but it can help too. thank.

  • @cambodeeritnews5629
    @cambodeeritnews5629 2 года назад

    how to solve when sqlite (database is locked) when we add/delete/update data into database. please help if you can. thanks.

    • @dexcodelab
      @dexcodelab 2 года назад

      Ok I'll try to upload a complete tutorial on using sqlite with c# windows form

  • @flicksonj
    @flicksonj 2 года назад

    thank you

  • @crovux1761
    @crovux1761 2 года назад

    what’s version of that camtasia?

  • @raulbalbuena
    @raulbalbuena 2 года назад

    Excelente explicación

  • @pablomonzon6251
    @pablomonzon6251 3 года назад

    Thx bro!!

  • @technologybeat1186
    @technologybeat1186 3 года назад

    how change animation in Accordion Control <<< And change Animation for any control via devexpress

    • @dexcodelab
      @dexcodelab 10 месяцев назад

      Never did such thing, sorry.

  • @chandrushekhar4738
    @chandrushekhar4738 3 года назад

    how handle this type exception error????

    • @dexcodelab
      @dexcodelab 3 года назад

      I hope this will help stackoverflow.com/questions/18392364/why-is-the-project-unable-to-find-a-file-that-is-right-beneath-its-nose

  • @chandrushekhar4738
    @chandrushekhar4738 3 года назад

    \Rectangle Blue.ico' for file 'Rectangle Blue.ico', located in '[TARGETDIR]', the file may be absent or locked

    • @dexcodelab
      @dexcodelab 3 года назад

      I hope this will help. stackoverflow.com/questions/18392364/why-is-the-project-unable-to-find-a-file-that-is-right-beneath-its-nose

  • @niggeljkd
    @niggeljkd 3 года назад

    Very Nice thank you sir, I use visualbasic, from time to time can you make videos for the visualbasic community?

  • @niggeljkd
    @niggeljkd 3 года назад

    Thank you very much for your kindness, I was waiting for this for a long time, but how would the code be modified so that the child elements are enabled or disabled according to a condition (if the data found is true it is activated, if it is false it is deactivated) , go ahead with your channel, there are not many who teach about devexpress greetings my friend

    • @dexcodelab
      @dexcodelab 3 года назад

      After 04:30 mins check out like no 28, replace that line with this code if (accordionElement.Text == "Child 1") accordionElement.Enabled = false; This will disable Button with text "Child 1"

    • @niggeljkd
      @niggeljkd 3 года назад

      Thank you i'will try

    • @dexcodelab
      @dexcodelab 3 года назад

      Welcome