Videos, Photos, Wallpapers, Free Download, Movies, Songs, Sports , Live TV, Entertainment

Differences between Datagrid, Datalist and Repeater?

noreply@blogger.com (asp.net C#) — Thu, 28 Feb 2013 23:14:00 -0800

What is the Difference between Repeater control and Datalist control and which one we should use, if it depends on situation and requirment,
Difference Between GridView and Repeater Control
Diff between DetailsView,FromView,ListView,DataList
Difference between datagrid, repeater and datalist?
Differences between Datagrid, Datalist and Repeater?

The main similarity between the DataGrid, DataList, and Repeater the only difference being that with a DataList or Repeater a DataListItem
Difference between GridView, Datagrid, DataList and Data Repeater: Please visit here, to get difference between Gridview and DataGrid
difference between datagrid, datalist and repeater?
Differences between Gridview, DataList, ListView etc
The difference between Repeater and DataList?
basic difference between gridview, datalist, repeater
Repeater, ListView, DataList, DataGrid, GridView … Which to choose? I've blogged on the differences between the ASPNET 40 data tools.

Example ASP.NET Data, Login, Validation and Navigation Controls - Navigation Controls, Validation Controls, Database Controls ADO.NET Objects, Introduction to Data-bound Controls

noreply@blogger.com (Unknown) — Sat, 25 Feb 2012 03:26:00 -0800

These controls are essential and this is a quick introduction to them. Data, Login, Navigation and Validation Controls.

Data and Navigation controls, the Login controls were introduced in ASP.NET 2.0 and are still strongly present in ASP.NET 4. With very little effort

Navigation Controls, Validation Controls, Database Controls ADO.NET Objects, Introduction to Data-bound Controls. ASP.NET 2.0 aims to reduce the amount of code required to accomplish common Web ... New data controls; Membership and roles; Personalization and themes; Coding and compilation options ... Data-Driven Site Navigation.

Introducing ASP.NET Data, Login, Validation and Navigation Controls - Navigation Controls, Validation Controls, Database Controls ADO.NET Objects, Introduction to Data-bound Controls

Questions for Interview - IT Questions and Answers - VB.Net to C# interview and answers - Interview Questions

noreply@blogger.com (Unknown) — Fri, 2 Dec 2011 04:28:00 -0800

IT Questions and Answers in this community of information technology (IT) experts and professionals, Includes sample interview questions and answers, Questions for Interview to ask the employer, as well as questions you shouldn't ask an interviewer during a job interview. Interview Questions in different categories and Interview questions and answers for .NET, VB.NET, SQL Server, C#, ASP.Net

What is IL?
What is JIT?
What is a CLR?
What is a CTS?
What is a CLS(Common Language Specification)?
What is a Managed Code?
What is a Assembly?
What are the different types of Assembly?
What is NameSpace?
What is Difference between NameSpace and Assembly?
If you want to view a Assembly how do you go about it ?
What is ILDASM ?
What is Manifest?
Where is version information stored of an assembly ?
Is versioning applicable to private assemblies?
What is GAC ?
What are situations when you register NET assembly in GAC ?
What is the concept of strong names ?
How do we generate strong names or what is the process of generating strong names, Whatis use the of SNEXE , How do we apply strong names to assembly, How do you sign an assem-bly?
How to add and remove an assembly from GAC?
What is Delay signing ?
What is garbage collection?
Can we force garbage collector to run ?
What is reflection?
What are different types of JIT ?
What are Value types and Reference types ?
What is concept of Boxing and Unboxing ?
What is the difference between VBNET and C# ?
What is the difference between System exceptions and Application exceptions?
What is CODE Access security?
What is a satellite assembly?
How to prevent my NET DLL to be decompiled?
What is the difference between ConverttoString and toString() method ?
What is Native Image Generator (Ngenexe)?
We have two version of the same assembly in GAC?
What is CodeDom?
Interoperability NET?
Once I have developed the COM wrapper do I have to still register the COM in registry?
How can we use NET components in COM?
What is CCW (COM callable wrapper) ?
How can we make Windows API calls in NET?
When we use windows API in NET is it managed or unmanaged code ?
What is COM ?
What is Reference counting in COM ?
Can you describe IUKNOWN interface in short ?
Can you explain what is DCOM ?
How do we create DCOM object in VB?
How to implement DTC in NET ?
How many types of Transactions are there in COM + NET ?
How do you do object pooling in NET ?
What are types of compatibility in VB?
What is equivalent for regsvr exe in NET ?
What is a Thread ?
Did VB support multi-threading ?
Can we have multiple threads in one App domain ?
Which namespace has threading ?
Can you explain in brief how can we implement threading ?
How can we change priority and what the levels of priority are provided by NET ?
What does AddressOf operator do in background ?
How can you reference current thread of the method ?
What's ThreadSleep() in threading ?
How can we make a thread sleep for infinite period ?
What is Suspend and Resume in Threading ?
What the way to stop a long running thread ?
How do I debug thread ?
What is ThreadJoin() in threading ?
What are Daemon threads and how can a thread be created as Daemon?
When working with shared data in threading how do you implement synchronization ?
Can we use events with threading ?
How can we know a state of a thread?
What is a monitor object?
What are wait handles ?
What is a mutex object ?
What is ReaderWriter Locks ?
How can you avoid deadlock in threading?
What is the difference between thread and process?
What is Remoting Webservices?
What is an domain?
Which class does the remote object has to inherit ?
What are two different types of remote object creation mode in NET ?

Describe in detail Remoting?
What are the situations you will use singleton architecture in remoting ?
What is fundamental of published or precreated objects in Remoting ?
What are the ways in which client can create object on server in CAO model ?
Are CAO stateful in nature ?
In CAO model when we want client objects to be created by “NEW” keyword is there any precau-tions to be taken ?
Is it a good design practice to distribute the implementation to Remoting Client ?
What are LeaseTime, SponsorshipTime, RenewonCallTime and LeaseManagerPollTime?
Which config file has all the supported channels/protocol ?
How can you specify remoting parameters using Config files ?
Can Non-Default constructors be used with Single Call SAO?
What are the limitation of constructors for Single call SAO ?
How can we call methods in remoting Asynchronously ?
What is Asynchronous One-Way Calls ?
What is marshalling and what are different kinds of marshalling ?
What is ObjRef object in remoting ?
What is a Web Service ?
What is UDDI ?
What is DISCO ?
What is WSDL?
What the different phase/steps of acquiring a proxy object in Webservice ?

What is file extension of Webservices ?
Which attribute is used in order that the method can be used as WebService ?
What are the steps to create a webservice and consume it ?
Do webservice have state ?
What is an application object ?
What’s the difference between Cache object and application object ?
How can get access to cache object ?
What are dependencies in cache and types of dependencies ?
Can you show a simple code showing file dependency in cache ?
What is Cache Callback in Cache ?
What is scavenging ?
What are different types of caching using cache object of ASPNET?

What are ASPNET session and compare ASPNET session with classic ASP session variables?
Which various modes of storing ASPNET session ?
Is Session_End event supported in all session modes ?

What are the precautions you will take in order that StateServer Mode work properly ?
What are the precautions you will take in order that SQLSERVER Mode work properly ?
Where do you specify session state mode in ASPNET ?
What are the other ways you can maintain state ?
What are benefits and Limitation of using Hidden fields ?
What is ViewState ?
Does the performance for viewstate vary according to User controls ?
What are benefits and Limitation of using Viewstate for state management?
How can you use Hidden frames to cache client data ?

What are benefits and limitations of using Hidden frames?
What are benefits and limitations of using Cookies?
What is Query String and What are benefits and limitations of using Query Strings?
What is OOPS?
What’s an Object ?
What is the relation between Classes and Objects ?
What are different properties provided by Object-oriented systems ?
Can you explain different properties of Object Oriented Systems?

What is difference between Association, Aggregation and Inheritance relationships?
How can we acheive inheritance in VBNET ?
What are abstract classes ?
What is a Interface ?
What is difference between abstract classes and interfaces?
What is a delegate ?
What are events ?
Do events have return type ?
Can event’s have access modifiers ?
Can we have shared events ?
What is shadowing ?
What is the difference between Shadowing and Overriding ?
What is the difference between delegate and events?
If we inherit a class do the private variables also get inherited ?
What are the different accessibility levels defined in NET ?
Can you prevent a class from overriding ?
What is the use of “MustInherit” keyword in VBNET ?
Do interface have accessibility modifier?

Regular Expression Example, Regular Expression in ASP.net

noreply@blogger.com (Unknown) — Sat, 29 Oct 2011 02:20:00 -0700

ASP.NET provides you some handfull validation controls like RequiredFiledValidator, RegularExpressionValidator etc. Most of the time we have to check whether user has given the correct number, date, time or anything as input. To validate such things we use RegularExpressionValidator.

The dash is a 'range separator'. Instead of listing the entire lowercase alphabet, we can merely list a-z, as above, to show all the characters. Therefore, in this example, basically, using [a-z] for the regular expression would mean that we would search the text, and only match, lower case alphabetic characters. That brings up another anomaly about Regular Expressions - case sensitivity. Yes, Regular Expressions ARE case sensitive. This means that if we wanted any alphabetic character to be matched, we would need to put in [a-z], plus [A-Z]. Of course, we could put numeric ranges here, too, like '[0-9]' to match ONLY numeric characters. Another special identifier '\d' does the same thing - the 'd' stands for a digit character.

The Caret (^)/(Shift-6), if it is INSIDE brackets will match anything BUT what is listed in the characters next to it - but - it 'negates' whatever is in the Regular Expression (like [^Aa] - this will match anything except the lower or upper case 'A'. However, if it is quite different when used outside brackets. Here, it will look for the characters next to it, and test them against only the BEGINNING of the string, but it looks for an exact match. For instance: '^Dav' will be found in the string 'David is here today', but it will not be matched in 'We're going to find David', since it's not at the beginning of the string.

The dollar sign ($), as opposed to the Caret, will look at the END of the target string. For instance, '$fox' will find a match in 'silver fox' but not in 'the fox jumped over the log'

The period (.) can be used like a wildcard. Anyone who has used databases should know a little about wildcards, hopefully. Let's say the Regular Expression was 'exp.' - It would match if it found 'expression', 'experience', or 'exponential'.

The question mark (?) matches the preceding character 0 or 1 times

The asterisk (*) matches the preceding character 0 or more times. It is also sort of like a wildcard.
The plus sign (+) matches the previous character 1 or more times.

using System;
using System.Collections.Generic;
using System.Text;

namespace ExampleUtil
{
public class RegExp
{

public static readonly string Url = "[a-zA-Z0-9-_\\$]+(//.[a-za-z0-9-_//$]+)?\\??" +
"[a-zA-Z0-9-_\\$]+=?[a-zA-Z0-9-_\\$]+(&[a-zA-Z0-9-_\\$]+=" +
"[a-zA-Z0-9-_\\$]+)*";">\\.[a-zA-Z0-9-_\\$]+)?\\??" +
"[a-zA-Z0-9-_\\$]+=?[a-zA-Z0-9-_\\$]+(&" +
"[a-zA-Z0-9-_\\$]+=[a-zA-Z0-9-_\\$]+)*";
public static readonly string Date = "(0[1-9]|[12][0-9]|3[01])[-]" +
"(0[1-9]|1[012])[-]((175[7-9])|(17[6-9][0-9])|(1[8-9][0-9][0-9])|" +
"([2-9][0-9][0-9][0-9]))";
// supports dates from 1-1-1757 to 31-12-9999 for SQL Server 2000 Date Range
public static readonly string Time = "(0[1-9]|[1][0-2])[:]" +
"(0[0-9]|[1-5][0-9])[:](0[0-9]|[1-5][0-9])[ ][A|a|P|p][M|m]";
public static readonly string Number = "[-+]?[0-9]*\\.?[0-9]*";
public static readonly string Digit = "[0-9]*";
public static readonly string NonNegative = "[+]?[0-9]*\\.?[0-9]*";

public static string MaxLength(int len)
{
return "[\\s\\S]{0," + len.ToString() + "}";
}
}
}

The ValidationErrorMessages class

using System.Collections.Generic;
using System.Text;

namespace Resource
{
public class ValidationErrorMessages
{

public static readonly string Url = "* Please enter a valid URL.<br>Valid " +
"characters are all alphanumeric characters and .?" +
"&_=-$<br> example: home.aspx?id=5&name=$my_name";
public static readonly string Required = "* Required";
public static readonly string Date = "* Please enter a valid date in dd-MM-yyyy format.";
public static readonly string Time = "* Please enter a valid time in hh:mm:ss am format.";
public static readonly string Number = "* Must be a valid number.";
public static readonly string Digit = "* Must be a valid whole number.";
public static readonly string NonNegative = "* Must be a non-negative number.";

public static string MaxLength(int len)
{
return "* Maximum " + len.ToString() + " characters are allowed.";
}
}
}

Defaul.aspx page.

<%@ Page Language="C#" AutoEventWireup="true"
CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>RegExp Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h3>
Validation Example</h3>
<table border="1" width="50%">
<tr>
<td style="width: 200px">
<asp:Label ID="LabelComment"
runat="server" Text="Comment:">
</asp:Label></td>
<td>
<asp:TextBox ID="TextBoxComment" runat="server"
TextMode="MultiLine" Width="500px" />
<asp:RegularExpressionValidator ID="CommentValidator"
runat="server" ControlToValidate="TextBoxComment">
</asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="LabelDate" runat="server"
Text="Date:"></asp:Label></td>
<td>
<asp:TextBox ID="TextBoxDate"
runat="server" Width="500px" />
<asp:RegularExpressionValidator ID="DateValidator" runat="server"
ControlToValidate="TextBoxDate"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="LabelTime" runat="server"
Text="Time:"></asp:Label></td>
<td>
<asp:TextBox ID="TextBoxTime" runat="server" Width="500px" />
<asp:RegularExpressionValidator ID="TimeValidator" runat="server"
ControlToValidate="TextBoxTime"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="LabelNumber" runat="server"
Text="Number:"></asp:Label></td>
<td>
<asp:TextBox ID="TextBoxNumber" runat="server" Width="500px" />
<asp:RegularExpressionValidator ID="NumberValidator" runat="server"
ControlToValidate="TextBoxNumber"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="LabelDigit" runat="server"
Text="Digit:"></asp:Label></td>
<td>
<asp:TextBox ID="TextBoxDigit" runat="server" Width="500px" />
<asp:RegularExpressionValidator ID="DigitValidator" runat="server"
ControlToValidate="TextBoxDigit"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="NonNegativeLabel" runat="server"
Text="Non Negative:"></asp:Label></td>
<td>
<asp:TextBox ID="TextBoxNonNegative" runat="server" Width="500px" />
<asp:RegularExpressionValidator ID="NonNegativeValidator" runat="server"
ControlToValidate="TextBoxNonNegative"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="UrlLabel" runat="server" Text="Url:">
</asp:Label></td>
<td>
<asp:TextBox ID="TextBoxUrl" runat="server" Width="500px" />
<asp:RegularExpressionValidator ID="UrlValidator" runat="server"
ControlToValidate="TextBoxUrl"></asp:RegularExpressionValidator>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>

Defaul.aspx.cs page

using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using ExampleUtil;
using Resource;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
CommentValidator.ValidationExpression = RegExp.MaxLength(50);
CommentValidator.ErrorMessage = ValidationErrorMessages.MaxLength(50);

DateValidator.ValidationExpression = RegExp.Date;
DateValidator.ErrorMessage = ValidationErrorMessages.Date;

TimeValidator.ValidationExpression = RegExp.Time;
TimeValidator.ErrorMessage = ValidationErrorMessages.Time;

NumberValidator.ValidationExpression = RegExp.Number;
NumberValidator.ErrorMessage = ValidationErrorMessages.Number;

DigitValidator.ValidationExpression = RegExp.Digit;
DigitValidator.ErrorMessage = ValidationErrorMessages.Digit;

NonNegativeValidator.ValidationExpression = RegExp.NonNegative;
NonNegativeValidator.ErrorMessage = ValidationErrorMessages.NonNegative;

UrlValidator.ValidationExpression = RegExp.Url;
UrlValidator.ErrorMessage = ValidationErrorMessages.Url;
}
}

