Grid View Editing

design

 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
                        ForeColor="#333333" GridLines="None" Width="502px"
                        onrowcancelingedit="GridView1_RowCancelingEdit"
                        onrowdatabound="GridView1_RowDataBound" onrowediting="GridView1_RowEditing"
                        onrowupdating="GridView1_RowUpdating"
                        onselectedindexchanged="GridView1_SelectedIndexChanged"
                        style="text-align: center" DataKeyNames="u_id">
                        <AlternatingRowStyle BackColor="White" />
                        <Columns>
                            <asp:TemplateField HeaderText="Name">
                                <EditItemTemplate>
                                    <asp:TextBox ID="txtname" runat="server" Text='<%# Bind("u_name") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("u_name") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Gender">
                                <EditItemTemplate>
                                    <asp:RadioButtonList ID="rdbGender" runat="server" RepeatDirection="Horizontal">
                                        <asp:ListItem>Male</asp:ListItem>
                                        <asp:ListItem>Female</asp:ListItem>
                                    </asp:RadioButtonList>
                                    <asp:TextBox ID="txtGender" runat="server" Text='<%# Bind("u_gender") %>' Visible="false"></asp:TextBox>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("u_gender") %>'></asp:Label>
                                    <asp:RadioButtonList ID="rdbGender" runat="server" RepeatDirection="Horizontal" Visible="false">
                                        <asp:ListItem>Male</asp:ListItem>
                                        <asp:ListItem>Female</asp:ListItem>
                                    </asp:RadioButtonList>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Class">
                                <EditItemTemplate>
                                    <asp:DropDownList ID="ddlClass" runat="server" Height="16px" Width="88px"
                                        onselectedindexchanged="ddlClass_SelectedIndexChanged">
                                    </asp:DropDownList>
                                    <asp:TextBox ID="txtClass" runat="server" Text='<%# Bind("c_name") %>' Visible="false"></asp:TextBox>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="Label3" runat="server" Text='<%# Bind("c_name") %>'></asp:Label>
                                    <asp:DropDownList ID="ddlClass" runat="server" Height="16px" Width="88px" Visible="false">
                                    </asp:DropDownList>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:CommandField ShowEditButton="True" />
                            <%--
                            <asp:BoundField DataField="u_name" HeaderText="Name" />

                            <asp:BoundField DataField="u_gender" HeaderText="Gender" />

                            <asp:BoundField DataField="c_name" HeaderText="Class" />

                            <asp:CommandField ShowEditButton="True" />--%>
                        </Columns>
                        <EditRowStyle BackColor="#7C6F57" />
                        <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                        <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                        <RowStyle BackColor="#E3EAEB" />
                        <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                        <SortedAscendingCellStyle BackColor="#F8FAFA" />
                        <SortedAscendingHeaderStyle BackColor="#246B61" />
                        <SortedDescendingCellStyle BackColor="#D4DFE1" />
                        <SortedDescendingHeaderStyle BackColor="#15524A" />
                    </asp:GridView>


Code

 protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        FillGrid();

    }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    { if (e.Row.RowType == DataControlRowType.DataRow)
            {
                TextBox txtG = (TextBox)e.Row.FindControl("txtGender");
                RadioButtonList rdb = (RadioButtonList)e.Row.FindControl("rdbGender");
                if (txtG != null)
                {
                    if (txtG.Text == "Male")
                    {
                        rdb.Items[0].Selected = true;

                    }
                    else
                    {
                        rdb.Items[1].Selected = true;
                    }
                }

                DropDownList ddl = (DropDownList)e.Row.FindControl("ddlClass");
                TextBox txtC = (TextBox)e.Row.FindControl("txtClass");
                string str = "select * from tbl_class";
                SqlDataAdapter adt = new SqlDataAdapter(str, con);
                DataTable dt = new DataTable();
                adt.Fill(dt);
                ddl.DataSource = dt;
                ddl.DataTextField = "c_name";
                ddl.DataValueField = "c_id";
                ddl.DataBind();
                if (txtC != null)
                {
                    ddl.SelectedValue = ddl.Items.FindByText(txtC.Text).Value;
                }
            }
     
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        FillGrid();
   
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
        TextBox txtn = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtname");
        RadioButtonList rdbg = (RadioButtonList)GridView1.Rows[e.RowIndex].FindControl("rdbGender");
        DropDownList ddl = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlClass");
        string strt = ddl.SelectedValue;
        TextBox txt= (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtname");
        string str = "update tbl_user set u_name='" + txtn.Text + "',u_gender='" + rdbg.SelectedItem + "',u_c_id=" +Convert.ToInt32(strt)   + "where u_id=" + id + "";
        SqlCommand cmd = new SqlCommand(str, con);
        cmd.ExecuteNonQuery();
        GridView1.EditIndex = -1;
 
        FillGrid();
     


    }

Calling javascript function from CodeBehind with C#

Injecting a javascript code into a label control

This is one of the simplest method to call a javascript function from code behind. You need to do the following:

1. Create a new website project
2. Add a label and button control on your Default.aspx page
3. You body part of the markup should now look something like this:
   <body>
    <form id="form1" runat="server">
    <div>
        <asp:Label ID="lblJavaScript" runat="server" Text=""></asp:Label>
        <asp:Button ID="btnShowDialogue" runat="server" Text="Show Dialogue" />
    </div>
    </form>
</body> 
4. Add a javascript function to show a message box as shown below:
   <head runat="server">
    <title>Calling javascript function from code behind example</title>
        <script type="text/javascript">
            function showDialogue() {
                alert("this dialogue has been invoked through codebehind.");
            }
        </script>
</head>
5. Now double-click on the button and add the following code:
   lblJavaScript.Text = "<script type='text/javascript'>showDialogue();</script>";
6. Run your project and click the Show Dialogue button
7. A message box will be displayed as shown below:
   

Logout or signout problem in asp.net c# using Master page and windows authentication

Login Page

protected void Page_Load(object sender, EventArgs e)
{
    Session["imp"] = "0";            
}

protected void LinkButton1_Click(object sender, EventArgs e)
{
    Session["imp"] = "1";
    Response.Redirect("AdminHome.aspx");
}

Log Out Page

protected void Page_Load(object sender, EventArgs e)
{
    Response.Cache.SetExpires(DateTime.UtcNow.AddMinutes(-1));
    Response.Cache.SetCacheability(HttpCacheability.NoCache);
    Response.Cache.SetNoStore();
    if (Session["imp"].ToString() == "1")
    { }
    else
    {
        Response.Redirect("HomePage.aspx");
    }  
}

protected void LinkButton1_Click(object sender, EventArgs e)
{
    Session["imp"] = "0";
    Session.Abandon();
    Response.Clear();
    Response.Redirect("HomePage.aspx");
}

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>

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();

        }

    }

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;

        }

}

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();

                                        }

           }