Wrox Programmer Forums
|
ASP.NET 1.x and 2.0 Application Design Application design with ASP.NET 1.0, 1.1, and 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.x and 2.0 Application Design section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 27th, 2004, 03:20 PM
Registered User
 
Join Date: May 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Data Grid

I am developing an application in ASP.NET with C# as the scripting language.I use a Datagrid.What i am planning is once the ADD link in the datagrid is clicked the datagrid should add a new row which contains text boxes.Once the the SAVE button is clicked it should save the values stored in textboxes to the table database.My problem is my datagrid is not showing on the screen.datarid shows on the screen only if it is bound with some data in the table in database.If the table in datatbase is empty datagrid wont show up.Also i need to display one row of the datagrid by default.And when i click the button it should insert a new row.I am attaching the code below

<%@ Page language="c#" Codebehind="NewUser.aspx.cs" AutoEventWireup="false" Inherits="TelecomGen.NewUser" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
    <HEAD>
        <title>NewUser</title>
        <meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
        <meta name="CODE_LANGUAGE" Content="C#">
        <meta name="vs_defaultClientScript" content="JavaScript">
        <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
    </HEAD>
    <body>
        <form id="Form1" method="post" runat="server">
            <P>
            </P>
            <DIV style="DISPLAY: inline; FONT-WEIGHT: bold; Z-INDEX: 101; LEFT: 112px; TEXT-TRANSFORM: capitalize; WIDTH: 159px; POSITION: absolute; TOP: 64px; HEIGHT: 40px; TEXT-DECORATION: underline"
                align="center" ms_positioning="FlowLayout">Sign
                    Up</DIV>
            <P></P>
            <P>&nbsp;</P>
            <P>&nbsp;</P>
            <P>&nbsp;</P>
            <P>&nbsp;</P>
            <P>&nbsp;</P>
            <P>&nbsp;</P>
            <P>&nbsp;</P>
            <P>&nbsp;</P>
            <P>&nbsp;</P>
            <P>&nbsp;</P>
            <P>&nbsp;</P>
            <TABLE id="Table1" style="Z-INDEX: 102; LEFT: 112px; WIDTH: 448px; POSITION: absolute; TOP: 128px; HEIGHT: 375px"
                cellSpacing="4" cellPadding="5" width="448" border="0">
                <TR>
                    <TD style="WIDTH: 134px; HEIGHT: 31px"><STRONG>First Name</STRONG></TD>
                    <TD style="HEIGHT: 31px"><INPUT id="txtFirstName" type="text"><STRONG></STRONG></TD>
                </TR>
                <TR>
                    <TD style="WIDTH: 134px; HEIGHT: 34px"><STRONG>Middle Name</STRONG></TD>
                    <TD style="HEIGHT: 34px"><INPUT id="txtMidName" type="text"><STRONG></STRONG></TD>
                </TR>
                <TR>
                    <TD style="WIDTH: 134px; HEIGHT: 31px"><STRONG>Last Name</STRONG></TD>
                    <TD style="HEIGHT: 31px"><INPUT id="txtLastName" type="text"><STRONG></STRONG></TD>
                </TR>
                <TR>
                    <TD style="WIDTH: 134px; HEIGHT: 33px"><STRONG>EMail Id</STRONG></TD>
                    <TD style="HEIGHT: 33px"><INPUT id="txtEMail" type="text"><STRONG></STRONG></TD>
                </TR>
                <TR>
                    <TD style="WIDTH: 134px; HEIGHT: 33px"><STRONG>Confirm EmailId</STRONG></TD>
                    <TD style="HEIGHT: 33px"><INPUT id="txtConfirmEMail" type="text"><STRONG></STRONG></TD>
                </TR>
                <TR>
                    <TD style="WIDTH: 134px; HEIGHT: 35px"><STRONG>Password</STRONG></TD>
                    <TD style="HEIGHT: 35px"><INPUT id="txtPassword" style="WIDTH: 152px; HEIGHT: 22px" type="password" size="20"><STRONG></STRONG></TD>
                </TR>
                <TR>
                    <TD style="WIDTH: 134px; HEIGHT: 29px"><STRONG>Password Confirm</STRONG></TD>
                    <TD style="HEIGHT: 29px"><INPUT id="txtPasswordConfirm" style="WIDTH: 152px; HEIGHT: 22px" type="password" size="20"></TD>
                </TR>
                <TR>
                    <TD style="WIDTH: 134px; HEIGHT: 29px"><STRONG>Security Question</STRONG></TD>
                    <TD style="HEIGHT: 29px">
                        <asp:DropDownList id="DropDownList1" runat="server" Width="208px">
                            <asp:ListItem Value="[Select a Question To Answer]" Selected="True">[Select a Question To Answer]</asp:ListItem>
                            <asp:ListItem Value="What is your birth star">What is your birth star</asp:ListItem>
                            <asp:ListItem Value="what is your pets name">what is your pets name</asp:ListItem>
                            <asp:ListItem Value="what is your favorite past time">what is your favorite past time</asp:ListItem>
                        </asp:DropDownList></TD>
                </TR>
                <TR>
                    <TD style="WIDTH: 134px; HEIGHT: 29px"><STRONG>Your Answer</STRONG></TD>
                    <TD style="HEIGHT: 29px">
                        <asp:TextBox id="txtAnswer" runat="server"></asp:TextBox></TD>
                </TR>
            </TABLE>
            <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            </P>
            <P>&nbsp;</P>
            <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ;
                <asp:Button id="Button1" runat="server" Text="Button"></asp:Button>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ;&nbsp;
                <TABLE id="Table2" style="WIDTH: 650px; HEIGHT: 158px" cellSpacing="1" cellPadding="1"
                    width="650" border="0">
                    <TR>
                        <TD>
                            <asp:DataGrid id="DataGrid1" runat="server" Width="640px" Height="202px" AutoGenerateColumns="False">
                                <ItemStyle BackColor="#FFFFC0"></ItemStyle>
                                <HeaderStyle Font-Bold="True" ForeColor="#C00000" BackColor="#FFFFC0"></HeaderStyle>
                                <Columns>
                                    <asp:TemplateColumn HeaderText="From">
                                        <ItemTemplate>
                                            <asp:TextBox ID="fromText" Runat="server" Text='<%#DataBinder.Eval(Container.DataItem, "FromCompany") %>'>
                                            </asp:TextBox>
                                        </ItemTemplate>
                                    </asp:TemplateColumn>
                                    <asp:TemplateColumn HeaderText="To">
                                        <ItemTemplate>
                                            <asp:TextBox ID="toText" Runat="server" Text='<%#DataBinder.Eval(Container.DataItem, "ToCompany") %>'>
                                            </asp:TextBox>
                                        </ItemTemplate>
                                    </asp:TemplateColumn>
                                    <asp:TemplateColumn HeaderText="Year">
                                        <ItemTemplate>
                                            <asp:TextBox ID="txtYear" Runat="server" Text='<%#DataBinder.Eval(Container.DataItem, "GenYear") %>'>
                                            </asp:TextBox>
                                        </ItemTemplate>
                                    </asp:TemplateColumn>
                                    <asp:TemplateColumn HeaderText="Type">
                                        <ItemTemplate>
                                            <asp:TextBox ID="txtType" Runat="server" Text='<%#DataBinder.Eval(Container.DataItem, "Type") %>'>
                                            </asp:TextBox>
                                        </ItemTemplate>
                                    </asp:TemplateColumn>
                                    <asp:ButtonColumn Text="Add" CommandName="Add"></asp:ButtonColumn>
                                    <asp:ButtonColumn Text="Remove" CommandName="Delete"></asp:ButtonColumn>
                                </Columns>
                                <PagerStyle HorizontalAlign="Center" ForeColor="#993366" BackColor="#FFFFCC" Mode="NumericPages"></PagerStyle>
                            </asp:DataGrid></TD>
                        </TD></TR>
                </TABLE>
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ;</P>
        </form>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    </body>
