ASP Dot NET Online Training Services by Quontra Solutions

Tuesday, 29 July 2014

ComboBox Append DataBound Items in ASP.NET Ajax

Ajax ComboBox – How to use AppendDataBoundItems in asp.net ComboBox

<%@ Page Language=“C#” AutoEventWireup=“true” %>
<%@ Register Assembly=“AjaxControlToolkit” Namespace=“AjaxControlToolkit” TagPrefix=“asp” %>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>
<script runat=“server”>
void ComboBoxDataBind()
{
string[] Colors = { “Red”, “Green”, “Blue” };
ComboBox1.DataSource = Colors;
ComboBox1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
ComboBox1.AppendDataBoundItems = true;
ComboBoxDataBind();
Label1.Text = “AppendDataBoundItems Now: True”;
}
protected void Button2_Click(object sender, EventArgs e)
{
ComboBox1.AppendDataBoundItems = false;
ComboBoxDataBind();
Label1.Text = “AppendDataBoundItems Now: False”;
}
</script>
<html xmlns=“http://www.w3.org/1999/xhtml”>
<head id=“Head1″ runat=“server”>
<title>Ajax ComboBox - How to use AppendDataBoundItems in asp.net ComboBox</title>
</head>
<body>
<form id=“form1″ runat=“server”>
<div>
<h2 style=“color:DarkBlue; font-style:italic;”>
ASP.NET Ajax ComboBox - How to use
<br />AppendDataBoundItems in asp.net ComboBox
</h2>
<hr width=“475″ align=“left” color=“LightBlue” />
<asp:ToolkitScriptManager ID=“ToolkitScriptManager1″ runat=“server”>
</asp:ToolkitScriptManager>
<asp:Label
ID=“Label1″
runat=“server”
Font-Size=“Large”
ForeColor=“Green”
>
</asp:Label>
<br /><br />
<asp:ComboBox
ID=“ComboBox1″
runat=“server”
DropDownStyle=“DropDown”
AutoCompleteMode=“None”
CaseSensitive=“false”
RenderMode=“Block”
AutoPostBack=“false”
Font-Names=“Comic Sans MS”
Font-Size=“Medium”
>
<asp:ListItem Text=“White”></asp:ListItem>
</asp:ComboBox>
<br /><br /><br />
<br /><br />
<asp:Button
ID=“Button1″
runat=“server”
OnClick=“Button1_Click”
Text=“Populate ComboBox: AppendDataBoundItems True”
Height=“45″
Font-Bold=“true”
ForeColor=“DodgerBlue”
/>
<br />
<asp:Button
ID=“Button2″
runat=“server”
OnClick=“Button2_Click”
Text=“Populate ComboBox: AppendDataBoundItems False”
Height=“45″
Font-Bold=“true”
ForeColor=“DodgerBlue”
/>
</div>
</form>
</body>
</html>

Using Control Parameter with Details View in ASP.NET

ASP.NET ControlParameter and DetailsView example

<%@ 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>asp.net ControlParameter and DetailsView example</title>
</head>
<body>
<form id=“form1″ runat=“server”>
<div>
<h2 style=“color:Teal”>ControlParameter and DetailsView</h2>
<asp:SqlDataSource
ID=“SqlDataSource1″
runat=“server”
ConnectionString=“<%$ ConnectionStrings:NorthwindConnectionString %>”
SelectCommand=“SELECT ProductID, ProductName FROM Products”
>
</asp:SqlDataSource>
<asp:SqlDataSource
ID=“SqlDataSource2″
runat=“server”
ConnectionString=“<%$ ConnectionStrings:NorthwindConnectionString %>”
SelectCommand=“SELECT ProductID, ProductName, UnitPrice FROM Products WHERE ProductID=@ProductID”
>
<SelectParameters>
<asp:ControlParameter ControlID=“DropDownList1″ Name=“ProductID” PropertyName=“SelectedValue” />
</SelectParameters>
</asp:SqlDataSource>
<asp:Label ID=“Label1″ runat=“server” Text=“Product” AssociatedControlID=“DropDownList1″ ForeColor=“SteelBlue” Font-Bold=“true”></asp:Label>
<asp:DropDownList
ID=“DropDownList1″
runat=“server”
DataSourceID=“SqlDataSource1″
DataTextField=“ProductName”
DataValueField=“ProductID”
AutoPostBack=“true”
ForeColor=“HotPink”
>
</asp:DropDownList>
<br /><br />
<asp:Label ID=“Label2″ runat=“server” Text=“Product Details” Font-Bold=“true” ForeColor=“Gray”></asp:Label>
<asp:DetailsView
ID=“DetailsView1″
runat=“server”
DataSourceID=“SqlDataSource2″
BackColor=“Snow”
ForeColor=“IndianRed”
BorderStyle=“Double”
BorderColor=“SteelBlue”
>
</asp:DetailsView>
</div>
</form>
</body>
</html>

