Tuesday, June 18, 2013

Embedded Code Blocks

An embedded code block is server code that executes during the page's render phase. The code in the block can execute programming statements and call functions in the current page class.
C#
<%@ Page Language="C#" %>
<html>
<body>
    <form id="form1" runat="server">
    <% for(int i = 0; i < 6; i++) %>
       <% { Response.Write("<br>" + i.ToString()); }%>
    </form>
</body>
</html>



C#


















<%@ Page Language="C#" %>
<script runat=server>
protected String GetTime()
{
    return DateTime.Now.ToString("t");
}
</script>
<html>
<body>
    <form id="form1" runat="server">
       Current server time is <% =GetTime()%>.
    </form>
</body>
</html>
Posted by at No comments:

General Class C# (SQL Client)

General Class

using System.Data.SqlClient;

public class Cls_ADO
{
    SqlConnection con;
     
public Cls_ADO()
      {
            con=new SqlConnection("Data Source=win2006\\sqlexpress;Initial Catalog=db_sample;Integrated Security=True");
        con.Open();
      }

    public void execute_Query(string str)
    {
        SqlCommand cmd = new SqlCommand(str, con);
        cmd.ExecuteNonQuery();
    }

    public DataTable select_Query(string str)
    {
        SqlDataAdapter adp = new SqlDataAdapter(str, con);
        DataTable dt = new DataTable();
        adp.Fill(dt);
        return dt;
    }

    public void fillGrid(GridView grd,string strQry)
    {
        DataTable dt = select_Query(strQry);
        if (dt != null)
        {
            grd.DataSource = dt;
            grd.DataBind();
        }

    }

    public void fillDropDown(DropDownList ddl,string valueField,string textField,string table)
    {
        string strQry = "select " + valueField + "," + textField + " from " + table + "";
        DataTable dt = select_Query(strQry);
        if (dt != null)
        {
            ddl.DataSource = dt;
            ddl.DataValueField = valueField;
            ddl.DataTextField = textField;
            ddl.DataBind();
            ddl.Items.Insert(0, "--select--");
            //ListItem li = new ListItem("-Select-", "0");
            //ddl.Items.Insert(0, li);
        }
    }


    public void fillRepetear(Repeater rptr, string strQry)
    {
        DataTable dt = select_Query(strQry);
        if (dt != null)
        {
            rptr.DataSource = dt;
            rptr.DataBind();
        }
    }

    public void fillDataList(DataList dtl, string strQry)
    {
        DataTable dt = select_Query(strQry);
        if (dt != null)
        {
            dtl.DataSource = dt;
            dtl.DataBind();
        }
    }

Posted by at No comments:

Validation Controls in ASP.NET

Validation Controls

 ü  Common property for all validation controls is
a.    ErrorMessage
b.   ControlToValidate
 ü  We can alse set validation group for validation controls
          Eg: -checkavailabilty button only for username text box.
We can set validation group for that button and validation control for that text box.

1.RequiredFieldValidator
a.InitialValue  (eg :-  “—select—“ for dropdownlist)
2.   RegularExpressionValidator
a.      ValidationExpression ( for email,length of password etc…)
Eg: ([A-Za-z0-9]{8,15}) – for password strength.
    Or ---  ^([A-Za-z0-9]{8,15})$
3.   CompareValidator
a.      ControlToValidate
b.      Control to Compare
4.   RangeValidator
a.      Minimum value
b.      Maximum value
c.       Type ( eg: for age between 20-30 – type –integer)
5.   ValidationSummary
a.      To show summary in separate section;
6.   CustomValidator  (takes values from server )
a.      Control to validate
b.      Error Message
c.       Write Code on CustomValidator Click
Example : - for SalaryField ( between 5000-8000)

protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
    {
        try
        {
            int val = Convert.ToInt32(args.Value);
            if (val>=5000 && val <=8000)
            {
                args.IsValid = true;
            }
            else
            {
                args.IsValid = false;
            }
        }
        catch
        {
            args.IsValid = false;
        }

}
Posted by at No comments:

Data List in ASP.NET

Data List
           
 1) Create one page – datalist.aspx
            2)  Insert one table
            3)  Place “Datalist“ from toolbox
            4) > click Edit Template
            5)  Insert Table ( in the Left side)
            6) Insert HTML "Image" from tool box
            7)  Select “DataList” – right Click - properties

                                                Repeat columns   -   4 
                                                 Repeat direction  -   horizontal
8)Go to  “HTML” source.
Stage-2

7)       Insert “Edit” & “Delete” button by type the code
                           <td><asp:LinkButton ID="LinkButton1" runat="server"
              CommandArgument='<%#Eval("user_name")%>'     
                       CommandName="Editme">Editme</asp:LinkButton></td>                 
8)       NB: When we press “Editme ” button we are passing the “Command Argument”.

Stage-3

9)       Select “DataList” – Right Click – Events  - Double Click “ITEMCOMMAND”
10)   We are catching the values using ITEM COMMAND

                     protected void Datalist1_ItemCommand(object source, RepeaterCommandEventArgs e)
                {
                  if (e.CommandName == "Editme")
                  {
                     String U_name = e.CommandArgument.ToString();
                                        }

           }
Posted by at No comments:
Subscribe to: Posts (Atom)