datagrid

shalini166

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

pls help me anyone.

Apr 29 '08 #1

Subscribe Post Reply

828

vee10

141

100+

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

http://www.aspdotnetcodes.com/GridView_Insert_Edit_Update_Delete.aspx

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

Expand|Select|Wrap|Line Numbers

  
<%@ 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;
 
    }

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

pls help me anyone.

Apr 29 '08 #2

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.

Apr 29 '08 #3

vee10

141

100+

hi...

sorry for posting wrong which is not ur requirement

Expand|Select|Wrap|Line Numbers

 
 <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>

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.

Apr 29 '08 #4

by: Ashish Shridharan | last post by:

Hi All I have been trying to add a control to the header cell of a datagrid on my ASP.NET page. These controls are defined in the HTML as ASP.NET web controls. They are being added into the...

.NET Framework

DataGrid/ComboBox custom column problems

by: Bill C. | last post by:

Hello, I know this has been discussed a lot already because I've been searching around for information the last few weeks. I'm trying to implement a DataGridComboBoxColumn class. I've found...

C# / C Sharp

c# Winforms DataGrid: What's the difference between highlighted and selected rows ???

by: BBFrost | last post by:

Win2000 ..Net 1.1 SP1 c# using Visual Studio Ok, I'm currently in a "knock down - drag out" tussle with the .Net 1.1 datagrid. I've come to realize that a 'block' of rows highlighted within...

C# / C Sharp

ComboBox in DataGrid,

by: pei_world | last post by:

I want to implement a key hit with enter to dropdown a combobox that is in the datagrid. in this case I need to override its original behaviours. I found some codes from the web. Does anyone know...

C# / C Sharp

DataGrid EditCommandColumn not firing events properly.

by: Rick | last post by:

Hello all, I hope all is well with you. I am having a seriously difficult time with this problem. Allow me to set up the problem. I have a System.Web.UI.Page with the following controls...

ASP.NET

Not able to page datagrid within the datalist

by: CVerma | last post by:

Hi, I have an embedded datagrid within a datalist. I am not able to perfrom paging in the datagrid. Any ideas? Here is my code: Here is my Simplegrid.cs file: using System; using...

ASP.NET

DataGrid Columns

by: CSL | last post by:

I am using the DataGrid in a Windows Application, how can I adjust the widths of each column individually.

Visual Basic .NET

DataGrid - 2 table comparisons

by: Dave | last post by:

Are there any add-on products or samples available that can do the following in an vb.net datagrid I want to compare 2 rows in a datagrid - one row from one database and another row for another...

Visual Basic .NET

DataGrid Edit Problem

by: rn5a | last post by:

A Form has a DataGrid which displays records from a SQL Server 2005 DB table. Users can modify the records using this DataGrid for which I am using EditCommandColumn in the DataGrid. This is the...

ASP.NET

Problem with Silverlight Datagrid

by: =?Utf-8?B?Y3JlYXZlczA2MjI=?= | last post by:

I have a nested datagrid in a xaml file, the parent datagrid loads the vendor information and the details loads the documents for that vendor in a datagrid. Everything is working fine until I click...

Visual Basic .NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Similar topics