Conditional Cursur by anil kumar alwar rajasthan

create  proc [dbo].[RAIL_ALL_DATA_WITH_SUPPORT_EMP_ASSIGNER]
 @ASSIGNER2 as nvarchar(50)

as
begin
declare @same as nvarchar(100)
set @same=''
DECLARE @ACTION_ID as nvarchar(100)
DECLARE @OWNERE as nvarchar(100)
DECLARE @SUPPORT_EMPLOYEE as nvarchar(50)
DECLARE @ACTION_DATE as nvarchar(50)
DECLARE @ACTION_TITLE as nvarchar(150)
DECLARE @ACTION_DESC as nvarchar(max)
DECLARE @ASSIGNER as nvarchar(50)
DECLARE @PROJECT as nvarchar(50)
DECLARE @EXPECT_COM_DATE as nvarchar(50)
DECLARE @SOURCE_DESC as nvarchar(50)
DECLARE @FLAG_DESC as nvarchar(50)
DECLARE @ACC_REJ_DATE as nvarchar(50)
DECLARE @REJECT_REMARKS as nvarchar(50)
DECLARE @TARGET_DATE as nvarchar(50)
DECLARE @REMINDER_DESC as nvarchar(50)
DECLARE @FORWARD_TO as nvarchar(50)
DECLARE @FORWARD_DATE as nvarchar(50)
DECLARE @ACCEPT as nvarchar(50)
DECLARE CURSOR1 cursor for



select ACTION_ID,ACTION_DATE,OWNERE,SUPPORT_EMPLOYEE,ACTION_TITLE,ACTION_DESC,ASSIGNER,PROJECT,EXPECT_COM_DATE,SOURCE_DESC,FLAG_DESC,ACC_REJ_DATE,REJECT_REMARKS,TARGET_DATE,REMINDER_DESC,FORWARD_TO,FORWARD_DATE,ACCEPT from RAIL_ALL_DATA2 WHERE ASSIGNER=@ASSIGNER2

OPEN CURSOR1
FETCH NEXT FROM CURSOR1 INTO @ACTION_ID,@ACTION_DATE,@OWNERE,@SUPPORT_EMPLOYEE,@ACTION_TITLE,@ACTION_DESC,@ASSIGNER,@PROJECT,@EXPECT_COM_DATE,@SOURCE_DESC,@FLAG_DESC,@ACC_REJ_DATE,@REJECT_REMARKS,@TARGET_DATE,@REMINDER_DESC,@FORWARD_TO,@FORWARD_DATE,@ACCEPT
WHILE @@FETCH_STATUS <> -1
BEGIN
if(@ACTION_ID!=@same)
begin
insert into temp_dtt(ACTION_ID,ACTION_DATE,OWNERE,SUPPORT_EMPLOYEE,ACTION_TITLE,ACTION_DESC,ASSIGNER,PROJECT,EXPECT_COM_DATE,SOURCE_DESC,FLAG_DESC,ACC_REJ_DATE,REJECT_REMARKS,TARGET_DATE,REMINDER_DESC,FORWARD_TO,FORWARD_DATE,ACCEPT)values(@ACTION_ID,@ACTION_DATE,@OWNERE,@SUPPORT_EMPLOYEE,@ACTION_TITLE,@ACTION_DESC,@ASSIGNER,@PROJECT,@EXPECT_COM_DATE,@SOURCE_DESC,@FLAG_DESC,@ACC_REJ_DATE,@REJECT_REMARKS,@TARGET_DATE,@REMINDER_DESC,@FORWARD_TO,@FORWARD_DATE,@ACCEPT)
set @same=@ACTION_ID
end
else
begin
insert into temp_dtt(ACTION_ID,ACTION_DATE,OWNERE,SUPPORT_EMPLOYEE,ACTION_TITLE,ACTION_DESC,ASSIGNER,PROJECT,EXPECT_COM_DATE,SOURCE_DESC,FLAG_DESC,ACC_REJ_DATE,REJECT_REMARKS,TARGET_DATE,REMINDER_DESC,FORWARD_TO,FORWARD_DATE,ACCEPT)values('','','',@SUPPORT_EMPLOYEE,'','','','','','','','','','','','','','')
end

