Connection between ASP.NET Website and SQL Sever Database

How to Connect Website with Database?

ASP.NET gives you flexibility in how you connect to databases. A simple way is to use data source controls, which allow you to encapsulate data access in a control that you can configure with connection and query information. Alternatively, you can write code to perform data access yourself using ADO.NET classes or LINQ queries.

Here Step by Step Guide to connect Database to ASP.NET website:

1. First Create A website 

     2. Click on Solution Explorer and Click to Connect Database Icon

  3. On Add Connect Window Choose Database Server, Authentication mode and then Choose your
        Database Name

At last click on Test Connect, if there wasn't any problem a success message will display
Now you successfully connected to database

Introduction to Visual Studio and it is Toolbars

What is Visual Studio?

Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft. It is used to develop computer programs for Microsoft Windows, as well as web sites, web applications and web services. Visual Studio uses Microsoft software development platforms such as Windows API, Windows Forms, Windows Presentation Foundation, Windows Store and Microsoft Silverlight. It can produce both native code and managed code.

Visual Studio includes a code editor supporting IntelliSense (the code completion component) as well as code refactoring. The integrated debugger works both as a source-level debugger and a machine-level debugger. Other built-in tools include a forms designer for building GUI applications, web designer, class designer, and database schema designer. It accepts plug-ins that enhance the functionality at almost every level—including adding support for source-control systems (like Subversion) and adding new toolsets like editors and visual designers for domain-specific languages or toolsets for other aspects of the software development lifecycle (like the Team Foundation Server client: Team Explorer).
Visual Studio supports different programming languages and allows the code editor and debugger to support (to varying degrees) nearly any programming language, provided a language-specific service exists. Built-in languages include C, C++ and C++/CLI (via Visual C++), VB.NET (via Visual Basic .NET), C# (via Visual C#), and F# (as of Visual Studio 2010). Support for other languages such as M, Python, and Ruby among others is available via language services installed separately. It also supports XML/XSLT, HTML/XHTML, JavaScript and CSS. Java (and J#) were supported in the past.
Before Visual Studio 2015, Commercial versions of Visual Studio were available for free to students via Microsoft's DreamSpark program , when only commercial versions supported plugins. Starting with Visual Studio 2015, Microsoft provides "Community" editions of its Visual Studio at no cost to any one, where Community edition supports installing plugins.

Toolbar is Visual Studio:
Menus and toolbars are the way users access commands in your VSPackage. Commands are functions that accomplish tasks, such as printing a document, refreshing a view, or creating a new file. Menus and toolbars are convenient graphical ways to present your commands to users. Typically, related commands are clustered together on the same menu or toolbar.

• Menus typically are displayed as one-word strings clustered in a row at the top of the integrated development environment (IDE) or a tool window. Menus also can be displayed as the result of a right-click event, and are referred to as shortcut menus in that context. When clicked, menus expand to display one or more commands. Commands, when clicked, can carry out tasks or launch submenus that contain additional commands. Some well-known menu names are File, Edit, View, and Window. For more information, see Extending Menus and Commands.
• Toolbars typically are rows of buttons and other controls, such as combo boxes, list boxes, text boxes, and menu controllers. All toolbar controls are associated with commands. When you click a toolbar button, its associated command is activated. Toolbar buttons usually have icons that suggest the underlying commands, such as a printer for a Print command. In a drop-down list control, each item in the list is associated with a different command. A menu controller is a hybrid in which one side of the control is a toolbar button and the other side is a down arrow that displays additional commands when clicked. For more information, see Adding a Menu Controller to a Toolbar.
• When you create a command, you also must create an event handler for it. The event handler determines when the command is visible or enabled, allows you to modify its text, and ensures that the command responds appropriately ("routes") when activated. In most instances, the IDE handles commands using the IOleCommandTarget interface. Commands in Visual Studio route in a hierarchical manner, starting with the innermost command context, based on the local selection, and proceeding to the outermost context, based on the global selection. Commands added to the main menu are immediately available for scripting. For more information, see MenuCommands Vs. OleMenuCommands and Selection Context Objects.

