Dot Da Net

AllowEdit property

2011-07-06T06:20:00.000-07:00

DataViewAllowEditProperty.aspx

    <%@ Page Language="C#" AutoEventWireup="true" %>
    <%@ 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 void Button1_Click(object sender, System.EventArgs e)
        {
            DataTable dt = new DataTable();
            dt.TableName = "Books";

            DataColumn dc1 = new DataColumn();
            dc1.ColumnName = "BookID";
            dc1.DataType = typeof(int);
            dc1.AllowDBNull = false;
            dc1.Unique = true;

            DataColumn dc2 = new DataColumn();
            dc2.ColumnName = "Category";
            dc2.DataType = typeof(string);

            DataColumn dc3 = new DataColumn();
            dc3.ColumnName = "BookName";
            dc3.DataType = typeof(string);

            DataColumn dc4 = new DataColumn();
            dc4.ColumnName = "Author";
            dc4.DataType = typeof(string);

            dt.Columns.AddRange(new DataColumn[] { dc1, dc2, dc3, dc4 });

            dt.Rows.Add(new object[] { 1, ".NET", "ASP.NET 3.5 Application Architecture and Design", "Vivek Thakur" });
            dt.Rows.Add(new object[] { 2, "Games", "Cocos2d for iPhone 0.99 Beginner's Guide", "Pablo Ruiz" });
            dt.AcceptChanges();

            GridView1.DataSource = dt.DefaultView;
            GridView1.DataBind();

            //this line create a new DataView
            DataView dView = new DataView(dt);
            dView.Sort = "BookName DESC" ;

            Label1.Text = "Here we create a new DataView<br />" +
                          "and set the sort order (BookName DESC)";

            GridView2.DataSource = dView;
            GridView2.DataBind();

            dView.AllowEdit = true;
            //this line edit a row in DataView which index is 0
            dView[0]["Category"] = ".NET";
            dView[0]["BookName"] = "Microsoft Windows Workflow Foundation 4.0 Cookbook";
            dView[0]["Author"] = "Andrew Zhu ";

            Label2.Text = "Here we edit a row in DataView, Now the DataView is...";
            GridView3.DataSource = dView;
            GridView3.DataBind();

            Label3.Text = "Now the source DataTable is...";
            GridView4.DataSource = dt;
            GridView4.DataBind();
        }
    </script>

    <html xmlns="http://www.w3.org/1999/xhtml">
    <head id="Head1" runat="server">
        <title>Using AllowEdit property - how to edit update row in a DataView in ado.net</title>
    </head>
    <body>
        <form id="form1" runat="server">
        <div>
            <h2 style="color:DarkBlue; font-style:italic;">
                Using AllowEdit property - how to
                <br /> edit update row in a DataView in ado.net
            </h2>
            <hr width="450" align="left" color="CornFlowerBlue" />
            <asp:GridView
                ID="GridView1"
                runat="server"
                BorderColor="Snow"
                ForeColor="Snow"
                Width="700"
                Font-Names="Courier"
                >
                <HeaderStyle BackColor="DarkMagenta" Height="30" />
                <RowStyle BackColor="DarkKhaki" />
                <AlternatingRowStyle BackColor="DarkOliveGreen" />
            </asp:GridView>
            <asp:Label
                 ID="Label1"
                 runat="server"
                 Font-Size="Large"
                 ForeColor="DodgerBlue"
                 Font-Italic="true"
                 >
            </asp:Label>
            <asp:GridView
                ID="GridView2"
                runat="server"
                BorderColor="Snow"
                ForeColor="Snow"
                Width="700"
                Font-Names="Courier"
                >
                <HeaderStyle BackColor="Maroon" Height="30" />
                <RowStyle BackColor="DarkKhaki" />
                <AlternatingRowStyle BackColor="DarkOliveGreen" />
            </asp:GridView>
            <asp:Label
                 ID="Label2"
                 runat="server"
                 Font-Size="Large"
                 ForeColor="DodgerBlue"
                 Font-Italic="true"
                 >
            </asp:Label>
            <asp:GridView
                ID="GridView3"
                runat="server"
                BorderColor="Snow"
                ForeColor="Snow"
                Width="700"
                Font-Names="Courier"
                >
                <HeaderStyle BackColor="Maroon" Height="30" />
                <RowStyle BackColor="DarkKhaki" />
                <AlternatingRowStyle BackColor="DarkOliveGreen" />
            </asp:GridView>
            <asp:Label
                 ID="Label3"
                 runat="server"
                 Font-Size="Large"
                 ForeColor="DodgerBlue"
                 Font-Italic="true"
                 >
            </asp:Label>
            <asp:GridView
                ID="GridView4"
                runat="server"
                BorderColor="Snow"
                ForeColor="Snow"
                Width="700"
                Font-Names="Courier"
                >
                <HeaderStyle BackColor="DarkMagenta" Height="30" />
                <RowStyle BackColor="DarkKhaki" />
                <AlternatingRowStyle BackColor="DarkOliveGreen" />
            </asp:GridView>
            <asp:Button
                ID="Button1"
                runat="server"
                OnClick="Button1_Click"
                Text="Populate GridView"
                Height="45"
                Font-Bold="true"
                ForeColor="DodgerBlue"
                />
        </div>
        </form>
    </body>
    </html>

DataView ToTable method to create a new DataTable in ado.net

2011-05-15T22:14:00.000-07:00

DataViewToTableMethod.aspx

