need to know how this repeater is working...Mainly the e.commandName RSS

2 replies

Last post Oct 28, 2016 12:02 PM by paindaasp

‹ Previous Thread|Next Thread ›

Shortcuts

Related Links

acmedeepak

Member

168 Points

497 Posts

need to know how this repeater is working...Mainly the e.commandName

Oct 27, 2016 09:40 AM|acmedeepak|LINK

I have code from an old project which I am changing it to a new version, In one page, we have a Repeater control and I am not able to understand the code, Especially the e.commandname in the c# code. Please help me in understanding it. Where are these command names(Add row,update database...) coming from in the c# code.

Please find my aspx page code:

<%@ Page Title="" Language="C#" EnableEventValidation="false" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="IC_Cost_Inventory_Form.aspx.cs" Inherits="Costing.IC_Cost_Inventory_Form" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <script>

    function doCustomSiteValidate(source, args) 
        {
        args.IsValid = false;

        if (document.getElementById('<% =Site.ClientID %>').value.length > 0) 
        {
            args.IsValid = true;
        }

    }

    function doCustomDateValidate(source, args) 
        {
        args.IsValid = false;

        if (document.getElementById('<% =InvyDate.ClientID %>').value.length > 0) 
        {
            args.IsValid = true;
        }

    }

    function VerifyHeaderVal(evt, ID) {
        //if 
        // alert("Please select the Site & Inventory Date before Upload");
        //return true;
    }

    </script>

         

     <style type="text/css">
        .style1
        {
            width: 317px;
        }
    </style>

    
    <script type="text/javascript" language="javascript">
        //No need...
        function runScript(evt, ID) {
            alert("Only QTY can be changed");
            return true;
        }
    </script>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <p class="T1">Cost Inventory</p>
