ProgrammingTuts

SQL Insert, Select, Update and Delete Statements | SQL CRUD in C# In this tutorial we're going see how to perform basic CRUD operations using SQL Queries, Statements in C# How to Insert data into SQL database? How to Update SQL database? How to Delete data in SQL database? How to Read SQL database? #SQLCRUDOperations #SQLQueries

Welcome SQL Server Tutorial Using C# | Create SQL database using C# | SQL C# | C# SQL In this tutorial we're going to see how to connect to SQL Server and create a SQL server database from scratch using C# and SQL statements. Feel free to drop questions or suggestions down below. How To Create a Database in SQL server using C# from scratch? How Connect to SQL server in C#? SQL Server Connection SQL Statement to Create a database SQL Connection String SQL Query to connect to SQL server SQL Query to create database #SQLServer #SQLQuery-Statement #CreateDatabase

Welcome To C# -SQL Server Tutorial | Create Table in SQL Server | SQL query to create table In this tutorial, we're going to see how to create a database table in SQL server using the "CREATE TABLE[tablename] ([column_name datatype constraints],..." query. Any questions please drop in comments section. How to Create Database Table Using C# in Visual Studio? How To Create a table in SQL Server? SQL Query to Create a Table? SQL Statement to Create a Table? #SQLServer #SQLQuery #CreateTable

CSV, TXT Files in Excel | Working with data in Excel | Import and Export Excel provides great tools to work with data. If you find yourself working with data this video should shed some light on some of the things you could do with excel to mold the data.. I appreciate the comments and whether you find this helpful information. Thanks How to Import CSV file to Excel? How to Import Text file to Excel? How to Import TSV file to Excel? How to Export CSV file from Excel? How to Export TXT file from Excel? How to Export TSV file from Excel? How to Convert CSV file to text file? How to Convert CSV file to TSV file? How to Convert CSV file to XML file? How to Convert TXT, TSV file to XML file? How to Convert a table to range? How to remove table format in Excel? #CSVFile #TextFile #Excel2019 #TSVFile

WPF | SQLite | Connect To SQLite and Display data in ListBox , Datagrid In this tutorial we're going to see how to connect to SQLite database and read data from the database. We will be using Entity Framework to accomplish this but you can also use previous methods shown in my other tutorials. This tutorial both C# and XAML. How to Connect To SQLite database in WPF? How to display SQLite database in a Listbox in WPF? How to display SQLite database in a Datagrid in WPF? SQLite Connection String How to use SQLite in WPF Project? How to Connect to SQLite Database using Entity Framework in WPF #WPF #SQLite #EntityFramework

How to import XML Data into Excel Spreadsheet, Worksheet? How to convert XML to XLS, XLSX? How to save XML data as excel workbook? How to convert XML file to EXCEL file? How to Open XML in Excel? How to read XML using Microsoft Excel? How to Export Excel Spreadsheet to XML (Part 2) XML to Excel Excel to XML Import XML to Excel Export Excel to XML #XMLtoExcel #ExceltoXML #ImportExportXML #ConvertingXMLtoSpreadsheet #ConvertingExcelWorksheetToXML

How to import XML Data into Excel Spreadsheet, Worksheet? (Part 1) How to save XML data as excel workbook? How to convert XML file to EXCEL file? How to Open XML in Excel? How to read XML using Microsoft Excel? How to Export Excel Spreadsheet to XML (Part 2) How to convert XLS, XLSX to XML file? XML to Excel Excel to XML Import XML to Excel Export Excel to XML #XMLtoExcel #ExceltoXML #ImportExportXML #ConvertingXMLtoSpreadsheet #ConvertingExcelWorksheetToXML

Welcome To SQLite Tutorials | From SQLite to XML | From XML to SQLite In this part we're going to try answer questions like with a few lines of code: How to convert SQLite database to XML file? How to convert XML file to SQLite database? Enjoy..Any questions? please drop in comments section #System.Data.Sqlite #SQLite #XMLfile #CSharp #EF #.NET Framework #Entity Framework On YouTube: https://youtu.be/bhAwEa93EhY code link: https://crudzone.wordpress.com/sqlite/

Welcome to SQLite Tutorial | SQLite with Entity Framework in C# In this episode we're going to cover How to connect SQLite database and perform CRUD (Create, Read, Update and Delete) operations using Entity Framework in C#. The best thing we're going to accomplish this without using and 3rd party API other than SQLite Nuget Package #SQLiteAndCSharp #SQLiteAndEntityFramework #EntityFramework How to connect to SQLite Database How to connect to SQLite using C# How to connect to SQLite using Entity Framework How to perform SQLite CRUD operations using Entity Framework in C# link to code: https://crudzone.wordpress.com/sqlite/