</HTML>

C# file

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace TelecomGen
{
    /// <summary>
    /// Summary description for NewUser.
    /// </summary>
    public class NewUser : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.TextBox txtAnswer;
        protected System.Web.UI.WebControls.DataGrid DataGrid1;
        protected System.Web.UI.WebControls.Button Button1;
        protected System.Web.UI.WebControls.DropDownList DropDownList1;

        private void Page_Load(object sender, System.EventArgs e)
        {
            // Put user code to initialize the page here

            if(!Page.IsPostBack)
            {
                BindGrid();
            }

        }

        //BINDING WITH DATA GRID
        private void BindGrid()
        {
            DataSet ds;
            if(Session["data"]==null)
            {
                CreateDataSet();
            }
            ds=(DataSet)Session["data"];
            DataGrid1.DataSource=ds;
            DataGrid1.DataMember="Geneology";
            DataGrid1.DataBind();
        }

        //CREATE DATASET FUNCTION
        private void CreateDataSet()
        {
            DataSet ds=new DataSet();
            SqlConnection cnn=new SqlConnection();
            cnn.ConnectionString=System.Configuration.Configur ationSettings.AppSettings["dbConnection"];
            SqlDataAdapter da=new SqlDataAdapter("select * from Geneology where 1=2",cnn);
            da.Fill(ds,"Geneology");
        }

        private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            if(e.CommandName=="Add")
            {
                DataSet ds=(DataSet)Session["data"];
                DataRow row=ds.Tables[0].NewRow();
                ds.Tables[0].Rows.Add(row);
                BindGrid();
            }

        }


        #region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            InitializeComponent();
            base.OnInit(e);
        }

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.DropDownList1.SelectedIndexChanged += new System.EventHandler(this.DropDownList1_SelectedInd exChanged);
            this.Button1.Click += new System.EventHandler(this.Button1_Click);
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion

        private void sqlConnection1_InfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)
        {

        }

        private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
        {

        }

        private void Button1_Click(object sender, System.EventArgs e)
        {



        }


    }
}





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to sort data in a data grid? zaheerabbas.sk ASP.NET 1.0 and 1.1 Basics 3 April 10th, 2007 02:37 PM
Export data from data grid to excel pomoc VB.NET 2002/2003 Basics 0 December 16th, 2005 03:11 PM
Export data from data grid to Excel pomoc Visual Basic 2005 Basics 0 December 16th, 2005 02:56 PM
trying to load db data into data grid itsajourney Beginning VB 6 2 June 7th, 2005 12:05 PM
About data grid Asteroid ASP.NET 1.0 and 1.1 Basics 4 December 9th, 2004 05:42 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.