Oct 06 2008

How To Use RadioButtonList as DropDownList Alternative

Tag: asp.netadmin @ 10:12 pm
<%@ Page Language=”C#” AutoEventWireup=”true” CodeFile=”PopUpRadioList.aspx.cs”
Inherits=”PopUpRadioList” %>

<%@ Register TagPrefix=”ajaxToolkit” Assembly=”AjaxControlToolkit”
Namespace=”AjaxControlToolkit” %>
<!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>Untitled Page</title>
</head>
<style type=”text/css”>
    .popupControl
    {
        background-color:White;
        position:absolute;
        visibility:hidden;
    }
</style>
<body>
<form id=”form1″ runat=”server”>
    <asp:ScriptManager ID=”ScriptManager1″ runat=”server”>
    </asp:ScriptManager>
    <asp:DetailsView ID=”dvProduct” runat=”server” DefaultMode=”Edit”
 AutoGenerateRows=”false”
        Width=”100%” HeaderText=”Products”>
        <HeaderStyle BackColor=”AliceBlue” Font-Bold=”true” />
        <FieldHeaderStyle BackColor=”aliceBlue” Width=”150px” Font-Bold=”true” />
        <RowStyle Height=”20px” />
        <Fields>
            <asp:BoundField HeaderText=”Column1″ DataField=”Column1″ />
            <asp:BoundField HeaderText=”Column2″ DataField=”Column2″ />
            <asp:TemplateField HeaderText=”Category”>
                <ItemTemplate>
                    <asp:TextBox ID=”txtCategory” runat=”server” Text=’<%# Eval(”Column2″) %>’ />
                    <asp:Panel ID=”pnlCategories” runat=”server” CssClass=”popupControl”>
                        <div style=”border: 1px outset white; width: 275px”>
                            <asp:UpdatePanel ID=”Update1″ runat=”server”>
                                <ContentTemplate>
                                    <div>
                                        <asp:RadioButtonList ID=”rdoButton” runat=”server”
DataSource=’<%#GetCustomMadeDataTable()%>’
                                            DataTextField=”Column1″ DataValueField=”Id”
AutoPostBack=”True”
SelectedValue=’<%# Bind(”Id”) %>’
                                            OnSelectedIndexChanged=”rdoButton_SelectedIndexChanged”>
                                        </asp:RadioButtonList>
                                    </div>
                                </ContentTemplate>
                            </asp:UpdatePanel>
                        </div>
                        <ajaxToolkit:PopupControlExtender ID=”popupControl” runat=”server”
TargetControlID=”txtCategory”
                            PopupControlID=”pnlCategories” CommitProperty=”value” Position=”Top”>
                        </ajaxToolkit:PopupControlExtender>
                    </asp:Panel>
                </ItemTemplate>
            </asp:TemplateField>
        </Fields>
    </asp:DetailsView>
</form>
</body>
</html>

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 AjaxControlToolkit;

public partial class PopUpRadioList : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {

        if (Session["strTemp"] != null)
        {

            dvProduct.DataSource = Session["strTemp"] as DataTable;

            dvProduct.DataBind();

        }
        else
        {
            dvProduct.DataSource = GetCustomMadeDataTable();

            dvProduct.DataBind();
        }
    }

}

