C# | SQL Server | Insert, Select, Update, Delete | CRUD Operations | Part 3
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
260
views
C# | SQL Server | How To Create Database Table | Part 2
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
193
views
C# | SQL Server | How To Create Database | Part 1 | C# SQL Server
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
163
views
Microsoft Excel 2019 | How to Import & Export .CSV, TXT Files | How to Convert CSV to Excel Table
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
80
views
WPF | How To Connect To SQLite Database | Read From SQLite | ListBox, Datagrid
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
232
views
Microsoft Excel 2019 | How To Export Excel to XML| How to Convert Excel data to XML file| Part ii
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
101
views
Microsoft Excel 2019 | How To Import XML Data| How to Convert XML file to Excel Worksheet | Part i
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
81
views
SQLite | C# | Part 7 | XML File | Convert To/From XML
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/
88
views
SQLite | C# [CSharp] | CSV | Convert To/From CSV
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
160
views
SQLite | C# | Entity Framework | SQLite CRUD Operations using EF6 in C#
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/
181
views
SQLite | C# | Part 3 | How To Read From SQLite Database Using C#
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#?
93
views
SQLite | Basics | Part ii | C# | Create DB, Add, Delete, Update Rows
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
125
views
SQLite | Basics | Part I | SQLite CREATE, INSERT, DELETE, UPDATE, SELECT Statements
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
132
views
WPF Documents | Flow Document -vi | RichTextBox -iii | Save As Text, XAML, RTF file
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
162
views
WPF Documents | Flow Document -v | RichTextBox -ii
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
156
views
WPF Documents | Flow Document -iv | RichTextBox -i
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
141
views
WPF Documents | Flow Document -iii | How to convert WPF documents to PDF file
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/
154
views
WPF Documents | Flow Documents-ii | Documents in WPF
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?
106
views
WPF Documents | Flow Documents-i | Documents in WPF
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?
129
views
WPF Documents | Fixed Document | Documents in WPF
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/
129
views
WPF Controls | 27-Datagrid Events | Delete Datagrid Rows | Part 9
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/
91
views
WPF Controls | 27-Datagrid | Search, Filter Rows , Filtering datagrid data| Part 10
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/
72
views
WPF Controls | 27-Datagrid | Events | Update Datagrid Rows| Part 8
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/
57
views
WPF Controls | 27-Datagrid | Custom Datagrid | Events | Part 7 | Adding New Row Using Datagrid
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/
143
views
WPF Controls | 27-Datagrid Custom Datagrid | Part 6 Styling
Welcome to WPF Tutorials | Custom Datagrid in WPF | Styling Datagrid
In this part of WPF Tutorials -Custom Datagrid in particular- we are going to cover some of the styling aspect of datagrid columns individually including conditional formatting where you can format or style a column based on the data, value in another column.. we will focusing on the XAML part in this tutorial..
#How to customize a Data Grid in WPF
#Custom datagrid in WPF
#Datagrid databinding
#how to style a datagrid
#how to change the look and feel of you controls in WPF
#how to change the style
#how to bind to datagrid
If you have anything that you want to be covered or if you have any ideas or questions please drop in comments section.
79
views