<br />


        
    <table>

            
        <tr>
        <asp:UpdatePanel ID="UP1" runat="server">
        <ContentTemplate>
                
            <td class="style6" valign="top"><strong>Inventory Number :</strong></td>  
            <td class="style1">
                <asp:TextBox ID="InvyNum" runat="server" ></asp:TextBox>
                <asp:Button ID="getData" runat="server" Text="Go" CssClass="groovybtn" onclick="getData_Click" onclientclick="getData_Click()" Font-Size="XX-Small" Height="25px" Width="40px"/>
            </td>
            <td class="style8"> 
                <ajaxToolkit:ToolkitScriptManager  ID="ScriptManager1" runat="server">
                </ajaxToolkit:ToolkitScriptManager>

                    <ajaxToolkit:AutoCompleteExtender ID="autoComplete1" runat="server"
                    BehaviorID="AutoCompleteEx"
                    MinimumPrefixLength="1"
                    TargetControlID="InvyNum"
                    ServicePath="ServiceGL.asmx"
                    ServiceMethod="GetInvyNumList">
                    </ajaxToolkit:AutoCompleteExtender>
                          
            </td>
            <td class="style8">
                <asp:TextBox ID="OrglInvyNum" runat="server" Text='<%# Eval("Last_InvyNum")%>' Visible="false"></asp:TextBox>
                <asp:TextBox ID="TxtHInvyNum" runat="server" Height="11px" Width="55px" Visible="false"></asp:TextBox>  <br />
            </td>

            <asp:Label ID="lblChosenName" runat="server" />

        </ContentTemplate>
        </asp:UpdatePanel>

        </tr>
                   

        <tr>
            <td class="style2"><strong>Count Site :</strong></td>
            <td>
                <asp:DropDownList ID="Site" runat="server">
                </asp:DropDownList>
                <ajaxToolkit:CascadingDropDown 
                ID="CascadingDropDown1"
                runat="server"
                Category="Site"
                TargetControlID="Site"
                PromptText="[Select Site]"
                ServicePath="ServiceGL.asmx"
                ServiceMethod="GetSite"/>
            </td>
                <td class="style5">
                <asp:CustomValidator ID="CustomSiteValidator" runat="server" ErrorMessage="* Select SiteID" 
                    ControlToValidate="Site" ClientValidationFunction="doCustomSiteValidate" 
                        ValidateEmptyText="true" ForeColor="#FF3300" ></asp:CustomValidator><br />
                </td>
            </tr>
         
                        
        <tr>
                <td class="style6" valign="top"><strong>Inventory Date :</strong></td>  
                <td class="style7" valign="top">
                <asp:TextBox ID="InvyDate" runat="server"></asp:TextBox>  
                <ajaxToolkit:CalendarExtender  ID="CalendarExtender1" TargetControlID="InvyDate"  runat="server" />  
                <asp:CustomValidator ID="CustomDateValidator" runat="server" ErrorMessage="* Select Date" 
                    ControlToValidate="InvyDate" ClientValidationFunction="doCustomDateValidate" ValidateEmptyText="true" 
                        ForeColor="Red" ></asp:CustomValidator><br />
                </td>
                <td class="style8"><asp:Button ID="UploadData" runat="server" Text="Upload" 
                        CssClass="groovybtn" onclick="UploadData_Click" 
                        onclientclick="VerifyHeaderVal()" Height="25px" Width="51px"
                        ToolTip="Click this and then click 'Go'"  
                        Font-Size="XX-Small" /></td>
        </tr>



    </table>
    <asp:TextBox ID="MessageBox" runat="server" Width="478px" 
            BorderColor="White" BorderStyle="None" Wrap="False" EnableViewState="False" 
            BackColor="White" Font-Bold="True" ForeColor="#FF0066"></asp:TextBox>

    </br>
        
    <table>
    <tr>
        <td class="style9">

    <asp:UpdatePanel ID="InvyUpdatePanel" runat="server" UpdateMode="Conditional">
    <ContentTemplate>
          
        <asp:Repeater ID="Repeater1" runat="server" OnItemCommand="Repeater1_ItemCommand">

        <HeaderTemplate>
            <asp:Label ID="ItemCode" Text="ItemCode" runat="server" Width="85" Font-Bold="true" BackColor='#002649' ForeColor='#bfd1e5' ></asp:Label>
            <asp:Label ID="Description" Text="Description" runat="server" Width="255" Font-Bold="true" BackColor='#002649' ForeColor='#bfd1e5'></asp:Label>
            <asp:Label ID="Qty" Text="Qty" runat="server" Width="55" Font-Bold="true" BackColor='#002649' ForeColor='#bfd1e5'></asp:Label>
            &nbsp;<asp:Label ID="Cost" Text="Cost" runat="server" Width="55" Font-Bold="true" BackColor='#002649' ForeColor='#bfd1e5'></asp:Label>
            <asp:Label ID="Value" Text="Value" runat="server" Width="55" Font-Bold="true" BackColor='#002649' ForeColor='#bfd1e5'></asp:Label>
            <br>
        </HeaderTemplate>
   
         <ItemTemplate>
              <asp:DropDownList ID="ddItemId" runat="server" Width="84" DataTextField='<%# Eval("ItemId")%>' Visible='<%# Eval("ItemId") == "" %>'>
                    </asp:DropDownList>
                    <ajaxToolkit:CascadingDropDown 
                    ID="CascadingDropDown2"
                    runat="server" 
                    Category="ItemId"
                    TargetControlID="ddItemId"
                    PromptText="[Item ID]"
                    ServicePath="ServiceGL.asmx"
                    ServiceMethod="GetItemId"/>
             <asp:TextBox ID="ItemId" runat="server" Text='<%# Eval("ItemId")%>' Width="79" BackColor='#75aadb' Visible='<%# Eval("ItemId") != "" %>'></asp:TextBox>

           	<asp:DropDownList ID="ddItemName" runat="server"  Width="257" BackColor='#75aadb' ReadOnly="True"  DataTextField='<%# Eval("ItemName")%>' Visible='<%# Eval("ItemId") == "" %>'></asp:DropDownList>
            <ajaxToolkit:CascadingDropDown 
                    ID="CascadingDropDown3"
                    runat="server" 
                    Category="ItemName"
                    TargetControlID="ddItemName" 
                    ParentControlID="ddItemId"
                    ServicePath="ServiceGL.asmx"
                    ServiceMethod="GetItemName"/>
            <asp:TextBox ID="ItemName" runat="server" Text='<%# Eval("ItemName")%>' Width="250" BackColor='#75aadb' Visible='<%# Eval("ItemId") != "" %>'></asp:TextBox>

            <asp:TextBox ID="Qnty" runat="server" Text='<%# Eval("Qnty")%>' Width="50" BackColor='#75aadb'></asp:TextBox>


            <asp:DropDownList ID="ddCost" runat="server"  Width="54" BackColor='#75aadb' ReadOnly="True"  DataTextField='<%# Eval("ItemName")%>' Visible='<%# Eval("ItemId") == "" %>'></asp:DropDownList>
            <ajaxToolkit:CascadingDropDown 
                    ID="CascadingDropDown4"
                    runat="server" 
                    Category="Cost"
                    TargetControlID="ddCost" 
                    ParentControlID="ddItemId"
                    ServicePath="ServiceGL.asmx"
                    ServiceMethod="GetItemCost"/>
            <asp:TextBox ID="Cost" runat="server" Text='<%# Eval("Cost")%>' Width="50" BackColor='#75aadb' ReadOnly="True" Visible='<%# Eval("ItemId") != "" %>'></asp:TextBox>


            <asp:TextBox ID="Value" runat="server" Text='<%# Eval("CalVal")%>' Width="50" BackColor='#75aadb' ReadOnly="True"></asp:TextBox>

            <asp:LinkButton ID="UpdateRow" runat="server" CommandName ="UpdateRow" Visible='<%# Eval("ItemId") != "" %>'>Update</asp:LinkButton>
            <asp:LinkButton ID="DeleteRow" runat="server" CommandName ="DeleteRow" Visible='<%# Eval("ItemId") != "" %>'>Delete</asp:LinkButton>
            <asp:LinkButton ID="lnkUpdataDatabase" runat="server" CommandName="UpdateDatabase" Visible='<%# Eval("ItemId") == "" %>'>Add</asp:LinkButton>
                

            <br>
        </ItemTemplate>



        </asp:Repeater>



    </ContentTemplate>

    </asp:UpdatePanel>


        </td>

    </tr>
    </table>


