Computer programming languages: February 2018

Wednesday 28 February 2018

Insert, Update, Delete, Search, Display, Single Click Insert Delete Both (Single click many operation) In GridView Using ASP.Net C#

Insert, Update, Delete, Search, Display, Single Click Insert Delete Both (Single click many operation) In GridView Using ASP.Net C#

******************** SQL Command *********************

create database test
create table new(name varchar (20)
               ,age int
               ,mobile bigint
                       )
********************* .aspx ********************

<!DOCTYPE html>

<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="Name"></asp:Label>
            
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />

        <asp:Label ID="Label2" runat="server" Text="Age"></asp:Label>
               
        <asp:Textbox ID="textbox2" runat="server"></asp:Textbox><br />

        <asp:Label ID="Label3" runat="server" Text="Mobile"></asp:Label>
          
        <asp:Textbox ID="textbox3" runat="server"></asp:Textbox><br /><br />

        <asp:Button ID="Button1" runat="server" Text="Insert" OnClick="Insert" />  
        <asp:Button ID="Button2" runat="server" Text="Update" OnClick="Update" />   
        <asp:Button ID="Button3" runat="server" Text="Delete" OnClick="Delete" />  
        <asp:Button ID="Button5" runat="server" Text="Display" OnClick="Display" />  
        <asp:Button ID="Button6" runat="server" Text="Search" OnClick="Search" />     <br />
        <asp:Button ID="Button7" runat="server" Text="Single_Click_Insert_Delete_Both" OnClick="Single_Click_Insert_Delete_Both" />  
         <br />
          <br />

        <asp:GridView ID="GridView1" runat="server"></asp:GridView>
    </div>
    </form>
</body>
</html>

********************** .cs *******************

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

public partial class _Default : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(@"Data Source=localhost;Initial Catalog=test;Integrated Security=True");
public void display()
    {
        con.Open();
        SqlCommand cmd = con.CreateCommand();
        cmd.CommandText = "select * from new";
        cmd.ExecuteNonQuery();

        DataTable dt = new DataTable();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.Fill(dt);
        GridView1.DataSource = dt;
        GridView1.DataBind();
        con.Close();
    }
    public void delete()
    {
        con.Open();
        SqlCommand cmd = con.CreateCommand();
        cmd.CommandText = "delete from new where name='" + TextBox1.Text + "'";
        cmd.ExecuteNonQuery();
        con.Close();
        display();
    }
protected void Insert(object sender, EventArgs e)
    {
        con.Open();
        SqlCommand cmd = con.CreateCommand();
        cmd.CommandText = "insert into new values('" + TextBox1.Text + "','" + textbox2.Text + "','" + textbox3.Text + "')";
        cmd.ExecuteNonQuery();
        con.Close();
        display();
    }

    protected void Update(object sender, EventArgs e)
    {
        con.Open();
        SqlCommand cmd = con.CreateCommand();
        cmd.CommandText = "update new set name='" + TextBox1.Text + "',mobile='" + textbox3.Text + "' where age='" + textbox2.Text + "'";
        cmd.ExecuteNonQuery();
        con.Close();
    }

    protected void Delete(object sender, EventArgs e)
    {
        con.Open();
        SqlCommand cmd = con.CreateCommand();
        cmd.CommandText = "delete from new where name='" + TextBox1.Text + "'";
        cmd.ExecuteNonQuery();
        con.Close();
        display();
    }

    protected void Display(object sender, EventArgs e)
    {
        display();
    }

    protected void Search(object sender, EventArgs e)
    {
        con.Open();
        SqlCommand cmd = con.CreateCommand();
        cmd.CommandText = "select * from new where name='" + TextBox1.Text + "'";
        cmd.ExecuteNonQuery();

        DataTable dt = new DataTable();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.Fill(dt);
        GridView1.DataSource = dt;
        GridView1.DataBind();
        con.Close();
    }

    protected void Single_Click_Insert_Delete_Both(object sender, EventArgs e)
    {
    con.Open();
    SqlCommand cmd = con.CreateCommand();
    cmd.CommandText = "insert into new values('" + TextBox1.Text + "','" + textbox2.Text + "','" + textbox3.Text + "')";
    // cmd.ExecuteNonQuery();
    // con.Close();
    // display();

    //con.Open();
    // SqlCommand cmd = con.CreateCommand();
    cmd.CommandText = "delete from new where name='" + TextBox1.Text + "'";
    cmd.ExecuteNonQuery();
    con.Close();
    // delete();
    display();
   }
}

Sunday 25 February 2018

How to insert a variable value into a table in SQL

declare @x int;
set @x=100-1;

