How to add button in last row last column in grid view

Question

1.00/5 (1 vote)

See more:

actually i'am using grid view in that it head retrieve sum textboxs and dropdownlists details i planing to add one button at last of the row last column

What I have tried:

ASP.NET

<asp:TemplateField HeaderText="save"
                    <ItemTemplate>
                   < FooterStyle HorizontalAlign="Right" VerticalAlign="Bottom"                     FooterTemplate >
                 <       asp:Button ID="Button1" runat="server" Text="save" >
                   < FooterTemplate > 
                  <ItemTemplate>
             <  asp:TemplateField >

i'am trying this but the save button is add on every row off the last column.
please give me hints

Posted 4-May-16 19:34pm

Nagarjuna99

Updated 2-Sep-16 1:14am

Santosh Kokatnur

v9

Add a Solution

Comments

Karthik_Mahalingam 5-May-16 2:26am

check my updated solution.

Nagarjuna99 5-May-16 2:36am

i have another doubt that is i'am taking save button,what my requirement i press save button the the multiple number of rows will be save on database ?
is it possible?

3 solutions

Solution 3

How to calculate time column .. Like if we have 2 column of datetime i want to multiply both columns value in 3rd column...How to do it?

Posted 2-Sep-16 1:14am

Mohammad Imran1

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)

Karthik_Mahalingam · Accepted Answer · 2016-05-04T20:03:00

Solution 2

try this

ASP.NET

<asp:GridView ID="GridView1" runat="server" ShowFooter="true" AutoGenerateColumns="false">
           <Columns>
               <asp:BoundField DataField="itemname" HeaderText="itemname" />
               <asp:BoundField DataField="itemprice" HeaderText="itemprice" />
               <asp:BoundField DataField="quantity" HeaderText="quantity" />
               <asp:BoundField DataField="tax" HeaderText="tax" />
               <asp:TemplateField  HeaderText="finalamount">
                   <ItemTemplate>
                       <asp:Label  Text='<%# Eval("finalamount") %>' runat="server" />
                   </ItemTemplate>
                   <FooterTemplate>
                       <asp:Button Text="Save" runat="server" />
                   </FooterTemplate>
               </asp:TemplateField>
           </Columns>
       </asp:GridView>

Posted 4-May-16 20:03pm

Karthik_Mahalingam

Updated 4-May-16 20:26pm

v2

Comments

Nagarjuna99 5-May-16 2:44am

button was not added

Karthik_Mahalingam 5-May-16 2:55am

ShowFooter="true"

Nagarjuna99 5-May-16 2:57am

show footer="true",now its working,
i'have another question when i press button ,the multiple rows of data will be save in database? how to do this

Karthik_Mahalingam 5-May-16 3:07am

check this
you will get.Insert all gridview data into a table[^]

Nagarjuna99 5-May-16 5:34am

for (int i = 0; i < GridView1.Rows.Count; i++)
{
string name = GridView1.Rows[i].Cells[0].Text;
string price = GridView1.Rows[i].Cells[1].Text;
string quantity = GridView1.Rows[i].Cells[2].Text;
string tax = GridView1.Rows[i].Cells[3].Text;
string final = GridView1.Rows[i].Cells[4].Text;

SqlConnection con = new SqlConnection("Data Source=XENORIX8-PC;Initial Catalog=xenorix;User ID=sa;Password=123");
string str = "insert into quantity1 values('" + name + "','" + price + "','"+quantity+"','"+tax+"','"+final+"')";
SqlCommand strCmd = new SqlCommand(str, con);
con.Open();
strCmd.ExecuteNonQuery();
con.Close();

}
i'am using this code to save grid view data into database ,but it has one problem that is final amount will save on 0.00.i think its not taking label 6 value off final amount what i do now?

Karthik_Mahalingam 5-May-16 5:36am

keep break point and check line by line why the value is getting 0

Nagarjuna99 5-May-16 5:39am

<asp:TemplateField HeaderText="finalamount">
<itemtemplate>
<asp:Label Text='<%# Eval("finalamount") %>' runat="server" />

<footertemplate>
<asp:Button Text="Save" runat="server" />

i think this label 6 value not taking.

Karthik_Mahalingam 5-May-16 5:48am

you should cast the value..
http://stackoverflow.com/a/10903924/1147428

Raje_ · Accepted Answer · 2016-05-04T19:53:00

Solution 1

Any control you add in footer will show in footer only. You are not doing it properly.
This is very basic thing. You need to go through some tutorial documents.

Inserting a New Record from the GridView's Footer (C#) | The ASP.NET Site[^]

Working with Footer Template in Gridview. - DotNetFunda.com[^]

Displaying Summary Information in the GridView's Footer (VB) | The ASP.NET Site[^]

[Edit]

ASP.NET

<asp:TemplateField HeaderText="Your header text">
                        <ItemTemplate>
                         <!-- your template control -->
                        </ItemTemplate>                       

                        <FooterTemplate>
                           <asp:Button ID="Button1" runat="server" Text="save" />
                        </FooterTemplate>
                    </asp:TemplateField>

Posted 4-May-16 19:53pm

Raje_

Updated 4-May-16 20:08pm

v3

Comments

Nagarjuna99 5-May-16 2:00am

i now but ,the html code was not coming properly in that so i removeing,
<asp:TemplateField HeaderText="save">
<itemtemplate>
<footerstyle horizontalalign="Right" verticalalign="Bottom">
<footertemplate>
<asp:Button ID="Button1" runat="server" Text="save" />

this is my code
please and check what i wrong

Nagarjuna99 5-May-16 2:01am

<asp:TemplateField HeaderText="save">
<itemtemplate>
<footerstyle horizontalalign="Right" verticalalign="Bottom">
<footertemplate>
<asp:Button ID="Button1" runat="server" Text="save" />

Raje_ 5-May-16 2:07am

check my edited answer. You see i have taken separate footer template for button.

Nagarjuna99 5-May-16 2:47am

in that case button was not displaying

Raje_ 5-May-16 2:50am

Did you add ShowFooter="true" to your grid view???

Raje_ 5-May-16 2:52am

You did not go through the links i have provided. Did you?

Nagarjuna99 5-May-16 2:54am

ya now i'am adding show footer="true,its working .thanks @Raje_

Raje_ 5-May-16 2:55am

Even now i will ask you to go through those links. You have lot to learn yet :)
My best wishes to you.

Nagarjuna99 5-May-16 2:58am

okey i will try as my best,thanks for giving this instractions