</asp:Content>

And my .aspx.cs page is:

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.Text.RegularExpressions;

using System.Web.Services;
using System.Web.Services.Protocols;
using System.Collections.Specialized;
using System.Web.UI.WebControls.WebParts;

using System.IO;


namespace Costing
{
    public partial class IC_Cost_Inventory_Form : System.Web.UI.Page
    {

        string ConString = System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;

        protected void Page_Load(object sender, EventArgs e)
        {
            // Load the New Invy Number from the saved last Invy Numer

           
            if (InvyNum.Text == "")
            {
                string SQL_LstInvyNum = "";

                SQL_LstInvyNum = "select 'INV' + Cast(Last_InvyNum+1 as varchar) Last_InvyNum from IC_ControlNum";

                SqlConnection conn = new SqlConnection(ConString);
                if (conn.State == ConnectionState.Closed)
                {
                    conn.Open();
                }

                SqlDataReader ResCmd;
                SqlCommand SelCmd = new SqlCommand(SQL_LstInvyNum, conn);

                ResCmd = SelCmd.ExecuteReader();
                string tmpInvy;
                if (ResCmd.Read())
                {
                    tmpInvy = Convert.ToString(ResCmd["Last_InvyNum"]);
                    InvyNum.Text = tmpInvy;
                }

                ResCmd.Close();

                //Now Update the table IC_ControlNum with the current Cost Inventory Number

                string newTNumber = InvyNum.Text;
                string SQLUpdtTNum = "";

                newTNumber = newTNumber.Remove(0, 3);
                int numValTNum = Int32.Parse(newTNumber);


                SQLUpdtTNum = "Update IC_ControlNum SET Last_InvyNum = '" + numValTNum + "'";
                SqlCommand cmd = new SqlCommand(SQLUpdtTNum, conn);
                if (conn.State == ConnectionState.Closed)
                {
                    conn.Open();
                }

                int temp = cmd.ExecuteNonQuery();

                conn.Close();
            }
        }

        //=============================== Line Level Repeater =======================================//
        protected System.Data.DataTable dt = null;

        // For Line level entries
        protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            
            
            if (e.CommandName == "AddRow")
            {
                GetData();
                dt.Rows.Add("", "", "", "", "");
                Repeater1.DataSource = dt;
                Repeater1.DataBind();
                return;
            }


            