declare @z int=1000-1;

create table newt(b int, c varchar(10),a int, d varchar(20))
insert into newt values(10, 'san', @x, @z)
select * from newt

Tuesday 13 February 2018

Models in an mvc application

2-add controller

3-controller

4-add view and (select modelclass name)

Select, Insert, Update, Delete Using Stored Procedure in SQL Server 2008

Alter PROCEDURE MasterInsertUpdateDelete
(
@id INTEGER,
@first_name VARCHAR(10),
@last_name VARCHAR(10),
@salary DECIMAL(10,2),
@city VARCHAR(20),
@StatementType nvarchar(20) = ''
)
AS
BEGIN

IF @StatementType = 'Insert'
BEGIN
insert into employee (id,first_name,last_name,salary,city) values( @id, @first_name, @last_name, @salary, @city) END

IF @StatementType = 'Select'
BEGIN
select * from employee
END

IF @StatementType = 'Update'
BEGIN
UPDATE employee SET
First_name = @first_name, last_name = @last_name, salary = @salary,
city = @city
WHERE id = @id
END

else IF @StatementType = 'Delete'
BEGIN
DELETE FROM employee WHERE id = @id
END

end

http://www.c-sharpcorner.com/UploadFile/rohatash/select-insert-update-delete-using-stored-procedure-in-sql/

Required field validator in asp.net

Registration form in HTML using JAVASCRIPT validation

<html>
    <head>
        <title> Validation using JavaScript </title>

    <script language="javascript">
    function validation()
        {
            var x=f.un.value;
            var len=x.length;
            var val=x.charCodeAt(0);

            var p=f.pw.value;
            var c=f.cpw.value;

            var a=f.email.value;
            var atpos=a.indexOf("@");
            var dotpos=a.lastIndexOf(".");

            if(len<6 || x=='' || x==null)
            {
                alert("check your username ! It must be minimum 6 characters");
                if(val<65 || val>90 && val<97 || val>122)
                alert("username must begin with an alphabet");
                return false;
            }
            else if(val<65 || val>90 && val <97 || val>122)
            {
                alert("username must begin with an alphabet");
                return false;
            }
            else if(p=='' || c=='' || p.length<6 || c.length<6 || p!=c)
            {
                alert("Password and Confirm Password should be same and greater than 6 characters!");
                return false;
            }
            else if(atpos<6 || dotpos<atpos+6 || dotpos+2>=a.length)
            {
                alert("Not a valid email id !!");
                return false;
            }
            else alert("Congragulations! you have successfully registered...");
        }

    </script>
</head>

<body>
        <h1 align=center>Welcome!! </h1>
        <h2 align=center>Please register Here...</h2>
        <hr width=50%>

    <table align=center border=3>

        <form name="f" action="home.html" onsubmit="return validation();" method="post">

            <tr>
                <td>User Name:</td>
                <td><input type="text" name="un"/></td>
            </tr>
            <tr>
                <td>Password:</td>
                <td><input type="password" name="pw"/></td>
            </tr>
            <tr>
                <td>Confirm Password:</td>
                <td><input type="password" name="cpw"/></td>
            </tr>
            <tr>
                <td>E-mail ID:</td>
                <td><input type="text" name="email"/></td>
            </tr>
            <tr>
                <td></td>
                <td><input type="submit" value="Submit"/></td>
            </tr>
        </form>
    </table>
</body>
</html>

Computer programming languages

Wednesday 28 February 2018

Insert, Update, Delete, Search, Display, Single Click Insert Delete Both (Single click many operation) In GridView Using ASP.Net C#

Sunday 25 February 2018

How to insert a variable value into a table in SQL

How to insert a variable value into a table in SQL

declare @x int;
set @x=100-1;

declare @z int=1000-1;

create table newt(b int, c varchar(10),a int, d varchar(20))
insert into newt values(10, 'san', @x, @z)
select * from newt

Tuesday 13 February 2018

About Me

Total Pageviews

Wednesday 28 February 2018

Insert, Update, Delete, Search, Display, Single Click Insert Delete Both (Single click many operation) In GridView Using ASP.Net C#

Sunday 25 February 2018

How to insert a variable value into a table in SQL

How to insert a variable value into a table in SQL

declare @x int;set @x=100-1;

declare @z int=1000-1;

create table newt(b int, c varchar(10),a int, d varchar(20))insert into newt values(10, 'san', @x, @z)select * from newt

Tuesday 13 February 2018

About Me

Total Pageviews

declare @x int;
set @x=100-1;

create table newt(b int, c varchar(10),a int, d varchar(20))
insert into newt values(10, 'san', @x, @z)
select * from newt