Wednesday, July 9, 2014

.Net Components?

Net Framework is a platform that provides tools and technologies to develop Windows, Web and Enterprise applications. It mainly contains two components,
1.   Common Language Runtime (CLR)
2.    .Net Framework Class Library. 
1. Common Language Runtime (CLR)

.Net Framework
 provides runtime environment called Common Language Runtime (CLR).It provides an environment to run all the .Net Programs. The code which runs under the CLR is called as Managed Code. Programmers need not to worry on managing the memory if the programs are running under the CLR as it provides memory management and thread management.


Programmatically, when our program needs memory, CLR allocates the memory for scope and de-allocates the memory if the scope is completed.

Language Compilers (e.g. C#, VB.Net, J#) will convert the Code/Program to Microsoft Intermediate Language (MSIL) intern this will be converted to Native Code by CLR. See the below Fig. 

There are currently over 15 language compilers being built by Microsoft and other companies also producing the code that will execute under CLR. 

2.
    .Net Framework Class Library (FCL)

This is also called as Base Class Library and it is common for all types of applications i.e. the way you access the Library Classes and Methods in VB.NET will be the same in C#, and it is common for all other languages in .NET. 

The following are different types of applications that can make use of .net class library. 
1.                   Windows Application.
2.                   Console Application
3.                   Web Application.
4.                   XML Web Services.
5.                   Windows Services.
In short, developers just need to import the BCL in their language code and use its predefined methods and properties to implement common and complex functions like reading and writing to file, graphic rendering, database interaction, and XML document manipulation.

Below are the few more concepts that we need to know and understand as part of this .Net framework. 

3.
   Common Type System (CTS)

It describes set of data types that can be used in different .Net languages in common. (i.e), CTS ensures that objects written in different .Net languages can interact with each other.

For Communicating between programs written in any .NET complaint language, the types have to be compatible on the basic level.

The common type system supports two general categories of types:  

Value types:


Value types directly contain their data, and instances of value types are either allocated on the stack or allocated inline in a structure. Value types can be built-in (implemented by the runtime), user-defined, or enumerations.

Reference types:


Reference types store a reference to the value's memory address, and are allocated on the heap. Reference types can be self-describing types, pointer types, or interface types. The type of a reference type can be determined from values of self-describing types. Self-describing types are further split into arrays and class types. The class types are user-defined classes, boxed value types, and delegates.  

4. Common Language Specification (CLS)

It is a sub set of CTS and it specifies a set of rules that needs to be adhered or satisfied by all language compilers targeting CLR. It helps in cross language inheritance and cross language debugging.

Common language specification Rules:


It describes the minimal and complete set of features to produce code that can be hosted by CLR. It ensures that products of compilers will work properly in .NET environment. 
Sample Rules: 
1.       Representation of text strings 
2.       Internal representation of enumerations 
3.       Definition of static members and this is a subset of the CTS which all .NET languages are expected to support.
4.   Microsoft has defined CLS which are nothing but guidelines that language to follow so that it can communicate with other .NET languages in a seamless manner.



Furniture Query for Stock Sale And Remaining Products Monthly Wise


select * from total
select * from done

select x.item,x.one-y.one as one,x.two-y.two as two
from
total x
left outer join
done y
on x.id=y.id

insert into total values('Chair',6,9),('Table',7,8)

insert into done values('Chair',2,4),('Table',5,2)

delete from done where one=5




select  x.item,x.one-y.one as one,x.two-y.two as two
from
total x
left outer join
done y
on x.id=y.id

select * from total
select * from done
select distinct(x.item),SUM(x.one-y.one) as one,SUM(x.two-y.two) as two
from
total x
left outer join                                                                                            
done y
on x.id=y.id


select distinct(item) from total

Nested Grid


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

<!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 align="center">
        <asp:GridView ID="grdouter" runat="server" AutoGenerateColumns="False" OnRowDataBound="grdouter_onrowdatabound"
            DataKeyNames="ig_cid" BackColor="LightGoldenrodYellow" BorderColor="Tan" BorderWidth="1px"
            CellPadding="2" ForeColor="Black" GridLines="None">
            <AlternatingRowStyle BackColor="PaleGoldenrod" />
            <Columns>
                <asp:TemplateField HeaderText="countryid">
                    <ItemTemplate>
                        <asp:Label ID="lblcid" runat="server" Text='<%# bind("ig_cid") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="countryname">
                    <ItemTemplate>
                        <asp:Label ID="lblcname" runat="server" Text='<%# bind("ig_cname") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="state">
                    <ItemTemplate>
                        <asp:GridView ID="grdinner" runat="server" AutoGenerateColumns="false" OnRowDataBound="grdinner_onrowdatabound"
                            DataKeyNames="ig_sid">
                            <Columns>
                                <asp:TemplateField HeaderText="stateid">
                                    <ItemTemplate>
                                        <asp:Label ID="lblstateid" runat="server" Text='<%# bind("ig_sid") %>'></asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="statename">
                                    <ItemTemplate>
                                        <asp:Label ID="lblstatename" runat="server" Text='<%# bind("ig_sname") %>'></asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Region">
                                    <ItemTemplate>
                                        <asp:GridView ID="grdnested" runat="server" AutoGenerateColumns="false">
                                            <Columns>
                                                <asp:TemplateField HeaderText="regionid">
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblrid" runat="server" Text='<%# bind("ig_rid") %>'></asp:Label>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="regionname">
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblrname" runat="server" Text='<%# bind("ig_rname") %>'></asp:Label>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                            </Columns>
                                        </asp:GridView>
                                    </ItemTemplate>
                                </asp:TemplateField>
                            </Columns>
                        </asp:GridView>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
            <FooterStyle BackColor="Tan" />
            <HeaderStyle BackColor="Tan" Font-Bold="True" />
            <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
            <SortedAscendingCellStyle BackColor="#FAFAE7" />
            <SortedAscendingHeaderStyle BackColor="#DAC09E" />
            <SortedDescendingCellStyle BackColor="#E1DB9C" />
            <SortedDescendingHeaderStyle BackColor="#C2A47B" />
        </asp:GridView>
    </div>
    </form>
</body>
</html>




ASPX.CS
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    ado _objado;
    protected void Page_Load(object sender, EventArgs e)
    {

        _objado = new ado();
        grdouter.DataSource = _objado.getoutergriddetails();
        grdouter.DataBind();
    }

    protected void grdouter_onrowdatabound(object sender, GridViewRowEventArgs e)
    {
        _objado = new ado();
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            string id = grdouter.DataKeys[e.Row.RowIndex].Value.ToString();
            GridView inner = e.Row.FindControl("grdinner") as GridView;
            inner.DataSource = _objado.getinnergriddetails(Convert.ToInt32(id));
            inner.DataBind();

        }
    }
    protected void grdinner_onrowdatabound(object sender, GridViewRowEventArgs e)
    {
        _objado = new ado();
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
           

            Label lbl_id = (Label)e.Row.FindControl("lblstateid");
           
            string id2 = lbl_id.Text;
            GridView nested = e.Row.FindControl("grdnested") as GridView;
            nested.DataSource = _objado.getnestedgriddetails(Convert.ToInt32(id2));
            nested.DataBind();


       
        }
   
    }
}
 ---------------------------------------------------------------