            if (e.CommandName == "UpdateDatabase")
            {
                try
                {

                    string SQLIns = "";
                    string newInvyNum = TxtHInvyNum.Text;
                    string newInvyDate = InvyDate.Text;
                    string newSite = Site.Text;
                    
                    string newItemId = ((TextBox)e.Item.FindControl("ItemId")).Text;
                    if (newItemId == "")
                    {
                        newItemId = ((DropDownList)e.Item.FindControl("ddItemId")).SelectedValue;
                    }
                    
                    string newItemName = ((TextBox)e.Item.FindControl("ItemName")).Text;
                    if (newItemName == "")
                    {
                        newItemName = ((DropDownList)e.Item.FindControl("ddItemName")).SelectedValue;
                    }

                    string newQty = ((TextBox)e.Item.FindControl("Qnty")).Text;
                    //if (newQty == "")
                    //{
                    //    newQty = ((DropDownList)e.Item.FindControl("Qnty")).SelectedValue;
                    //}
                    
                    Int32 newNumQty = Convert.ToInt32(newQty);
                    
                    string newCost = ((TextBox)e.Item.FindControl("Cost")).Text;
                    if (newCost == "")
                    {
                        newCost = ((DropDownList)e.Item.FindControl("ddCost")).SelectedValue;
                    }
                    
                    Int32 Orgnl_Qty;

                    //--- Check for the same item already exists...
                    string SQL_verify = "";
                    SQL_verify = "select ItemId,Qty from IC_Inventory_T where Invy_Num = '" + newInvyNum + "' and ItemId = '" + newItemId + "'";

                    SqlDataReader ResData;
                    SqlConnection conn = new SqlConnection(ConString);

                    if (conn.State == ConnectionState.Closed)
                    {
                        conn.Open();
                    }

                    SqlCommand SelCmd = new SqlCommand(SQL_verify, conn);
                    ResData = SelCmd.ExecuteReader();

                    if (ResData.Read())
                    {
                        Orgnl_Qty = Convert.ToInt32(ResData["Qty"]);
                        newNumQty = newNumQty + Orgnl_Qty;
                        SQLIns = "Update IC_Inventory_T set Qty = '" + newNumQty + "' where Invy_Num = '" + newInvyNum + "' and ItemID = '" + newItemId + "'";
                    }
                    else
                    {
                        SQLIns = "Insert into IC_Inventory_T (Invy_Num,Invy_Date,SiteID,ItemId,ItemName,Qty,Cost) values ('" + newInvyNum + "','" + newInvyDate + "','" + newSite + "','" + newItemId + "','" + newItemName + "','" + newNumQty + "','" + newCost + "')";
                    }

                    ResData.Close();

                    //-- End of Check for the same item already exists...


                    conn = new SqlConnection(ConString);
                    SqlCommand cmd = new SqlCommand(SQLIns, conn);
                    if (conn.State == ConnectionState.Closed)
                    {
                        conn.Open();
                    }

                    string Str1 = newQty;
                    string Str2 = newCost;
                    double Num1, Num2;
                    bool isNum1 = double.TryParse(Str1, out Num1);
                    bool isNum2 = double.TryParse(Str2, out Num2);
                    if ((isNum1) && (isNum2))
                    {
                    int temp = cmd.ExecuteNonQuery();
                    }
                    else
                    {
                        MessageBox.Text = "Qty should be numeric";
                    }

                    MessageBox.Text = "";
                    conn.Close();
                }

                catch (Exception ex)
                {
                    MessageBox.Text = "Qty should be numeric";
                }

            }

            if (e.CommandName == "UpdateRow")
            {
                string SQLUpdt = "";
                string newInvyNum = TxtHInvyNum.Text;
                string newItemId = ((TextBox)e.Item.FindControl("ItemId")).Text;
                string newItemName = ((TextBox)e.Item.FindControl("ItemName")).Text;
                string newQty = ((TextBox)e.Item.FindControl("Qnty")).Text;
                string newCost = ((TextBox)e.Item.FindControl("Cost")).Text;
                // Update Line item
                SQLUpdt = "Update IC_Inventory_T set Qty = '" + newQty + "' where Invy_Num = '" + newInvyNum + "' and ItemID = '" + newItemId + "'";

                SqlConnection conn = new SqlConnection(ConString);
                SqlCommand cmd = new SqlCommand(SQLUpdt, conn);
                if (conn.State == ConnectionState.Closed)
                {
                    conn.Open();
                }

                try
                {
                    int temp = cmd.ExecuteNonQuery();
                    MessageBox.Text = "";
                }

                catch (Exception ex)
                {
                    MessageBox.Text = "Qty should be numeric";
                }

                conn.Close();
            }




            if (e.CommandName == "DeleteRow")
            {
                string SQLDel = "";
                string newInvyNum = TxtHInvyNum.Text;
                string newItemId = ((TextBox)e.Item.FindControl("ItemId")).Text;
                // Delete row
                SQLDel = "Delete IC_Inventory_T where Invy_Num = '" + newInvyNum + "' and ItemID = '" + newItemId + "'";

                SqlConnection conn = new SqlConnection(ConString);
                SqlCommand cmd = new SqlCommand(SQLDel, conn);
                if (conn.State == ConnectionState.Closed)
                {
                    conn.Open();
                }
                int temp = cmd.ExecuteNonQuery();
                conn.Close();
            }