Class Method Example, Methods in ASP.net C# Programming

noreply@blogger.com (Unknown) — Fri, 28 Oct 2011 23:46:00 -0700

A method is a code block that contains a series of statements. A program causes the statements to be executed by calling the method and specifying any required method arguments. In C#, every executed instruction is performed in the context of a method. The Main method is the entry point for every C# application and it is called by the common language runtime (CLR) when the program is started.

Method Signatures
Methods are declared in a class or struct by specifying the access level such as public or private, optional modifiers such as abstract or sealed, the return value, the name of the method, and any method parameters. These parts together are the signature of the method.

abstract class Motorcycle
{
// Anyone can call this.
public void StartEngine() {/* Method statements here */ }

// Only derived classes can call this.
protected void AddGas(int gallons) { /* Method statements here */ }

// Derived classes can override the base class implementation.
public virtual int Drive(int miles, int speed) { /* Method statements here */ return 1; }

// Derived classes must implement this.
public abstract double GetTopSpeed();
}

Method Access
Calling a method on an object is like accessing a field. After the object name, add a period, the name of the method, and parentheses. Arguments are listed within the parentheses, and are separated by commas. The methods of the Motorcycle class can therefore be called as in the following example:

class TestMotorcycle : Motorcycle
{

public override double GetTopSpeed()
{
return 108.4;
}

static void Main()
{

TestMotorcycle moto = new TestMotorcycle();

moto.StartEngine();
moto.AddGas(15);
moto.Drive(5, 20);
double speed = moto.GetTopSpeed();
Console.WriteLine("My top speed is {0}", speed);
}
}

