![Dex Code Lab](/img/default-banner.jpg)
- Видео 22
- Просмотров 58 512
Dex Code Lab
США
Добавлен 20 июн 2020
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.
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
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.
Download the 32-bit version and install it using quiet in command prompt, please check the complete video for the process.
Thanku bro this solution is best one
You're welcome
Amazing thanks for your labor and solution. !!! We are excitedly waiting for content.
Thankyou for liking the content, will try to upload more helpful content in future
How can I import data with more than one file to more than one table??
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.
nice job! thanks for doing this.
My pleasure!
thank you it worked
Glad it helped
Very good explanation. Short and clear.
Glad you liked it
Thank you very much!
You're welcome sir
Thank you so much
You're welcome sir
Please make an video of. Net core web api, entity frame work sql server
Sir you want web api tutorial? Ok i will try to create a small web api crud tutorial.
that was perfect
Thankyou sir
Very good video, really understood. data can be saved very 👍👍👍👍
Thank you sir
Thank you very much! Finally, thanks to your video tutorial, I understood this topic!)
You're welcome. Glad it helped!
how to change it to Net core web APi
Sure, i will try to make a video for this
@@dexcodelab thank you
welcome sir, New video with API is uploaded
Please make video for bulk insert from excel to sql server like 1m row insert at one click
That sounds good! I'll keep it in mind for future content.
Thank u man keep going!
You're welcome
thanks you for tutorial ^^
You're welcome 😊
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.
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?
thank you so much
You're welcome! 😊
is it possible this excel file display gridview and store database (without EF and migration)
Yes you can do it by using ADO.NET (you will be writing sql queries in this case)
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!
Ok sir I will try
Is it possible to do a project without entity framework and without migration? It would be very helpful if possible. Please in details..
You can use ADO.NET and write sql queries in your c# code to insert data in database.
Can you do a video about export excel file from db?
I don't promise but i will try
I am getting an error can you please help me with that error 🙏
Where are you getting the error?
@@dexcodelab during the database app user creation
Can you please share the exact error?
Is it with the validation too
Validation of?
@@dexcodelab SQL data types
Can you please share the exact error?
Nice explanation..very useful
Thank you sir
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?
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.
i love the music
Thanks 🥰
This code allow to save on database?
No sir, it only reads the excel file and display it.
@@dexcodelab Thanks!, if You have time could You add feature to save into database using EF Netcore 7?, 🙃
@@KevinMoralesP Sure Sir, It will be uploaded soon
@@KevinMoralesP I have created and uploaded the tutorial you requested. I hope you will find it helpful.
@@dexcodelab thanks so much!!! I Will see now
if i have looping. can i show the data that currently process to the caption section ?
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.
I will really appreciate is you write down the link to download the Solution Explorer, thank you.
Noted sir, from now on I'll try to upload solution as well.
Thanks for help
Welcome sir
i still get the same problem
That's sad, for migration it is the only library needed
Thanks
Welcome
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?
You might have missed the dll, copy all dlls to the published directory
How can i hide ID(First Column) from this SearchLookUpEdit Popup?
In the properties find the item properties
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?
I recently used it with 4.8 it worked.. you get the same issue?
YOU JUST SAVE ME A FEW HOURS OF LIFE!!!! THANK YOU SO FCKN MUCH. I ALREADY SPEND ABOUT 5HOURS ......TO FIX IT... FINAALLYYY
Welcome sir
Brabo!
😊
Gracias
😊
this video help me so much when i load form in vb not c# but it can help too. thank.
Thanks alot
how to solve when sqlite (database is locked) when we add/delete/update data into database. please help if you can. thanks.
Ok I'll try to upload a complete tutorial on using sqlite with c# windows form
thank you
Welcome
what’s version of that camtasia?
2019
Excelente explicación
Thanks
Thx bro!!
Welcome
how change animation in Accordion Control <<< And change Animation for any control via devexpress
Never did such thing, sorry.
how handle this type exception error????
I hope this will help stackoverflow.com/questions/18392364/why-is-the-project-unable-to-find-a-file-that-is-right-beneath-its-nose
\Rectangle Blue.ico' for file 'Rectangle Blue.ico', located in '[TARGETDIR]', the file may be absent or locked
I hope this will help. stackoverflow.com/questions/18392364/why-is-the-project-unable-to-find-a-file-that-is-right-beneath-its-nose
Very Nice thank you sir, I use visualbasic, from time to time can you make videos for the visualbasic community?
Yes, soon
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
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"
Thank you i'will try
Welcome