            GetData();
            dt.Rows.Add("", "", "", "", "");
            Repeater1.DataSource = dt;
            Repeater1.DataBind();

        }
        //============================================================================================//



        protected void Page_PreRender(object sender, EventArgs e)
        {

            if (!IsPostBack)
            {
                GetData();
                Repeater1.DataSource = dt;
                Repeater1.DataBind();
            }

        }


        void GetData()
        {
            string temp;
            if ((TxtHInvyNum.Text == null) || (TxtHInvyNum.Text == ""))
            {
                temp = " ";
            }
            else
            {
                temp = TxtHInvyNum.Text;
            }
            //((TextBox)e.Item.FindControl("ItemId")).ReadOnly = true;
            
            // TxtInvyNum.Text = temp;
            string ConString = System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
            SqlConnection conn = new SqlConnection(ConString);
            conn.Open();

            System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter("select ItemID, ItemName, Cast(Qty as varchar(5)) Qnty, Cost, Cast((Qty*(Cast(Cost as float))) as varchar(10))CalVal from IC_Inventory_T where Invy_Num = '" + temp + "'", conn);

            dt = new System.Data.DataTable();
           
            try
            {
                da.Fill(dt);
            }
            catch (Exception ex)
            {
                MessageBox.Text = "Qty should be numeric";
            }

            conn.Close();
            conn.Dispose();
        }



        protected void getData_Click(object sender, EventArgs e)
        {

            //Get other related info from IC_Invy_T table and assign to the fields...code for 'Go' button
            string SQLGetTrn = "";
            string CurrTNumber = InvyNum.Text;
            TxtHInvyNum.Text = CurrTNumber;
            SQLGetTrn = "select Invy_Date,SiteID,ItemID,ItemName, Qty,Cost,Row_Num from IC_Inventory_T where Invy_Num = '" + CurrTNumber + "'";
            SqlConnection conn = new SqlConnection(ConString);
            SqlCommand cmd = new SqlCommand(SQLGetTrn, conn);
            if (conn.State == ConnectionState.Closed)
            {
                conn.Open();
            }
            SqlDataReader ResCmd;
            SqlCommand SelCmd = new SqlCommand(SQLGetTrn, conn);


            if (CurrTNumber != "")
            {
                ResCmd = SelCmd.ExecuteReader();

                if (ResCmd.Read())
                {
                    string tmpDate = Convert.ToString(ResCmd["Invy_Date"]);

                    int foundS1 = tmpDate.IndexOf(" ");     //position of first blank
                    tmpDate = tmpDate.Substring(0, foundS1);
                    InvyDate.Text = tmpDate;
                    CascadingDropDown1.SelectedValue = Convert.ToString(ResCmd["SiteID"]);
                    // Make these fields protected...
                    InvyDate.Enabled = false;

                }
            }

            conn.Close();
            conn.Dispose();
            GetData();
            dt.Rows.Add("", "", "", "", "");
            Repeater1.DataSource = dt;
            Repeater1.DataBind();
        }