Method Parameters vs. Arguments
The method definition specifies the names and types of any parameters that are required. When calling code calls the method, it provides concrete values called arguments for each parameter. The arguments must be compatible with the parameter type but the argument name (if any) used in the calling code does not have to be the same as the parameter named defined in the method. For example:

public void Caller()
{
int numA = 4;
// Call with an int variable.
int productA = Square(numA);

int numB = 32;
// Call with another int variable.
int productB = Square(numB);

// Call with an integer literal.
int productC = Square(12);

// Call with an expression that evaulates to int.
productC = Square(productA * 3);
}

int Square(int i)
{
// Store input argument in a local variable.
int input = i;
return input * input;
}

Passing by Reference vs. Passing by Value

By default, when a value type is passed to a method, a copy is passed instead of the object itself. Therefore, changes to the argument have no effect on the original copy in the calling method. You can pass a value-type by reference by using the ref keyword. For more information, see Passing Value-Type Parameters . For a list of built-in value types.

Reference types are passed by reference. When an object of a reference type is passed to a method, the reference points to the original object, not a copy. Changes made through this reference will therefore be reflected in the calling method. A reference type is created by using the class keyword as in the following example:

public class SampleRefType
{
public int value;
}

Now, if an object that is based on this type is passed to a method, the object will be passed by reference. For example:

public static void TestRefType()
{
SampleRefType rt = new SampleRefType();
rt.value = 44;
ModifyObject(rt);
Console.WriteLine(rt.value);
}
static void ModifyObject(SampleRefType obj)
{
obj.value = 33;
}

Return Values
Methods can return a value to the caller. If the return type, the type listed before the method name, is not void, the method can return the value by using the return keyword. A statement with the return keyword followed by a value that matches the return type will return that value to the method caller. The return keyword also stops the execution of the method. If the return type is void, a return statement without a value is still useful to stop the execution of the method. Without the return keyword, the method will stop executing when it reaches the end of the code block. Methods with a non-void return type are required to use the return keyword to return a value. For example, these two methods use the return keyword to return integers:

int result = obj.AddTwoNumbers(1, 2);
result = obj.SquareANumber(result);
// The result is 9.
Console.WriteLine(result)

source: MSDN

Web Form Master Pages in Visual Studio 2008

noreply@blogger.com (Unknown) — Fri, 28 Oct 2011 23:40:00 -0700

The way you use Master pages has changed in Visual Studio 2008. Remember, how in Visual Studio 2005 when you add a new Web Form in ASP.NET applications - you get to choose a master page to apply to the Web form. If you choose to use a Master page - then the page that is added, when you check the HTML code for that page - it is stripped of all the standard HTML tags - only the Page directive and the tags are available. This is a Content page.

In Visual Studio there are two types of Web Forms available - Web Form and the Web Content Form.

The Web Form is a standard Web Form - without the Master page, with its HTML code like a standard HTML page. Whereas, the Web Content Form is the one to which you can attach a Master page.

The Web Form page also has a MasterPageFile property. But, if you create a Web Form and then set the MasterPageFile property to link to your Master page you will get a run time error.

Content controls have to be top-level controls in a content page or a nested master page that references a master page.

This is because content pages must not have another other HTML tags or controls.

If you want to use Master Pages use Web Content Form, otherwise use the Web Form.

Another nice feature in Visual Studio 2008 - is that in that in the top right corner of the Design window of the Web content page is a link to the Master page that this page is linked to. Also, you can now see the source and the design view tiled in the design area.

SqlParameter Example, How to use SqlParameter in ASP.Net C#, SqlParameter, SqlDataReader, SqlCommand, SqlConnection Example

noreply@blogger.com (Unknown) — Thu, 20 Oct 2011 00:18:00 -0700

The process of SqlParameter using parameter contains two steps:

Create SqlParameter object and insert there value with applicable properties define the parameter in the SqlCommand command string, and assign the SqlParameter object to the SqlCommand object. When the SqlCommand executes, parameters will be replaced with values specified by the SqlParameter object.

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Configuration" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">
    protected void Page_Load(object sender, System.EventArgs e) {
        if (!Page.IsPostBack) {
            SqlConnection MyConnection;
            SqlCommand MyCommand;
            SqlDataReader MyReader;
            SqlParameter ITEMParam;

            MyConnection = new SqlConnection();
            MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings["AppConnectionString1"].ConnectionString;

            MyCommand = new SqlCommand();
            MyCommand.CommandText = "SELECT * FROM ITEM WHERE ITEMNAME = @ITEMNAME";
            MyCommand.CommandType = CommandType.Text;
            MyCommand.Connection = MyConnection;

            ITEMParam = new SqlParameter();
            ITEMParam.ParameterName = "@ITEMNAME";
            ITEMParam.SqlDbType = SqlDbType.VarChar;
            ITEMParam.Size = 25;
            ITEMParam.Direction = ParameterDirection.Input;
            ITEMParam.Value = "COMPUTER";

            MyCommand.Parameters.Add(ITEMParam);

            MyCommand.Connection.Open();
            MyReader = MyCommand.ExecuteReader(CommandBehavior.CloseConnection);

            GridViewExample.DataSource = MyReader;
            GridViewExample.DataBind();

            MyCommand.Dispose();
            MyConnection.Dispose();
        }
    }
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>SqlParameter Example: How to use SqlParameter in ASP.Net C#</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridViewExample" runat="server">
        </asp:GridView>
    </div>
    </form>
</body>
</html>

The SqlParameter type provides an easy and fast way to parameterize queries, allowing for bullet-proof and simple data access code. Here we examine the SqlParameter in an example written in the C# programming language, and then discuss some relevant points to parameterized queries and finally mention SQL injection issues.

Public method :: SqlParameter() -> Initializes a new instance of the SqlParameter class.

Public method :: SqlParameter(String, SqlDbType) -> Initializes a new instance of the SqlParameter class that uses the parameter name and the data type.

Public method :: SqlParameter(String, Object) -> Initializes a new instance of the SqlParameter class that uses the parameter name and a value of the new SqlParameter.

Public method :: SqlParameter(String, SqlDbType, Int32) -> Initializes a new instance of the SqlParameter class that uses the parameter name, the SqlDbType, and the size.

Public method :: SqlParameter(String, SqlDbType, Int32, String) -> Initializes a new instance of the SqlParameter class that uses the parameter name, the SqlDbType, the size, and the source column name.

Public method :: SqlParameter(String, SqlDbType, Int32, ParameterDirection, Boolean, Byte, Byte, String, DataRowVersion, Object) -> Initializes a new instance of the SqlParameter class that uses the parameter name, the type of the parameter, the size of the parameter, a ParameterDirection, the precision of the parameter, the scale of the parameter, the source column, a DataRowVersion to use, and the value of the parameter.

Public method :: SqlParameter(String, SqlDbType, Int32, ParameterDirection, Byte, Byte, String, DataRowVersion, Boolean, Object, String, String, String) -> Initializes a new instance of the SqlParameter class that uses the parameter name, the type of the parameter, the length of the parameter the direction, the precision, the scale, the name of the source column, one of the DataRowVersion values, a Boolean for source column mapping, the value of the SqlParameter, the name of the database where the schema collection for this XML instance is located, the owning relational schema where the schema collection for this XML instance is located, and the name of the schema collection for this parameter.

Public property :: CompareInfo -> Gets or sets the CompareInfo object that defines how string comparisons should be performed for this parameter.

Public property :: DbType -> Gets or sets the SqlDbType of the parameter.

Public property :: Direction -> Gets or sets a value that indicates whether the parameter is input -> only, output -> only, bidirectional, or a stored procedure return value parameter. (Overrides DbParameter.Direction.)

Public property :: IsNullable -> Gets or sets a value that indicates whether the parameter accepts null values. (Overrides DbParameter.IsNullable.)

Public property :: LocaleId -> Gets or sets the locale identifier that determines conventions and language for a particular region.

Public property :: Offset -> Gets or sets the offset to the Value property.

