Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
programer
Posting Yak Master
221 Posts |
 Posted - 2011-07-30 : 05:41:24
|
| Hi,I need your help.DEPOSIT METHOD:CREDIT CARD:1 – Visa credit card2 – Visa electron3 – Mastercard4 – Diners Club E-WALLET:5 – Moneybookers6 – Neteller7 – PayPal PREPAID CARD8 – Paysafecard 9…. 50 WITHDRAWALS METHOD: BANK TRANSFER:51 – Bank transfer E-WALLET:52 – Moneybookers53 – Neteller54 – PayPal 55 …… 100In the table tbl_Transactions I have column TransactionType in which have values deposit method, withdrawals method.TransactionType used because it would not like to use words (paypal, etc ...).This means that the column stores TransactionType int number of words instead of payment methods.So if the column TransactionType is enough number for this or do I create a new table in which are stored methods?Column TransactionType specify the number you want to change the Gridview like this:<% # "1." Equals (Convert.ToString (Eval ("TransactionType")))? "Deposit": "2." Equals (Convert.ToString (Eval ("TransactionType")))? "Withdraw": "3." Equals (Convert.ToString (Eval ("TransactionType")))? "Stake": "0"%> |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-30 : 06:21:34
|
| it depends on your requirement. If you want analysis based on payment methods then you need to add it in a new column.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
programer
Posting Yak Master
221 Posts |
Posted - 2011-07-30 : 07:14:27
|
quote:
Originally posted by visakh16
it depends on your requirement. If you want analysis based on payment methods then you need to add it in a new column.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
New column or new table? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-30 : 08:19:36
|
| new table to store payment methods against transactiontype------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
programer
Posting Yak Master
221 Posts |
Posted - 2011-07-30 : 10:29:02
|
quote:
Originally posted by visakh16
new table to store payment methods against transactiontype------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
Ok,Like this:tbl_MethodsID, NameMethod1, paypal2, stakeand thentbl_transacitonTransactionType111222Please note that this is also provided for the word "stake" |
|
|
|
|
|
|
TransactionType