Welcome To SQLite Tutorials | From SQLite to CSV | From CSV to SQLite In this part we're going to try answer questions like with a few lines of code: How to convert SQLite database to CSV file? How to convert CSV file to SQLite database? Enjoy..Any questions? please drop in comments section #System.Data.Sqlite #SQLite #CSV file #CSharp #EF #.NET Framework #Entity Framework

SQLite Tutorial In this part, we are going to look into how to read SQLite database by using SELECT FROM statement in C#. #SQLite #SelectFromStatement #SQLiteDataReader #SQLiteCommand #SQLiteConnection How to read SQLite data using SELECT statement in C#?

SQLite Tutorial using C# In the first part we've seen how to create a sqlite table using a Firefox add on SQLite reader tool to create table, to add, delete and update rows. In this part, we're going to see how to create a SQLite database, add a table to the database, add rows to the table created and then delete and update rows using C# in visual studio. How to create SQLite Database using C#? How to add table to SQLite Database in C#? How add rows to SQLite table in C#? How add , delete and update rows in SQLite table using C#? CRUD operation in SQLite using C# SQLite INSERT INTO statement SQLite DELETE FROM statement SQLite UPDATE statement SQLite CREATE TABLE statement #SQLite-C# #SQLiteConnection #SQLiteDatabase #SQLiteTable https://youtu.be/ipIqZL9Szew

SQLite Tutorial In this part, we're going to talk about "what is SQLite", "How to use SQLite", "when to use SQLite" etc. Then, we're going to see how to create a SQLite table , how to add rows, how to delete rows, how to update rows, how to read the table and so on using a Firefox Add-on tool called SQLite Reader. In a nutshell SQLite is single file full database. Its extremely portable, fast, easy to use, serverless and ACID compliant. #SQLite #CreateTable #InsertInto #DeleteFrom #UpdateSet #What is SQLite? #Why SQLite? #How to use SQLite? #Where to use SQLite? #CRUD in SQLite How to create a table in SQLite? How to add rows? How to delete rows? How to delete a table? How to update a row? How to read, display rows? https://youtu.be/mU8yn7PUtBE

Welcome to WPF Tutorials | RichTextBox in WPF This is part six of the Flow Document Series and part threeof the RichTextBox tutorial. In this part, we're going see how to save the content of our RichTextBox as .TXT, .XAML and .RTF file formats. https://crudzone.wordpress.com/wpf-controls-menu/ the complete code will follow at the end of RichTextBox tutorial. #SavingRichTextBoxContent #.TXT,.XAML,.RTF File Formats #How to create, use RichTextBox #ApplicationCommands #EditingCommands

Welcome to WPF Tutorials | RichTextBox in WPF In this part, we're going to check out the Rich Text Box as the last wrapper for Flow Documents. RichTextBox differs from other wrappers by providing Read and Write feature whereas all others are read only wrappers. Most of the code used in this tutorial is almost same as previous tutorials which is posted at following link https://crudzone.wordpress.com/wpf-controls-menu/ the complete code will follow at the end of RichTextBox tutorial. #RichTextBoxInWPF #How to create, use RichTextBox https://youtu.be/8JwNgSgaRvU

Welcome to WPF Tutorials | RichTextBox in WPF This is part five of the Flow Document Series and part two of the RichTextBox tutorial. In this part, we're going to turn Rich TextBox into a text editor such as WordPad application that can be found on your windows machine. We're going to see how to use built in Application Commands and Editing Commands such as Copy, Paste, FontSize, Bullet List, Number List etc along the way.. https://crudzone.wordpress.com/wpf-controls-menu/ the complete code will follow at the end of RichTextBox tutorial. #RichTextBoxInWPF #How to create, use RichTextBox #ApplicationCommands #EditingCommands

Welcome to WPF Tutorials | Documents in WPF | FlowDocument in WPF In this part ,we're going to see a few ways to convert WPF Flow Documents to PDF files..Mostly XAML with a chance of C# . Same applies to Fixed Documents as well. #ConvertingDocumentsToPDF #HowToConvertFixedDocumentToPDF? #HowToConvertFlowDocumentToPDF? #How to create PDF file in WPF? #Convert to PDF file using C# #WPFtoPDF Link to Code: https://crudzone.wordpress.com/wpf-controls-menu/

Welcome to WPF Tutorials ~ Documents in WPF ~ FlowDocument in WPF Flow documents in WPF are built similar to html pages. Flow documents are hosted by a few types of wrappers or document types ie FlowDocumentPageViewer, FlowDocumentScrollViewer, FlowDocumentReader and RichTextBox. A flow document added inside the wrapper and then the content added to the flow document in forms of paragraphs, lists, tables, BlockUIContainers so on.. In this part, we're going to see Figure, Floater, Span , Run and more and some of the key properties associated..enjoy What is a Flow Document? How to create Flow Document? What's the difference between flow document and fixed document? How to use a flow document? What type of flow documents? What are the common document types?