<%@ Page Language="C#" AutoEventWireup="true" %>
<%@ 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 void Button1_Click(object sender, System.EventArgs e)
{
DataTable dt = new DataTable();
dt.TableName = "Books";

DataColumn dc1 = new DataColumn();
dc1.ColumnName = "BookID";
dc1.DataType = typeof(int);
dc1.AllowDBNull = false;
dc1.Unique = true;

DataColumn dc2 = new DataColumn();
dc2.ColumnName = "Category";
dc2.DataType = typeof(string);

DataColumn dc3 = new DataColumn();
dc3.ColumnName = "BookName";
dc3.DataType = typeof(string);

DataColumn dc4 = new DataColumn();
dc4.ColumnName = "Author";
dc4.DataType = typeof(string);

dt.Columns.AddRange(new DataColumn[] { dc1, dc2, dc3, dc4 });

dt.Rows.Add(new object[] { 1, "iPhone", "iPhone User Interface Cookbook: RAW", "Cameron Banga" });
dt.Rows.Add(new object[] { 2, "MySQL", "MySQL 5.1 Plugin Development", "Andrew Hutchings, Sergei Golubchik" });
dt.Rows.Add(new object[] { 3, "MySQL", "MySQL Admin Cookbook", "Daniel Schneller, Udo Schwedt" });
dt.AcceptChanges();

Label1.Text = "Source DataTable";
GridView1.DataSource = dt.DefaultView;
GridView1.DataBind();

//this line create a new DataView
DataView dView = new DataView(dt);
dView.RowFilter = "Category = 'MySQL'";

Label2.Text = "Here we create a new DataView<br />" +
"and set the RowFilter (Category = 'MySQL')";

GridView2.DataSource = dView;
GridView2.DataBind();

//this line create a new DataTable from DataView
DataTable dt2 = dView.ToTable();

Label3.Text = "Here we create a new DataTable from DataView";
GridView3.DataSource = dt2;
GridView3.DataBind();
}
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>How to use DataView ToTable method to create a new DataTable in ado.net</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h2 style="color:DarkBlue; font-style:italic;">
How to use DataView ToTable method
<br /> to create a new DataTable in ado.net
</h2>
<hr width="450" align="left" color="CornFlowerBlue" />
<asp:Label
ID="Label1"
runat="server"
Font-Size="Large"
ForeColor="DodgerBlue"
Font-Italic="true"
>
</asp:Label>
<asp:GridView
ID="GridView1"
runat="server"
BorderColor="Snow"
ForeColor="Snow"
Width="600"
Font-Names="Courier"
>
<HeaderStyle BackColor="DarkSlateBlue" Height="30" />
<RowStyle BackColor="MediumVioletRed" />
<AlternatingRowStyle BackColor="PaleVioletRed" />
</asp:GridView>
<br />
<asp:Label
ID="Label2"
runat="server"
Font-Size="Large"
ForeColor="DodgerBlue"
Font-Italic="true"
>
</asp:Label>
<asp:GridView
ID="GridView2"
runat="server"
BorderColor="Snow"
ForeColor="Snow"
Width="600"
Font-Names="Courier"
>
<HeaderStyle BackColor="DarkSlateBlue" Height="30" />
<RowStyle BackColor="MediumVioletRed" />
<AlternatingRowStyle BackColor="PaleVioletRed" />
</asp:GridView>
<br />
<asp:Label
ID="Label3"
runat="server"
Font-Size="Large"
ForeColor="DodgerBlue"
Font-Italic="true"
>
</asp:Label>
<asp:GridView
ID="GridView3"
runat="server"
BorderColor="Snow"
ForeColor="Snow"
Width="600"
Font-Names="Courier"
>
<HeaderStyle BackColor="DarkSlateBlue" Height="30" />
<RowStyle BackColor="MediumVioletRed" />
<AlternatingRowStyle BackColor="PaleVioletRed" />
</asp:GridView>
<asp:Button
ID="Button1"
runat="server"
OnClick="Button1_Click"
Text="Populate GridView"
Height="45"
Font-Bold="true"
ForeColor="DodgerBlue"
/>
</div>
</form>
</body>
</html>

Reduce DB Space

2011-04-13T01:10:00.000-07:00

SpreadsheetGear: ASP.NET Excel Reporting

Easily create richly formatted Excel reports without Excel using the new generation of spreadsheet technology built from the ground up for scalability and reliability. Recently I have delete 2 million unwanted records from my sql server database table, what i realise is even after deleting records, space used by database is not reducing.

1) Whenever we delete records from table, sql server doesn't reduce size of database immediately.

2) Even after deleting table , sql server doesn't reduce size of database.

3) Instead of Freeing space for deleted records, sql server marks pages containing deleted records as free pages, showing that they belong to the table. When new data are inserted, they are put into those pages first. Once those pages are filled up, SQL Server will allocate new pages.

So In order to claim database space after deleting records in Table, go through following steps:

1) Check what is Size of your Database using following command?

Exec sp_spaceused

2) Delete Records from table, If you have already did that skip this step.

3) Run below command to claim unused database space.

DBCC SHRINKDATABASE(0)

DBCC SHRINKDATABASE command - Shrinks the size of the data and log files in the specified database.

Best Practise to use this command

A shrink operation is most effective after an operation that creates lots of unused space, such as a truncate table or a drop table operation.Most databases require some free space to be available for regular day-to-day operations. If you shrink a database repeatedly and notice that the database size grows again, this indicates that the space that was shrunk is required for regular operations. In these cases, repeatedly shrinking the database is a wasted operation.A shrink operation does not preserve the fragmentation state of indexes in the database, and generally increases fragmentation to a degree. This is another reason not to repeatedly shrink the database.

If you have Created, Alter or Drop any Database table recently then run below command.

DBCC UPDATEUSAGE(0)

DBCC UPDATEUSAGE(0) - Reports and corrects pages and row count inaccuracies in the catalog views. These inaccuracies may cause incorrect space usage reports returned by the sp_spaceused system stored procedure.

Example showing how this command helps me to reduce size of my database after deleting records from table.

1) Take Backup of your Production Database.

2) Take Backup of Table Scripts of your Production Database.

3) Create Test Database in Local Environment.

4) Run Tables creation script.

5) Restore Production Database to Test Database in local environment

6) Check Size of your Database

Exec sp_spaceused

7) Run Update Usage command
DBCC UPDATEUSAGE(0)

8) Check Size of your Database

Exec sp_spaceused

9) Run Shrink Database command
DBCC SHRINKDATABASE(0)

10) Check Size of your Database
Exec sp_spaceused

If everything goes smooth then you would see that your database size is reduced.

How to set change Chart Legend TitleSeparatorColor programmatically in asp.net

2011-04-07T11:34:00.000-07:00

ChartLegendTitleSeparatorColor.aspx

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

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

protected void Button1_Click(object sender, System.EventArgs e)

