mysql with repeater and modified values

Question

0.00/5 (No votes)

See more:

I place values from mysql into repeater

and have some values to be calculated for each row , and then display only that value in repeater according to the id ...

for exp.

in mysql i have values

name surname price

maulik shah 258
perva rasool 123
sharer taval 147

Now , i want to add 25 to price for maulik, add 85 to perva ,and same price for sharer in aspx.cs code behind and then set in repeater ,,,

or set first datasource in repeater and then make changes..

or u suggest

i hope you understood..

Posted 3-Feb-14 23:04pm

maulikshah1990

Add a Solution

1 solution

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)

ravikhoda · Answer 1 · 2014-02-03T23:40:00

Solution 1

you can set values to the dataset using ado.net features.
when you get data from sql

use datatable object and change the values as per you need like below

C#

for(int i = 0;i<dt.roww.count;i++)
{
if(discount != 0)
{
double newvlaue = oldvalue +  (oldvalue * discount)/100;

datatable.rows[0]["price"] = newvlaue 
}
else 
{
keep price as it is 
}

datatable.acectpchanges();
repeater.datasource = datatable;
repeater.databind();
}

Posted 3-Feb-14 23:40pm

ravikhoda

Updated 4-Feb-14 0:00am

v3

Comments

maulikshah1990 4-Feb-14 5:46am

Hi
i get mysql into dataset, then i need to check if discount!=0 , then take price for that rows, calculate according to discount. and update price in dataset and then datasource and databind to asp:repeater..

ravikhoda 4-Feb-14 6:00am

please check solution again maybe this one help you