ADVANCE COURSES

DIGITAL MARKETING

DOT NET TECHNOLOGY

GRAPHIC DESIGNING

MECHANICAL & CIVIL SOFTWARE TRAINING COURSE

OFFICE AUTOMATION

ADO.NET

Microsoft SQL Server 2005 Express (3HR)

Overview of SQL Server 2005 Express
Installation of SQL Server 2005 Express
Features of SQL Server Express
SQL Server 2005 Express management tools
Server databases versus Local Databases
Summary

Overview of Data Access (3HR)

Using Data Bound Controls
Working with List Controls
Working with tabular Data Bound Controls
Working with Hierarchical Data Bound Controls
Working with other Controls
Using Data Source Controls
Using ASP.NET parameters with data source controls
Using programmatic Data Binding
Understanding Templates and Data binding Expressions.
Using templates
Using Data Binding Expressions
Using 2 way Data Binding Expression
Summary

Using SQL Data Source Control (4 hrs)

Creating database connections
Connecting to MSSQL Server
Connecting to ORACLE and MS Access
Storing connection String in web configuration file
Executing Database Commands
Executing inline SQL Statements
Executing Stored Procedures
Filtering database rows
Changing the data source mode
Handling SQL Command execution errors
Canceling command execution
Using ASP.NET parameters with SQL Data Source Control
Using the ASP.NET cookie parameter object
Using the Query String Parameter object
Programmatically Executing Sql data Source commands
Adding ado.net parameters
Executing Insert, Update and Delete commands
Executing select commands
Caching Database Data with Sql Data Source control
Summary

Using List Controls (4 hrs)

Overview of the List Controls
Declaring List Items
Binding to a Data Source
Determining the selected List Item
Appending data items
Enabling automatic post backs
Using the Items Collection
Working with the Drop Down List control
Working with the Radio Butto List control
Working with the List Box control
Working with the Check Box List control
Working with Bulleted List control
Summary

Using the Grid View Control (4 hrs)

Grid View Control fundamentals
Displaying Data
Selecting Data
Using Data Keys
Sorting Data
Paging through Data
Editing Data
Displaying Empty Data
Formatting the Grid View Control
Using View State with Grid View Control
Using fields with Grid View control
Using Bound Fields
Using Check Box Fields
Using Command Fields
Using Button Fields
Using Hyper Link Field
Using Image Field
Displaying Column Summaries
Displaying nested master/details form
Extending the Grid View Control
Creating a long text field
Creating a delete button field
Creating a validated field
Summary

Using the Details View and Form View Controls ( 3 hrs)

Using the Details View control
Displaying data with the Details View control
Using Fields with the Details View control
Displaying Empty data with the Details View control
Paging Through Data with the Details View control
Updating Data with the Details View control
Inserting data with the Details View control
Deleting Data with the Details View control
Working with the Details View control
Formatting the Details View control
Using the Form View Control
Displaying Data with the Form View control
Paging through Data with the Form View control
Editing data with the Form View control
Inserting data with the Form View control
Deleting Data with the Form View control
Summary

Using Repeater And Data List Controls (3 hrs)

Using Repeater Control
Displaying data with the Repeater Control
Using Templates with the Repeater Control
Using the Data List Controls
Displaying Data with the Data List Control
Displaying Data with Multiple Columns
Using templates with the Data List Control
Selecting data with the Data List Control
Editing data with the Data List Control
Formatting the Data List Control
Summary

Using The List View and Data Pager Controls (3 hrs)

List View Control
Layout template and Item Template
Using Group Template
Selecting a row
Sorting/editing Data
Using Data Pager Control
Creating a custom user interface for paging
Data Source paging
Summary

Data Access with LINQ to SQL (3 hrs)

New C# and VB.NET Language features
Understanding Automatic Properties
Understanding Initializers
Understanding type inference/lamda exp/generics/anonymous types
Creating LINQ to SQL Entities
Performing standard database commands with LINQ to SQL
Creating a custom LINQ entity Base Class
Standard Data-access operation
Performing Validation

Seminars and group discussions

During the course it is compulsory for every
Student to take participation in
Seminars and group discussion.

Live Project

Getting customer’s requirements
Preparing designs, database and business logics
Developing software application project
Testing and implementing the project
Troubleshooting the project application after implementation

Please login to see your profile content

We support programs that create advancement opportunities for people.

Useful links

Courses
Careers
About Us

Contact Us

Office no F21, first floor , Haware Centurion Complex Sector 19a, near seawoods, Nerul (E, Navi Mumbai, Maharashtra 400706

Get directions on google

info@samiinfotech.com

Designed & Developed by samiinfotech

© Copyright samiinfotech.com