grid view with text box

Question

5.00/5 (1 vote)

See more:

i have grid view like

ASP.NET

<asp:GridView ID="grdSector" runat="server" AutoGenerateColumns="False"  >
                                <columns>
                                    <asp:TemplateField HeaderText="Sectors">
                                        <itemtemplate>
                                           <%# Eval("SectorName")%>
                                        </itemtemplate>
                                    
                                    <asp:TemplateField HeaderText="Roof/ParaPet Clearance in Case of RTT/RTP">
                                        <itemtemplate>
                                            <asp:TextBox ID="_txtClearance" runat="server">
                                        </itemtemplate>
                                    
                                    <asp:TemplateField HeaderText="Azimuth (Degree)">
                                        <itemtemplate>
                                            <asp:TextBox ID="_txtAzimuth" runat="server">
                                        </itemtemplate>
                                    
                                    <asp:TemplateField HeaderText="Ht From Gnd(m)">
                                        <itemtemplate>
                                            <asp:TextBox ID="_txtHeight" runat="server">
                                        </itemtemplate>
                                    
                                    <asp:TemplateField HeaderText="Mount Type">
                                        <itemtemplate>
                                            <asp:Label ID="_lblMountType" runat="server" Text="GBM">
                                        </itemtemplate>
                                    
                                    <asp:TemplateField HeaderText="Ant type">
                                        <itemtemplate>
                                            <asp:TextBox ID="_txtAntType" runat="server">
                                        </itemtemplate>
                                    
                                    <asp:TemplateField HeaderText="Tilt">
                                        <itemtemplate>
                                            <asp:TextBox ID="_txtTilt" runat="server">
                                        </itemtemplate>
                                    
                                    <asp:TemplateField HeaderText="Coverage Objective :- ( Any Important Landmark nearby">
                                        <itemtemplate>
                                            <asp:DropDownList runat="server" ID="_dropObjective">
                                            
                                        </itemtemplate>
                                    
                                    <asp:TemplateField HeaderText="Avg Clutter Height">
                                        <itemtemplate>
                                            <asp:TextBox ID="_txtAvgClutterHeight" runat="server">
                                        </itemtemplate>
                                    
                                </columns>

when user submit the buttom i want to fetch data from textboxes n insert into table in database. can any one help me here

Posted 14-Dec-11 5:20am

spydeehunk

Updated 14-Dec-11 5:26am

Mehdi Gholam

v2

Add a Solution

2 solutions

Solution 1

For the retrieval of the data from textboxes you can use .FindControl() method:

C#

foreach(DataRow row in GridView.Rows)
{
  TextBox txtClearence = (textBox)row.FindControl("_txtClearence");
  TextBox txtHeight = (textBox)row.FindControl("_txtHeight");
  string valClearence = txtClearence.Text;
  string valHeight = txtHeight.Text;
}

For insert to the database you can find an example
here[^]

Good luck,
OI

Posted 14-Dec-11 5:53am

Orcun Iyigun

Updated 14-Dec-11 5:54am

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2011-12-14T05:55:00

Solution 2

This might[^] might help you out.

Posted 14-Dec-11 5:55am

Abhinav S

Comments

Sergey Alexandrovich Kryukov 14-Dec-11 12:20pm

Never saw the FAQ article before. A good idea. My 5.
--SA

Abhinav S 14-Dec-11 12:23pm

Thank you SA.

Monjurul Habib 14-Dec-11 14:38pm

5!

Abhinav S 15-Dec-11 0:23am

Thank you.

sriman.ch 14-Dec-11 23:23pm

Nice article....thanks bro...

Abhinav S 15-Dec-11 0:23am

Thank you.