design


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


<!DOCTYPE html>


<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title></title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

        <h1 align="center">STUDENT RESULT</h1>


        


    <table align="center">

        <tr>

            <td><asp:Label ID="lblscnce" runat="server" Text="Science"></asp:Label></td>

            <td><asp:TextBox ID="txtsc" runat="server"></asp:TextBox></td>

        </tr>

        <tr>

            <td><asp:Label ID="lblART" runat="server" Text="Art"></asp:Label></td>

            <td><asp:TextBox ID="txtart" runat="server"></asp:TextBox></td>

        </tr>

        <tr>

            <td><asp:Label ID="lblcommerce" runat="server" Text="Commerce"></asp:Label></td>

            <td><asp:TextBox ID="txtcommerc" runat="server"></asp:TextBox></td>

        </tr>

        <tr>

            <td><asp:Label ID="lbldate" runat="server" Text="Date"></asp:Label></td>

            <td><asp:TextBox ID="txtdate" runat="server"></asp:TextBox></td>

        </tr>

        </table>

        <table align="center" style="margin-top: 40px;">

            

        <tr style="border-spacing:115px";><td><asp:Button ID="btnsave" runat="server" text="Save" OnClick="btnsave_Click" /></td>

            <td><asp:Button ID="delete" runat="server" text="Delete" OnClick="delete_Click" /></td>

            <td><asp:Button ID="btnupd" runat="server" Text="Update" OnClick="btnupd_Click" /></td>

        </tr>

    </table>

    </div>

        <div></div>

        

        <div  align="center">

            <asp:GridView ID="grd" runat="server" AutoGenerateColumns="false" OnRowCommand="grd_RowCommand" OnRowEditing="grd_RowEditing" OnRowDeleting="grd_RowDeleting">

                <Columns>

                    <asp:TemplateField HeaderText="science">

                        <ItemTemplate>

                            <asp:Label ID="lblsce" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Science") %>'></asp:Label>

                        </ItemTemplate>

                    </asp:TemplateField>

                     <asp:TemplateField HeaderText="Art">

                        <ItemTemplate><asp:Label ID="lblar" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Art") %>'></asp:Label></ItemTemplate>

                    </asp:TemplateField>

                     <asp:TemplateField HeaderText="commerce">

                        <ItemTemplate><asp:Label ID="lblco" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Commerce") %>'></asp:Label></ItemTemplate>

                    </asp:TemplateField>

                     <asp:TemplateField HeaderText="date">

                        <ItemTemplate><asp:Label ID="lbldt" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Date") %>'></asp:Label></ItemTemplate>

                    </asp:TemplateField>

                     <asp:TemplateField HeaderText="studentid" Visible="false">

                        <ItemTemplate><asp:Label Visible="false" ID="lblid" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"studentid") %>'></asp:Label></ItemTemplate>

                    </asp:TemplateField>

                    <asp:TemplateField HeaderText="">

                        <ItemTemplate>

                            <asp:LinkButton ID="lnkbtnedit" Text="edit" runat="server" CommandName="edit" CommandArgument='<%#Eval("studentid")%>'></asp:LinkButton>

                            <asp:LinkButton ID="lnkbtndelete" text="delete" runat="server" CommandName="delete" CommandArgument='<%#Eval("studentid")%>'></asp:LinkButton>

                        </ItemTemplate>

                    </asp:TemplateField>

                </Columns>

            </asp:GridView>

        </div>

        <asp:HiddenField ID="hdnstudentid" runat="server"/>

    </form>

</body>

</html>

