Asp.net

Front 1

What are "roles"

Back 1

A role is a named set of permissions. In other words, a role contains permissions. Roles can be granted to or
revoked from users; granting a role to a user has the same effect as granting the user all the permissions in
that role. Roles are important because they allow the administrator to manage user privileges in a much more
convenient way.

Front 2

What is "hashing" used for?

Back 2

Hashing is a common method for storing passwords. The hash value of a password is calculated by applying
a mathematical function (hash algorithm) to it. The essential property about the hash algorithm is that you
can’t obtain the original password from its hash value (the algorithm is one-way).

Front 3

What are MD5, SHA-0, and SHA-1?

Back 3

Popular hashing algorithms.

Front 4

What does the Login control include?

Back 4

It displays a login box asking for the username
and password and a check box for the “remember me next time” feature.

Front 5

What is the LoginView?

Back 5

Templates, e.g. "You are not logged in" before log in, or user-appropriate links if the user IS logged in.

Front 6

What is the LoginName?

Back 6

Displays the logged-in user's name.

Front 7

What is LoginStatus?

Back 7

Displays a Login link if the user is NOT logged is, or a Logout link if the user IS logged in.

Front 8

How do you start the ASP.NET Web Site Administration
Tool

Back 8

In VS: Web -> ASP.NET Configuration.

Front 9

What is the default requirement for passwords for ASP.NET membership?

Back 9

At least 7 letters, at least one of which must be non-alphanumeric, e.g. [ * ! etc.

Front 10

Where is the ASP.NET password requirement determined?

Back 10

In machine.config's AspNetSqlMemberShipProvider section.

Front 11

Do you have to modify the machine.config to alter password requirements?

Back 11

No, you can also modify the application's web.config.

Front 12

How do you get a reference to a control on a web page, in your code behind?

Back 12

Use <page>.FindControl( "<control_id>") and cast to the appropriate control type:

TextBox usernameTextBox = (TextBox)Login1.FindControl( "UserName" );

Front 13

What is a placeholder control?

Back 13

It's an ASP.NET control to which another control can easily be added dynamically, at run-time.

Front 14

How can you use a GUI to manage your web.config application settings?

Back 14

In VS: Website -> ASP.NET Configuration, then the Application tab, then the Manage Application Settings link.

Front 15

What database is used to store your authentication data (by default)?

Back 15

ASPNETDB.MDF

Front 16

What is the AnonymousTemplate?

Back 16

It's part of the LoginView control's template, determines what appears before the user logs in.

Front 17

How do you expose the component controls of the Login control?

Back 17

Click the Smarttag (upper-right corner) and select "Convert to Template"

Front 18

What does * mean, as in

{deny users="*" }

?

Back 18

* means "all identities" so all users would be denied.

Front 19

What does ? mean, as in

{deny users="?" }
{allow users="*" }


?

Back 19

? means "anonymous users", those who have not logged in... so the config would deny all those NOT logged in, allow all those who ARE logged in.

Front 20

What is the default access to web pages, if you don't do anything to control it?

Back 20

All visitors get access to all pages.

Front 21

How do you execute a DB command that doesn't return any result set (delete / update / insert)?

Back 21

command.ExecuteNonQuery(), where command is a DbCommand object.

Front 22

How do you add columns to a GridView, using the UI

Back 22

Click the SmartTag, then click Add New Column (repeating for each column)

Front 23

What are the GridView's built-in types? (6)

Back 23

BoundField, CheckBoxField, HyperLinkField,
ButtonField, CommandField, ImageField, and TemplateField.

Front 24

What is a GridView BoundField?

Back 24

Displays a column from the database.

Front 25

Why are skins easy from the developer's perspective?

Back 25

Default skins apply to all controls of that kind in a web site, so you have just one place to set those attributes.

Front 26

When a control is skinned, how can you set its attributes to a different look?

Back 26

If you to apply more than one skin to a given type of control, you need to create named skins and add a corresponding SkinID property to the control's definition.

Front 27

How do you put a GridView row into edit mode?

Back 27

In the grid_RowEditing event:

grid.EditIndex = e.NewEditIndex;

where e is the event argument passed to RowEditing.

Front 28

How do you get out of edit mode, with a GridView?

Back 28

In the RowCancelingEdit event, set the grid.EditIndex = -1.

Front 29

How do you tell a GridView about a table's primary keys?

Back 29

Set its DataKeyNames property.

Front 30

How do you access a primary key associated with DataKeyNames?

Back 30

string id =
grid.DataKeys[e.RowIndex].Value.ToString()

Front 31

How do you read the value from a GridView cell?

Back 31

Use zero-based addressing and cast to TextBox:

string name = ((TextBox)grid.Rows[e.RowIndex].Cells[0].Controls[0]).Text;

Front 32

How can you get more control of how a GridView renders a column?

Back 32

Convert it to a <b>template column</b>.

This is in contrast to using the built-in BoundField, HyperLinkField, etc.

Front 33

How do you read a GridView value, using the column name?

Back 33

Use FindControl():

string description = ((TextBox)grid.Rows[e.RowIndex].FindControl("descriptionTextBox")).Text;

Front 34

How do you bind a control to a database column, in the mark-up?

Back 34

Use
<%# Bind( "ColumnName") %>

Front 35

How do you get the value of a query string parameter?

Back 35

string departmentId =
Request.QueryString["DepartmentID"];

Front 36

How do you redirect to a different page?

Back 36

<b>Response.Redirect</b>

Response.Redirect( Request.ApplicationPath + "/CatalogAdmin.aspx" );

Front 37

What is the difference between Eval() and Bind()?

Back 37

Both return the value of their reference, but Eval() is one-way -- display only -- and Bind() is two-way -- display AND UPDATE.

Front 38

What kind of object holds a parameter that you're passing to a stored procedure

Back 38

DbParameter

Front 39

Why use a DbType.AnsiString parameter instead of DbType.String, here?

param.DbType = DbType.AnsiString;
param.Size = 5000;

Back 39

Because DbType.String
stores Unicode characters and only supports strings up to 4,000 characters.

Front 40

How do you format data from an Eval() as currency?

Back 40

Text='<%# String.Format("{0:0.00}", Eval("Price")) %>'>

Front 41

What is a GUID?

Back 41

A GUID (Globally Unique
Identifier) is a value guaranteed to be unique across time and space.

Front 42

Why use GUIDs?

Back 42

Two generated GUIDs will never be the same.

Front 43

How long is a GUID?

Back 43

The
string representation of a GUID has 36 characters: The GUID itself is 32 bytes long, and its string representation also
contains 4 separating dashes. An example of a GUID is ff8029a7-91e2-4ca2-b4e7-99a7588be751.

Front 44

How do you pronounce "GUID"?

Back 44

Some hold that it rhymes with "squid", others say "fluid". Does it matter? :)

Front 45

When do you want to use Char the Char datatype, in SQL Server, as opposed to VarChar?

Back 45

When you know the exact length of the strings you’re storing in a table field, it’s better to use the Char
data type instead of VarChar.

Front 46

When do you want to use Char the Char datatype, in SQL Server, as opposed to VarChar?

Back 46

When you know the exact length of the strings you’re storing in a table field, it’s better to use the Char
data type instead of VarChar.

Front 47

What is a composite primary key?

Back 47

One comprised of more than one column.