Public property :: ParameterName -> Gets or sets the name of the SqlParameter.

Public property :: Precision -> Gets or sets the maximum number of digits used to represent the Value property.

Public property :: Scale -> Gets or sets the number of decimal places to which Value is resolved.

Public property :: Size -> Gets or sets the maximum size, in bytes, of the data within the column.

Public property :: SourceColumn -> Gets or sets the name of the source column mapped to the DataSet and used for loading or returning the Value (Overrides DbParameter.SourceColumn.)

Public property :: SourceColumnNullMapping -> Sets or gets a value which indicates whether the source column is nullable. This allows SqlCommandBuilder to correctly generate Update statements for nullable columns. (Overrides DbParameter.SourceColumnNullMapping.)

Public property :: SourceVersion ->     Gets or sets the DataRowVersion to use when you load Value (Overrides DbParameter.SourceVersion.)

Public property :: SqlDbType -> Gets or sets the SqlDbType of the parameter.

Public property :: SqlValue -> Gets or sets the value of the parameter as an SQL type.

Public property :: TypeName -> Gets or sets the type name for a table -> valued parameter.

Public property :: UdtTypeName -> Gets or sets a string that represents a user -> defined type as a parameter.

Public property :: Value -> Gets or sets the value of the parameter.

Public property :: XmlSchemaCollectionDatabase -> Gets the name of the database where the schema collection for this XML instance is located.

Public property :: XmlSchemaCollectionName -> Gets the name of the schema collection for this XML instance.

Public property :: XmlSchemaCollectionOwningSchema -> The owning relational schema where the schema collection for this XML instance is located.

Example Splitting String, Split(ParamArray Char()) As String() ASP.Net C# Split String Function

noreply@blogger.com (Unknown) — Wed, 19 Oct 2011 03:51:00 -0700

ASP.Net C# Split string function provides the functionality to split the string into a string array by specifying its delimiters. C# split string function splits the string into array collection according to the number of separators passed to the split function. ASP.Net C# split string function removes the delimiters from the string and stores each part separated at consecutive indexes of array object. In ASP.Net 2.0 C# split string function has 6 overloads as follows:

1. public string[] Split(params char[] separator);

2. public string[] Split(char[] separator, int count);

3. public string[] Split(char[] separator, StringSplitOptions options);

4. public string[] Split(string[] separator, StringSplitOptions options);

5. public string[] Split(char[] separator, int count, StringSplitOptions options);

6. public string[] Split(string[] separator, int count, StringSplitOptions options);

How to Split a String with Specific Delimiter and Populate an Array in ASP.Net, String.Split Method (String[], StringSplitOptions) (System)

noreply@blogger.com (Unknown) — Wed, 19 Oct 2011 03:49:00 -0700

You want to split strings on different characters with single character or string delimiters.

using System;

class Program
{
    static void Main()
    {
    string s = "split strings on different characters";
    //
    // Split string on spaces.
    // ... This will separate all the words.
    //
    string[] words = s.Split(' ');
    foreach (string word in words)
    {
        Console.WriteLine(word);
    }
    }
}

Output:-

split
strings
on
different
characters

The input string, which contains four words, is split on spaces and the foreach loop then displays each word. The result value from Split is a string[] array.

StringSplitOptions:-

While the Regex type methods can be used to Split strings effectively, the string type Split method is faster in many cases. The Regex Split method is static; the string Split method is instance-based. The next example shows how you can specify an array as the first parameter to string Split.