public DataTable GetCustomMadeDataTable()
{

    //Create a new DataTable object

    System.Data.DataTable objDataTable = new System.Data.DataTable();

    //Create three columns with string as their type

    objDataTable.Columns.Add(“Id”, typeof(string));
    objDataTable.Columns.Add(“Column1″, typeof(string));
    objDataTable.Columns.Add(“Column2″, typeof(string));
    objDataTable.Columns.Add(“Column3″, typeof(string));

    //Adding some data in the rows of this DataTable
    DataRow dr;
    for (int i = 0; i <= 5; i++)
    {

        dr = objDataTable.NewRow();
        dr[0] = i.ToString();
        dr[1] = “Column1Data” + i.ToString();
        dr[2] = “Column2Data” + i.ToString();
        dr[3] = “Column3Data” + i.ToString();
        objDataTable.Rows.Add(dr);

    }
    DataColumn[] dcPk = new DataColumn[1];
    dcPk[0] = objDataTable.Columns["Id"];
    objDataTable.PrimaryKey = dcPk;
    Session["strTemp"] = objDataTable;

    return objDataTable;
}
protected void rdoButton_SelectedIndexChanged(object sender, EventArgs e)
{
    RadioButtonList rdoButtons = (RadioButtonList)sender;
    PopupControlExtender popupControl =
(PopupControlExtender)rdoButtons.NamingContainer.FindControl(“popupControl”);

    // Popup result is the selected category
    popupControl.Commit(rdoButtons.SelectedItem.Text);

}
}

Oct 06 2008

Highlight a Row in GridView without a postback using ASP.NET and JavaScript

Tag: asp.netadmin @ 10:12 pm
<%@ Page Language=”C#” AutoEventWireup=”true” CodeFile=”GridViewSelect.aspx.cs”
Inherits=”GridViewSelect” %>

<!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>Untitled Page</title>
</head>
<body>
  <form id=”form1″ runat=”server”>
  <div>
      <asp:GridView ID=”GridView1″ runat=”server”
OnRowCreated=”GridView1_RowCreated”>
      </asp:GridView>

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;

public partial class GridViewSelect : System.Web.UI.Page
{
  protected void Page_Load(object sender, EventArgs e)
  {
      if (!IsPostBack)
      {
          if (Session["dtTemp"] != null)
          {
              GridView1.DataSource = Session["dtTemp"] as DataTable;

              GridView1.DataBind();
              this.DataBind();

          }
          else
          {
              GridView1.DataSource = GetCustomMadeDataTable();
              GridView1.DataSource = GetCustomMadeDataTable();
              this.DataBind();

          }
      }

  }
  protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
  {
      e.Row.Attributes.Add(“onMouseOver”, “this.style.background=’#eeff00′”);
      e.Row.Attributes.Add(“onMouseOut”, “this.style.background=’#ffffff’”);
  }

  public DataTable GetCustomMadeDataTable()
  {

      //Create a new DataTable object

      System.Data.DataTable objDataTable = new System.Data.DataTable();

      //Create three columns with string as their type

      objDataTable.Columns.Add(“Id”, typeof(string));
      objDataTable.Columns.Add(“FirstName”, typeof(string));
      objDataTable.Columns.Add(“LastName”, typeof(string));
      objDataTable.Columns.Add(“Address”, typeof(string));
      objDataTable.Columns.Add(“Email”, typeof(string));
      DataRow dr;
      //Adding some data in the rows of this DataTable
      for (int i = 0; i <= 50; i++)
      {
          dr = objDataTable.NewRow();
          dr[0] = i.ToString();
          dr[1] = “FirstName” + i.ToString();
          dr[2] = “LastName” + i.ToString();
          dr[3] = “Address” + i.ToString();
          dr[4] = “Email” + i.ToString();
          objDataTable.Rows.Add(dr);

      }

      DataColumn[] dcPk = new DataColumn[1];
      dcPk[0] = objDataTable.Columns["Id"];
      objDataTable.PrimaryKey = dcPk;
      Session["dtTemp"] = objDataTable;
      return objDataTable;
  }
}

Oct 06 2008

How To Split String and Display in GridView

Tag: asp.netadmin @ 10:11 pm
<%@ Page Language=”C#” AutoEventWireup=”true” CodeFile=”SplitFunctionUsingRegx.aspx.cs”
Inherits=”SplitFunctionUsingRegx” %>

<!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>Untitled Page</title>
</head>
<body>
  <form id=”form1″ runat=”server”>
  <div>
 Original String<asp:TextBox ID=”TextBox1″ runat=”server”></asp:TextBox> <br />
 Separator<asp:TextBox ID=”TextBox2″ runat=”server”></asp:TextBox><br />
 <asp:Button ID=”btnConvert” runat=”server” Text=”Split” OnClick=”btnConvert_Click” />
 <asp:GridView ID=”GridView1″ runat=”server”></asp:GridView>

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 System.Text.RegularExpressions;

public partial class SplitFunctionUsingRegx : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnConvert_Click(object sender, EventArgs e)
    {
        string str = TextBox1.Text;
        string strSplit = TextBox2.Text;
        ArrayList arSplit = new ArrayList();
        Regex r = new Regex(strSplit);
        string[] s = r.Split(str);
        foreach (object o in s)
        {

            arSplit.Add(o);

        }

        GridView1.DataSource = arSplit;
        GridView1.DataBind();

    }
}

Oct 06 2008

How To Change GridView Header Text At Runtime

Tag: asp.netadmin @ 10:10 pm
<%@ Page Language=”C#” AutoEventWireup=”true” CodeFile=”ChangeHeaderAtRuntime.aspx.cs”
Inherits=”ChangeHeaderAtRuntime” %>

<!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>Untitled Page</title>
</head>
<body>
   <form id=”form1″ runat=”server”>
   <div>
    <div>
  <asp:GridView ID=”GridView1″  runat=”server”
OnRowCreated=”GridView1_RowCreated”></asp:GridView>