Before Creating A Website

 

What is Necessary before creating a website?

Answer:
A basic concept of web base technologies like HTML, CSS and Javascript

HTML:
HTML is a markup language for describing web documents (web pages).

1. HTML stands for Hyper Text Markup Language
2. A markup language is a set of markup tags
3. HTML documents are described by HTML tags
4. Each HTML tag describes different document content 

An Example of HTML 

<html>
<head>
<title>Page Title</title>
</head>
<body>

<h1>My First Heading</h1>
<p>My first paragraph.</p>

</body>
</html>

Write the above code in notepad or other web Editor application and save it in .html format

 

Introduction to Csharp

 What is C# (Sharp):

Definition:

C# is an elegant and type-safe object-oriented language that enables developers to build a variety of secure and robust applications that run on the .NET Framework. You can use C# to create Windows client applications, XML Web services, distributed components, client-server applications, database applications, and much, much more. Visual C# provides an advanced code editor, convenient user interface designers, integrated debugger, and many other tools to make it easier to develop applications based on the C# language and the .NET Framework.

 

 

C# syntax is highly expressive, yet it is also simple and easy to learn. The curly-brace syntax of C# will be instantly recognizable to anyone familiar with C, C++ or Java. Developers who know any of these languages are typically able to begin to work productively in C# within a very short time. C# syntax simplifies many of the complexities of C++ and provides powerful features such as nullable value types, enumerations, delegates, lambda expressions and direct memory access, which are not found in Java. C# supports generic methods and types, which provide increased type safety and performance, and iterators, which enable implementers of collection classes to define custom iteration behaviors that are simple to use by client code. Language-Integrated Query (LINQ) expressions make the strongly-typed query a first-class language construct

Database Learning - SQL Server

What is SQL Server and Database?

Definition of SQL Server:
SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment. SQL Server runs on T-SQL (Transact -SQL), a set of programming extensions from Sybase and Microsoft that add several features to standard SQL, including transaction control, exception and error handling, row processing, and declared variables.

Code named Yukon in development, SQL Server 2005 was released in November 2005. The 2005 product is said to provide enhanced flexibility, scalability, reliability, and security to database applications, and to make them easier to create and deploy, thus reducing the complexity and tedium involved in database management. SQL Server 2005 also includes more administrative support.
The original SQL Server code was developed by Sybase; in the late 1980s, Microsoft, Sybase and Ashton-Tate collaborated to produce the first version of the product, SQL Server 4.2 for OS/2. Subsequently, both Sybase and Microsoft offered SQL Server products. Sybase has since renamed their product Adaptive Server Enterprise.

Learning New Web Tutorial

Follow our Tutorial

ASP.NET Complete Tutorial

A Step by Step ASP.NET Tutorial 

1. Introduction to ASP.NET
2. Introduction to Database and SQL
3. Introduction to C#
4. Before Creating and Building A website
5. Introduction to Visual Studio and it is Toolbars
6. Connection between ASP.NET Website and SQL Sever Database
7. What is IIS and how it works
8. What ASP.NET Page Life Cycle Events
9. IsPostBack in ASP.NET
10. Data bind asp.net dropdownlist with data from the database
11. GridView in asp.net
12. Fileupload in asp.net
13. Hidden field in asp.net
14. Literal in asp.net
15. RequiredField validator in asp.net
16. Sending emails in asp.net
17. Add item in ASP.Net DropDownList using For Loop 
18. DataList in ASP.Net
19. SiteMapPath with example in ASP.Net
20. Bind Repeater from Code Behind using DataTable in ASP.Net
21. Reset Form fields data after form submit PostBack in ASP.Net
22. Bootstrap style GridView in ASP.Net
23. Configuring web.config
24. uploading and complete website in httpdoc folder