.cs------------------------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
/// <summary>
/// Summary description for ado
/// </summary>
public class ado
{
    string conn = ConfigurationManager.ConnectionStrings["config"].ToString();

    SqlConnection con;
    SqlCommand cmd;
    SqlDataAdapter dap;
    DataSet ds;

    public DataSet getoutergriddetails()
    {
        con = new SqlConnection(conn);
        cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "sp_country";
        cmd.CommandType = CommandType.StoredProcedure;
        con.Open();
        ds = new DataSet();
        dap = new SqlDataAdapter(cmd);
        dap.Fill(ds);
        return ds;


    }
    public DataSet getinnergriddetails(int ig_cid)
    {
        con = new SqlConnection(conn);
        cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "sp_state";
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@ig_cid", ig_cid);
        con.Open();
        ds = new DataSet();
        dap = new SqlDataAdapter(cmd);
        dap.Fill(ds);
        return ds;

    }

    public DataSet getnestedgriddetails(int ig_sid)
    {
        con = new SqlConnection(conn);
        cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "sp_region";
        cmd.CommandType = CommandType.StoredProcedure;
        //cmd.Parameters.AddWithValue("@ig_cid", ig_cid);
        cmd.Parameters.AddWithValue("@ig_sid", ig_sid);
        con.Open();
        ds = new DataSet();
        dap = new SqlDataAdapter(cmd);
        dap.Fill(ds);
        return ds;
    }
}

//    public object getnestedgriddetails(int p)
//    {
//        throw new NotImplementedException();
//    }
//}