{

Chart1.Legends["Legend1"].TitleSeparatorColor = System.Drawing.Color.BlanchedAlmond;

}

</script>

<title>How to set change Chart Legend TitleSeparatorColor programmatically in asp.net</title>

{

color:Crimson;

font-style:italic;

}

</style>

</head>

<body>

<div>

<h2>Chart example and tutorial: How to set change Chart Legend<br /> TitleSeparatorColor programmatically in asp.net</h2>

<br />

<asp:Chart

ID="Chart1"

runat="server"

Width="625"

BackColor="DarkCyan"

BorderlineColor="AliceBlue"

BorderlineDashStyle="Solid"

BorderlineWidth="2"

<asp:Legend

Name="Legend1"

BackColor="DodgerBlue"

ForeColor="Snow"

BorderColor="MidnightBlue"

Docking="Right"

TableStyle="Wide"

Title="Nokia Phone Legend"

TitleForeColor="Snow"

TitleSeparator="DoubleLine"

</asp:Legend>

</Legends>

<asp:Series

Name="NokiaPhone"

YValueType="Double"

ChartArea="DefaultChartArea"

ChartType="Pyramid"

Palette="Excel"

<asp:DataPoint AxisLabel="Nokia N8" YValues="549" />

<asp:DataPoint AxisLabel="Nokia N97 Mini Driver Ed." YValues="399.99" />

<asp:DataPoint AxisLabel="Nokia E72 Driver Edition" YValues="349" />

<asp:DataPoint AxisLabel="X6 16GB Driver Edition" YValues="329" />

<asp:DataPoint AxisLabel="Nokia C6" YValues="309" />

<asp:DataPoint AxisLabel="Nokia 5800 Driver Edition" YValues="289" />

</Points>

</asp:Series>

</Series>

<asp:ChartArea

Name="DefaultChartArea"

BorderDashStyle="Solid"

BorderWidth="2"

BorderColor="OliveDrab"

BackColor="DarkOliveGreen"

</asp:ChartArea>

</ChartAreas>

</asp:Chart>

<br />

<asp:Button

ID="Button1"

runat="server"

Text="Set Chart Legend TitleSeparatorColor BlanchedAlmond"

Font-Bold="true"

OnClick="Button1_Click"

ForeColor="DarkBlue"

Height="45"

</div>

</form>

</body>

</html>

How to populate ComboBox from XmlDataSource in asp.net

2011-03-30T22:51:00.000-07:00

ComboBoxXmlDataSource.aspx

<%@ 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">

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
   <title>Ajax ComboBox - How to populate ComboBox from XmlDataSource in asp.net</title>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:DarkBlue; font-style:italic;">
   ASP.NET Ajax ComboBox - How to populate ComboBox
   <br /> from XmlDataSource programmatically in asp.net
   </h2>
   <hr width="525" align="left" color="LightBlue" />
   <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
   </asp:ToolkitScriptManager>
   <br /><br />
   <asp:ComboBox
   ID="ComboBox1"
   runat="server"
   DropDownStyle="DropDown"
   DataSourceID="XmlDataSource1"
   DataTextField="Name"
   DataValueField="ID"
   AutoCompleteMode="None"
   CaseSensitive="false"
   RenderMode="Block"
   AppendDataBoundItems="true"
   AutoPostBack="false"
   Font-Names="Comic Sans MS"
   Font-Size="Medium"
   ForeColor="Green"
   >
   </asp:ComboBox>
   <asp:XmlDataSource ID="XmlDataSource1" runat="server">
   <Data>
   <Colors>
   <Color ID="1" Name="Crimson" />
   <Color ID="2" Name="CornFlowerBlue" />
   <Color ID="3" Name="BlanchedAlmond" />
   <Color ID="4" Name="IndianRed" />
   <Color ID="5" Name="Coral" />
   </Colors>
   </Data>
   </asp:XmlDataSource>
   </div>
   </form>
</body>
</html>

How to use ComboBox RenderMode Block and Inline in asp.net

2011-03-28T10:36:00.000-07:00

ComboBoxRenderMode.aspx

<%@ 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">

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
   <title>Ajax ComboBox - How to use ComboBox RenderMode Block and Inline in asp.net</title>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:DarkBlue; font-style:italic;">
   ASP.NET Ajax ComboBox - How to use ComboBox
   <br /> RenderMode Block and Inline in asp.net
   </h2>
   <hr width="525" align="left" color="LightBlue" />
   <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
   </asp:ToolkitScriptManager>
   <asp:Label
   ID="Label1"
   runat="server"
   Font-Size="Large"
   ForeColor="DarkGreen"
   Font-Italic="true"
   Text="ComboBox RenderMode Inline"
   >
   </asp:Label>
   <br /><br />
   <asp:ComboBox
   ID="ComboBox1"
   runat="server"
   DropDownStyle="DropDown"
   AutoCompleteMode="None"
   CaseSensitive="false"
   RenderMode="Inline"
   AutoPostBack="false"
   Font-Names="Comic Sans MS"
   Font-Size="Medium"
   ForeColor="SaddleBrown"
   >
   <asp:ListItem Text="Red"></asp:ListItem>
   <asp:ListItem Text="Green"></asp:ListItem>
   <asp:ListItem Text="Yellow"></asp:ListItem>
   <asp:ListItem Text="White"></asp:ListItem>
   </asp:ComboBox>
   <br /><br /><br />
   <asp:Label
   ID="Label2"
   runat="server"
   Font-Size="Large"
   ForeColor="Crimson"
   Font-Italic="true"
   Text="ComboBox RenderMode Block"
   >
   </asp:Label>
   <br /><br />
   <asp:ComboBox
   ID="ComboBox2"
   runat="server"
   DropDownStyle="DropDown"
   AutoCompleteMode="None"
   CaseSensitive="false"
   RenderMode="Block"
   AutoPostBack="false"
   Font-Names="Comic Sans MS"
   Font-Size="Medium"
   ForeColor="SaddleBrown"
   >
   <asp:ListItem Text="IndianRed"></asp:ListItem>
   <asp:ListItem Text="Crimson"></asp:ListItem>
   <asp:ListItem Text="DarkBlue"></asp:ListItem>
   <asp:ListItem Text="Khaki"></asp:ListItem>
   </asp:ComboBox>
   </div>
   </form>
