How Can I Divide Two Field In Sharepoint With Visual Studio C#

Question

0.00/5 (No votes)

See more:

, +

hi everyone, i want to divide 2 field in SharePoint using visual studio c#. I have the code as shown below

SPView vw = jobDef.View["All items"];
vW.ViewFields.Add("MinSalary");
vW.ViewFields.Add("MaxSalary");
vW.ViewFields.Add("AvgSalary");
vw.InLineEdit = "TRUE";
vw.update();


SPListItem newDef;
newDef = jobDef.Items.Add();
newDef["MinSalary"] = "40000";
newDef["MaxSalary"] = "80000";
newDef["AvgSalary"] = int.Parse("MaxSalary")/ int.Parse(MinSalary); // i dont know how what to do here

anyone help me please!

Posted 5-Jul-15 21:30pm

Nderon Hiseni

Updated 2-Aug-16 1:41am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nderon Hiseni · Answer 1 · 2015-07-05T23:09:00

Solution 1

i solved it by myself thanks anyway

int avgSalary = Convert.ToInt32(newDef["MaxSalary"]) / Convert.ToInt32(newDef["MinSalary"]);
newDef["AvgSalary"] = avgSalary.ToString();

Posted 5-Jul-15 23:09pm

Nderon Hiseni

Bajirao_ · Answer 2 · 2016-08-02T01:41:00

Hi Nderon Hiseni,

I suggest you should create calculated field in list.
You can apply formula to your field, whose result may or may not be dependent on other column in list.

My suggestion is
1. Create calculated column manually(possible with c# too) in list from advance setting of list.
2. Apply your formula
3. Add column in View

Work Done !!!!

References :
Manually[^]
By code[^]
Learn more about formula[^]

Note : Out of box is always better than customization, it minimizes bug possibility.