///////////////////////////////////code behind/////////////////
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 _Default : System.Web.UI.Page
{
    static string DatabaseConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ConnectionString;

    protected void Page_Load(object sender, EventArgs e)
    {
        BindGrid();
    }
    protected void btnsave_Click(object sender, EventArgs e)
    {
        try
        {

            DataSet ds = new DataSet();
            SqlConnection sqlCon = null;
            using (sqlCon = new SqlConnection(DatabaseConnectionString))
            {
                sqlCon.Open();
                SqlCommand sql_cmnd = new SqlCommand("STUDENT_INFO", sqlCon);
                sql_cmnd.CommandType = CommandType.StoredProcedure;

                if (hdnstudentid.Value != "")
                {
                    sql_cmnd.Parameters.AddWithValue("@studentid", SqlDbType.NVarChar).Value = hdnstudentid.Value;
                    sql_cmnd.Parameters.AddWithValue("@Type", SqlDbType.VarChar).Value = "U";
                }
                else
                {
                    sql_cmnd.Parameters.AddWithValue("@Type", SqlDbType.VarChar).Value = "I";
                }

                sql_cmnd.Parameters.AddWithValue("@Science", SqlDbType.NVarChar).Value = txtsc.Text;
                sql_cmnd.Parameters.AddWithValue("@Art", SqlDbType.VarChar).Value = txtart.Text;
                sql_cmnd.Parameters.AddWithValue("@Commerce", SqlDbType.VarChar).Value = txtcommerc.Text;
                
               

                using (SqlDataAdapter sqa = new SqlDataAdapter())
                {
                    sqa.SelectCommand = sql_cmnd;
                    sqa.Fill(ds, "tableName");
                }
                sqlCon.Close();

                if (ds.Tables.Count>0)
                {
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        ScriptManager.RegisterStartupScript(Page, Page.GetType(), "MSG", "alert('Record successfully inserted');", true);
                    }
                    else
                    {
                        ScriptManager.RegisterStartupScript(Page, Page.GetType(), "MSG", "alert('Record not inserted');", true);
                    }
                }
               
            }
        }
        catch
        {
            ScriptManager.RegisterStartupScript(Page, Page.GetType(), "MSG", "alert('Record not inserted');", true);
        }
    }
    protected void delete_Click(object sender, EventArgs e)
    {

    }
    protected void btnupd_Click(object sender, EventArgs e)
    {

    }
    protected void BindGrid()
    {
        try
        {

            DataSet ds = new DataSet();
            SqlConnection sqlCon = null;
            using (sqlCon = new SqlConnection(DatabaseConnectionString))
            {
                sqlCon.Open();
                SqlCommand sql_cmnd = new SqlCommand("STUDENT_INFO", sqlCon);
                sql_cmnd.CommandType = CommandType.StoredProcedure;
                sql_cmnd.Parameters.AddWithValue("@Type", SqlDbType.VarChar).Value = "B";

                using (SqlDataAdapter sqa = new SqlDataAdapter())
                {
                    sqa.SelectCommand = sql_cmnd;
                    sqa.Fill(ds, "tableName");
                }
                sqlCon.Close();

                if (ds.Tables.Count > 0)
                {
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        grd.DataSource=ds.Tables[0];
                        grd.DataBind();
                    }
                }

            }
        }
        catch
        {
            ScriptManager.RegisterStartupScript(Page, Page.GetType(), "MSG", "alert('Something went wrong');", true);
        }
    }

    protected void grd_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).NamingContainer;
        if (e.CommandName == "edit")
        {
           
            int index = row.RowIndex;

            Label science = (Label)row.FindControl("lblsce");
            Label Arts = (Label)row.FindControl("lblar");
            Label comers = (Label)row.FindControl("lblco");
            Label date = (Label)row.FindControl("lbldt");
            Label stuid = (Label)row.FindControl("lblid");


            txtsc.Text = science.Text;
        txtart.Text =  Arts.Text;
        txtcommerc.Text = comers.Text;
        txtdate.Text = date.Text;
        hdnstudentid.Value = stuid.Text;

        }
        if (e.CommandName == "delete")
        {
            
            try
            {
                int index = Convert.ToInt32(e.CommandArgument);
                Label stuid = (Label)row.FindControl("lblid");


                DataSet ds = new DataSet();
                SqlConnection sqlCon = null;
                using (sqlCon = new SqlConnection(DatabaseConnectionString))
                {
                    sqlCon.Open();
                    SqlCommand sql_cmnd = new SqlCommand("STUDENT_INFO", sqlCon);
                    sql_cmnd.CommandType = CommandType.StoredProcedure;

                    sql_cmnd.Parameters.AddWithValue("@studentid", SqlDbType.NVarChar).Value = stuid.Text;
                    sql_cmnd.Parameters.AddWithValue("@Type", SqlDbType.VarChar).Value = "D";

                    using (SqlDataAdapter sqa = new SqlDataAdapter())
                    {
                        sqa.SelectCommand = sql_cmnd;
                        sqa.Fill(ds, "tableName");
                    }
                    sqlCon.Close();

                    if (ds.Tables.Count > 0)
                    {
                        if (ds.Tables[0].Rows.Count > 0)
                        {
                            ScriptManager.RegisterStartupScript(Page, Page.GetType(), "MSG", "alert('Record successfully delete');", true);
                            BindGrid();
                        }
                        else
                        {
                            ScriptManager.RegisterStartupScript(Page, Page.GetType(), "MSG", "alert('Record not delete');", true);
                        }
                    }

                }
            }
            catch
            {
                ScriptManager.RegisterStartupScript(Page, Page.GetType(), "MSG", "alert('Record not delete');", true);
            }
        }
    }
    protected void grd_RowEditing(object sender, GridViewEditEventArgs e)
    {

    }
    protected void grd_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {

    }
}