</body>
</html>

How to set change ComboBox RenderMode programmatically in asp.net

2011-03-24T00:36:00.000-07:00

ChangeComboBoxRenderMode.aspx

<%@ 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">
   protected void Button1_Click(object sender, EventArgs e)
   {
   ComboBox1.RenderMode = ComboBoxRenderMode.Block;
   Label1.Text = "ComboBox RenderMode Now: " + ComboBox1.RenderMode.ToString();
   }
   protected void Button2_Click(object sender, EventArgs e)
   {
   ComboBox1.RenderMode = ComboBoxRenderMode.Inline;
   Label1.Text = "ComboBox RenderMode Now: " + ComboBox1.RenderMode.ToString();
   }

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
   <title>Ajax ComboBox - How to set change ComboBox RenderMode programmatically in asp.net</title>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:DarkBlue; font-style:italic;">
   ASP.NET Ajax ComboBox - How to set change ComboBox
   <br /> RenderMode programmatically in asp.net
   </h2>
   <hr width="525" align="left" color="LightBlue" />
   <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
   </asp:ToolkitScriptManager>
   <asp:Label
   ID="Label1"
   runat="server"
   Font-Size="Large"
   ForeColor="DarkGreen"
   Font-Italic="true"
   >
   </asp:Label>
   <br /><br />
   <asp:ComboBox
   ID="ComboBox1"
   runat="server"
   DropDownStyle="DropDown"
   AutoCompleteMode="None"
   CaseSensitive="false"
   AutoPostBack="false"
   Font-Names="Comic Sans MS"
   Font-Size="Medium"
   ForeColor="Crimson"
   >
   <asp:ListItem Text="Ivory"></asp:ListItem>
   <asp:ListItem Text="FireBrick"></asp:ListItem>
   <asp:ListItem Text="Yellow"></asp:ListItem>
   <asp:ListItem Text="LightPink"></asp:ListItem>
   </asp:ComboBox>
   <br /><br /><br />
   <br /><br /><br />
   <asp:Button
   ID="Button1"
   runat="server"
   OnClick="Button1_Click"
   Text="Set ComboBox RenderMode Block"
   Height="45"
   Font-Bold="true"
   ForeColor="DodgerBlue"
   />
   <asp:Button
   ID="Button2"
   runat="server"
   OnClick="Button2_Click"
   Text="Set ComboBox RenderMode Inline"
   Height="45"
   Font-Bold="true"
   ForeColor="DodgerBlue"
   />
   </div>
   </form>
</body>
</html>

How to set change ComboBox DataSourceID programmatically in asp.net

2011-03-23T10:35:00.000-07:00

ComboBoxDataSourceID.aspx

<%@ 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">
   protected void Button1_Click(object sender, EventArgs e)
   {
   ComboBox1.DataSourceID = "XmlDataSource1";
   ComboBox1.DataTextField = "Name";
   ComboBox1.DataValueField = "ID";
   }
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
   <title>Ajax ComboBox - How to set change ComboBox DataSourceID programmatically in asp.net</title>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:DarkBlue; font-style:italic;">
   ASP.NET Ajax ComboBox - How to set change ComboBox
   <br /> DataSourceID programmatically in asp.net
   </h2>
   <hr width="550" align="left" color="LightBlue" />
   <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
   </asp:ToolkitScriptManager>
   <br /><br />
   <asp:ComboBox
   ID="ComboBox1"
   runat="server"
   DropDownStyle="DropDown"
   AutoCompleteMode="None"
   CaseSensitive="false"
   RenderMode="Block"
   AppendDataBoundItems="false"
   AutoPostBack="false"
   Font-Names="Comic Sans MS"
   Font-Size="Medium"
   ForeColor="DeepPink"
   >
   </asp:ComboBox>
   <asp:XmlDataSource ID="XmlDataSource1" runat="server">
   <Data>
   <Colors>
   <Color ID="1" Name="Indigo" />
   <Color ID="2" Name="DarkGoldenRod" />
   <Color ID="3" Name="BlanchedAlmond" />
   <Color ID="4" Name="DarkGrey" />
   <Color ID="5" Name="FireBrick" />
   </Colors>
   </Data>
   </asp:XmlDataSource>
   <br /><br /><br />
   <br /><br /><br />
   <asp:Button
   ID="Button1"
   runat="server"
   OnClick="Button1_Click"
   Text="Set ComboBox DataSourceID: 'XmlDataSource1'"
   Height="45"
   Font-Bold="true"
   ForeColor="DodgerBlue"
   />
   </div>
   </form>
</body>
</html>

How to use ComboBox CssClass property in asp.net

2011-03-21T22:27:00.000-07:00

ComboBoxCssClass.aspx

<%@ 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">

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
   <title>Ajax ComboBox - How to use ComboBox CssClass property in asp.net</title>
   <style type="text/css">
   .RedTypeComboBoxStyle .ajax__combobox_textboxcontainer input {
   background-color: Ivory;
   border: 2px solid DeepPink;
   color: Crimson;
   font-family:Comic Sans MS;
   font-size:large;
   }
   .RedTypeComboBoxStyle .ajax__combobox_buttoncontainer button {
   background-color: SandyBrown;
   border: 1px solid SaddleBrown;
   }
   .RedTypeComboBoxStyle .ajax__combobox_buttoncontainer button {
   background-color: SandyBrown;
   border: 1px solid SaddleBrown;
   }
   .RedTypeComboBoxStyle .ajax__combobox_itemlist
   {
   background-color:FloralWhite;
   color:HotPink;
   font-family:Courier New;
   font-size:large;
   font-style:italic;
   border: 2px dotted Pink;
   }
   </style>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:DarkBlue; font-style:italic;">
   ASP.NET Ajax ComboBox - How to use ComboBox
   <br /> CssClass property in asp.net
   </h2>
   <hr width="500" align="left" color="LightBlue" />
   <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
   </asp:ToolkitScriptManager>
   <br /><br />
   <asp:ComboBox
   ID="ComboBox1"
   runat="server"
   DropDownStyle="DropDown"
   AutoCompleteMode="None"
   AutoPostBack="false"
   RenderMode="Block"
   CssClass="RedTypeComboBoxStyle"
   >
   <asp:ListItem Text="Orange"></asp:ListItem>
   <asp:ListItem Text="FireBrick"></asp:ListItem>
   <asp:ListItem Text="CadetBlue"></asp:ListItem>
   <asp:ListItem Text="LightPink"></asp:ListItem>
   <asp:ListItem Text="DeepPink"></asp:ListItem>
   </asp:ComboBox>
   </div>
   </form>
