datagrid

**vee10** · Apr 29 '08, 11:00 AM

hi ..
few days back i was also looking into the solution i got the solution

http://www.aspdotnetco des.com/GridView_Insert _Edit_Update_De lete.aspx

i am also just posting my code but its not using the database

Code:

 

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

<!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">
    <div>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"  OnRowCancelingEdit="GridView1_RowCancelingEdit"  OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating"> 
<Columns> 
<asp:TemplateField HeaderText="Edit" ShowHeader="False"> 
<EditItemTemplate> 
  <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update" Text="Update"></asp:LinkButton> 
  <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"></asp:LinkButton> 
</EditItemTemplate> 

<ItemTemplate> 
  <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit"></asp:LinkButton> 
</ItemTemplate> 
</asp:TemplateField> 

<%--<asp:CommandField HeaderText="Delete" ShowDeleteButton="True" ShowHeader="True" /> --%>
<asp:TemplateField HeaderText="WTTPath" SortExpression="Name"> <EditItemTemplate> 
  <asp:TextBox ID="txtWTTPath" runat="server" Text='<%# Eval("WTTPath") %>'></asp:TextBox> 
</EditItemTemplate> 
<ItemTemplate> 
  <asp:Label ID="Label2" runat="server" Text='<%# Bind("WTTPath") %>'></asp:Label> 
</ItemTemplate> 
</asp:TemplateField> 




<asp:TemplateField HeaderText="PSPath"> 
<EditItemTemplate> 
  <asp:TextBox ID="txtPSPath" runat="server" Text='<%# Bind("PSPath") %>'></asp:TextBox> 
</EditItemTemplate> 

<ItemTemplate> 
  <asp:Label ID="Label3" runat="server" Text='<%# Bind("PSPath") %>'></asp:Label> 
</ItemTemplate> 
</asp:TemplateField> 





</Columns> 
</asp:GridView> 

    </div>
    
    </form>
</body>
</html>


protected void Page_Load(object sender, EventArgs e)
    {
        DataTable dt = new DataTable("ComponentTable");
        DataRow dr = dt.NewRow();
        DataColumn dc = new DataColumn("WTTPath");
        dc.DataType = Type.GetType("System.String");
        dt.Columns.Add(dc);
        dc = new DataColumn("PSPath");
        dc.DataType = Type.GetType("System.String");
        dt.Columns.Add(dc);
        dr["WTTPath"] = "WTTPath";
        dr["PSpath"] = "PSpath";
        dt.Rows.Add(dr);
        GridView1.DataSource = dt;
        GridView1.DataBind(); 
    }

    protected void FillData()
    {
        DataTable dt = new DataTable("ComponentTable");
        DataRow dr = dt.NewRow();
        DataColumn dc = new DataColumn("WTTPath");
        dc.DataType = Type.GetType("System.String");
        dt.Columns.Add(dc);
        dc = new DataColumn("PSPath");
        dc.DataType = Type.GetType("System.String");
        dt.Columns.Add(dc);
        dr["WTTPath"] = "WTTPath"; //u should fill data using database not directly assigning like this
        dr["PSpath"] = "PSpath";
        dt.Rows.Add(dr);
        GridView1.DataSource = dt;
        GridView1.DataBind(); 
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        FillData();
    }
    protected void GridView1_RowCommand(object sender, EventArgs e)
    {
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        TextBox txtName = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtWTTPath");        
        TextBox txtCity = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtPSPath");
        //write logic what ever u want  ie save this in database

        FillData();
        GridView1.EditIndex = -1;

    } 
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
    
    }

Originally posted by shalini166

How to insert textbox into datagrid and all the values in the row is inserted into the database.

pls help me anyone.

**shalini166** · Apr 29 '08, 11:35 AM

thank for ur reply
i am not using edit.but i need textbox in datagrid.then i want how to insert checkbox into datagrid or gridview.

pls help me.

**vee10** · Apr 29 '08, 12:10 PM

hi...

sorry for posting wrong which is not ur requirement

Code:

 <asp:GridView ID="GridView1" runat="server" > 
        <Columns>
            <asp:TemplateField HeaderText="Check">
                <EditItemTemplate>
                    <asp:CheckBox ID="CheckBox1" runat="server" />
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:CheckBox ID="CheckBox1" runat="server" />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="dropdown">
                <EditItemTemplate>
            <asp:DropDownList ID="drop" runat="server"></asp:DropDownList>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:DropDownList ID="drop" runat="server"></asp:DropDownList>
                </ItemTemplate>
            
            </asp:TemplateField>
            
            <asp:TemplateField HeaderText="dropdown">
                <EditItemTemplate>
                <asp:TextBox ID="text" runat="server"></asp:TextBox>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:TextBox ID="text" runat="server"></asp:TextBox>
                </ItemTemplate>
            
            </asp:TemplateField>
        </Columns>

</asp:GridView>

Originally posted by shalini166

thank for ur reply
i am not using edit.but i need textbox in datagrid.then i want how to insert checkbox into datagrid or gridview.

pls help me.

datagrid

datagrid

Comment

Comment

Comment