   </div>

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;

public partial class ChangeHeaderAtRuntime : System.Web.UI.Page
{
   protected void Page_Load(object sender, EventArgs e)
   {
       if (!IsPostBack)
       {
           if (Session["strTemp"] != null)
           {

               GridView1.DataSource = Session["strTemp"] as DataTable;

               GridView1.DataBind();

           }
           else
           {
               GridView1.DataSource = GetCustomMadeDataTable();

               GridView1.DataBind();
           }
       }

   }
   public DataTable GetCustomMadeDataTable()
   {

       //Create a new DataTable object

       System.Data.DataTable objDataTable = new System.Data.DataTable();

       //Create three columns with string as their type

       objDataTable.Columns.Add(“Id”, typeof(string));
       objDataTable.Columns.Add(“Column1″, typeof(string));
       objDataTable.Columns.Add(“Column2″, typeof(string));
       objDataTable.Columns.Add(“Column3″, typeof(string));

       //Adding some data in the rows of this DataTable
       DataRow dr;
       for (int i = 0; i <= 20; i++)
       {

           dr = objDataTable.NewRow();
           dr[0] = i.ToString();
           dr[1] = “Column1Data” + i.ToString();
           dr[2] = “Column2Data” + i.ToString();
           dr[3] = “Column3Data” + i.ToString();
           objDataTable.Rows.Add(dr);

       }
       DataColumn[] dcPk = new DataColumn[1];
       dcPk[0] = objDataTable.Columns["Id"];
       objDataTable.PrimaryKey = dcPk;
       Session["strTemp"] = objDataTable;

       return objDataTable;
   }
   protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
   {
       if (e.Row.RowType == DataControlRowType.Header)
       {
           Int32 idx = 0;
           foreach (TableCell cell in e.Row.Cells)
           {
               cell.Text = String.Format(“{0}_{1}”, cell.Text, (++idx));
               if (idx % 2 == 0)
               {
                   cell.HorizontalAlign = HorizontalAlign.Right;
               }
               else
               {
                   cell.BackColor = System.Drawing.Color.Blue;
                   cell.ForeColor = System.Drawing.Color.White;
               }
           }
       }

   }
}

Oct 06 2008

How to fill a javascript array from a database using inline code?

Tag: asp.net, javascriptadmin @ 10:10 pm
<%@ Page Language=”C#” AutoEventWireup=”true” CodeFile=”ClientSideCalcGridview.aspx.cs”
   Inherits=”ClientSideCalcGridview” %>

<!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>Untitled Page</title>
</head>
<body>
   <form id=”form1″ runat=”server”>
       <div>
           <input type=”text” id=”indexText” />
           <input type=”button” id=”showButton”
 value=”Show Array Element By Index”
onclick=”ShowItem(document.getElementById(’indexText’).value);” />
       </div>
   </form>
</body>

<script type=”text/javascript”>
       function ShowItem(index)
       {
          alert(‘myArray['+index+'] = ‘ + myArray[index]);
         //alert(myArray[index]); 
       }
</script>

</html>

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;

public partial class ClientSideCalcGridview : System.Web.UI.Page
{
   protected void Page_Load(object sender, EventArgs e)
   {
       Session.Clear();
       DataSet ds = new DataSet();
       if (Session["dt"] == null)
       {
           ds = c();
       }
       else
       {
           ds = Session["dt"] as DataSet;
       }
       foreach (DataRow dr in ds.Tables[0].Rows)
       {
           this.ClientScript.RegisterArrayDeclaration(“myArray”, “‘” + dr["Address"].ToString() + “‘”);

       }

   }
   public DataSet c()
   {
       DataSet ds = new DataSet();
       DataTable dt = new DataTable(“Company”);
       DataRow dr;
       dt.Columns.Add(new DataColumn(“accountNo”, typeof(Int32)));
       dt.Columns.Add(new DataColumn(“CompanyName”, typeof(string)));
       dt.Columns.Add(new DataColumn(“Address”, typeof(string)));
       for (int i = 0; i <= 10; i++)
       {
           dr = dt.NewRow();
           dr[0] = i;
           dr[1] = “Company” + i + Environment.NewLine + “Title” + i;
           dr[2] = “Address” + i.ToString();
           dt.Rows.Add(dr);
       }
       ds.Tables.Add(dt);
       Session["dt"] = dt;
       return ds;
   }
}

Oct 06 2008

Conditional statement in CSS

Tag: Uncategorizedadmin @ 10:09 pm
<html>