</body>
</html>

How to use css to design ComboBox textbox container input element in asp.net

2011-03-21T04:12:00.000-07:00

ComboBoxTextboxContainerInputElement.aspx

<%@ 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">

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
   <title>Ajax ComboBox - How to use css to design ComboBox textbox container input element in asp.net</title>
   <style type="text/css">
   .BlueTypeComboBoxStyle .ajax__combobox_textboxcontainer input {
   background-color: AliceBlue;
   border: 2px solid DarkBlue;
   color: DodgerBlue;
   font-family:Trebuchet MS;
   font-size:large;
   padding-left: 5px;
   }
   </style>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:DarkBlue; font-style:italic;">
   ASP.NET Ajax ComboBox - How to use css to design
   <br /> ComboBox textbox container input element in asp.net
   </h2>
   <hr width="525" align="left" color="LightBlue" />
   <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
   </asp:ToolkitScriptManager>
   <br /><br />
   <asp:ComboBox
   ID="ComboBox1"
   runat="server"
   DropDownStyle="DropDown"
   AutoCompleteMode="None"
   AutoPostBack="false"
   RenderMode="Block"
   CssClass="BlueTypeComboBoxStyle"
   >
   <asp:ListItem Text="DeepSkyBlue"></asp:ListItem>
   <asp:ListItem Text="Lavender"></asp:ListItem>
   <asp:ListItem Text="DodgerBlue"></asp:ListItem>
   <asp:ListItem Text="LightGreen"></asp:ListItem>
   <asp:ListItem Text="MidnightBlue"></asp:ListItem>
   </asp:ComboBox>
   </div>
   </form>
</body>
</html>

How to use css to design ComboBox button container button element in asp.net

2011-03-19T23:38:00.000-07:00

ComboBoxButtonContainerButtonElement.aspx

<%@ 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">

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
   <title>Ajax ComboBox - How to use css to design ComboBox button container button element in asp.net</title>
   <style type="text/css">
   .OrangeTypeComboBoxStyle .ajax__combobox_buttoncontainer button {
   background-color: OrangeRed;
   border: 2px solid Orange;
   }
   </style>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:DarkBlue; font-style:italic;">
   ASP.NET Ajax ComboBox - How to use css to design
   <br /> ComboBox button container button element in asp.net
   </h2>
   <hr width="525" align="left" color="LightBlue" />
   <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
   </asp:ToolkitScriptManager>
   <br /><br />
   <asp:ComboBox
   ID="ComboBox1"
   runat="server"
   DropDownStyle="DropDown"
   AutoCompleteMode="None"
   AutoPostBack="false"
   RenderMode="Block"
   CssClass="OrangeTypeComboBoxStyle"
   >
   <asp:ListItem Text="SlateGrey"></asp:ListItem>
   <asp:ListItem Text="SpringGreen"></asp:ListItem>
   <asp:ListItem Text="Tomato"></asp:ListItem>
   <asp:ListItem Text="WhiteSmoke"></asp:ListItem>
   <asp:ListItem Text="YellowGreen"></asp:ListItem>
   </asp:ComboBox>
   </div>
   </form>
</body>
</html>

How to use css to design ComboBox list item elements in asp.net

2011-03-19T23:34:00.000-07:00

DesignComboBoxListItemElements.aspx

<%@ 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">

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
   <title>Ajax ComboBox - How to use css to design ComboBox list item elements in asp.net</title>
   <style type="text/css">
   .GreenTypeComboBoxStyle .ajax__combobox_itemlist li {
   background-color: DarkGreen;
   border: 1px solid YellowGreen;
   color: White;
   font-size:medium;
   font-family:Courier New;
   padding-bottom: 5px;
   }
   </style>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:DarkBlue; font-style:italic;">
   ASP.NET Ajax ComboBox - How to use css to design
   <br /> ComboBox list item elements in asp.net
   </h2>
   <hr width="525" align="left" color="LightBlue" />
   <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
   </asp:ToolkitScriptManager>
   <br /><br />
   <asp:ComboBox
   ID="ComboBox1"
   runat="server"
   DropDownStyle="DropDown"
   AutoCompleteMode="None"
   AutoPostBack="false"
   RenderMode="Block"
   CssClass="GreenTypeComboBoxStyle"
   >
   <asp:ListItem Text="GoldenRod"></asp:ListItem>
   <asp:ListItem Text="FloralWhite"></asp:ListItem>
   <asp:ListItem Text="DeepPink"></asp:ListItem>
   <asp:ListItem Text="DarkSlateBlue"></asp:ListItem>
   <asp:ListItem Text="DarkGoldenRod"></asp:ListItem>
   <asp:ListItem Text="Chocolate"></asp:ListItem>
   <asp:ListItem Text="BlanchedAlmond"></asp:ListItem>
   </asp:ComboBox>
   </div>
   </form>
</body>
</html>

To change meta element in asp.net using the HtmlGenericControl class

2011-03-14T11:03:00.000-07:00

HTMLGenericControlClass.aspx

<%@ Page Language="C#" %>
<script runat="server">
   protected void Page_Load(object sender, System.EventArgs e)
   {
   if (!Page.IsPostBack)
   {
   Meta1.Attributes["name"] = "description";
   Meta1.Attributes["content"] = "huge asp.net examples with images";
   }
   }
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
   <title>How to change meta element in asp.net using the HtmlGenericControl class</title>
   <meta id="Meta1" runat="server" />
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:Navy; font-style:italic;">HtmlGenericControl Class Example: change meta element</h2>

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

To set change meta keywords programmatically

2011-03-14T10:55:00.000-07:00

ChangeMetaElement.aspx