ASP.NET DetailsView and SqlDataSource example – Using Insert, Edit

DetailsView and SqlDataSource example: Using Insert, Edit

<%@ 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>DetailsView and SqlDataSource example: Using Insert, Edit</title>
</head>
<body>
<form id=“form1″ runat=“server”>
<div>
<asp:DetailsView ID=“DetailsView1″ runat=“server” AllowPaging=“True”
AutoGenerateRows=“False” DataKeyNames=“CustomerID”
DataSourceID=“SqlDataSource1″ Height=“50px” Width=“125px”>
<Fields>
<asp:BoundField DataField=“CustomerID” HeaderText=“CustomerID” ReadOnly=“True”
SortExpression=“CustomerID” />
<asp:BoundField DataField=“CompanyName” HeaderText=“CompanyName”
SortExpression=“CompanyName” />
<asp:BoundField DataField=“ContactName” HeaderText=“ContactName”
SortExpression=“ContactName” />
<asp:BoundField DataField=“ContactTitle” HeaderText=“ContactTitle”
SortExpression=“ContactTitle” />
<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=“PostalCode” HeaderText=“PostalCode”
SortExpression=“PostalCode” />
<asp:BoundField DataField=“Country” HeaderText=“Country”
SortExpression=“Country” />
<asp:BoundField DataField=“Phone” HeaderText=“Phone” SortExpression=“Phone” />
<asp:BoundField DataField=“Fax” HeaderText=“Fax” SortExpression=“Fax” />
<asp:CommandField ShowDeleteButton=“False” ShowEditButton=“True”
ShowInsertButton=“True” />
</Fields>
</asp:DetailsView>
<asp:SqlDataSource ID=“SqlDataSource1″ runat=“server”
ConflictDetection=“CompareAllValues”
ConnectionString=“<%$ ConnectionStrings:NorthwindConnectionString %>”
InsertCommand=“INSERT INTO [Customers] ([CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax]) VALUES (@CustomerID, @CompanyName, @ContactName, @ContactTitle, @Address, @City, @Region, @PostalCode, @Country, @Phone, @Fax)”
OldValuesParameterFormatString=“original_{0}”
SelectCommand=“SELECT * FROM [Customers]“
UpdateCommand=“UPDATE [Customers] SET [CompanyName] = @CompanyName, [ContactName] = @ContactName, [ContactTitle] = @ContactTitle, [Address] = @Address, [City] = @City, [Region] = @Region, [PostalCode] = @PostalCode, [Country] = @Country, [Phone] = @Phone, [Fax] = @Fax WHERE [CustomerID] = @original_CustomerID AND [CompanyName] = @original_CompanyName AND [ContactName] = @original_ContactName AND [ContactTitle] = @original_ContactTitle AND [Address] = @original_Address AND [City] = @original_City AND [Region] = @original_Region AND [PostalCode] = @original_PostalCode AND [Country] = @original_Country AND [Phone] = @original_Phone AND [Fax] = @original_Fax”>
<UpdateParameters>
<asp:Parameter Name=“CompanyName” Type=“String” />
<asp:Parameter Name=“ContactName” Type=“String” />
<asp:Parameter Name=“ContactTitle” Type=“String” />
<asp:Parameter Name=“Address” Type=“String” />
<asp:Parameter Name=“City” Type=“String” />
<asp:Parameter Name=“Region” Type=“String” />
<asp:Parameter Name=“PostalCode” Type=“String” />
<asp:Parameter Name=“Country” Type=“String” />
<asp:Parameter Name=“Phone” Type=“String” />
<asp:Parameter Name=“Fax” Type=“String” />
<asp:Parameter Name=“original_CustomerID” Type=“String” />
<asp:Parameter Name=“original_CompanyName” Type=“String” />
<asp:Parameter Name=“original_ContactName” Type=“String” />
<asp:Parameter Name=“original_ContactTitle” Type=“String” />
<asp:Parameter Name=“original_Address” Type=“String” />
<asp:Parameter Name=“original_City” Type=“String” />
<asp:Parameter Name=“original_Region” Type=“String” />
<asp:Parameter Name=“original_PostalCode” Type=“String” />
<asp:Parameter Name=“original_Country” Type=“String” />
<asp:Parameter Name=“original_Phone” Type=“String” />
<asp:Parameter Name=“original_Fax” Type=“String” />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name=“CustomerID” Type=“String” />
<asp:Parameter Name=“CompanyName” Type=“String” />
<asp:Parameter Name=“ContactName” Type=“String” />
<asp:Parameter Name=“ContactTitle” Type=“String” />
<asp:Parameter Name=“Address” Type=“String” />
<asp:Parameter Name=“City” Type=“String” />
<asp:Parameter Name=“Region” Type=“String” />
<asp:Parameter Name=“PostalCode” Type=“String” />
<asp:Parameter Name=“Country” Type=“String” />
<asp:Parameter Name=“Phone” Type=“String” />
<asp:Parameter Name=“Fax” Type=“String” />
</InsertParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>