   <head>

       <title>Conditional CSS</title>

       <style type=”text/css”>

           body

           {

               color:blue;

           }

       </style>

       <!–[if IE 7]>

        <style type=”text/css”>

        body {

            background-color:red;

        }

        </style>

        <![endif]–>

   </head>

   <body>

       <p>

           Conditional CSS

       </p>

   </body>

</html>

Oct 06 2008

ASP.Net C# Code to Create Dynamic Tables

Tag: asp.netadmin @ 10:08 pm
To generate the table you can use the following C# code:

// create a string type variable to generate dynamic table

string dynTable=“”;

// start with table tag with following attributes

dynTable = “<table cellspacing=\”0\” cellpadding=\”2\” border=\”1\”>”;

// outer loop to generate table rows
for (int tRows = 0; tRows < 5; tRows++)

{

//start table row

dynTable += “<tr>”;

// inner loop to generate columns
for (int tCols = 0; tCols < 4; tCols++)

{

// create column
dynTable += “<td>”; dynTable += “Row: “ + (tRows+1) + ” Col: “ + (tCols+1) ;

// close td column tag
dynTable += “</td>”;

}

// close table row

dynTable += “</tr>”;

}

// close the table tag

dynTable += “</table>”;

Literal1.Text = dynTable;

Above C# code will build a string having table tag, tr as table row, td as table data/column. To display the data retrieved from database you can set the tRows < [No. of DataRows Retrieved] and tCols < [No. of DataColmns].

Output Result of above code:

Row: 1 Col: 1 Row: 1 Col: 2 Row: 1 Col: 3 Row: 1 Col: 4
Row: 2 Col: 1 Row: 2 Col: 2 Row: 2 Col: 3 Row: 2 Col: 4
Row: 3 Col: 1 Row: 3 Col: 2 Row: 3 Col: 3 Row: 3 Col: 4
Row: 4 Col: 1 Row: 4 Col: 2 Row: 4 Col: 3 Row: 4 Col: 4
Row: 5 Col: 1 Row: 5 Col: 2 Row: 5 Col: 3 Row: 5 Col: 4

Oct 06 2008

How to convert an array into a comma-delimited string with String

Tag: javascriptadmin @ 10:07 pm
<%@ Page Language=“C#” %>
<script runat=“server”>

void Page_Load(Object sender, EventArgs e)
{
string[] ids = {“2343″,“2344″,“2345″};
string idString = String.Join(“,”,ids);
Response.Write(idString);
}

</script>

Oct 06 2008

How to sort a DataTable before passing on to DataGrid

Tag: Uncategorizedadmin @ 10:06 pm

If you are displaying a DataTable with a DataGrid and would like to have it sorted

