Wednesday, July 16, 2014

Binding Dropdowns Using Single Method.. and At A time inserting Dataset to Database... Xml tag Creation... temp table creation


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

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       
    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        XmlDocument XmlDocObj = new XmlDocument();
        XmlDocObj.Load(Server.MapPath("BookStore.xml"));
        XmlNode RootNode = XmlDocObj.SelectSingleNode("bookstore");
        XmlNode bookNode = RootNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "book", ""));
        bookNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "Title", "")).InnerText = tbTitle.Text;
        bookNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "Author", "")).InnerText = tbAuthor.Text;
        bookNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "Year", "")).InnerText = tbYear.Text;
        bookNode.AppendChild(XmlDocObj.CreateNode(XmlNodeType.Element, "Price", "")).InnerText = tbPrice.Text;

        XmlDocObj.Save(Server.MapPath("BookStore.xml"));

        gridDataBind();
        //bind();

    }

    //private void bind()
    //{


    //}

    public void sessionusername(DataSet ds)
    {
        Session["username"] = ds;

        DataSet ds1 = (DataSet)Session["username"];
    }



    public void gridDataBind()
    {
        DataSet ds = new DataSet();
        ds.ReadXml(Server.MapPath("BookStore.xml"));
        gvBookStoreRecords.DataSource = ds;
        gvBookStoreRecords.DataBind();
        SqlConnection con = new SqlConnection("Data Source=KCLINK-45-PC\\SQLEXPRESS;Initial Catalog=naresh;Integrated Security=True");
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        con.Open();
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = "Sp_title1";
      
        //SqlDataAdapter dap = new SqlDataAdapter(cmd);
        //DataSet ds = new DataSet();
        //dap.Fill(ds);
        cmd.Parameters.AddWithValue("@datacontainer", ds.Tables[0]);
        cmd.ExecuteNonQuery();
        filldropdown(drp, ds,"Title","Price");
        filldropdown(DropDownList1, ds,"Author","Price");
        filldropdown(DropDownList2, ds,"Year","Price");


    }

    public void filldropdown(DropDownList drp, DataSet ds,string text,string value)
    {
        drp.DataSource = ds;
        drp.DataTextField = text;
        drp.DataValueField = value;
        drp.DataBind();
    }



}
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.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>
        <br />
        <table style="width: 100%;">
            <tr>
                <td class="auto-style1">
                    Title:
                </td>
                <td>
                    <asp:TextBox ID="tbTitle" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td class="auto-style1">
                    Author:
                </td>
                <td>
                    <asp:TextBox ID="tbAuthor" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td class="auto-style1">
                    Year:
                </td>
                <td>
                    <asp:TextBox ID="tbYear" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td class="auto-style1">
                    Price:
                </td>
                <td>
                    <asp:TextBox ID="tbPrice" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td class="auto-style1">
                </td>
                <td>
                    <asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="btnSubmit_Click" />
                </td>
            </tr>

            <tr>
             <td>
               <asp:DropDownList ID="drp" runat="server"></asp:DropDownList>
                <asp:DropDownList ID="DropDownList1" runat="server"></asp:DropDownList>
                 <asp:DropDownList ID="DropDownList2" runat="server"></asp:DropDownList>

 <asp:DropDownList ID="DropDownList4" runat="server"></asp:DropDownList>
                  <asp:DropDownList ID="DropDownList3" runat="server"></asp:DropDownList>
             </td>
            </tr>
        </table>
        <asp:GridView ID="gvBookStoreRecords" runat="server" CellPadding="4" ForeColor="#333333"
            GridLines="None">
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
            <EditRowStyle BackColor="#999999" />
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#E9E7E2" />
            <SortedAscendingHeaderStyle BackColor="#506C8C" />
            <SortedDescendingCellStyle BackColor="#FFFDF8" />
            <SortedDescendingHeaderStyle BackColor="#6F8DAE" />


          
        </asp:GridView>
    </div>
    </form>
</body>
</html>

