Saturday, 7 April 2012

all in linq2sql


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Linq;
public partial class linq : System.Web.UI.Page
{
    DataClassesDataContext dc = new DataClassesDataContext();
 
    Table1 t = new Table1();
 
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bind();
        }
    }

    private void bind()
    {
        var a = dc.Table1s.ToList();
        GridView1.DataSource = a;
        GridView1.DataBind();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {


        t.Address = TextBox2.Text;
        t.name = TextBox1.Text;
        dc.Table1s.InsertOnSubmit(t);
        dc.SubmitChanges();
        /* if sp require
         * dc.spinsert(TextBox2.Text,TextBox1.Text);
         *  leftouterjoin in linq*/


        //var q = from t1 in dc.Table1s
        //        join t2 in dc.count_tbls on t1.id equals t2.id into t1t2
        //        from t2 in t1t2.DefaultIfEmpty()
        //        select new {t1.id,t1.name,t2.month};
       


       
     
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        bind();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        GridViewRow gd = GridView1.Rows[e.RowIndex];
        int id1 = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
        var h = dc.Table1s.Where(m => m.id == id1).Single<Table1>();
        dc.Table1s.DeleteOnSubmit(h);
        dc.SubmitChanges();
        bind();
        Response.Write("Delete");
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        bind();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        GridViewRow gd = GridView1.Rows[e.RowIndex];
        int id1 = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
        string t1 = ((TextBox)gd.Cells[3].Controls[0]).Text;
        var h = dc.Table1s.Where(m=>m.id==id1).Single<Table1>();
        h.name = t1;
       
        dc.SubmitChanges();
        GridView1.EditIndex = -1;
        bind();


        Response.Write("update");

    }
}
/*source*/

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

<!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:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
        <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id"
            OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit"
            OnRowDeleting="GridView1_RowDeleting">
            <Columns>
                <asp:CommandField ShowEditButton="True" />
                <asp:CommandField ShowDeleteButton="True" />
                <asp:BoundField DataField="id" HeaderText="id" Visible="false" />
                <asp:BoundField DataField="name" HeaderText="Name" />
               
             
            </Columns>
        </asp:GridView>
    </div>
    </form>
</body>
</html>


Posted by at No comments:

all in edmx


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

public partial class Default2 : System.Web.UI.Page
{
    jayEntities j = new jayEntities();
    Table1 t = new Table1();
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        int i = Convert.ToInt32(TextBox1.Text);

       
        /* If where condition for one field  Require */
     
        var a = j.Table1.Where(m => m.id == i).ToList().Select(m => m.name);
       
     
        GridView1.DataSource = a;
        GridView1.DataBind();

        /* if where condition  require */
        var d1 = j.Table1.Where(f => f.name.StartsWith("h")&& f.name.Contains("c")).Select(f=>f.name);
     
        /*Display two field
       
        //var d1 = j.Table1.Select(f => new { f.id,f.name}).OrderBy(f=>f.name).Where(f=>f.id==i);
     //  var d4 = j.Table1.Select(f => new { f.name });*/

        GridView2.DataSource = d1;
        GridView2.DataBind();
        /*All Table Data */
        var d2 = j.Table1.ToList();
        GridView3.DataSource = d2;
        GridView3.DataBind();
        /*If where condition for two field  Require */


        //List<jayModel.Table1> list = new List<jayModel.Table1>();
        var list = j.Table1.Where(m => m.id == i).ToList();
        //var list1 = j.count_tbl.Where(m => m.id == i).ToList();
        var objJoin = list.Join(list, b => b.id, c => c.id, (b, c) => new { name = b.name, address = b.Address });
        //left outer join
        var q = from t1 in j.Table1
                join t2 in j.count_tbl on t1.id equals t2.id into t1t2
                from t2 in t1t2.DefaultIfEmpty()
                select new { t1.id, t1.name };
        //right outer join
        var q1 = from t2 in j.count_tbl join t1 in j.Table1 on t2.id equals t1.id into t1t2 from t1 in t1t2.DefaultIfEmpty() select new { t2.month, t2.number, t1.name };

