DOTNET ADHERENTS: ASP.NET CODE FOR INSERTION,DELETION AND UPDATION USING C# WITH VALIDATION........|||||

DESIGN VIEW:

SOURCE VIEW:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!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></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>

        <asp:Label ID="Label1" runat="server" Text="Username"></asp:Label>
                                        
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
 
        <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
            ControlToValidate="TextBox1" ErrorMessage="Enter Your Username"
            ForeColor="#FF0066"></asp:RequiredFieldValidator>
        <br />
                                                                                         
        <br />
        <br />
        <asp:Label ID="Label2" runat="server" Text="Email Id"></asp:Label>
                                           
        <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
 
        <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
            ControlToValidate="TextBox2" ErrorMessage="Enter Email Id" ForeColor="#FF0066"></asp:RequiredFieldValidator>
        <br />
                                                                                          
        <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"
            ControlToValidate="TextBox2" ErrorMessage="Enter Vailid Email Id"
            ForeColor="#660066"
            ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator>
        <br />
        <br />
        <asp:Label ID="Label3" runat="server" Text="Mobile No."></asp:Label>
                                      
        <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
 <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
            ControlToValidate="TextBox3" ErrorMessage="Enter Mobile Number"
            ForeColor="#FF0066"></asp:RequiredFieldValidator>
        <br />
                                                                                         
        <asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server"
            ControlToValidate="TextBox3" ErrorMessage="Enter Valid Mobile No"
            ForeColor="#660066" ValidationExpression="^[1-9][0-9]{9}$"></asp:RegularExpressionValidator>
 <br />
        <br />
        <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Insert" />
   
        <asp:Button ID="Button2" runat="server" onclick="Button2_Click" Text="Delete" />
  
        <asp:Button ID="Button3" runat="server" onclick="Button3_Click" Text="Update" />
  
        <br />
        <br />
        <br />
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>

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

CODE VIEW:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class Default2 : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection("Data Source=devsharma-pc\\sqlexpress;Initial Catalog=NorthWindServices;Integrated Security=True;Pooling=False");
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        con.Open();
        cmd.CommandText = "Insert into student (username,emailid,mobnumber) values(@un,@em,@mo)";
        cmd.Parameters.AddWithValue("@un", TextBox1.Text);
        cmd.Parameters.AddWithValue("@em", TextBox2.Text);
        cmd.Parameters.AddWithValue("@mo", TextBox3.Text);
        cmd.ExecuteNonQuery();
        con.Close();
        display();

    }
    public void display()
    {
        SqlDataAdapter da = new SqlDataAdapter("Select * from student", con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        con.Open();
        cmd.CommandText = "Delete from student where username=@un";
        cmd.Parameters.AddWithValue("@un", TextBox1.Text);

        cmd.ExecuteNonQuery();
        con.Close();
        display();
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        con.Open();
        cmd.CommandText = "Update student set emailid =@em where username=@un";
        cmd.Parameters.AddWithValue("@un", TextBox1.Text);
        cmd.Parameters.AddWithValue("@em", TextBox2.Text);

        cmd.ExecuteNonQuery();
        con.Close();
        display();
    }
}

OUTPUT:

DOTNET ADHERENTS

Saturday, 23 November 2013

ASP.NET CODE FOR INSERTION,DELETION AND UPDATION USING C# WITH VALIDATION........|||||

No comments:

Post a Comment

About Me