Welcome to WPF Tutorials ~ Documents in WPF ~ FlowDocument in WPF Flow documents in WPF are built similar to html pages. Flow documents are hosted by a few types of wrappers or document types ie FlowDocumentPageViewer, FlowDocumentScrollViewer, FlowDocumentReader and RichTextBox. A flow document added inside the wrapper and then the content added to the flow document in forms of paragraphs, lists, tables, BlockUIContainers so on.. What is a Flow Document? How to create Flow Document? What's the difference between flow document and fixed document? How to use a flow document? What type of flow documents? What are the common document types?

Welcome to WPF Tutorials ~ Documents in WPF ~ FixedDocument In this tutorial we're going to talk about FixedDocument in WPF. How to create and how to use it via XAML and Code Behind. FixedDocument can only have PageContent as child element and PageContent can only have FixedPage as a child. Whereas Fixed page can have UIelements as children. Beyond this basic visual tree structure, Fixed Document can also be hosted in DocumentViewer and so on. This also ties into printing, which provides a convenient way to setup up your pages and print as you wish.. Link to the code can be found at https://crudzone.wordpress.com/wpf-controls-menu/

Welcome to WPF Tutorials | Data Grid in WPF | How to Delete Datagrid Rows In this part of WPF Datagrid series, we're going to cover how to delete a row and update the source file which is a CSV file with new data. We'll be using PreviewKeyDown Event along with a new method to accomplish the task. We'll be using mostly C# code with a tiny bit of XAML in VS2019. Hope it helps with your learning.. This tutorial will include C# and XAML goodness. #How to create Datagrid in WPF #How to Use Datagrid in WPF #How to bind to Datagrid #Data binding to Datagrid #Row details in Datagrid #How to create datagrid programmatically #How to create datagrid using C# #how to create datagrid dynamically #how to create datagrid on the fly #How to add rows in datagrid #How t o update rows in datagrid #how to remove rows in datagrid #how to delete rows in datagrid Feel free to drop your thoughts, comments and questions down below https://crudzone.wordpress.com/wpf/

Welcome to WPF Tutorials ~Data Grid in WPF In this part of our Datagrid in WPF series, which will probably be our last tutorial on datagrid, we're going to add search, filtering functionality to our application via Textbox_TextChanged event.. As well as, we're going create a datagrid programmatically on the fly using C# code. This tutorial will include C# and XAML goodness. #How to create Datagrid in WPF #How to Use Datagrid in WPF #How to bind to Datagrid #Data binding to Datagrid #Row details in Datagrid #How to create datagrid programmatically #How to create datagrid using C# #how to create datagrid dynamically #how to create datagrid on the fly #How to search data in datagrid #How to filter datagrid data, records #Filtering data in WPF Please drop questions, comments and ideas down below in comments Thanks.. https://crudzone.wordpress.com/wpf/

Welcome to WPF Tutorials ~ Data Grid in WPF | How to update rows | How to update records | How to update data In this part, we're going to Update a record using our custom datagrid. We'll be using the same event as in previous part -RowEditEnding- which fires when Enter key pressed or when you tab thru until you reach the last column. We're going to add a new method that will interact with the .CSV file when updating it. This corresponds to the U in CRUD (Create, Read, Update, Delete) operations. This tutorial will include C# and XAML goodness. #How to create Datagrid in WPF #How to Use Datagrid in WPF #How to bind to Datagrid #Data binding to Datagrid #Row details in Datagrid #How to create datagrid programmatically #How to create datagrid using C# #how to create datagrid dynamically #how to create datagrid on the fly #How to Update datagrid rows #Data grid events #How to add data to datagrid #CRUD operations on Datagrid #WPF CRUD operations As always, drop a comment if any questions or suggestions.. https://crudzone.wordpress.com/wpf/

Welcome to WPF Tutorials | Data Grid in WPF In this part of the WPF tutorials, and particularly part 7 of our custom datagrid series we're going cover how to add a new row or new record, data, to our data source which is currently a CSV file but could easily be an xml file or a database such as sql, sqlite or any others. In the next part, we're going cover Updating and Deleting - aka CRUD operations. Lots of C# and XAML fun using Visual Studio 2019.. Enjoy and remember to tap on bell for new videos #CRUD operations with Datagrid #Datagrid events #How to add, delete, update data in Datagrid #how to bind to datagrid Drop questions in comments please i'll try to reply as soon as possible https://crudzone.wordpress.com/wpf/

Welcome to WPF Tutorials | Custom Datagrid in WPF In this chapter of WPF Tutorials, we're going to continue where we left off in part 4 of this series. In this part we're going to cover the template column and row details column. Enjoy.. #WPF Datagrid #Datagrid in WPF #How to create and use a custom datagrid in WPF #C Sharp #XAML any questions? Drop in comments please