<%@ Page Language="C#" %>
<script runat="server">
   protected void Page_Load(object sender, System.EventArgs e)
   {
   if (!Page.IsPostBack)
   {
   Meta1.Attributes["name"] = "keywords";
   Meta1.Attributes["content"] = "asp.net, example, tutorial, web, web design, web development";
   }
   }
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
   <title>How to set change meta keywords programmatically in asp.net</title>
   <meta id="Meta1" runat="server" />
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:Red; font-style:italic;">Meta element Example: How to change meta keywords</h2>

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

How to use OnChanged event in asp.net Rating

2011-03-09T00:15:00.000-08:00

RatingOnChangedEvent.aspx

<%@ 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">
   protected void Rating1_Changed(object sender, EventArgs e)
   {
   int ratingValue = Rating1.CurrentRating;
   if (ratingValue <= 3)
   {
   Label1.ForeColor = System.Drawing.Color.Red;
   }
   else
   {
   Label1.ForeColor = System.Drawing.Color.Green;
   }
   Label1.Text = "You Rated: " + ratingValue;
   }
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
   <title>Ajax Rating - How to use OnChanged event in asp.net Rating</title>
   <style type="text/css">
   .StarCss {
   background-image: url(/Image/star.png);
   height:24px;
   width:24px;
   }
   .FilledStarCss {
   background-image: url(/Image/filledstar.png);
   height:24px;
   width:24px;
   }
   .EmptyStarCss {
   background-image: url(/Image/star.png);
   height:24px;
   width:24px;
   }
   .WaitingStarCss {
   background-image: url(/Image/waitingstar.png);
   height:24px;
   width:24px;
   }
   </style>

</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:DarkBlue; font-style:italic;">
   ASP.NET Ajax Rating - How to use OnChanged
   <br /> event in asp.net Rating
   </h2>
   <hr width="500" align="left" color="LightBlue" />
   <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
   </asp:ToolkitScriptManager>
   <table border="0" cellpadding="4" cellspacing="4">
   <tr>
   <td>
   <asp:Image
   ID="Image1"
   runat="server"
   ImageUrl="~/Image/RedBird.jpg"
   Height="250"
   />
   </td>
   <td>
   <asp:Label
   ID="Label1"
   runat="server"
   Font-Size="X-Large"
   Font-Italic="true"
   Font-Names="Comic Sans MS"
   >
   </asp:Label>
   <br /><br />
   <asp:Label
   ID="Label2"
   runat="server"
   ForeColor="SandyBrown"
   Font-Size="Large"
   Text="Rate this image"
   >
   </asp:Label>
   <br />
   <asp:Rating
   ID="Rating1"
   runat="server"
   StarCssClass="StarCss"
   FilledStarCssClass="FilledStarCss"
   EmptyStarCssClass="EmptyStarCss"
   WaitingStarCssClass="WaitingStarCss"
   AutoPostBack="true"
   OnChanged="Rating1_Changed"
   >
   </asp:Rating>
   </td>
   </tr>
   </table>
   </div>
   </form>
</body>
</html>

To use button control as HTML server control in asp.net

2011-03-07T21:15:00.000-08:00

HTMLServerControl.aspx

<%@ Page Language="C#" %>
<script runat="server">
   protected void Button1_ServerClick(object sender, System.EventArgs e)
   {
   Label1.Text = "Hi! " + TextBox1.Text;
   }
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
   <title>How to use button control as HTML server control in asp.net</title>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:Navy; font-style:italic;">HTML Server Control Example: Using Button</h2>
   <asp:Label
   ID="Label1"
   runat="server"
   Font-Bold="true"
   ForeColor="DodgerBlue"
   Font-Size="Larger"
   >
   </asp:Label>
   <br /><br />
   <asp:Label
   ID="Label2"
   runat="server"
   Text="Name"
   Font-Bold="true"
   ForeColor="DeepPink"
   >
   </asp:Label>
   <asp:TextBox
   ID="TextBox1"
   runat="server"
   BackColor="PaleGoldenrod"
   ForeColor="DeepPink"
   >
   </asp:TextBox>
   <br />
   <input
   type="button"
   id="Button1"
   value="Submit"
   runat="server"
   onserverclick="Button1_ServerClick"
   />
   </div>
   </form>
</body>
</html>

To use onserverclick event in HTML button control in asp.net

2011-03-07T21:01:00.000-08:00

HTMLButtonOnServerClick.aspx

<%@ Page Language="C#" %>
<script runat="server">
   protected void Button1_ServerClick(object sender, System.EventArgs e)
   {
   int ImageSize =(Int16) Image1.Height.Value;
   Image1.Height = ImageSize + 100;
   Label1.Text = "Image Height: " + Image1.Height.ToString();
   }
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
   <title>How to use onserverclick event in HTML button control in asp.net</title>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:Navy; font-style:italic;">HTML Server Control Example: Using onserverclick event</h2>
   <asp:Label
   ID="Label1"
   runat="server"
   Font-Bold="true"
   ForeColor="IndianRed"
   Font-Size="Larger"
   >
   </asp:Label>
   <br /><br />
   <asp:Image
   ID="Image1"
   runat="server"
   ImageUrl="~/Images/Image1.jpg"
   Height="250"
   />
   <br />
   <input
   type="button"
   id="Button1"
   value="Increase Image Size"
   runat="server"
   onserverclick="Button1_ServerClick"
   />
   </div>
   </form>
</body>
</html>

To get user list in asp.net

2011-03-05T01:18:00.000-08:00

GetAllUsersExample.aspx

<%@ 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 Button1_Click(object sender, System.EventArgs e) {
   ListBox1.DataSource = Membership.GetAllUsers();
   ListBox1.DataBind();
   }
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
   <title>GetAllUsers method example: how to get user list in asp.net</title>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2>GetAllUsers Method Example</h2>
   <asp:Label ID="Label1" runat="server" Text="All Users" AssociatedControlID="ListBox1"></asp:Label>
   <asp:ListBox ID="ListBox1" runat="server"></asp:ListBox>
   <br />
   <asp:Button ID="Button1" runat="server" Text="Get All Users" OnClick="Button1_Click" />
   </div>
   </form>
</body>
</html>

To delete a user in asp.net

2011-03-05T01:13:00.000-08:00

