Archive for 2016
Using Ajax Control Toolkit in ASP.NET
Download Ajax Control Tool Kit from below link
Ajax control toolkit download link
Extract The file then Go To Visual Studio
Open Tool Box
Right Click On The Existing Tab
And Click On Add New Tab
Name the tab
Right click on the newly tab
click on.
Tag :
ASP.NET
Tag :
ASP.NET
ASP.NET Master Pages
Master pages are used to create common layout for multiple websites.
Master pages will have .master as page extension and we can see output of master page directly.
Multiple web forms(.aspx pages) can be created using single master page. All these.
Tag :
ASP.NET
Introduction to ASP.NET
ASP.NET is a technology under .NET Framework which is used to create web sites.
ASP stands for Active Server Pages.
HTML, CSS and javascript are used as basic building blocks for developing websites using ASP.NET.
C#.NET will act as a code behind.
Tag :
ASP.NET
SQL Injection
Hacking database by entering input data which maninpulates sql queries is
known as sql injection.
Example:
Expected: select * from tbl_data where name='admin' and pwd='password'
Hacked: select * from tbl_data where name='admin' and pwd=' or 'a'='a'
With.
C#.NET ref and out parameters with example
ref stands for reference and out stands for output.
ref parameter variable should be initialized before we call the method. That value will be used a as reference value in the method.
out parameter variable initialization is not required but it should.
Stored Procedures in ADO.NET
// 1. create a command object identifying
// the stored procedure
SqlCommand cmd = new SqlCommand(
.
Tag :
ADO.NET
Disconnected Architecture Delete
//Disconnected architecture - delete
//Delete product
private void BtnDeleteProduct_Click(object
sender, EventArgs e)
.
Tag :
ADO.NET
Disconnected Architecture Update
//Disconnected - update
//Update product name based on the
product name under a category
private void BtnUpdateProduct_Click(object
sender, EventArgs e)
.
Tag :
ADO.NET
Disconnected Architecture Insert
//Disconnected Insert
//Adding product
private void BtnAddProduct_Click(object
sender, EventArgs e)
{
SqlConnection.
Tag :
ADO.NET
Disconnected Architecture Select
//Disconnected - Select
//Populate the datagridview with
registered users information
public void GetData()
{
SqlConnection.
Tag :
ADO.NET
DataAdapter
DataAdapter is used to disconnected architecture to execute all the commands. It is capable of opening the connection to the database server, executing the command, Storing data in DataSet and closing the connection.
.
Tag :
ADO.NET
Connected Architecture Delete
//Connected architecture - delete
//Delete Category
private void BtnDeleteCategory_Click(object sender, EventArgs e)
.
Tag :
ADO.NET
Connected Architecture Update
//Connected Architecture - update
//Update Category
private void BtnUpdateCategory_Click(object sender, EventArgs e)
.
Tag :
ADO.NET
Connected Architecture Insert and Select
SQL Command to create SQL table
CREATE TABLE [dbo].[Tbl_Data](
[Id]
[int] IDENTITY(1,1) NOT NULL,
[UserName]
[varchar](50) NULL,
.
Tag :
ADO.NET