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 

 

 

 

Answer 1

Sorry don't understand your question proper.

you want discount percentage in text box from where form datagridview column or other.

Answer 2

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();

}

Answer 3

publicpartialclassDefault3:System.Web.UI.Page
{
SqlConnectioncon=newSqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString.ToString());
protectedvoidPage_Load(objectsender,EventArgse)
{
con.Open();
stringq="Select*fromamount";
SqlCommandcmd=newSqlCommand(q,con);
SqlDataReaderdr=cmd.ExecuteReader();
DataTabledt=newDataTable();
dt.Load(dr);
DataSetds=newDataSet();
ds.Tables.Add(dt);
GridView1.DataSource=ds;
GridView1.DataBind();
}
protectedvoidButton1_Click(objectsender,EventArgse)
{
doubletotalamount=0;

doublediscount=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();
}
}
}

<formid="form1"runat="server">
<div>
Discountin%<asp:TextBoxID="TextBox1"runat="server"></asp:TextBox><br/>
<asp:ButtonID="Button1"runat="server"Text="Calculate"OnClick="Button1_Click"/><br/>
<asp:GridViewID="GridView1"runat="server"Width="600"AutoGenerateColumns="false">
<Columns>
<asp:BoundFieldDataField="CO_RoomRent"HeaderText="CO_RoomRent"/>
<asp:BoundFieldDataField="CO_ExtrbedAmount"HeaderText="CO_ExtrbedAmount"/>
<asp:BoundFieldDataField="CO_ExtrapersonAmount"HeaderText="CO_ExtrapersonAmount"/>
<asp:BoundFieldDataField="CO_TotalRoomRent"HeaderText="CO_TotalRoomRent"/>
<asp:BoundFieldDataField="CO_TransactionAmount"HeaderText="CO_TransactionAmount"/>
</Columns>
</asp:GridView>
</div>
</form>

Answer 4

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

Answer 5

sir

rowdatabound event where is locatedin gridview property foe windows application

i did not get that after all events searched belongs gird

Answer 6

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

Answer 7

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