0

need an insert query for my code , i wrote code to add table rows having textboxes, dynamically, e.g yoh have only passed HSSC exam then you have to fill 2 levels of education SSC, HSSC......or say you have passed Phd , then SSC,HSSC,BS, MS, Phd, you have to fill all, for which i worte code , given below but how an insert statement would look like for it ,i have no idea anymore
Using asp.net 3.5(c#),sql server 2008

.cs code:

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;


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

    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        int cnt = Convert.ToInt32(DropDownList1.SelectedValue);
        GenerateTable(5, cnt);
    }
    //Here’s the code block for the generating the Tables with TextBoxes.

    private void GenerateTable(int colsCount, int rowsCount)
    {
        //Creat the Table and Add it to the Page
        Table table = new Table();
        table.ID = "Table1";
        Page.Form.Controls.Add(table);

        // Now iterate through the table and add your controls 
        for (int i = 0; i < rowsCount; i++)
        {
            TableRow row = new TableRow();
            for (int j = 0; j < colsCount; j++)
            {
                TableCell cell = new TableCell();
                TableCell lblcell = new TableCell();
                TextBox tb = new TextBox();
                Label lbl = new Label();

                // Set a unique ID for each TextBox added
                tb.ID = "TextBoxRow_" + i + "Col_" + j;
                lbl.ID = "Label_" + i + "Col_" + j;
                lbl.Text = DropDownList1.Items[i].ToString();
                // Add the control to the TableCell
                lblcell.Controls.Add(lbl);
                cell.Controls.Add(tb);

                // Add the TableCell to the TableRow
                row.Cells.Add(lblcell);
                row.Cells.Add(cell);
            }

            // Add the TableRow to the Table
            table.Rows.Add(row);
        }
        Panel1.Controls.Add(table);
    }
}

.aspx code:

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

<!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>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
        <div id="pnlTextBox">
            <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
                onselectedindexchanged="DropDownList1_SelectedIndexChanged" Width="150px">
                <asp:ListItem Value="1">SSLC</asp:ListItem>
                <asp:ListItem Value="2">HSC</asp:ListItem>
                <asp:ListItem Value="3">Graduate</asp:ListItem>
                <asp:ListItem Value="4">Post Graduate</asp:ListItem>
                <asp:ListItem Value="5">Ph.D</asp:ListItem>
            </asp:DropDownList>
            <asp:Panel ID="Panel1" runat="server">
            </asp:Panel>
        </div>

       </ContentTemplate>
      </asp:UpdatePanel>

    </form>
</body>
</html>
2
Contributors
1
Reply
4
Views
4 Years
Discussion Span
Last Post by LastMitch
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.