        GridView4.DataSource = q1;
        GridView4.DataBind();
    }
}
/*souce*/

<%@ 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:TextBox ID="TextBox1" runat="server">
        </asp:TextBox>
        <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
        <br />
        <br />
        <br />
        <br />
        <asp:GridView ID="GridView1" runat="server">
           <%-- <Columns>
                <asp:TemplateField>
                    <HeaderTemplate>
                        Name</HeaderTemplate>
                    <ItemTemplate>
                        <asp:Label ID="lab1" runat="server" Text='<%#Eval("name") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>--%>
        </asp:GridView>
        <asp:GridView ID="GridView2" runat="server">
        </asp:GridView>
        <asp:GridView ID="GridView3" runat="server">
        </asp:GridView>
        <asp:GridView ID="GridView4" runat="server">
        </asp:GridView>
    </div>
    </form>
</body>
</html>


Posted by at No comments:

listviewall


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;
using System.EnterpriseServices;
using System.Data.EntityModel;
using jayModel;
using System.Drawing.Text;


public partial class listview : System.Web.UI.Page
{
  /*here listview1 or listview2
    /*if any chid control data bind in listview so use Listview1_Itemcreated*/
    jayEntities j = new jayEntities();

    Table1 tt = new Table1();

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            TextBox1.Text = Request.QueryString["id"].ToString();
            Label2.Text = Session["id"].ToString();
            bind();
            bind1();
        }
    }

    private void bind()
    {

        var v = j.spselect();
        ListView1.DataSource = v;
        ListView1.DataBind();






    }

    private void bind1()
    {

        var v = j.spselect();
        ListView2.DataSource = v;
        ListView2.DataBind();






    }
    protected void ListView1_ItemInserting(object sender, ListViewInsertEventArgs e)
    {
        string name = "";
        TextBox txt = (e.Item.FindControl("EmpNameTextBox")) as TextBox;
        if (txt != null)
            name = txt.Text;


        Table1 t1 = new Table1();
        t1.name = name;


        j.AddToTable1(t1);
        j.SaveChanges();
        ListView1.EditIndex = -1;
        bind();
       

    }
    protected void ListView1_ItemUpdating(object sender, ListViewUpdateEventArgs e)
    {
       
        TextBox txt = (ListView1.Items[e.ItemIndex].FindControl("EmpNameTextBox")) as TextBox;
        DropDownList dr = (ListView1.Items[e.ItemIndex].FindControl("Dropdownlist2")) as DropDownList;

        int id1 = Convert.ToInt32(ListView1.DataKeys[e.ItemIndex].Value);

        //var f = j.Table1.Where(m => m.id == id1).Single<Table1>();
        Table1 tt = j.Table1.Where(m => m.id == id1).Single<Table1>();
        tt.name = dr.SelectedItem.Text;
        //tt.name = txt.Text;
        j.SaveChanges();
        ListView1.EditIndex = -1;
        bind();
    }

    protected void ListView1_ItemCanceling(object sender, ListViewCancelEventArgs e)
    {
        ListView1.EditIndex = -1;
        bind();
    }
    protected void ListView1_ItemDeleting(object sender, ListViewDeleteEventArgs e)
    {

        int id1 = Convert.ToInt32(ListView1.DataKeys[e.ItemIndex].Value);
        var tt = j.Table1.Where(n => n.id == id1).ToList();
        j.DeleteObject(tt);
        j.SaveChanges();
        ListView1.EditIndex = -1;
        bind();
    }
    protected void ListView1_ItemEditing(object sender, ListViewEditEventArgs e)
    {
        ListView1.EditIndex = e.NewEditIndex;


        bind();
    }

    protected void ListView1_ItemCreated(object sender, ListViewItemEventArgs e)
    {
        try
        {
            //if (e.Item.ItemType == ListViewItemType.InsertItem)
            //{

            DropDownList drp_town = (DropDownList)(e.Item.FindControl("Dropdownlist2"));
            var s = j.spselect().ToList();
            drp_town.DataSource = s;
            drp_town.DataTextField = "name";
            drp_town.DataValueField = "id";
            drp_town.DataBind();


        }
        catch (Exception ex)
        {
            ex.Message.ToString();
        }

    }

    protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
    {
       
     
    }
    protected void ListView1_ItemDataBound(object sender, ListViewItemEventArgs e)
    {




        //ListView objListView = (ListView)sender;

        //// Only do this if we are editing the ListView

        //// Only do this if we are editing this item
        //if (objListView.EditIndex > -1)
        //{
        //    if (e.Item.ID == objListView.EditItem.ID)
        //    {
        //        DropDownList Dropdownlist2 = (DropDownList)(e.Item.FindControl("Dropdownlist2"));

        //        Dropdownlist2.SelectedIndexChanged += new EventHandler(DropDownList2_SelectedIndexChanged);



        //    }

        //    //drp_town.Items.FindByText("jay").Selected = true;

        //    //drp_town.Items.FindByValue("Dropdownlist2").Selected = true;
        //}

    }







    protected void ListView2_ItemEditing(object sender, ListViewEditEventArgs e)
    {
        ListView2.EditIndex = e.NewEditIndex;


        bind1();

    }
    protected void ListView2_ItemInserted(object sender, ListViewInsertedEventArgs e)
    {

    }
    protected void ListView2_ItemInserting(object sender, ListViewInsertEventArgs e)
    {
        string name = "";
        TextBox txt = (e.Item.FindControl("nameTextBox")) as TextBox;
        if (txt != null)
            name = txt.Text;


        Table1 t1 = new Table1();
        t1.name = name;


        j.AddToTable1(t1);
        j.SaveChanges();
        ListView2.EditIndex = -1;
        bind1();

       

    }
    protected void ListView2_ItemUpdating(object sender, ListViewUpdateEventArgs e)
    {
        TextBox txt = (ListView2.Items[e.ItemIndex].FindControl("nameTextBox")) as TextBox;
     

        int id1 = Convert.ToInt32(ListView1.DataKeys[e.ItemIndex].Value);

        //var f = j.Table1.Where(m => m.id == id1).Single<Table1>();
        Table1 tt = j.Table1.Where(m => m.id == id1).Single<Table1>();
     
        tt.name = txt.Text;
        j.SaveChanges();
        ListView1.EditIndex = -1;
        bind1();
    }
    protected void ListView2_ItemDeleting(object sender, ListViewDeleteEventArgs e)
    {
        int id1 = Convert.ToInt32(ListView2.DataKeys[e.ItemIndex].Value);
        var tt = j.Table1.Where(n => n.id == id1).ToList();
        j.DeleteObject(tt);
        j.SaveChanges();
        ListView2.EditIndex = -1;
        bind1();
    }
    protected void Dropdownlist2_SelectedIndexChanged(object sender, EventArgs e)
    {

    }

 
}