How to use SqlParameter in asp.net

SqlParameter example: how to use SqlParameter in asp.net

Create a web form name SqlParameterExample.aspx. Now add a GridView control. We populate the GridView control with SqlDataSource Data. But here we filter the data by SqlParameter. In this example we select the NorthWind database Products table data and filter it with SqlParameter product name. The source code of SqlParameterExample.aspx is here.

<%@ 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 ProductNameParam;
MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings["AppConnectionString1"].ConnectionString;
MyCommand = new SqlCommand();
MyCommand.CommandText = “SELECT * FROM PRODUCTS WHERE PRODUCTNAME = @PRODUCTNAME”;
MyCommand.CommandType = CommandType.Text;
MyCommand.Connection = MyConnection;
ProductNameParam = new SqlParameter();
ProductNameParam.ParameterName = “@PRODUCTNAME”;
ProductNameParam.SqlDbType = SqlDbType.VarChar;
ProductNameParam.Size = 25;
ProductNameParam.Direction = ParameterDirection.Input;
ProductNameParam.Value = “CHAI”;
MyCommand.Parameters.Add(ProductNameParam);
MyCommand.Connection.Open();
MyReader = MyCommand.ExecuteReader(CommandBehavior.CloseConnection);
GridView1.DataSource = MyReader;
GridView1.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</title>
</head>
<body>
<form id=“form1″ runat=“server”>
<div>
<asp:GridView ID=“GridView1″ runat=“server”>
</asp:GridView>
</div>
</form>
</body>
</html>

How to use DataReader in ASP.NET

DataReader example: how to use DataReader in asp.net

<%@ 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;
MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings["AppConnectionString1"].ConnectionString;
MyCommand = new SqlCommand();
MyCommand.CommandText = “SELECT TOP 10 * From PRODUCTS”;
MyCommand.CommandType = CommandType.Text;
MyCommand.Connection = MyConnection;
MyCommand.Connection.Open();
MyReader = MyCommand.ExecuteReader(CommandBehavior.CloseConnection);
GridView1.DataSource = MyReader;
GridView1.DataBind();
MyCommand.Dispose();
MyConnection.Dispose();
}
}
</script>
<html xmlns=“http://www.w3.org/1999/xhtml”>
<head runat=“server”>
<title>DataReader example: how to use DataReader in asp.net</title>
</head>
<body>
<form id=“form1″ runat=“server”>
<div>
<asp:GridView ID=“GridView1″ runat=“server”>
</asp:GridView>
</div>
</form>
</body>
</html>

How to use GridView in ASP.NET

How to use GridView in ASP.NET an Example
Gridview is a very important control in asp.net. gridview is mainly uses for display tabular data. it also can edit update insert data. you can use it for variuos requirements. this can help you to display and format tabular data very fastest way. we can format the gridview’s nearly all parts as example header, row, alternate row pager etc. even we can place insert,edit,delete button for each row.
In this simple example we create a deafult formatted gridview. we also create a sqldatasource control populate the datasource by a simple database query. we fetch data from northwind databse customer table. finally we populate gridview by that sqldatasource. we set the gridview sorting, paging, auto generate columns true. so sorting, paging, columns names facility are created without much more coding.

