您如何在d文本框中接受销售价值n从下表计算佣金 [英] how do u accept the sales value in d text box n calculate commission from table below

问题描述

使用asp如下创建表格，根据销售目标向销售人员提供佣金

目标佣金
1-100K     2％
101K-150K 3％
151K-200K   4％
> 201 K      6％

接受销售价值在一个文本框中，并按照上表显示佣金

Create a table as given below using asp, based on the sales target sales man will be provided the commission

Target(Rs) Commission
1-100K        2%
101K-150K   3%
151K-200K   4%
>201 K        6%

Accept the sales value in a text box and display the commission as per the above table

推荐答案

不确定您的意思是什么.

Not sure what do you mean by.

报价:

使用asp如下所示创建表

Create a table as given below using asp

如果要在数据库中创建表，请查看下面的链接.
http://www.w3schools.com/sql/sql_create_table.asp

我建议在SQl-Server中为您的表进行数据库设计.

表名称-"TargetCommissionDetails"

tr>

Id(int)	TargetMin(money)	TargetMax(money)	Commission(float)
1	1	100000	2
2	100001	150000	3
...

然后，您可以使用 SQL BETWEEN运算符根据目标下降的范围找出佣金.
http://www.w3schools.com/sql/sql_between.asp

看看下面的链接，了解基本的Asp.Net页面设计.
http://msdn.microsoft.com/en-us/library/k4cbh4dh.aspx

您可以参考下面的链接来学习Ado.Net.
http://social.msdn.microsoft.com/Forums/eu/adodotnetdataproviders/thread/8d9e2f96-4879-43e4-97db-1f24957a98ab

为初学者使用ADO.NET

http://msdn.microsoft.com/en-us/library/e80y5yhx.aspx

If you want to create a Table in Databases then have a look at below link.
http://www.w3schools.com/sql/sql_create_table.asp

I would suggest below database-design for your table in SQl-Server.

Table Name - "TargetCommissionDetails"

Id(int)	TargetMin(money)	TargetMax(money)	Commission(float)
1	1	100000	2
2	100001	150000	3
...

Then you may use SQL BETWEEN Operator to find out Commission based on in which range Target is falling.
http://www.w3schools.com/sql/sql_between.asp

Have a look at below link to understand basic Asp.Net Page Design.
http://msdn.microsoft.com/en-us/library/k4cbh4dh.aspx

You may refer below links to learn Ado.Net.
http://social.msdn.microsoft.com/Forums/eu/adodotnetdataproviders/thread/8d9e2f96-4879-43e4-97db-1f24957a98ab

Using ADO.NET for beginners

http://msdn.microsoft.com/en-us/library/e80y5yhx.aspx

这篇关于您如何在d文本框中接受销售价值n从下表计算佣金的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！