//sourcepage

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

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!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:ListView ID="ListView1" runat="server" InsertItemPosition="LastItem" OnItemCanceling="ListView1_ItemCanceling"
            OnItemDeleting="ListView1_ItemDeleting" OnItemInserting="ListView1_ItemInserting"
            OnItemUpdating="ListView1_ItemUpdating" OnItemEditing="ListView1_ItemEditing"
            DataKeyNames="id" OnItemCreated="ListView1_ItemCreated" OnItemDataBound="ListView1_ItemDataBound"
            allowpaging="true">
            <LayoutTemplate>
                <table id="Table1" runat="server">
                    <tr id="Tr1" runat="server">
                        <td id="Td1" runat="server">
                            <table id="itemPlaceholderContainer" runat="server" border="1" style="">
                                <tr id="Tr2" runat="server" style="">
                                    <th id="th1" runat="server">
                                    </th>
                                    <th id="Th2" runat="server">
                                        Name
                                    </th>
                                </tr>
                                <tr id="itemPlaceholder" runat="server">
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
                <div style="clear: both;">
                    <asp:DataPager ID="DataPager1" runat="server" PageSize="3">
                        <Fields>
                            <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowLastPageButton="True" />
                        </Fields>
                    </asp:DataPager>
                </div>
            </LayoutTemplate>
            <ItemTemplate>
                <tr style="">
                    <td>
                        <asp:Button ID="Btnedit" runat="server" Text="Edit" CommandName="Edit" />
                        <asp:Button ID="Btndelete" runat="server" Text="Delete" CommandName="Delete" />
                    </td>
                    <td border="1" runat="server">
                       <%-- <asp:Label ID="Name" runat="server" Text='<%# Eval("Name") %>'></asp:Label>--%>
                       <%# Eval("Name") %>
                        <%-- <asp:DropDownList ID="DropDownList2"  runat="server" selectedvalue='<%# Eval("id") %>'>
                        </asp:DropDownList>--%>
                    </td>
                    <td>
                    </td>
                </tr>
            </ItemTemplate>
            <EditItemTemplate>
                <tr style="">
                    <td>
                        <asp:Button ID="UpdateButton" runat="server" CommandName="Update" Text="Update" />
                        <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Cancel" />
                    </td>
                    <td>
                        <%--<asp:TextBox ID="IDTextBox" runat="server" Text='<%# Bind("id") %>' />--%>
                        <asp:TextBox ID="EmpNameTextBox" runat="server" Text='<%# Bind("Name") %>' />
                    </td>
                    <td>
                        <%--<asp:TextBox ID="IDTextBox" runat="server" Text='<%# Bind("id") %>' />--%>
                        <asp:DropDownList ID="DropDownList2" runat="server" SelectedValue='<%# Eval("id") %>'
                            AutoPostBack="true"   onselectedindexchanged="DropDownList2_SelectedIndexChanged">
                        </asp:DropDownList>
                    </td>
                </tr>
            </EditItemTemplate>
            <InsertItemTemplate>
                <tr style="">
                    <td>
                        <asp:Button ID="InsertButton" runat="server" CommandName="Insert" Text="Insert" />
                        <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Clear" />
                    </td>
                    <td  runat ="server" border="1">
                        <asp:TextBox ID="EmpNameTextBox" runat="server" Text='<%# ("Name") %>' />
                    </td>
                    <td>
                        <%--<asp:DropDownList ID="DropDownList2" runat="server" DataTextField="Name" >
                        </asp:DropDownList>--%>
                    </td>
                </tr>
            </InsertItemTemplate>
        </asp:ListView>
        <%--<asp:DataPager ID="data1" runat="server" PagedControlID="ListView1"
            PageSize="2" >
            <Fields>
                <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True"
                    ShowLastPageButton="True" />
            </Fields>
        </asp:DataPager>--%>
        <table>
            <tr>
                <%-- <td class="style1">
                    <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True">
                    </asp:DropDownList>
                 
                </td>--%>
                <td>
                    You have
                    <asp:Label ID="Label1" runat="server" Text=""></asp:Label>
                    Entries
                    <br />
                </td>
            </tr>
        </table>
    </div>
    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
    <asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
 
 
    <br />
    <br />
    <br />
    <asp:ListView ID="ListView2" runat="server" InsertItemPosition="LastItem" DataKeyNames="id"
        OnItemDeleting="ListView2_ItemDeleting" OnItemEditing="ListView2_ItemEditing"
        OnItemInserted="ListView2_ItemInserted" OnItemInserting="ListView2_ItemInserting"
        OnItemUpdating="ListView2_ItemUpdating">
        <LayoutTemplate>
            <table runat="server">
                <tr runat="server">
                    <td runat="server">
                        <table id="itemPlaceholderContainer" runat="server" border="1" style="background-color: #FFFFFF;
                            border-collapse: collapse; border-color: #999999; border-style: none; border-width: 1px;
                            font-family: Verdana, Arial, Helvetica, sans-serif;">
                            <tr runat="server" style="background-color: #DCDCDC; color: #000000;">
                                <th runat="server">
                                </th>
                                <th runat="server">
                                    id
                                </th>
                                <th runat="server">
                                    name
                                </th>
                                <%--<th runat="server">
                                    Address</th>--%>
                            </tr>
                            <tr id="itemPlaceholder" runat="server">
                            </tr>
                        </table>
                    </td>
                </tr>
                <tr runat="server">
                    <td runat="server" style="text-align: center; background-color: #CCCCCC; font-family: Verdana, Arial, Helvetica, sans-serif;
                        color: #000000;">
                        <asp:DataPager ID="DataPager1" runat="server">
                            <Fields>
                                <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowLastPageButton="True" />
                            </Fields>
                        </asp:DataPager>
                    </td>
                </tr>
            </table>
        </LayoutTemplate>
        <ItemTemplate>
            <tr style="background-color: #DCDCDC; color: #000000;">
                <td>
                    <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="Delete" />
                    <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
                </td>
                <td>
                    <asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
                </td>
                <td>
                    <asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' />
                </td>
                <%-- <td>
                    <asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
                </td>--%>
            </tr>
        </ItemTemplate>
        <AlternatingItemTemplate>
            <tr style="background-color: #FFF8DC;">
                <td>
                    <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="Delete" />
                    <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
                </td>
                <td>
                    <asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
                </td>
                <td>
                    <asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' />
                </td>
                <%--<td>
                    <asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
                </td>--%>
            </tr>
        </AlternatingItemTemplate>
        <EditItemTemplate>
            <tr style="background-color: #008A8C; color: #FFFFFF;">
                <td>
                    <asp:Button ID="UpdateButton" runat="server" CommandName="Update" Text="Update" />
                    <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Cancel" />
                </td>
                <td>
                    <%--<asp:Label ID="idLabel1" runat="server" Text='<%# Eval("id") %>' />--%>
                </td>
                <td>
                    <asp:TextBox ID="nameTextBox" runat="server" Text='<%# Bind("name") %>' />
                </td>
                <%--<td>
                    <asp:TextBox ID="AddressTextBox" runat="server" Text='<%# Bind("Address") %>' />
                </td>--%>
            </tr>
        </EditItemTemplate>
        <EmptyDataTemplate>
            <table runat="server" style="background-color: #FFFFFF; border-collapse: collapse;
                border-color: #999999; border-style: none; border-width: 1px;">
                <tr>
                    <td>
                        No data was returned.
                    </td>
                </tr>
            </table>
        </EmptyDataTemplate>
        <InsertItemTemplate>
            <tr style="">
                <td>
                    <asp:Button ID="InsertButton" runat="server" CommandName="Insert" Text="Insert" />
                    <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Clear" />
                </td>
                <td>
                    <%--<asp:TextBox ID="idTextBox" runat="server" Text='<%# Bind("id") %>' />--%>
                </td>
                <td>
                    <asp:TextBox ID="nameTextBox" runat="server" Text='<%# Bind("name") %>' />
                </td>
                <%--<td>
                    <asp:TextBox ID="AddressTextBox" runat="server" Text='<%# Bind("Address") %>' />
                </td>--%>
            </tr>
        </InsertItemTemplate>
        <%-- <SelectedItemTemplate>
            <tr style="background-color:#008A8C;font-weight: bold;color: #FFFFFF;">
                <td>
                    <asp:Button ID="DeleteButton" runat="server" CommandName="Delete"
                        Text="Delete" />
                    <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
                </td>
                <td>
                    <asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
                </td>
                <td>
                    <asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' />
                </td>
                <td>
                    <asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
                </td>
            </tr>
        </SelectedItemTemplate>--%>
    </asp:ListView>
    <br />
    <br />
    </form>
