Contents tagged with Visual Web Developer
-
Installing Ajax Control Toolkit in Visual Studio 2010
I needed to install the Ajax Control Toolkit for Visual Studio 2010 4.0 Framework, so I googled "install ajax control toolkit visual studio 2010" and found this step by step guide:
-
Property: Visual Studio Tip
In Visual Studio, when you create a new Property, you're likely aware that as you type, intellisense will allow you to type the property name and type and upon hitting enter, it prepopulates the Property as below:
-
Section 9: C# and VB Project: Using our TableAdapters, DataTables and Intellisense
In our final Section 9 of this tutorial by Nannette Thacker, we learn how to use our TableAdapters within our code. We also look at how Intellisense makes it easy to set up your TableAdapter code.
-
Section 8: C# and VB Project: Using an OleDbDataReader to Retrieve Our Data
In Section 8 of this tutorial by Nannette Thacker, we take a look at adding a OleDbDataReader and the ExecuteReader method to retrieve data from an Excel Spreadsheet.
-
Section 7: C# and VB Project: TableAdapter Select and Insert Queries with Parameters
In Section 7 of this tutorial by Nannette Thacker, we learn how to create a select query statement in our table adapter and pass parameters to it. We learn how to create an insert query, use a "SELECT SCOPE_IDENTITY()" to retrieve the identity key value returned, and set our ExecuteMode to "Scalar" in our properties sheet.
-
Section 6: C# and VB Project: Data Access Layer DataSet TableAdapters
In Section 6 of this tutorial by Nannette Thacker, we learn how to retrieve data from an uploaded spreadsheet, and import it into a SQL Server database. We will create a Data Access Layer DataSet and some TableAdapters. We will learn how to add a data connection to our web.config. We will learn how to create SQL Statements in our TableAdapters and use the Query Builder.
-
Section 5: Bind the Excel Data to a GridView using an OleDbDataAdapter
In Section 5 of this tutorial by Nannette Thacker, we will learn how to create a connection to our Excel Spreadsheet using an OleDbConnection with a Microsoft.Jet.OLEDB Connection String. We will learn how to create a SELECT query to retrieve data from a given Excel worksheet using an OleDbCommand. We will populate and bind our data to our GridView using an OleDbDataAdapter and DataSet.
We will also look at using Server.MapPath to find a physical directory on the server. -
Section 4: Auto Formatting a Web Form GridView
In Section 4 of this tutorial by Nannette Thacker, we will learn how to add and Auto Format a GridView in our WebForm. We will also learn how to create and add a Cascading Style Sheet to our project.
We will learn more about the Design view, and look at applying a scheme via the AutoFormat functionality of the GridView. -
Section 3: FileUpload Control and Functionality
In Section 3 of this tutorial by Nannette Thacker, we are going to look at the "FileUpload" control. We will discuss how to set a Label text value and set Panel visibility from Codebehind. We will also learn how to use the Handles key word at the end of our procedure declarations to handle our Button Click events. We will also view a snippet of code that uses error handling through Try/Catch/Finally.
-
Section 2: WebForm: Table, Label, and Panel Controls
In Section 2 of this tutorial by Nannette Thacker, we learn how to work with our WebForm and define the properties of an ASP.NET Table control to layout our buttons. We will learn how to add controls for Buttons, Panels and Labels.
We will learn a little bit about the Design mode, by creating our Tables using the Design mode.