FETCH NEXT FROM CURSOR1 INTO @ACTION_ID,@ACTION_DATE,@OWNERE,@SUPPORT_EMPLOYEE,@ACTION_TITLE,@ACTION_DESC,@ASSIGNER,@PROJECT,@EXPECT_COM_DATE,@SOURCE_DESC,@FLAG_DESC,@ACC_REJ_DATE,@REJECT_REMARKS,@TARGET_DATE,@REMINDER_DESC,@FORWARD_TO,@FORWARD_DATE,@ACCEPT
END
CLOSE CURSOR1
DEALLOCATE CURSOR1
select * from temp_dtt
truncate table temp_dtt

end

nesting of gridview by kumaranilaggarwal

.aspx
<fieldset>
                    <legend style="color: #669900; font-size: medium; font-weight: bold">Factor</legend>
                    <div style="height: 600px; overflow: scroll;">
                        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
                            Width="100%" ForeColor="#333333" GridLines="None">
                            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" CssClass="ll" />
                            <FooterStyle BackColor="#5D7B9D" ForeColor="White" Font-Bold="True" />
                            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                            <Columns>
                                <asp:TemplateField HeaderText="Factor" HeaderStyle-CssClass="ll">
                                    <ItemTemplate>
                                        <asp:HiddenField ID="Label2" runat="server" Value='<%# Eval("fact_id") %>'></asp:HiddenField>
                                        <asp:Label ID="lblfactor" runat="server" Text='<%# Eval("fact_desc") %>' Width="200"></asp:Label>
                                        <asp:TextBox ID="txtFactor" runat="server" Width="70"></asp:TextBox>
                                    </ItemTemplate>
                                    <HeaderStyle CssClass="ll"></HeaderStyle>
                                </asp:TemplateField>
                                <asp:TemplateField>
                                    <ItemTemplate>
                                        <asp:GridView ID="GridView2" runat="server" CssClass="ll" AutoGenerateColumns="false"
                                            Width="100%" ShowHeader="true">
                                            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                                            <Columns>
                                                <asp:TemplateField HeaderText="SubFactor" HeaderStyle-CssClass="ll">
                                                    <ItemTemplate>
                                                        <asp:HiddenField ID="Label21" runat="server" Value='<%# Eval("fact_dtl_id") %>' />
                                                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("fact_dtl_desc") %>' Width="200"></asp:Label>
                                                        <asp:TextBox ID="txtSubFactor" runat="server" Width="70"></asp:TextBox>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField>
                                                    <ItemTemplate>
                                                        <asp:GridView ID="GridView3" CssClass="ll" runat="server" AutoGenerateColumns="false"
                                                            Width="100%" ShowHeader="true">
                                                            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                                                            <Columns>
                                                                <asp:TemplateField HeaderText="SubFactorDetail" HeaderStyle-CssClass="ll">
                                                                    <ItemTemplate>
                                                                        <asp:HiddenField ID="Label2id" runat="server" Value='<%# Eval("fact_subdtl_id") %>' />
                                                                        <asp:Label ID="Label111" runat="server" Text='<%# Eval("fact_subdtl_desc") %>' Width="200"></asp:Label>
                                                                        <asp:TextBox ID="txtCalculation" runat="server" Width="70"></asp:TextBox>
                                                                    </ItemTemplate>
                                                                </asp:TemplateField>
                                                            </Columns>
                                                        </asp:GridView>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                            </Columns>
                                        </asp:GridView>
                                    </ItemTemplate>
                                </asp:TemplateField>
                            </Columns>
                            <EditRowStyle BackColor="#999999" />
                            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                        </asp:GridView>
                    </div>
                </fieldset>


.cs
 public void fill()
    {
        string s = "select * from fact_mst";
        ds = c1.selectds(s);
        GridView1.DataSource = ds;
        GridView1.DataBind();
        SecondGridBind();
    }

    protected void SecondGridBind()
    {
        foreach (GridViewRow row in GridView1.Rows)
        {
            HiddenField lblid = row.FindControl("Label2") as HiddenField;
            GridView GridView2 = row.FindControl("GridView2") as GridView;
            string str = "select * from  fact_dtl_mst where fact_id='" + lblid.Value + "'";
            ds = c1.selectds(str);
            GridView2.DataSource = ds;
            GridView2.DataBind();
            foreach (GridViewRow rows in GridView2.Rows)
            {
                HiddenField lblid3 = rows.FindControl("Label21") as HiddenField;
                GridView GridView3 = rows.FindControl("GridView3") as GridView;
                string str3 = "select * from  fact_subdtl_mst where fact_dtl_id='" + lblid3.Value + "'";
                ds = c1.selectds(str3);
                GridView3.DataSource = ds;
                GridView3.DataBind();

            }
        }
    }