DeleteUserExample.aspx

<%@ 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(!Page.IsPostBack){
   DropDownListDataBind();
   }
   }

   protected void Button1_Click(object sender, System.EventArgs e) {
   Membership.DeleteUser(DropDownList1.SelectedItem.Text);
   Label1.Text = "User deleted successfully!";
   DropDownListDataBind();
   }

   protected void DropDownListDataBind() {
   DropDownList1.DataSource = Membership.GetAllUsers();
   DropDownList1.DataBind();
   }
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
   <title>DeleteUser method example: how to delete a user in asp.net</title>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2>DeleteUser method example</h2>
   <asp:Label ID="Label1" runat="server" Font-Bold="true" ForeColor="DarkCyan"></asp:Label>
   <br /><br />
   <b>Select user</b>
   <br />
   <asp:DropDownList ID="DropDownList1" runat="server" BackColor="AliceBlue"></asp:DropDownList>
   <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="DropDownList1" Text="*"></asp:RequiredFieldValidator>
   <br /><br />
   <asp:Button ID="Button1" runat="server" Text="Delete selected user" OnClick="Button1_Click" />
   </div>
   </form>
</body>
</html>

ListView ItemTemplate and AlternatingItemTemplate

2011-03-02T09:49:00.000-08:00

ListViewAlternatingItemTemplate.aspx

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

<!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>ListView ItemTemplate and AlternatingItemTemplate - how to use</title>
   <style type="text/css">
   .TableCSS
   {
   border-style:none;
   background-color:IndianRed;
   width: 700px;
   }
   .TableHeader
   {
   background-color:Crimson;
   color:Snow;
   font-size:large;
   font-family:Verdana;
   height:45px;
   text-align:center;
   }
   .ItemCSS
   {
   background-color:IndianRed;
   color:Snow;
   font-family:MS Sans Serif;
   font-size:medium;
   font-weight:bold;
   height:28px;
   }
   .AlternatingItemCSS
   {
   background-color:Salmon;
   color:Snow;
   font-family:MS Sans Serif;
   font-size:medium;
   font-weight:bold;
   height:28px;
   }
   </style>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:OliveDrab; font-style:italic;">
   ListView Example: How To Use <br /> ItemTemplate And AlternatingItemTemplate
   </h2>
   <hr width="575" align="left" color="Salmon" />
   <asp:SqlDataSource
   ID="SqlDataSource1"
   runat="server"
   ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
   SelectCommand="Select Top 10 ProductName, UnitPrice, QuantityPerUnit From products Order By ProductName"
   >
   </asp:SqlDataSource>
   <br />
   <asp:ListView
   ID="ListView1"
   runat="server"
   DataSourceID="SqlDataSource1"
   >
   <LayoutTemplate>
   <table runat="server" class="TableCSS">
   <tr runat="server" class="TableHeader">
   <td runat="server">Product Name</td>
   <td runat="server">Unit Price</td>
   <td runat="server">Quantity Per Unit</td>
   </tr>
   <tr id="ItemPlaceholder" runat="server">
   </tr>
   </table>
   </LayoutTemplate>
   <ItemTemplate>
   <tr class="ItemCSS">
   <td>
   <asp:Label
   ID="Label1"
   runat="server"
   Text='<%# Eval("ProductName")%>'
   >
   </asp:Label>
   </td>
   <td>
   <asp:Label
   ID="Label2"
   runat="server"
   Text='<%# Eval("UnitPrice")%>'
   >
   </asp:Label>
   </td>
   <td>
   <asp:Label
   ID="Label3"
   runat="server"
   Text='<%# Eval("QuantityPerUnit")%>'
   >
   </asp:Label>
   </td>
   </tr>
   </ItemTemplate>
   <AlternatingItemTemplate>
   <tr class="AlternatingItemCSS">
   <td>
   <asp:Label
   ID="Label1"
   runat="server"
   Text='<%# Eval("ProductName")%>'
   >
   </asp:Label>
   </td>
   <td>
   <asp:Label
   ID="Label2"
   runat="server"
   Text='<%# Eval("UnitPrice")%>'
   >
   </asp:Label>
   </td>
   <td>
   <asp:Label
   ID="Label3"
   runat="server"
   Text='<%# Eval("QuantityPerUnit")%>'
   >
   </asp:Label>
   </td>
   </tr>
   </AlternatingItemTemplate>
   </asp:ListView>
   </div>
   </form>
</body>
</html>

How to DataBind ListView programmatically

2011-03-02T09:42:00.000-08:00

ListViewDataBind.aspx
<%@ Page Language="C#" AutoEventWireup="true" %>

<!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)
   {
   ListView1.DataSourceID = "SqlDataSource1";
   ListView1.DataBind();
   }

</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
   <title>ListView DataBinding - how to DataBind ListView programmatically</title>
   <style type="text/css">
   .TableCSS
   {
   border-style:none;
   background-color:Navy;
   width: 700px;
   }
   .TableHeader
   {
   background-color:DarkBlue;
   color:Snow;
   font-size:large;
   font-family:Verdana;
   height:45px;
   text-align:center;
   }
   .ItemCSS
   {
   background-color:DodgerBlue;
   color:Snow;
   font-family:MS Sans Serif;
   font-size:medium;
   font-weight:bold;
   height:28px;
   }
   </style>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:Crimson; font-style:italic;">ListView Example: How To DataBind ListView Programmatically</h2>
   <hr width="625" align="left" color="DarkRed" />
   <asp:SqlDataSource
   ID="SqlDataSource1"
   runat="server"
   ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
   SelectCommand="Select Top 10 ProductName, UnitPrice, QuantityPerUnit From products Order By ProductName"
   >
   </asp:SqlDataSource>
   <br />
   <asp:Button
   ID="Button1"
   runat="server"
   ForeColor="DodgerBlue"
   Text="Populate ListView"
   OnClick="Button1_Click"
   Font-Bold="true"
   Height="45"
   />
   <br /><br />
   <asp:ListView
   ID="ListView1"
   runat="server"
   >
   <LayoutTemplate>
   <table id="Table1" runat="server" class="TableCSS">
   <tr id="Tr1" runat="server" class="TableHeader">
   <td id="Td1" runat="server">Product Name</td>
   <td id="Td2" runat="server">Unit Price</td>
   <td id="Td3" runat="server">Quantity Per Unit</td>
   </tr>
   <tr id="ItemPlaceholder" runat="server">
   </tr>
   </table>
   </LayoutTemplate>
   <ItemTemplate>
   <tr class="ItemCSS">
   <td>
   <asp:Label
   ID="Label1"
   runat="server"
   Text='<%# Eval("ProductName")%>'
   >
   </asp:Label>
   </td>
   <td>
   <asp:Label
   ID="Label2"
   runat="server"
   Text='<%# Eval("UnitPrice")%>'
   >
   </asp:Label>
   </td>
   <td>
   <asp:Label
   ID="Label3"
   runat="server"
   Text='<%# Eval("QuantityPerUnit")%>'
   >
   </asp:Label>
   </td>
   </tr>
   </ItemTemplate>
   </asp:ListView>
   </div>
   </form>
