Jack is Here, asp.net findings

As a software engineer, I focus on .NET, especially asp.net, C#, WCF and so on, and I am also very interested in Search Engine Optimization.

Entries Tagged ‘microsoft sql server’

FIX: An EXCEPTION_STACK_OVERFLOW exception may occur when you try to run a Transact-SQL query in SQL Server 2005

Symptoms
This article describes the following about this hotfix release: The issues that are fixed by this hotfix packageThe prerequisites for applying the hotfix packageWhether you must restart the computer after you apply the hotfix packageWhether the hotfix package is replaced by any other hotfix packageWhether you must make any registry changes after you apply the hotfix packageThe files that are contained in the hotfix package
Resolution
When you try to run a Transact-SQL query in Microsoft SQL Server 2005, an EXCEPTION_STACK_OVERFLOW exception may occur. When this problem occurs, the SQL Server service may stop unexpectedly.
Note This problem may only occur in SQL Server 2005 x64 editions.

How to Create a Data Source in Visual Studio.net

Welcome, in this tutorial we are going to create a new data source in Visual Studio.Net using the built in wizards and drag-n-drop. To begin go to “File”, “New”, “Project” and name the project something like “MyPubsDataSource” or whatever makes sense to you. This will be a windows application although it’s not really important because we just need any type of project because creating a new data source is commom to all project types. Ok after you enter a name for your project and press the “Ok” button VS.Net will have created your first form for you named “Form1.cs”. At this point the form1 view should be already in design view(If you see a rectangular window that reads “Form1.cs[Design]* then you are in design view.
Ok next click once anywhere on the form and then select the “ToolBox” tab on the left of the design window. If it’s not viewable then select “View”, “ToolBox” from the main menu.(See image below)

[Click to see full-size]

Which will show you the window below.

[Click to see full-size]

Ok, next select the “SQLDataAdapter” from the ToolBox and drop it anywhere onto your form. Once you release it, it does not actually sit on top your form but instead it positions itself just below your form inside the design area. At this point you will have another window in front of you for you to choose your data source like this(See image below).

[Click to see full-size]

In the next window, select Microsoft SQL Server or Microsoft SQL Server 2005 Express or whatever data your server can be. The next thing to do is enter the server name if you know what this is, if not click the drop arrow and select from the list of providers. (See picture below).

[Click to see full-size]

Next, if your server is setup for it then you can choose “Windows Authentication” if not and you know what your SQL Server login settings are then enter the user name and password. Now you want to test your settings and make sure you can connect to your server so click on the “Test Connection” button now. Next you will get a message box showing the connection status of the test. If it’s ok press the “OK” button and the form will close and you will be back at the Data Adapter Configuration Wizard. Select either “Yes or No” to save the password for your connection in the App.config file. (Please note if you select “No” you will be promted for it each time you run any of your applications that need to connect to SQL server for data). I normally select “Yes” as I setup a login on SQl Server with only enough rights to handle the data I’m working with.
Ok, now click “Next” to advance to the next screen of the wizard. Here you can use sql statements, use existing stored procedures, or create new stored procedures. For now select “Use SQL Statements” and press the “Next” button.(See image below)

[Click to see full-size]

The next window you will see will be this one.

[Click to see full-size]

Select the “Sales” table and press the “Add” button and then the “Close” button.

The following window will appear below.

[Click to see full-size]

Select the (All Columns) square to place a tic mark and then press the “OK” button to save and close the window. You are once again back at the wizard and now you will see this code in the center.

SELECT sales.*
FROM sales
Ok, great, now press the “Next” and then the “Finish” button. In design view of Form1 just below the bottom of the form right click on the “sqlDataAdapter” and select generate dataset. Just go with the default settings and press the “OK” button. Ok now right click on the “sqlDataAdapter” again but this time choose “Preview Data”. On the form that pops up(See image below) press the “Preview” button

[Click to see full-size]

You will now see your data in the resulting form.(See image below)

[Click to see full-size]

Now look at the ball only because once data is
Thank you for taking the time to go through this tutorial, I really hope you have gained some knowledge. I fully intend to make these tutorials as complete and as easy as possible. Until next time take care, continuous learning.
JR

>> View the entire article here

The Significance of ASP.NET Development

Cut in today's competitive business environment of the throat, ASP.NET development is playing an important role in software development. Now days, many software development company, ASP.NET for developing the Web, because of its robustness, and used to develop application-based solutions.

ASP.NET Development is used by developers to create dynamic web applications, web services and web. ASP.NET development can be used to create anything from small websites to large web applications.

ASP.NET Development make use of. NET Framework, which includes a huge library of predefined categories include features for common programming problems. The core of the. NET Framework contains Common Language Runtime (CLR), which provides the Runtime Environment to carry out the programs developed for it. NET Framework.

ASP.NET Development can make use of Visual Studio.NET to design the ASP.NET Web Forms and debug and deploy ASP.NET web applications.

ASP.NET provides interaction between developing applications in different environments. It also provides support for ADO.NET to access various data sources, such as Microsoft SQL Server, Oracle, and DB2. In addition, ASP.NET provides a unique development of a code library for mobile devices.

ASP.NET Developers use various ASP.NET features to develop and customize the ASP.NET applications. Various features are:

??? ?Master page: Helps you to apply a consistent look and feel to every webpage of the web application.

? AJAX controls: Provides a set of tools used to create dynamic and rich web applications. These controls help protect you from the complexity of AJAX.

??? ?Language Integrated Query (LINQ): Provides the data querying capability to C# and VB.NET, which allows you to retrieve data from databases, objects, and XML. LINQ provides support for compiler and intellisense.

? Windows Presentation Foundation (WPF): Provides a consistent programming model that includes functions to build rich application user interface, media and documents.

? Windows Communication Foundation (WCF): Uses a service-oriented programming model for simplifying the development of linked applications.

??? ?Web Service support: Provides in-built functions that help you to consume and publish the web service in an efficient manner.

??? ?Rich-Output Caching: Allows you to cache the data to avoid the recreation of information.

??? ?Themes: Allows you to customize the look and feel of the web application.