FIND SQL SERVERS on LOCAL NETWORK in C# ASYNC - PART ONE

Опубликовано: 28 Сентябрь 2024
на канале: How To 365
470
8

Learn How to FIND SQL SERVERS on LOCAL NETWORK in C# ASYNC

-------- S O L U T I O N S

✔️ Using built-in SQL libraries I fetch the name of the Servers and if there, Instance names as well

-------- P A R T 1

💿 Discover Servers: (Current Video)

🔗    • FIND SQL SERVERS on LOCAL NETWORK in ...  

-------- P A R T 2

💿 Test Connection to SQL Server:

🔗    • FIND SQL SERVERS on LOCAL NETWORK in ...  

-------- P A R T 3

💿 Get Database names:

🔗    • FIND SQL SERVERS on LOCAL NETWORK in ...  

-------- P R E V I O U S V I D E O

⏮️ INSTALL a NEW SQL SERVER INSTANCE:

🔗    • INSTALL a NEW Microsoft SQL SERVER IN...  

-------- R E L A T E D V I D E O S

💡 Want to know more about Instances?, Check this video

🔗    • INSTALL a NEW Microsoft SQL SERVER IN...  

------- C R E D I T S T O M U S I C

🎵 Royalty Free Music by Bensound: https://www.bensound.com/

🎵 Royalty Free Music by Pixabay: https://www.pixabay.com/

-------- S U B S C R I B E

❤️ DON'T forget to LIKE, COMMENT your IDEA, and SUBSCRIBE

🔗 https://bit.ly/3Pakd48

-------- I N S T A G R A M

📷   / atrin_noori  

--------- C # D E V E L O P M E N T E P I S O D E 9 ---------

00:00 - DISCOVER SQL SERVERS on your LOCAL NETWORK using C# ASYNC
00:08 - Video Overview and goal
00:38 - Discovering SQL Servers on network
00:48 - How to create a new project in VS 2019
01:22 - UI design of the project
02:58 - How to add a progressBar in ToolStrip C#
03:34 - How to use TASKS in C#
04:27 - How to Get SQL Server Names on Network using Tasks
04:50 - How to call a TASK function with ASYNC and AWAIT
05:15 - How to fill a ComboBox from a DataTable
06:22 - First try
06:53 - How to handle UI while TASKS are running
08:02 - Final test
08:28 - Second part coming soon!
08:38 - End screen

--------- A B O U T S E C T I O N ---------

🙍 About Microsoft Visual Studio:
Visual Studio is an integrated development environment from Microsoft. It is used to develop computer programs including websites, web apps, web services and mobile apps

🙍 About C#:
C# is a general-purpose high-level programming language supporting multiple paradigms. C# encompasses static typing, strong typing, lexically scoped, imperative, declarative, functional, generic, object-oriented, and component-oriented programming disciplines.

🙍 About Async and Await:
In computer programming, the async/await pattern is a syntactic feature of many programming languages that allows an asynchronous, non-blocking function to be structured in a way similar to an ordinary synchronous function

🙍 About Microsoft SQL Server:
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network

🙍 About SQL:
Structured Query Language, abbreviated as SQL, is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system