deduction Values

Question

i have a gridview in that CO_RoomRent as [Room Rent], CO_ExtrbedAmount as [Extra Bed Amount], CO_ExtrapersonAmount as [Extra Person Amount], CO_TotalRoomRent as [Total Amount], CO_TransactionAmount as [Transaction Amount] those are the fields now in textbox i will give discount percentage using that percentage deduct that percentage display remaining value display in gridview desktop application c# sql server2008 please help me

Feroz Khan · Answer

Sorry don't understand your question proper. you want discount percentage in text box from where form datagridview column or other.

Feroz Khan · Answer

Dear Yesubabu, If you want to show value in grid view then you need to do below code. foreach (DataGridViewRow row in dataGridView1.Rows) { int n = row.Index; dataGridView1.Rows[n].Cells[6].Value = Double.Parse(dataGridView1.Rows[n].Cells[4].Value.ToString()) / Double.Parse(dataGridView1.Rows[n].Cells[5].Value.ToString()); } and if you want to show value in Text Box so need to do below code. double issue = 0; int storedays = Convert.ToInt32(Total_StoreDays_txt.Text); if (double.TryParse(Total_issue_txt.Text, out issue)) { remainingvalue.Text = (TotalValue / Percentage).ToString(); }

Dipika · Answer

public partial class Default3:System.Web.UI.Page { SqlConnectioncon= new SqlConnection(ConfigurationManager.ConnectionStrings[ "conn" ].ConnectionString.ToString()); protected void Page_Load(objectsender,EventArgse) { con.Open(); stringq= "Select*fromamount" ; SqlCommandcmd= new SqlCommand(q,con); SqlDataReaderdr=cmd.ExecuteReader(); DataTabledt= new DataTable(); dt.Load(dr); DataSetds= new DataSet(); ds.Tables.Add(dt); GridView1.DataSource=ds; GridView1.DataBind(); } protected void Button1_Click(objectsender,EventArgse) { double totalamount=0; double discount=Convert.ToDouble(TextBox1.Text); foreach(GridViewRowrowinGridView1.Rows) { totalamount=Convert.ToDouble(row.Cells[3].Text); totalamount=totalamount-(totalamount*(discount/100)); row.Cells[3].Text=totalamount.ToString(); } } } form id = "form1" runat = "server" > div > Discountin% asp:TextBox ID = "TextBox1" runat = "server" > asp:TextBox > br /> asp:Button ID = "Button1" runat = "server" Text = "Calculate" OnClick = "Button1_Click" /> br /> asp:GridView ID = "GridView1" runat = "server" Width = "600" AutoGenerateColumns = "false" > Columns > asp:BoundField DataField = "CO_RoomRent" HeaderText = "CO_RoomRent" /> asp:BoundField DataField = "CO_ExtrbedAmount" HeaderText = "CO_ExtrbedAmount" /> asp:BoundField DataField = "CO_ExtrapersonAmount" HeaderText = "CO_ExtrapersonAmount" /> asp:BoundField DataField = "CO_TotalRoomRent" HeaderText = "CO_TotalRoomRent" /> asp:BoundField DataField = "CO_TransactionAmount" HeaderText = "CO_TransactionAmount" /> Columns > asp:GridView > div > form >

Dipika · Answer

You want to change it in database or temporary basis in the grid only

yesubabu k · Answer

sir rowdatabound event where is locatedin gridview property foe windows application i did not get that after all events searched belongs gird

Dipika · Answer

You will need to update that in database, the amount column value should get updated and then bind the grid

yesubabu k · Answer

Sir I Have a form containing textbox(Percentage), gridview for Displaying result gridview has Total amount column Ex: total amount / percentage = remaining value it will show in gridview when i give some value automatically remaining value change then display in my gridview

deduction Values

Tapan Patel

Manas Mohapatra

Ritesh Singh