</body>
</html>

How to populate ComboBox from an array in asp.net

2011-02-25T09:54:00.000-08:00

ComboBoxArray.aspx

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

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
  <script runat="server">
   protected void Button1_Click(object sender, EventArgs e)
   {
   string[] Colors = {"BurlyWood","Chartreuse","Salmon","Ivory","Magenta"};
   ComboBox1.DataSource = Colors;
   ComboBox1.DataBind();
   }
</script>
<head id="Head1" runat="server">
   <title>Ajax ComboBox - How to populate ComboBox from an array in asp.net</title>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:DarkBlue; font-style:italic;">
   ASP.NET Ajax ComboBox - How to populate
   <br /> ComboBox from an array in asp.net
   </h2>
   <hr width="475" align="left" color="Pink" />
   <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
   </asp:ToolkitScriptManager>
   <asp:ComboBox
   ID="ComboBox1"
   runat="server"
   DropDownStyle="DropDown"
   AutoCompleteMode="None"
   CaseSensitive="false"
   RenderMode="Block"
   AutoPostBack="false"
   Font-Names="Comic Sans MS"
   Font-Size="Large"
   ForeColor="SeaGreen"
   >
   </asp:ComboBox>
   <br /><br /><br />
   <br /><br /><br />
   <asp:Button
   ID="Button1"
   runat="server"
   OnClick="Button1_Click"
   Text="Populate ComboBox From Array"
   Height="45"
   Font-Bold="true"
   ForeColor="DodgerBlue"
   />
   </div>
   </form>
</body>
</html>

Using ComboBox AutoCompleteMode Append in asp.net

2011-02-25T09:48:00.000-08:00

ComboBoxAutoCompleteModeAppend.aspx

<%@ 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">
   protected void ComboBox1_SelectedIndexChanged(object sender, EventArgs e)
   {
   Label1.Text = "You select: " + ComboBox1.SelectedItem.Text;
   }
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
   <title>Ajax ComboBox - Using ComboBox AutoCompleteMode Append in asp.net</title>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:DarkBlue; font-style:italic;">
   ASP.NET Ajax ComboBox - Using ComboBox
   <br /> AutoCompleteMode Append in asp.net
   </h2>
   <hr width="500" align="left" color="Pink" />
   <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="Append"
   CaseSensitive="false"
   RenderMode="Block"
   AutoPostBack="true"
   Font-Names="Comic Sans MS"
   Font-Size="Large"
   OnSelectedIndexChanged="ComboBox1_SelectedIndexChanged"
   >
   <asp:ListItem Text="DarkRed"></asp:ListItem>
   <asp:ListItem Text="SaddleBrown"></asp:ListItem>
   <asp:ListItem Text="DarkSalmon"></asp:ListItem>
   <asp:ListItem Text="DeepPink"></asp:ListItem>
   <asp:ListItem Text="IndianRed"></asp:ListItem>
   <asp:ListItem Text="SkyBlue"></asp:ListItem>
   </asp:ComboBox>
   </div>
   </form>
</body>
</html>

Using ComboBox AutoCompleteMode SuggestAppend in asp.net

2011-02-25T09:26:00.000-08:00

ComboBoxAutoCompleteModeSuggestAppend.aspx
<%@ Page Language="C#" AutoEventWireup="true" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>

<script runat="server">
   protected void ComboBox1_SelectedIndexChanged(object sender, EventArgs e)
   {
   Label1.Text = "You choose: " + ComboBox1.SelectedItem.Text;
   }
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
   <title>Ajax ComboBox - Using ComboBox AutoCompleteMode SuggestAppend in asp.net</title>
</head>
<body>
   <form id="form1" runat="server">
   <div>
   <h2 style="color:DarkBlue; font-style:italic;">
   ASP.NET Ajax ComboBox - Using ComboBox
   <br /> AutoCompleteMode SuggestAppend in asp.net
   </h2>
   <hr width="500" align="left" color="LightBlue" />
   <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
   </asp:ToolkitScriptManager>
   <asp:Label
   ID="Label1"
   runat="server"
   Font-Size="X-Large"
   ForeColor="Green"
   Font-Italic="true"
   Font-Underline="true"
   >
   </asp:Label>
   <br /><br />
   <asp:ComboBox
   ID="ComboBox1"
   runat="server"
   DropDownStyle="DropDown"
   AutoCompleteMode="SuggestAppend"
   CaseSensitive="false"
   RenderMode="Block"
   AutoPostBack="true"
   Font-Names="Comic Sans MS"
   Font-Size="X-Large"
   OnSelectedIndexChanged="ComboBox1_SelectedIndexChanged"
   ForeColor="Red"
   >
   <asp:ListItem Text="SaddleBrown"></asp:ListItem>
   <asp:ListItem Text="Black"></asp:ListItem>
   <asp:ListItem Text="Magenta"></asp:ListItem>
   <asp:ListItem Text="Blue"></asp:ListItem>
   <asp:ListItem Text="Violet"></asp:ListItem>
   <asp:ListItem Text="BlueViolet"></asp:ListItem>
   </asp:ComboBox>
   </div>
   </form>
</body>
</html>

Using ComboBox AutoCompleteMode SuggestAppend in asp.net

2011-02-25T09:25:00.000-08:00