Program that splits on multiple characters [C#]

using System;

class Program
{
    static void Main()
    {
    //
    // This string is also separated by Windows line breaks.
    //
    string value = "Jeans\r\nBabyDress\r\nKidsPants\r\nManJacket";

    //
    // Use a new char[] array of two characters (\r and \n) to break
    // lines from into separate strings. Use "RemoveEmptyEntries"
    // to make sure no empty strings get put in the string[] array.
    //
    char[] delimiters = new char[] { '\r', '\n' };
    string[] parts = value.Split(delimiters, StringSplitOptions.RemoveEmptyEntries);
    for (int i = 0; i < parts.Length; i++)
    {
        Console.WriteLine(parts[i]);
    }

    //
    // Same as the previous example, but uses a new string of 2 characters.
    //
    parts = value.Split(new string[] { "\r\n" }, StringSplitOptions.None);
    for (int i = 0; i < parts.Length; i++)
    {
        Console.WriteLine(parts[i]);
    }
    }
}

Output:-

Jeans
BabyDress
KidsPants
ManJacket

Separate words::

Here we see how you can separate words with Split. Usually, the best way to separate words is to use a Regex that specifies non-word chars. This example separates words in a string based on non-word characters. It eliminates punctuation and whitespace from the return array.

Program that separates on non-word pattern [C#]

using System;
using System.Text.RegularExpressions;

class Program
{
    static void Main()
    {
    string[] w = SplitWords("That is a cute girl, boy");
    foreach (string s in w)
    {
        Console.WriteLine(s);
    }
    Console.ReadLine();
    }

    /// <summary>
    /// Take all the words in the input string and separate them.
    /// </summary>
    static string[] SplitWords(string s)
    {
    //
    // Split on all non-word characters.
    // ... Returns an array of all the words.
    //
    return Regex.Split(s, @"\W+");
    // @      special verbatim string syntax
    // \W+    one or more non-word characters together
    }
}

Output

That
is
a
cute
girl
boy

Example How to split a string with specific delimiter and populate an array in ASP.Net:-

<%@ Page Language="C#" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">
    protected void page_Load(object sender, System.EventArgs e) {
        if(!this.IsPostBack)
        {
            txtExample1.Text = "Red.Green.Blue.HotPink.Pink";
            txtExample1.Width = 250;
        }
    }
    protected void btnExample1_Click(object sender, System.EventArgs e) {
        string myString = txtExample1.Text.ToString();
        char[] separator = new char[] {'.'};
        string[] colorList = myString.Split(separator);
        lstBoxExample1.DataSource = colorList;
        lstBoxExample1.DataBind();
        lstBoxExample1.Height = 100;
        lblExample1.Text = "String split and populate ListBox successfully!";
    }
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>How to split a string with specific delimiter and populate an array in ASP.Net </title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <h2 style="color:Teal">ASP.Net string example: Split</h2>
        <asp:Label
             ID="lblExample1"
             runat="server"
             Font-Size="Large"
             ForeColor="HotPink"
             Font-Bold="true"
             Font-Italic="true"
             >
        </asp:Label>
        <br /><br />
        <asp:ListBox
             ID="lstBoxExample1"
             runat="server"
             BackColor="DodgerBlue"
             ForeColor="AliceBlue"
             >
        </asp:ListBox>
        <br /><br />
        <asp:Label
             ID="lblExample2"
             runat="server"
             Text="Test String"
             ForeColor="DarkGreen"
             >
        </asp:Label>
        <asp:TextBox
             ID="txtExample1"
             runat="server"
             BackColor="DarkSeaGreen"
             ForeColor="DarkGreen"
             >
        </asp:TextBox>
        <br /><br />
        <asp:Button
             ID="btnExample1"
             runat="server"
             OnClick="btnExample1_Click"
             Font-Bold="true"
             Text="ASP.Net Split String And Populate ListBox"
             ForeColor="DarkGreen"
             />
    </div>
    </form>
</body>
</html>

Example How to Joining and Splitting Strings in ASP.Net C# Split(ParamArray Char()) As String()

noreply@blogger.com (Unknown) — Wed, 19 Oct 2011 03:48:00 -0700

Identifies the substrings in this instance that are delimited by one or more characters specified in an array, then places the substrings into a String array.

Overload List:

Identifies the substrings in this instance that are delimited by one or more characters specified in an array, then places the substrings into a String array.

Supported by the .NET Compact Framework.

    [Visual Basic] Overloads Public Function Split(ParamArray Char()) As String()

    [C#] public string[] Split(params char[]);

    [C++] public: String* Split(__wchar_t __gc[]) __gc[];

    [JScript] public function Split(Char[]) : String[];

Identifies the substrings in this instance that are delimited by one or more characters specified in an array, then places the substrings into a String array. A parameter specifies the maximum number of array elements to return.

    [Visual Basic] Overloads Public Function Split(Char(), Integer) As String()

    [C#] public string[] Split(char[], int);

    [C++] public: String* Split(__wchar_t __gc[], int) __gc[];

    [JScript] public function Split(Char[], int) : String[];

The string Split() and Join() methods provide functionality to work with delimited strings. The Split() method allows you to gather a delimited set of values from a string into an array and the Join() method lets you create a delimited string from an array. This supports both custom data formats as well as information interchange with other programs.

using System;

namespace ASPcsharp
{
    class StringJoinSplitExample
    {
        static void Main(string[] args)
        {
            // comma delimited string
            string commaDelimitedExample = "Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec";

            Console.WriteLine("Original Comma Delimited String: \n{0}\n", commaDelimitedExample);

            // separate individual items between commas
            string[] year = commaDelimitedExample.Split(new char[] {','});

            Console.WriteLine("Each individual item: ");

            foreach(string month in year)
            {
                Console.Write("{0} ", month);
            }
            Console.WriteLine("\n");

            // combine array elements with a new separator
            string colonDelimeted = String.Join(":", year);

            Console.WriteLine("New Colon Delimited String: \n{0}\n", colonDelimeted);

            string[] quarter = commaDelimitedExample.Split(new Char[] {','}, 3);

            Console.WriteLine("The First Three Items: ");

            foreach(string month in quarter)
            {
                Console.Write("{0} ", month);
            }
            Console.WriteLine("\n");

            string thirdQuarter = String.Join("/", year, 6, 3);

            Console.WriteLine("The Third Quarter: \n{0}\n", thirdQuarter);
        }
    }
}

.Net GridView - GridView Paging and Sorting Examples Paging and Sorting Data in ASP.Net 2.0/3.5/4.0- How to Paging & Sort GridView Data from a SqlDataSource GridView's Data, GridView control

noreply@blogger.com (Unknown) — Wed, 19 Oct 2011 03:40:00 -0700

.Net GridView Paging and sorting data in a GridView that comes from a SqlDataSource is a breeze with ASP.NET 2.0. As in the demos before, start by adding a SqlDataSource that accesses the desired data. Next, add a GridView. The GridView's Smart Tag contains two checkboxes: Enable Paging and Enable Sorting. To turn on sorting and/or paging, simply check the appropriate checkboxes. It's that simple!

The SqlDataSource has a DataSourceMode property that you can set to specify if the SqlDataSource returns a DataReader or DataSet, with DataSet being the default. When creating a pageable GridView you must return a DataSet. The GridView's sorting capabilities can only be utilized with either a DataSet or a DataReader, but when sorting by returning a DataReader you must retrieve your data from a stored procedure. Furthermore, this stored procedure must accept a parameter indicating the sort expression; specify the name of this input parameter through the SqlDataSource's SortParameterName property.

<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<script runat="server">
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Example Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:SqlDataSource ID="ItemDataSource" Runat="server"
         SelectCommand="SELECT [ItemName], [ItemUnitPrice],
         [ItemUnitsInStock], [ItemQuantityPerUnit] FROM [ItemProducts]"
            ConnectionString=
            "<%$ ConnectionStrings:MyConnectionString %>">
        </asp:SqlDataSource>
        <asp:GridView ID=" ExampleGridView" Runat="server"
         DataSourceID="ItemDataSource" AutoGenerateColumns="False"
            AllowSorting="True" BorderWidth="2px" BackColor="White"
            GridLines="None" CellPadding="3"
            CellSpacing="1" BorderStyle="Ridge" BorderColor="White"
            AllowPaging="True">
            <FooterStyle ForeColor="Black"
               BackColor="#C6C3C6"></FooterStyle>
            <PagerStyle ForeColor="Black" HorizontalAlign="Right"
               BackColor="#C6C3C6"></PagerStyle>
            <HeaderStyle ForeColor="#E7E7FF" Font-Bold="True"
               BackColor="#4A3C8C"></HeaderStyle>
            <Columns>
                <asp:BoundField HeaderText="Product"
                  DataField="ItemName" SortExpression="ItemName">
                </asp:BoundField>
                <asp:BoundField HeaderText="Unit Price"
                  DataField="ItemUnitPrice" SortExpression="ItemUnitPrice"
                    DataFormatString="{0:c}">
                    <ItemStyle HorizontalAlign="Right"></ItemStyle>
                </asp:BoundField>
                <asp:BoundField HeaderText="Units In Stock"
                  DataField="ItemUnitsInStock"
                  SortExpression="ItemUnitsInStock"
                    DataFormatString="{0:d}">
                    <ItemStyle HorizontalAlign="Right"></ItemStyle>
                </asp:BoundField>
                <asp:BoundField HeaderText="Quantity Per Unit"
                  DataField="ItemQuantityPerUnit"></asp:BoundField>
            </Columns>
            <SelectedRowStyle ForeColor="White" Font-Bold="True"
                 BackColor="#9471DE"></SelectedRowStyle>
            <RowStyle ForeColor="Black" BackColor="#DEDFDE"></RowStyle>
        </asp:GridView>
        <i>You are viewing page
        <%=ExampleGridView.PageIndex + 1%>
        of
        <%=ExampleGridView.PageCount%>
        </i>
    </div>
    </form>
</body>
</html>

In order to have the data paged appropriately in the ASP.NET page there are a couple of settings on the ObjectDataSource we must set in order to have paging work correctly:

A.EnablePaging—set this to True.
B.MaximumRowsParameterName—this property provides the name of the first integer parameter to the method that pages the results. It defaults to maximumRows. If you use a different parameter name in your methods, you'll need to specify that parameter name in this property.
C.StartRowIndexParameterName—similar to MaximumRowsParameterName, in that this property value specifies the second integer parameter name for paging. It defaults to startRowIndex, so you only need to set this property explicitly if you use a different parameter name in your code.
D.SelectCountMethod—the name of the method that returns the total number of records to be paged through.

And one property we must set in order to have sorting work properly:

1.SortParameterName—the name of the string input parameter specifying how to sort the data.

<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<script runat="server">
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Grid Example Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:ObjectDataSource ID="GridDataSource"
          Runat="server" TypeName="GridProductDAL"
          SortParameterName="SortExpression"
            SelectMethod="GridGetProducts" EnablePaging="True"
            SelectCountMethod="GridTotalNumberOfProducts">
        </asp:ObjectDataSource>
        <asp:GridView ID="ItemproductsGridView" AllowPaging="True"
         BorderColor="White" BorderStyle="Ridge"
            CellSpacing="1" CellPadding="3" GridLines="None"
            BackColor="White" BorderWidth="2px"
            AutoGenerateColumns="False"
            DataSourceID="GridDataSource"
            Runat="server" AllowSorting="True">
            <FooterStyle ForeColor="Black" BackColor="#C6C3C6"></FooterStyle>
            <PagerStyle ForeColor="Black" HorizontalAlign="Right"
             BackColor="#C6C3C6"></PagerStyle>
            <HeaderStyle ForeColor="#E7E7FF" Font-Bold="True"
             BackColor="#4A3C8C"></HeaderStyle>
            <Columns>
                <asp:BoundField HeaderText="Product"
                  DataField="ItemProductName"
                  SortExpression="ItemProductName"></asp:BoundField>
                <asp:BoundField HeaderText="Unit Price"
                  DataField="ItemUnitPrice" SortExpression="ItemUnitPrice"
                    DataFormatString="{0:c}">
                    <ItemStyle HorizontalAlign="Right"></ItemStyle>
                </asp:BoundField>
                <asp:BoundField HeaderText="Units In Stock"
                    DataField="ItemUnitsInStock"
                    SortExpression="ItemUnitsInStock"
                    DataFormatString="{0:d}">
                    <ItemStyle HorizontalAlign="Right"></ItemStyle>
                </asp:BoundField>
                <asp:BoundField HeaderText="Quantity Per Unit"
                   DataField="ItemQuantityPerUnit"></asp:BoundField>
            </Columns>
            <SelectedRowStyle ForeColor="White"
               Font-Bold="True"
               BackColor="#9471DE"></SelectedRowStyle>
            <RowStyle ForeColor="Black" BackColor="#DEDFDE"></RowStyle>
        </asp:GridView>
        <i>You are viewing page
        <%=ItemproductsGridView.PageIndex + 1%>
        of
        <%=ItemproductsGridView.PageCount%>
        </i>

    </div>
    </form>
</body>
</html>

.Net GridView - GridView Sorting Example, How to Sort GridView Data, GridView control in ASP.Net 2.0/3.5/4.0

noreply@blogger.com (Unknown) — Wed, 19 Oct 2011 03:38:00 -0700

.Net GridView GridView.Sorting Event

public event GridViewSortEventHandler Sorting

<asp:GridView OnSorting="GrExampleIDViewSortEventHandler" />

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

protected voExampleID ExampleGridView_Sorting(object sender, GrExampleIDViewSortEventArgs e)
{

    //Retrieve the table from the session object.
    DataTable dt = Session["ExampleTable"] as DataTable;

    if (dt != null)
    {

      //Sort the data.
      dt.DefaultView.Sort = e.SortExpression + " " + GetSortDirection(e.SortExpression);
      ExampleGridView.DataSource = Session["ExampleTable"];
      ExampleGridView.DataBind();
    }

}

private string GetSortDirection(string column)
{

    // By default, set the sort direction to ascending.
    string sortDirection = "ASC";

    // Retrieve the last column that was sorted.
    string sortExpression = ViewState["SortExpression"] as string;

    if (sortExpression != null)
    {
      // Check if the same column is being sorted.
      // Otherwise, the default value can be returned.
      if (sortExpression == column)
      {
        string lastDirection = ViewState["SortDirection"] as string;
        if ((lastDirection != null) && (lastDirection == "ASC"))
        {
          sortDirection = "DESC";
        }
      }
    }

    // Save new values in ViewState.
    ViewState["SortDirection"] = sortDirection;
    ViewState["SortExpression"] = column;

    return sortDirection;
}

protected voExampleID Page_Load(object sender, EventArgs e)
{

    if (!Page.IsPostBack)
    {

      // Create a new table.
      DataTable ExampleTable = new DataTable("TaskList");

      // Create the columns.
      ExampleTable.Columns.Add("ExampleID", typeof(int));
      ExampleTable.Columns.Add("ExampleDescription", typeof(string));

      //Add data to the new table.
      for (int i = 0; i < 10; i++)
      {
        DataRow tableRow = ExampleTable.NewRow();
        tableRow["ExampleID"] = i;
        tableRow["ExampleDescription"] = "Task " + (10 - i).ToString();
        ExampleTable.Rows.Add(tableRow);
      }

      //Persist the table in the Session object.
      Session["ExampleTable"] = ExampleTable;

      //Bind the GrExampleIDView control to the data source.
      ExampleGridView.DataSource = Session["ExampleTable"];
      ExampleGridView.DataBind();

    }

}

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Sorting Example asp:GridView </title>
</head>
<body>
    <form ExampleID="form1" runat="server">
    <div>

      <asp:GridView ExampleID="ExampleGridView" runat="server"
        AllowSorting="true"
        OnSorting="ExampleGridView_Sorting" >
      </asp:GridView>

    </div>
    </form>
</body>
</html>

The Sorting event is raised when the hyperlink to sort a column is clicked, but before the GridView control handles the sort operation. This enables you to provide an event-handling method that performs a custom routine, such as canceling the sorting operation, whenever this event occurs.

A GridViewSortEventArgs object is passed to the event-handling method, which enables you to determine the sort expression for the column and to indicate that the selection operation should be canceled. To cancel the selection operation, set the Cancel property of the GridViewSortEventArgs object to true.

For information about how to programmatically initiate a sort operation.

<%@ Page Language="C#" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>ASP.Net GridView Sorting Example- How to Sort GridView Data</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <h2 style="color:Green">Sorting In GridView</h2>
        <asp:SqlDataSource
             ID="SqlDataSourceExample"
             runat="server"
             ConnectionString="<%$ ConnectionStrings:MyConnectionString %>"
             SelectCommand="SELECT TOP 6 ItemID, ItemName, ItemUnitPrice FROM TableProducts"
             >
        </asp:SqlDataSource>
        <asp:GridView
             ID="GridViewExample"
             runat="server"
             DataSourceID="SqlDataSourceExample"
             AutoGenerateColumns="false"
             BackColor="Red"
             ForeColor="Goldenrod"
             BorderColor="Yellow"
             BorderStyle="Groove"
             AllowSorting="true"
             >
            <Columns>
                <asp:BoundField SortExpression="ItemID" HeaderText="Product ID" DataField="ItemID" />
                <asp:BoundField SortExpression="ItemName" HeaderText="Product Name" DataField="ItemName" />
                <asp:BoundField SortExpression="ItemUnitPrice" HeaderText="Unit Price" DataField="ItemUnitPrice" />
            </Columns>
        </asp:GridView>
    </div>
    </form>
</body>
</html>

DataAdapter Example, How to use DataAdapter / SqlDataAdapter in ASP.Net 2.0/3.5/4.0, C# ADO.NET SqlDataAdapter

noreply@blogger.com (Unknown) — Wed, 19 Oct 2011 03:35:00 -0700

The ADO.NET DataSet is a memory-resident representation of data that provides a consistent relational programming model independent of the data source. The DataSet represents a complete set of data including tables, constraints, and relationships among the tables. Because the DataSet is independent of the data source, a DataSet can include data local to the application, as well as data from multiple data sources. Interaction with existing data sources is controlled through the DataAdapter.

Each .NET Framework data provider included with the .NET Framework has a DataAdapter object: the .NET Framework Data Provider for OLE DB includes an OleDbDataAdapter object, the .NET Framework Data Provider for SQL Server includes a SqlDataAdapter object, and the .NET Framework Data Provider for ODBC includes an OdbcDataAdapter object. A DataAdapter is used to retrieve data from a data source and populate tables within a DataSet. The DataAdapter also resolves changes made to the DataSet back to the data source. The DataAdapter uses the Connection object of the .NET Framework data provider to connect to a data source and Command objects to retrieve data from and resolve changes to the data source.

The SelectCommand property of the DataAdapter is a Command object that retrieves data from the data source. The InsertCommand, UpdateCommand, and DeleteCommand properties of the DataAdapter are Command objects that manage updates to the data in the data source according to modifications made to the data in the DataSet. These properties are covered in more detail in Updating the Database with a DataAdapter and the DataSet.

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Configuration" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">
    protected void Page_Load(object sender, System.EventArgs e) {
        if (!Page.IsPostBack) {
            SqlConnection MySqlConnection;
            SqlCommand MySqlCommand;
            SqlDataAdapter MySqlDataAdapter;
            DataTable MyDataTable;

            MySqlConnection = new SqlConnection();
            MySqlConnection.ConnectionString = ConfigurationManager.ConnectionStrings["MyAppConnectionString"].ConnectionString;

            MySqlCommand = new SqlCommand();
            MySqlCommand.CommandText = "SELECT TOP 50 * FROM < Tbl Employee >";
            MySqlCommand.CommandType = CommandType.Text;
            MySqlCommand.Connection = MySqlConnection;

            MyDataTable = new DataTable();
            MySqlDataAdapter = new SqlDataAdapter();
            MySqlDataAdapter.SelectCommand = MySqlCommand;
            MySqlDataAdapter.Fill(MyDataTable);

            GridViewData.DataSource = MyDataTable.DefaultView;
            GridViewData.DataBind();

            MySqlDataAdapter.Dispose();
            MySqlCommand.Dispose();
            MySqlConnection.Dispose();

        }
    }
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>DataAdapter Example: How to use DataAdapter in ASP.Net C#</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridViewData" runat="server"></asp:GridView>
    </div>
    </form>
</body>
</html>

ADO.NET includes many objects you can use to work with data. This section introduces some of the primary objects you will use. Over the course of this tutorial, you'll be exposed to many more ADO.NET objects from the perspective of how they are used in a particular lesson. The objects below are the ones you must know. Learning about them will give you an idea of the types of things you can do with data when using ADO.NET.

using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace WindowsFormsApplicationExample
{
    public partial class FormExample : Form
    {
    public FormExample()
    {
        InitializeComponent();
        FillData();
    }

    void FillData()
    {

        // 1.Open connection
        using (SqlConnection conn = new SqlConnection(
        Properties.Settings.Default.DataConnectionString))
        {
        conn.Open();


        // 2.Create new DataAdapter
        using (SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM EmployeeTable", conn))
        {


            // 3.Use DataAdapter to fill DataTable
            DataTable table = new DataTable();
            adapter.Fill(table);


            // 4.Render data onto the screen
            // dataGridViewExample.DataSource = table;
        }
        }
    }
    }
}

The purpose of the DataAdapter is embedded in its name: It performs the activities necessary to get the data from the data source on the server into the database that's held in the DataSet. To do that, the DataAdapter lets us specify the commands that should be carried out to retrieve and update data.

In ADO, if we used a client-side Recordset, our data was disconnected from the data source. This had lots of advantages, not the least of which was that we could close our application's connection to the data source and still work with the data. This would free up the connection so that it could be used by other applications, improving our application's scalability.

ASP Gridview - Gridview in ASP.Net - How to use GridView in ASP.Net, GridView Control

noreply@blogger.com (Unknown) — Tue, 18 Oct 2011 05:42:00 -0700

ASP Gridview - Gridview in ASP.Net -GridView Example- How to use GridView in ASP.Net

The new data source controls in ASP.NET 2.0 make accessing data much quicker and easier than with ASP.NET 1.x. Similarly, the GridView makes displaying that data much simpler than with the DataGrid in ASP.NET 1.x. With the GridView you can specify that the data be sortable and/or pageable by simply checking a checkbox. Same for adding a Delete column or for allowing the user to edit the GridView's underlying data.

In this article we'll look at how to use the GridView to display data. To start, we'll take a look at the data source controls and see how to bind various types of data to a GridView, all without writing a single line of code. After these preliminary examples, we'll move on to examining how to accomplish a number of real-world tasks with the GridView, including: formatting; paging, sorting, editing, and deleting; filtering data; effectively displaying drill-down data; and other examples. Each example we'll look at includes a discussion on the new techniques examined and, where source code is needed, both Visual Basic and C# code is provided. Best of all, you can download the complete, working examples and try them out as-is or tweak them to meet your particular needs.

<%@ Page Language="C#" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>How to use GridView in asp.net</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>

        <asp:GridView ID="GridViewExample" runat="server" AllowPaging="True"
            AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="EmployeeID"
            DataSourceID="SqlDataSourceData">
            <Columns>
                <asp:BoundField DataField="EmployeeID" HeaderText="EmployeeID" ReadOnly="True"
                    SortExpression="EmployeeID" />
                <asp:BoundField DataField="CompanyName" HeaderText="CompanyName"
                    SortExpression="CompanyName" />
                <asp:BoundField DataField="PersonName" HeaderText="PersonName"
                    SortExpression="PersonName" />
                <asp:BoundField DataField="PersonTitle" HeaderText="PersonTitle"
                    SortExpression="PersonTitle" />
                <asp:BoundField DataField="Address" HeaderText="Address"
                    SortExpression="Address" />
                <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
                <asp:BoundField DataField="Region" HeaderText="Region"
                    SortExpression="Region" />
                <asp:BoundField DataField="PinCode" HeaderText="PinCode"
                    SortExpression="PinCode" />
                <asp:BoundField DataField="Country" HeaderText="Country"
                    SortExpression="Country" />
                <asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" />
                <asp:BoundField DataField="Fax" HeaderText="Fax" SortExpression="Fax" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSourceData" runat="server"
            ConnectionString="<%$ ConnectionStrings:AppSQLConnectionString %>"
            SelectCommand="SELECT * FROM [Employee]"></asp:SqlDataSource>

    </div>
    </form>
</body>
</html>

There is another cool feature that I want to mention here. Suppose you have many records in the database and you execute a query and some of the records in the database are blank meaning that there is nothing inside them but just merely NULL values. When you bind those to the grid view control as expected you will get some blank rows on the page which really looks ugly. Grid view exposes a property named EmptyDataText which can be used to fill the rows with the text which are empty and hence return nothing. This will only work and the text will only be shown if EmptyDataTemplate is not defined.

I don't know if you have noticed or not but did you wonder that where are the edit,update and cancel buttons which were used for in-place editing feature. Well they all are placed under the CommandField type column.

You can add Edit, Delete, Select, Update and Cancel link buttons to your grid view control. In Asp.net 1.1 and using the datagrid control we had to write some code in order to get the datagrid in the edit mode. Grid View does not need any code to transform into edit mode and you can just switch to edit mode with a click of a button also you don't need any code in order to cancel the edit mode and switch the grid view back to its original condition.

What is Type safety in .NET?

noreply@blogger.com (Unknown) — Sat, 15 Oct 2011 05:01:00 -0700

Type-safe code accesses only the memory locations it is authorized to access. For example, type-safe code cannot read values from another object’s private fields. It accesses types only in well-defined, allowable ways. If we want to work directly with memory addresses and can manipulate bytes at these addresses then we have to declare that code chunk as unsafe using the unsafe Keyword in C#. So that CLR will not do any extra verification on this code.

Actually during just-in-time (JIT) compilation, an optional verification process examines the metadata and Microsoft intermediate language (MSIL) of a method to be JIT-compiled into native machine code to verify that they are type safe. This process is skipped if the code has permission to bypass verification. For example, the runtime cannot prevent unmanaged code from calling into native (unmanaged) code and performing malicious operations. When code is type safe, the runtime’s security enforcement mechanism ensures that it does not access native code unless it has permission to do so. All code that is not type safe must have been granted Security Permission with the passed enum member Skip Verification to run.

What is the role of garbage collector in .NET?

noreply@blogger.com (Unknown) — Sat, 15 Oct 2011 04:58:00 -0700

Objects created are stored on heap. Since the memory (here heap) is exhaustible, .NET identifies a mechanism to collect the unused memory(heap). GC does an automatic sweep of heap once it is full. GC can only destroy managed objects.

GC will finalize all the objects in the memory that are not being used anymore and thereby freeing the memory allocated to them.

.NET uses a three-generation approach to collecting memory. Newly allocated memory tends to be freed more frequently than older allocations, which tend to be more permanent. Gen 0 (Zero) is the youngest generation and, after a garbage collection, any survivors go on to Gen 1. Likewise, any survivors of a Gen 1 collection go on to Gen 2. Usually garbage collection will occur only on Gen 0, and only if after it has reached some limit. Until memory is exhausted, the cost of allocating each new object is that of incrementing a pointer–which is close to the performance of advancing the stack pointer.

CLR calls the GC when there is a high memory pressure and it is not able to find any exact place to allocate a new object or the applied threshold is reached.

What is the difference between manageable and unmanageable code?

noreply@blogger.com (Unknown) — Sat, 15 Oct 2011 04:55:00 -0700

Code which targets the .NET framework CLR is manageable meaning CLR can provide its services like type safety, memory management, exceptional handling etc to this type of code.
Managed code is always compiled into MSIL. When a .NET application is run this compiled MSIL is compiled to native code using JIT (Just In Time compiler). This JIT generates the native code as per the hardware specification on the system.
Since all this process happens under the control of a managed environment CLR, CLR provides all its rich functionality. Managed code provides platform independence since the code is converted to MSIL and then converted to native code depending on the system architecture.

The code that does not target CLR is unmanageable. It cannot run under CLR. This code directly runs under OS control. Applications written in traditional applications like C++, VB, C generate unmanaged code. This targets the computer architecture. Unmanaged code is always compiled to target a specific architecture and will only run on the intended platform. This means that if you want to run the same code on different architecture then you will have to recompile the code using that particular architecture. Unmanaged code is always compiled directly to the native code which is architecture specific. This code cannot be executed on other platforms that are different than the one on which the code was compiled.
All the features provided by CLR are unavailable and are to be taken care by the code. Hence this causes memory leaks in traditional applications.

What is an AppDomain? What is a process? What is thread? What is the difference between AppDomain and process?

noreply@blogger.com (Unknown) — Sat, 15 Oct 2011 04:52:00 -0700

Process:

A computer program is a set of instructions. Operating system executes a computer program by allocating a process for a program. Several processes may be associated with the execution of a single program. A process is an instance of machine code associated with a program. It has memory for instructions, data, a call stack and a heap

AppDomain:

An AppDomain is a light-weight process which separates one application in .NET with another. CLR creates an AppDomain when an application is loaded. Each application will have an AppDomain associated. Each AppDomain can have different threads running in it. Each app domain will have its associated code, data and configuration. Hence when one application crashes, it does not affect other.

Thread:

Each process can have multiple threads. Multiple threads can share same execution code and resources.
A multi-threaded process can perform several tasks concurrently.

How does one compare strings in C#?

noreply@blogger.com (Unknown) — Sat, 15 Oct 2011 04:42:00 -0700

In the past, you had to call .ToString() on the strings when using the == or != operators to compare the strings’ values. That will still work, but the C# compiler now automatically compares the values instead of the references when the == or != operators are used on string types. If you actually do want to compare references, it can be done as follows: if ((object) str1 == (object) str2) { … } Here’s an example showing how string compares work:

using System;
public class StringTest
{
    public static void Main(string[] args)
    {
        Object nullObj = null; Object realObj = new StringTest();
        int i = 10;
        Console.WriteLine(\"Null Object is [\" + nullObj + \"]\n\"
            + \"Real Object is [\" + realObj + \"]\n\"
            + \"i is [\" + i + \"]\n\");
            // Show string equality operators
        string str1 = \"foo\";
        string str2 = \"bar\";
        string str3 = \"bar\";
        Console.WriteLine(\"{0} == {1} ? {2}\", str1, str2, str1 == str2 );
        Console.WriteLine(\"{0} == {1} ? {2}\", str2, str3, str2 == str3 );
    }
}

Output:

Null Object is []
Real Object is [StringTest]
i is [10]
foo == bar ? False
bar == bar ? True

Can you have two files with the same file name in GAC?

noreply@blogger.com (Unknown) — Sat, 15 Oct 2011 04:41:00 -0700

Can you have two files with the same file name in GAC? Yes, remember that GAC is a very special folder, and while normally you would not be able to place two files with the same name into a Windows folder, GAC differentiates by version number as well, so it’s possible for MyApp.dll and MyApp.dll to co-exist in GAC if the first one is version 1.0.0.0 and the second one is 1.1.0.0.

What is delay signing?

noreply@blogger.com (Unknown) — Sat, 15 Oct 2011 04:40:00 -0700

Delay signing allows you to place a shared assembly in the GAC by signing the assembly with just the public key. This allows the assembly to be signed with the private key at a later stage, when the development process is complete and the component or assembly is ready to be deployed. This process enables developers to work with shared assemblies as if they were strongly named, and it secures the private key of the signature from being accessed at different stages of development.

What is a Windows Service and how does its lifecycle differ from a standard EXE? (interview questions and answers)

noreply@blogger.com (Unknown) — Sat, 15 Oct 2011 03:58:00 -0700

ASP.NET interview questions and answers

    1.Describe the difference between a Thread and a Process?
    2.What is a Windows Service and how does its lifecycle differ from a standard EXE?
    3.What is the maximum amount of memory any single process on Windows can address? Is this different than the maximum virtual memory for the system? How would this affect a system design?
    4.What is the difference between an EXE and a DLL?
    5.What is strong-typing versus weak-typing? Which is preferred? Why?

    6.What is wrong with a line like this? DateTime.Parse(myString)?
    7.What are PDBs? Where must they be located for debugging to work?
    8.What is cyclomatic complexity and why is it important?
    9.Write a standard lock() plus double check to create a critical section around a variable access.
    10.What is FullTrust? Do GAC’ed assemblies have FullTrust?
    11.What benefit does your code receive if you decorate it with attributes demanding specific Security permissions?
    12.What does this do? gacutil /l | find /i “about”
    13.What does this do? sn -t foo.dll
    14.What ports must be open for DCOM over a firewall? What is the purpose of Port 135?
    15.Contrast OOP and SOA. What are tenets of each
    16.How does the XmlSerializer work? What ACL permissions does a process using it require?
    17.Why is catch(Exception) almost always a bad idea?
    18.What is the difference between Debug.Write and Trace.Write? When should each be used?
    19.What is the difference between a Debug and Release build? Is there a significant speed difference? Why or why not?
    20.Does JITting occur per-assembly or per-method? How does this affect the working set?
    21.Contrast the use of an abstract base class against an interface?
    22.What is the difference between a.Equals(b) and a == b?
    23.In the context of a comparison, what is object identity versus object equivalence?
    24.How would one do a deep copy in .NET?
    25.Explain current thinking around IClonable.
    26.What is boxing?
    27.Is string a value type or a reference type?

Exception in .NET / C# / VB.Net

noreply@blogger.com (Unknown) — Sat, 24 Sep 2011 03:05:00 -0700

Exceptions are errors that occur during the runtime of a program.

The advantage of using exceptions is that the program doesn’t terminate due to the occurrence of the exception.

Whenever an exception is occurred the .NET runtime throws an object of specified type of Exception.

The class ‘Exception’ is the base class of all the exceptions.

common types of exceptions:

    ArgumentException

    ArgumentNullException

    ArgumentOutOfRangeException

    DuplicateWaitObjectException

    ArithmeticException

    DivideByZeroException

    OverflowException

    NotFiniteNumberException

    ArrayTypeMismatchException

    ExecutionEngineException

    FormatException

    IndexOutOfRangeException

    InvalidCastException

    InvalidOperationException

    ObjectDisposedException

    InvalidProgramException

    IOIOException

    IODirectoryNotFoundException

    IOEndOfStreamException

    IOFileLoadException

    IOFileNotFoundException

    IOPathTooLongException

    NotImplementedException

    NotSupportedException

    NullReferenceException

    OutOfMemoryException

    RankException

    SecuritySecurityException

    SecurityVerificationException

    StackOverflowException

    ThreadingSynchronizationLockException

    ThreadingThreadAbortException

    ThreadingThreadStateException

    TypeInitializationException

    UnauthorizedAccessException

It is a runtime error which occurs because of unexpected and invalid code execution.

.Net had enhanced exception handling features. All exceptions inherit from System.Exception.

object pooling and connection pooling in ASP.Net / C#

noreply@blogger.com (Unknown) — Sat, 24 Sep 2011 03:05:00 -0700

In Object pooling, you can control the number of connections.

In connection pooling, you can control the maximum number reached.

When using connection pooling, if there is nothing in the pool, a connection is created since the creation is on the same thread.

In object pooling, the pool decides the creation of an object depending on whether the maximum is reached which in case if it is, the next available object is returned. However, this could increase the time complexity if the object is heavy.

Object pooling allows you to control the number of connections being used, whereas connection pooling allows the control of maximum number reached.

Object Pool in C#.NET:

Creating pool manager.

public sealed class MyPoolManager
{
       private Queue poolQ = new Queue();
       private Hashtable tblPool = new Hashtable();
       private static readonly object objLock = new object();
       private const int PoolSize = 10;
       private int count = 0;
       private static MyPoolManager poolManager = null;
       ///

/// Private constructor to prevent instantiation
///

       private MyPoolManager()
       {
       }

    static MyPoolManager()
     {
          poolManager = new MyPoolManager();
     }

      public static MyPoolManager Instance
      {
           get
           {
                if (poolManager != null)
                {
                     return poolManager;
                }
                      return null;
            }
       }

      public void CreatePoolObjects(object obj)
      {
             object _obj = obj;
             count = 0;
             poolQ.Clear();
             tblPool.Clear();

             for (int objCounter = 0; objCounter < PoolSize; objCounter++)
             {
                  _obj = new object();

                  lock (objLock)
                  {
                        tblPool.Add(_obj.GetHashCode(), _obj);
                        poolQ.Enqueue(_obj);
                        count++;
                   }
              }
       }

       public bool AddObjectToPool(object obj)
       {
            if (count == PoolSize)
                 return false;

             lock (objLock)
             {
                   tblPool.Add(obj.GetHashCode(), obj);
                   poolQ.Enqueue(obj);
                   count++;
             }
                    return true;
         }

       public object ReleaseObjectFromPool()
       {
            if (count == 0)
                  return null;

             lock (objLock)
             {
                   tblPool.Remove(poolQ.Dequeue().GetHashCode());
                   count--;
                   if (poolQ.Count > 0)
                           return poolQ.Dequeue();
              }
                    return null;
         }

       public object ReleaseObjectFromPool(object obj)
       {
                if (count == 0)
                        return null;

                lock (objLock)
                {
                        tblPool.Remove(obj.GetHashCode());
                        count--;
                        PutInPoolAgain();
                        return obj;
               }
       }

       private void PutInPoolAgain()
       {
               if (poolQ.Count > 0)
                         poolQ.Clear();

               foreach (int key in tblPool.Keys)
               {
                      poolQ.Enqueue(tblPool[key]);
               }
       }

        public int CurrentObjectsInPool
        {
               get
               {
                    return count;
               }
         }

        public int MaxObjectsInPool
        {
                  get
                  {
                          return PoolSize;
                  }
         }
}

using MyPoolManager
object obj1 = new object();
object obj2 = new object();
MyPoolManager poolManager = MyPoolManager.Instance;
poolManager.AddObjectToPool(obj1);
poolManager.AddObjectToPool(obj2);
MessageBox.Show(poolManager.CurrentObjectsInPool.ToString());
poolManager.ReleaseObjectFromPool(obj1);
MessageBox.Show(poolManager.CurrentObjectsInPool.ToString());
object obj = null;
for(;;)
{
       obj = poolManager.ReleaseObjectFromPool();
       if(obj != null)
            MessageBox.Show(obj.GetHashCode().ToString());
       else
       {
            MessageBox.Show("No more objects in the pool");
            break;
       }
}

Web Service in .NET C# / VB.Net

noreply@blogger.com (Unknown) — Sat, 24 Sep 2011 03:03:00 -0700

"WebMethod()" converts the functions in your application into web services

Example:

VB.Net:

<%@ WebService Language="VBScript" Class="LengthConvert" %>

Imports System
Imports System.Web.Services

Public Class LengthConvert :Inherits WebService
   Public Function KilometerToMeter(ByVal Kilometer As String) As String
         return (Kilometer * 1000)
         end function
end class

C#:

[WebService(Namespace = http://tempuri.org/)]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class Service1 : System.Web.Services.WebService
{
     [WebMethod]
     public string HelloWorld()
     {
            return "Hello World";
     }
}