 by a column, here is the two line solution (copy it to a DataView, sort the
DataView, and then define the DataSource of the DataGrid as the DATAVIEW, not the
 DataGrid.
<%@ Page Language=“C#” %>
<%@ Import Namespace=“System.Data” %>
<script runat=“server”>

   public void Page_Load(Object sender, EventArgs E) {

       DataTable dt = GetDataTable();

       //sort the DataTable
       DataView dv=dt.DefaultView;
       dv.Sort=“LastName DESC”;

       dgMembers.DataSource = dv;
       dgMembers.DataBind();
   }

   private DataTable GetDataTable() {
       //create table
       DataTable dt = new DataTable(“Members”);
       dt.Columns.Add(“ID”,Type.GetType(“System.Int32″));
       dt.Columns.Add(“LastName”,Type.GetType(“System.String”));
       dt.Columns.Add(“Lectures”,Type.GetType(“System.Int32″));

       //create fields
       DataColumn[] pk = new DataColumn[1];
       pk[0] = dt.Columns["ID"];
       dt.PrimaryKey = pk;
       dt.Columns["ID"].AutoIncrement = true;
       dt.Columns["ID"].AutoIncrementSeed = 1;
       dt.Columns["ID"].ReadOnly = true;

       //fill rows
       DataRow dr;
       for(int x=1;x<=10;x++) {
           //make every other one different
           if(Math.IEEERemainder(x,2) == 0) {
               dr = dt.NewRow();
               dr["LastName"] =  “Riss”;
               dr["Lectures"] = 14;
               dt.Rows.Add(dr);
           } else {
               dr = dt.NewRow();
               dr["LastName"] =  “Anders”;
               dr["Lectures"] = 3;
               dt.Rows.Add(dr);

           }
       }

       return dt;
   }

</script>
<html>
<head>
</head>
<body>
<form runat=“server”>
<asp:DataGrid id=“dgMembers” runat=“server”></asp:DataGrid>
</form>
</body>
</html>

Oct 06 2008

How to share arrays between code behind and javascript with RegisterStartupScript and RegisterArrayDeclaration

Tag: asp.netadmin @ 10:06 pm
<%@ Page Language=“C#” Debug=“true” %>
<script runat=“server”>

void Page_Load(Object sender, EventArgs e)
{
String scriptString = “\n”;
scriptString += “<script language=JavaScript>\n”;
scriptString += “<” + “!–\n”;
scriptString += ”    function showIds() {\n”;
scriptString += ”        for(var index=0;index < ids.length;index++)\n”;
scriptString += ”        document.write(ids[index] + ‘<br>’);\n”;
scriptString += ”    }\n”;
scriptString += “//–>\n”;
scriptString += “<” + “/” + “script>\n”;

RegisterStartupScript(“arrayScript”, scriptString);

string[] ids = {“111″,“112″,“the third one”,“114″};
RegisterArrayDeclaration(“ids”,“‘” + String.Join(“‘,’”,ids) + “‘”);

}

Next Page »