///////////////////////////////////database//////////////
ALTER Procedure STUDENT_INFO(
@studentid int=NULL ,
@Science varchar(255) = NULL,
@Art varchar(255)= NULL,
@Commerce varchar(255) =NULL,
@Date datetime= NULL,
@Type varchar=NULL
)
as

begin 
if (@Type='I')
BEGIN
insert into STUDENT(Science,Art,Commerce,Date)values(@Science,@Art,@Commerce,GETDATE())
select 'value'= @@IDENTITY
END
IF(@Type='U')

BEGIN
UPDATE STUDENT SET Science=@Science,Art=@Art,Commerce=@Commerce WHERE studentid=@studentid
END

IF(@Type='D')

BEGIN
delete from STUDENT WHERE studentid=@studentid
select 'value'= 1
END
if (@Type='B')
BEGIN
select * from STUDENT
END
end

Comments

Post a Comment

Popular posts from this blog

How To Create Table In MSSQL

The beginner should know the basic steps to create the table in sql. CREATE TABLE TABLENAME  ( COMP_CODE    VARCHAR(30), UNIT_CODE        VARCHAR(20), BR_CODE            VARCHAR(20) ) EXPLANATION :- 1-- Here  TABLENAME  is   the name of table  the you want to create. 2-  Here  COMP_CODE    is the name of column in the table. 3 -Here   VARCHAR(30),  is the the data type use for column and 30 show its size. This is the basic step to create table in database, Like that we can create number of tables in database. *Table is basically a database object which consists number of row and column,its appear like    Gride.
Read more

How To Find Nth Salary Of Employee

The question always asked during interview is how to find Nth salary of Employee # Let we consider a table  Employee_Salary  contains the columns  Emp_Id,Emp_Name,Emp_Salary . Employee_Salary   Emp_Name   Emp_Id   Emp_Salary  Rakesh  001  8000  Ashish   002  10000  Shalu   003  11000  Mohit   004  12000  Anurag   005  13000  Bhanu   006  14000 ##  Now we go through N th Salary * SELECT  Top 1 Emp_Salary FROM  (Select  Top Nth   Emp_Salary form  Employee_Salary           order   by  Emp_Salary desc) as EmpSalary order by Emp_Salary   Example #   SELECT   Top 1  Emp_Salary FROM  (Select   Top 3   Emp_Salary form  Employee_Salary  ...
Read more

How To Find Second Max Salary Of Employee

The basic question always asked during interview is how to find second max salary of Employee # Let we consider a table Employee_Salary contains the columns Emp_Id,Emp_Name,Emp_Salary . Employee_Salary   Emp_Name   Emp_Id   Emp_Salary  Rakesh  001  8000  Ashish   002  10000  Shalu   003  11000  Mohit   004  12000  Anurag   005  13000  Bhanu   006  14000 ## So let we go through Max Salary *  SELECT  MAX(Emp_Salary) FROM   Employee_Salary  here we get the max salary of employee from  Employee_Salary   table. ///////ouput is  14000 ## Now we go through Second Max Salary * SELECT  MAX(Emp_Salary) FROM   E...
Read more