        protected void UploadData_Click(object sender, EventArgs e)
        {

            System.Data.DataTable dt = new System.Data.DataTable();
            string line = null;
            int i = 0;

            //using (StreamReader sr = File.OpenText(@Server.MapPath( "data\Inventory.csv")))
            //using (StreamReader sr = File.OpenText(@"D:\CONVERSIONS\Costing_VS2010\Costing\Costing\Data\Inventory.csv"))
            using (StreamReader sr = File.OpenText(@"D:\CONVERSIONS\Costing_VS2010\Costing\Data\Inventory.csv"))
            {
                while ((line = sr.ReadLine()) != null)
                {
                    string[] data = line.Split(',');
                    if (data.Length > 0)
                    {
                        if (i == 0)
                        {
                           foreach (object item in data)
                           {
                             dt.Columns.Add(new System.Data.DataColumn());
                           }
                            i++;
                        }
                        System.Data.DataRow row = dt.NewRow();
                        row.ItemArray = data;
                        dt.Rows.Add(row);
                    }
                }


                SqlConnection conn = new SqlConnection(this.ConString);
                conn.Open();

                //--- First delete the records from the temp table: IC_Inventory_Temp
                string SQLtmpDel = "";
                SQLtmpDel = "Delete from IC_Inventory_Temp";

                SqlCommand delcmd = new SqlCommand(SQLtmpDel, conn);
                if (conn.State == ConnectionState.Closed)
                {
                    conn.Open();
                }
                int temp = delcmd.ExecuteNonQuery();


                //-- Copy the csv data into the temp table: IC_Inventory_Temp
                SqlBulkCopy s = new SqlBulkCopy(conn);
                s.DestinationTableName = "IC_Inventory_Temp";
                s.WriteToServer(dt);
                s.Close();

                //--- Delete the first record from the temp table: IC_Inventory_Temp

                SQLtmpDel = "Delete from IC_Inventory_Temp where Qty = 'Qty'";
                SqlCommand delrec = new SqlCommand(SQLtmpDel, conn);
                if (conn.State == ConnectionState.Closed)
                {
                    conn.Open();
                }
                temp = delrec.ExecuteNonQuery();


                //-- Insert the values into the Arrays
                string newInvyNum = InvyNum.Text;
                string newInvyDate = InvyDate.Text;
                string newSite = Site.Text;
                string[] ItemID = new string[1000];
                string[] ItemName = new string[1000]; 
                Int32[] Qty = new Int32[1000];
                Decimal[] Cost = new Decimal[1000]; 


                string SQL_PickfromTmp = "";
                string InsInvyItem = "";
                SQL_PickfromTmp = "select IC_Inventory_Temp.ItemId,Qty,ItemName,Cost from IC_Inventory_Temp,IC_Item_M where IC_Inventory_Temp.ItemID = IC_Item_M.ItemID order by IC_Inventory_Temp.ItemID";

                SqlDataReader ResData;

                if (conn.State == ConnectionState.Closed)
                {
                    conn.Open();
                }

                SqlCommand SelCmd = new SqlCommand(SQL_PickfromTmp, conn);
                ResData = SelCmd.ExecuteReader();

                Int32 count = 0;

                while (ResData.Read())
                {
                    ItemID[count] = Convert.ToString(ResData["ItemId"]);
                    ItemName[count] = Convert.ToString(ResData["ItemName"]);
                    Qty[count] = Convert.ToInt32(ResData["Qty"]);
                    Cost[count] = Convert.ToDecimal(ResData["Cost"]);

                    count = count + 1;
                }

                ResData.Close();


                // Insert into IC_Inventory_T from the Arrays
                for (int j = 0; j < count; j++)
                {
                    InsInvyItem = "Insert into IC_Inventory_T (Invy_Num,Invy_Date,SiteID,ItemId,ItemName,Qty,Cost) values ('" + newInvyNum + "','" + newInvyDate + "','" + newSite + "','" + ItemID[j] + "','" + ItemName[j] + "','" + Qty[j] + "','" + Cost[j] + "')";
                    SqlCommand cmd = new SqlCommand(InsInvyItem, conn);
                    int temp1 = cmd.ExecuteNonQuery();
                }
                conn.Close();

            }

        }




    }
}

Please explain me what these command names are and how can I understand this repeater controls operations...

Thanks,

Deepak

- Reply
mazhar khan...
Member

235 Points

574 Posts

Re: need to know how this repeater is working...Mainly the e.commandName

Oct 27, 2016 11:13 AM|mazhar khan india|LINK

Dear acmedeepak,

Firstly understand visually what output is coming and what you need to implement into new version and Dont use the above code because its 1 tier architecture,

try to implement into 3 tier architecture, then above code will be easy to develop. Thank you
- Reply
paindaasp
Star

11749 Points

2997 Posts
Re: need to know how this repeater is working...Mainly the e.commandName

Oct 28, 2016 12:02 PM|paindaasp|LINK
The e.commandName's equate to the CommandName = "..." in the LinkButtons in your Repeater. I didn't see any button that would use the "AddRow" code, though.
```
<asp:LinkButton ID="UpdateRow" runat="server" CommandName ="UpdateRow" Visible='<%# Eval("ItemId") != "" %>'>Update</asp:LinkButton>
<asp:LinkButton ID="DeleteRow" runat="server" CommandName ="DeleteRow" Visible='<%# Eval("ItemId") != "" %>'>Delete</asp:LinkButton>
<asp:LinkButton ID="lnkUpdataDatabase" runat="server" CommandName="UpdateDatabase" Visible='<%# Eval("ItemId") == "" %>'>Add</asp:LinkButton>
```
To better understand your code, run it in Debug mode and step though your code line by line. Set a BreakPoint on the if (e.CommandName == "AddRow") line in the Repeater1_ItemComman routine and go from there.