Help needed in C#.NET windows form

Ashimjungthapa · December 22nd, 2010, 03:55 AM

Hi everyone,

I am trying to develop a finance software.And I am stuck in somewhere between.
I have a column named NDeposit (type float) in NormalDeposit table.Now what i want is to query all row from that coulmn.

Next I have a cloumn named ND (type float) in InterestRate table.Now i need to get the value from ND column as well.There is only one row in this table.so only one possible valued of ND.

Then I want to perform the:

All row Values from NDeposit + (All row Values from NDeposit * row value from ND)

NOTE:

I am able to get all rows from NDeposit column.But this value are in object type.I need to convert them to float type all at once.

Please I need a help in C#.NET
Thank you in advacne.I am using visual Studio 2008 and SQL Server 2005

samjudson · December 22nd, 2010, 05:26 AM

Sounds like you need to learn SQL, more than you need to learn C#.

The following would do the calculation for you in the SQL itself, then you just use whatever method you are already using to get NDeposit to get both columns:

Code:

SELECT NormalDeposit.NDeposit, NormalDeposit.NDeposit * InterestRate.ND AS Total FROM NormalDeposit, InterestRate

Ashimjungthapa · December 22nd, 2010, 07:34 AM

Thanks for the help.I tried that query and it worked.Actually I modified it as:

SELECT NormalDeposit.NDeposit+ NormalDeposit.NDeposit * InterestRate.ND AS Total FROM NormalDeposit, InterestRate

but it only solved my half of the problem.

Actually i need to store this result back into same column i.e

insert into NormalDeposit values NDepsoit.NOw please could you help me in it as well.

Thanks for your help. I really appreciated this.

And looking forward to your suggestion and help.

samjudson · December 22nd, 2010, 07:48 AM

I think you should post your questions on a SQL forum - you will likely get more answers that way.

It is unclear if you want to insert a new row (in which case INSERT INTO is the correct thing) or you want to update the row (in which case UPDATE is what you want to look at).

Perhaps look up those commands on the Microsoft MSDN site.

Ashimjungthapa · December 22nd, 2010, 11:19 AM

Actually its Update.Thats what i wanna do.

msenthilkumarmca · April 6th, 2011, 05:58 AM

Quote:

Originally Posted by Ashimjungthapa

Actually its Update.Thats what i wanna do.

Then tryout this code:

Code:

UPDATE NormalDeposit SET             
           NDeposit = NDeposit + (NDeposit * Interest.RateofInterest)
        FROM tbl_NDeposit , (SELECT  CAST(ND AS FLOAT) AS RateofInterest
            FROM InterestRate) AS Interest