<%@ 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>GridView example: how to use GridView in asp.net</title>
</head>
<body>
<form id=“form1″ runat=“server”>
<div>
<asp:GridView ID=“GridView1″ runat=“server” AllowPaging=“True”
AllowSorting=“True” AutoGenerateColumns=“False” DataKeyNames=“CustomerID”
DataSourceID=“SqlDataSource1″>
<Columns>
<asp:BoundField DataField=“CustomerID” HeaderText=“CustomerID” ReadOnly=“True”
SortExpression=“CustomerID” />
<asp:BoundField DataField=“CompanyName” HeaderText=“CompanyName”
SortExpression=“CompanyName” />
<asp:BoundField DataField=“ContactName” HeaderText=“ContactName”
SortExpression=“ContactName” />
<asp:BoundField DataField=“ContactTitle” HeaderText=“ContactTitle”
SortExpression=“ContactTitle” />
<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=“PostalCode” HeaderText=“PostalCode”
SortExpression=“PostalCode” />
<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=“SqlDataSource1″ runat=“server”
ConnectionString=“<%$ ConnectionStrings:AppConnectionString1 %>”
SelectCommand=“SELECT * FROM [Customers]“></asp:SqlDataSource>
</div>
</form>
</body>
</html>

the above image show the output of this example. here you can see how easily gridview present the tabular data. paging and columns names are hyperlinked. so if you click them it can show next page or sort by specific column.

How to use MaskedEditValidator in ASP.NET Ajax

Ajax MaskedEditValidator – How to use MaskedEditValidator in ASP.NET Ajax

<%@ Page Language=“C#” AutoEventWireup=“true” %>
<%@ Register Assembly=“AjaxControlToolkit” Namespace=“AjaxControlToolkit” TagPrefix=“cc1″ %>
<!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 Button1_Click(object sender, EventArgs e)
{
Label1.Text = “You submitted date: “;
Label1.Text += Convert.ToDateTime(TextBox1.Text).ToLongDateString();
}
</script>
<html xmlns=“http://www.w3.org/1999/xhtml” >
<head id=“Head1″ runat=“server”>
<title>Ajax MaskedEditValidator - How to use MaskedEditValidator in asp.net ajax</title>
</head>
<body>
<form id=“form1″ runat=“server”>
<div>
<h2 style=“color:IndianRed; font-style:italic;”>Ajax Control Toolkit Example: Using MaskedEditValidator</h2>
<hr width=“600″ align=“left” color=“Salmon” />
<asp:ScriptManager
ID=“ScriptManager1″
runat=“server”
>
</asp:ScriptManager>
<br /><br />
<asp:Label
ID=“Label1″
runat=“server”
ForeColor=“DeepPink”
Font-Size=“Large”
Font-Italic=“true”
Font-Bold=“true”
>
</asp:Label>
<br /><br />
<asp:Label
ID=“Label2″
runat=“server”
Text=“Meeting Date [mm/dd/yyyy] “
ForeColor=“DarkSeaGreen”
Font-Bold=“true”
>
</asp:Label>
<asp:TextBox
ID=“TextBox1″
runat=“server”
BackColor=“DarkSeaGreen”
Font-Bold=“true”
ForeColor=“Snow”
>
</asp:TextBox>
<cc1:MaskedEditExtender
ID=“MaskedEditExtender1″
runat=“server”
TargetControlID=“TextBox1″
Mask=“99/99/9999″
MaskType=“Date”
MessageValidatorTip=“true”
>
</cc1:MaskedEditExtender>
<cc1:MaskedEditValidator
ID=“MaskedEditValidator1″
runat=“server”
ControlToValidate=“TextBox1″
ControlExtender=“MaskedEditExtender1″
IsValidEmpty=“false”
EmptyValueMessage=“Input date”
InvalidValueMessage=“inputted date not valid”
>
</cc1:MaskedEditValidator>
<br /><br />
<asp:Button
ID=“Button1″
runat=“server”
Text=“Submit Next Meeting Date”
Font-Bold=“true”
ForeColor=“SaddleBrown”
OnClick=“Button1_Click”
Height=“40″
/>
</div>
</form>
</body>
</html>