<?xml version="1.0" encoding="utf-8"?>
<bookstore>
  <book>
    <Title>adsd</Title>
    <Author>dsfffg</Author>
    <Year>2323</Year>
    <Price>2323</Price>
  </book>
  <book>
    <Title>jhgj</Title>
    <Author>ersfser</Author>
    <Year>56547</Year>
    <Price>5466768</Price>
  </book>
  <book>
    <Title>jhgj</Title>
    <Author>ersfser</Author>
    <Year>56547</Year>
    <Price>2323</Price>
  </book>
  <book>
    <Title>nbhb</Title>
    <Author>gh</Author>
    <Year>6767</Year>
    <Price>766</Price>
  </book>
  <book>
    <Title>.net</Title>
    <Author>naresh</Author>
    <Year>2014</Year>
    <Price>1000</Price>
  </book>
  <book>
    <Title>.net</Title>
    <Author>naresh</Author>
    <Year>2014</Year>
    <Price>1000</Price>
  </book>
  <book>
    <Title>jkd</Title>
    <Author>fgs</Author>
    <Year>dfgfd</Year>
    <Price>dfgdfg</Price>
  </book>
  <book>
    <Title>naresh</Title>
    <Author>sdfa</Author>
    <Year>asdfasd</Year>
    <Price>sadfasdf</Price>
  </book>
  <book>
    <Title>cghbn</Title>
    <Author>vbnc</Author>
    <Year>vbncv</Year>
    <Price>vbncv</Price>
  </book>
  <book>
    <Title>gfhd</Title>
    <Author>fghd</Author>
    <Year>fdghs</Year>
    <Price>dfsg</Price>
  </book>
  <book>
    <Title>gbdcnc</Title>
    <Author>fbnf</Author>
    <Year>vbndf</Year>
    <Price>vbnv</Price>
  </book>
  <book>
    <Title>bncvb</Title>
    <Author>bvnc</Author>
    <Year>vbncbn</Year>
    <Price>vcbnc</Price>
  </book>
  <book>
    <Title>nnn</Title>
    <Author>nnn</Author>
    <Year>nnn</Year>
    <Price>nnnn</Price>
  </book>
  <book>
    <Title>hh</Title>
    <Author>hh</Author>
    <Year>hh</Year>
    <Price>hh</Price>
  </book>
  <book>
    <Title>fgbfg</Title>
    <Author>cvbcv</Author>
    <Year>cvbc</Year>
    <Price>cvbc</Price>
  </book>
  <book>
    <Title>.net</Title>
    <Author>naresh</Author>
    <Year>2014</Year>
    <Price>1000</Price>
  </book>
  <book>
    <Title>esdfs</Title>
    <Author>sdfsd</Author>
    <Year>sdfsd</Year>
    <Price>sdfsdf</Price>
  </book>
  <book>
    <Title>dfgdsfg</Title>
    <Author>sdfgdsfg</Author>
    <Year>sdfgdsfg</Year>
    <Price>345435</Price>
  </book>
  <book>
    <Title>asdasd</Title>
    <Author>asdasd</Author>
    <Year>asdasd</Year>
    <Price>23423423</Price>
  </book>
  <book>
    <Title>dfghdfgh</Title>
    <Author>hjkhjk</Author>
    <Year>gvbnvc</Year>
    <Price>456456</Price>
  </book>
  <book>
    <Title>r</Title>
    <Author>sdfasdfg</Author>
    <Year>sdfgdsfg</Year>
    <Price>34545</Price>
  </book>
  <book>
    <Title>dfgdfsg</Title>
    <Author>sdfgsdfg</Author>
    <Year>dsfgdsfg</Year>
    <Price>345435</Price>
  </book>
  <book>
    <Title>asdfasdf</Title>
    <Author>asdfsadf</Author>
    <Year>asdfsadf</Year>
    <Price>23232</Price>
  </book>
</bookstore>
-----------------------------------------------------------------------------------
create table title(Title varchar(50),Author varchar(50),Year varchar(50),Price varchar(50))



create type title1 as table(Title varchar(50),Author varchar(50),Year varchar(50),Price varchar(50))

create procedure Sp_title
@datacontainer as title1 readonly
as
begin
insert into title select * from @datacontainer
end
go

select * from title