</body>
</html>


Posted by at No comments:

autocomplete extender with webservice


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
using System.EnterpriseServices;
using System.Data.EntityModel;
using jayModel;


/*auto complete extender with webservice with edmx*/
public partial class Google : System.Web.UI.Page
{

    protected void Page_Load(object sender, EventArgs e)
    {

    }

    [System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
    public static string[] HelloWorld(string prefixText, int count)
    {
        // Class1 cs = new Class1();
        WebService ws = new WebService();
        return ws.HelloWorld(prefixText, count);
    }
}
//source file

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

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!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>
    <%--<script language="javascript" type="text/javascript">

     function mypopup(url, width, height) {
         mywindow = window.open(url, "mywindow2112", "location=0,status=1,scrollbars=1,resizable=1,menubar=0,toolbar=no,width=" + width + ",height=" + height);
         mywindow.focus();
     }

    </script>
    --%>
</head>
<body>
    <form id="form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <div>
        <table style="width: 104%">
            <tr>
                <td>
                    <asp:Image ID="Image1" runat="server" ImageUrl="~/image/google1.bmp"
                        Width="1330px" />
                </td>
            </tr>
        </table>
    </div>
    <p align="center">
        <asp:TextBox ID="TextBox1" runat="server" Text='<%#Bind("name") %>' Wrap="False"
            Height="16px" Width="357px"></asp:TextBox>
        <cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="TextBox1"
            ServiceMethod="HelloWorld" MinimumPrefixLength="1" UseContextKey="false" CompletionInterval="500"
            EnableCaching="true" CompletionSetCount="12">
        </cc1:AutoCompleteExtender>
    </p>
    <div>
        <table width="100%">
            <tr>
                <td>
                    <asp:Image ID="Image2" runat="server" ImageUrl="~/image/google2.bmp"
                        Width="1330px" />
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>
//web service

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
using System.EnterpriseServices;
using System.Data.EntityModel;
using jayModel;

/// <summary>
/// Summary description for WebService
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class WebService : System.Web.Services.WebService {
    jayEntities j = new jayEntities();
    Table1 t = new Table1();
    public WebService () {

        //Uncomment the following line if using designed components
        //InitializeComponent();
    }

    [WebMethod]
 
    public string[] HelloWorld(string prefix, int count)
    {
        var a = j.Table1.Where(f => f.name.StartsWith(prefix)).Select(f => f.name).ToArray();

        return a;



    }
   
}


Posted by at No comments:

Sunday, 11 March 2012

edmx


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

public partial class Default2 : System.Web.UI.Page
{
/*name of entity class is jay*/
    jayEntities j = new jayEntities();
    Table1 t = new Table1();
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        int i = Convert.ToInt32(TextBox1.Text);

       
        /* If where condition for one field  Require using query */
     
