Friday, 24 January 2014

Table Value Parameter

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

<!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>
    <panel>
    <asp:Repeater ID="rpt" runat="server" ViewStateMode="Enabled">
    <HeaderTemplate>
    <table>
    <tr>
    <td width="150px" align="center">Name</td>
    <td width="150px" align="center">Sex</td>
    <td width="150px" align="center">Age</td>
    </tr></table>
    </HeaderTemplate>
    <ItemTemplate>
    <table>
    <tr>
    <td width="150px" align="center"><asp:Label ID="lblName" runat="server" Text='<%#Bind("Name") %>'/></td>
    <td width="150px" align="center"><asp:Label ID="lblSex" runat="server" Text='<%#Bind("Sex") %>'/></td>
    <td width="150px" align="center"><asp:Label ID="Age" runat="server" Text='<%#Bind("Age") %>'/></td>
    </tr>
    </table>
    </ItemTemplate>
    </asp:Repeater>
    <br />
    <br />
    <asp:GridView ID="gv_Details" runat="server" AutoGenerateColumns="false"
            Width="444px">
    <Columns>
    <asp:TemplateField HeaderText="Name">
    <ItemTemplate>
    <asp:Label ID="Name" runat="server" Text='<%#Bind("Name") %>'/>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Sex">
    <ItemTemplate>
    <asp:Label ID="Sex" runat="server" Text='<%#Bind("Sex") %>'/>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Age">
    <ItemTemplate>
    <asp:Label ID="Age" runat="server" Text='<%#Bind("Age") %>'/>
    </ItemTemplate>
        </asp:TemplateField>
    </Columns>
    </asp:GridView>
        <br />
        <br />
    <table width="450px">
   
    <tr>
    <td width="150px" align="center">Name</td>
    <td width="150px" runat="server">
    <asp:TextBox ID="txtName" runat="server"></asp:TextBox>
    </td>
     </tr>
     <tr>
    <td width="150px" align="center">Sex</td>
    <td width="150px" runat="server">
    <asp:TextBox ID="txtSex" runat="server"></asp:TextBox>
    </td></tr>
    <tr>
    <td width="150px" align="center">Age</td>
    <td  width="150px" runat="server">
    <asp:TextBox ID="txtAge" runat="server"></asp:TextBox>
    </td>
   </tr>
   <tr>
   <td ><asp:Button ID="btnAdd" runat="server" Text="AddNew" onclick="btnAdd_Click"
           style="height: 26px" /></td>
   <td>
   <asp:Button Id="btnBind" Text="Bind" runat="server" onclick="btnBind_Click" />
   </td>
   </tr>
   <tr>
   <td colspan="2" align="center">
   <asp:Button ID="btnInsert" Text="Insert" runat="server" onclick="btnInsert_Click" />
   </td>
   </tr>
    </table>
        </panel>
    </div>
    </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;
using System.Configuration;

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

    }
    DataTable dt = new DataTable();
    protected void btnBind_Click(object sender, EventArgs e)
    {

    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        if (ViewState["Emp"] == null)
        {
            dt.Columns.Add("Name");
            dt.Columns.Add("Sex");
            dt.Columns.Add("Age");
        }
        else
            dt=(DataTable)ViewState["Emp"];
            DataRow dr=dt.NewRow();
            dr["Name"]=txtName.Text;
            dr["Sex"]=txtSex.Text;
            dr["Age"]=txtAge.Text;
            dt.Rows.Add(dr);
            ViewState["Emp"] = dt;
            dt =(DataTable)ViewState["Emp"];
       

    }
    protected void btnInsert_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Y"].ToString());
        con.Open();
        dt = (DataTable)ViewState["Emp"];
        SqlCommand cmd = new SqlCommand("SP_EMP",con);
       cmd.CommandType=CommandType.StoredProcedure;
       SqlParameter para = new SqlParameter();
       para.ParameterName = "@EmployeeDetail";
       para.Value = dt;
       para.SqlDbType = SqlDbType.Structured;
       cmd.Parameters.Add(para);
       cmd.ExecuteNonQuery();
       
    }
}
Posted by at

1 comment:

  1. Kolkatech24 January 2014 at 08:35

    Table Value Parameter can pass table vales as row value into another table

    ReplyDelete

Subscribe to: Post Comments (Atom)