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(objectsenderEventArgse) { con.Open(); stringq= Select*fromamount ; SqlCommandcmd= new SqlCommand(qcon); 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(objectsenderEventArgse) { 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