        var a = j.Table1.Where(m => m.id == i).ToList().Select(m => m.name);
       
     
        GridView1.DataSource = a;
        GridView1.DataBind();

        /* if where condition  require */
 /*here name start with h and contain c  */
        var d1 = j.Table1.Where(f => f.name.StartsWith("h")&& f.name.Contains("c")).Select(f=>f.name);
     
        /*Display two field
       
        //var d1 = j.Table1.Select(f => new { f.id,f.name}).OrderBy(f=>f.name).Where(f=>f.id==i);
     //  var d4 = j.Table1.Select(f => new { f.name });*/

        GridView2.DataSource = d1;
        GridView2.DataBind();
        /*All Table Data */
        var d2 = j.Table1.ToList();
        GridView3.DataSource = d2;
        GridView3.DataBind();
        /*If where condition for two field  Require */


        //List<jayModel.Table1> list = new List<jayModel.Table1>();
        var list = j.Table1.Where(m => m.id == i).ToList();
        //var list1 = j.count_tbl.Where(m => m.id == i).ToList();
        var objJoin = list.Join(list, b => b.id, c => c.id, (b, c) => new { name = b.name, address = b.Address });
        //left outer join using edmx
        var q = from t1 in j.Table1
                join t2 in j.count_tbl on t1.id equals t2.id into t1t2
                from t2 in t1t2.DefaultIfEmpty()
                select new { t1.id, t1.name };
        //right outer join using edmx
        var q1 = from t2 in j.count_tbl join t1 in j.Table1 on t2.id equals t1.id into t1t2 from t1 in t1t2.DefaultIfEmpty() select new { t2.month, t2.number, t1.name };

        GridView4.DataSource = q1;
        GridView4.DataBind();
    }
}
Posted by at No comments:

edmx-linq

edmx and linq both are not use in one application
Posted by at No comments:

what is bubble event

bubble event means parent -child event
example==one grid view and its child control is drop down list
so child control not directly call so we find child control in parent control and then work with child control

Posted by at No comments:
Subscribe to: Posts (Atom)