Click here to Skip to main content
15,896,111 members

Comments by Member-2338430 (Top 148 by date)

Member-2338430 13-May-20 14:30pm View    
GetData is Webmethod
[WebMethod]
public static List<chartdata> GetData(string name)
{
string x = name;
DataTable table = GetDataMethod(x);

List<chartdata> dataList = new List<chartdata>();

foreach (DataRow dtrow in table.Rows)
{
ChartData details = new ChartData();
details.yil = dtrow[0].ToString();
details.sayi = float.Parse(dtrow[1].ToString(), CultureInfo.InvariantCulture.NumberFormat);


dataList.Add(details);
}
return dataList;
}
Member-2338430 13-Feb-15 3:39am View    
another question like this
there are two table same as;
pay table has product_id and how many product added so: number
product table same above product_id and stock
for ex X product stock=10 I paid or added 2 so product table stock must be update new value 8.
I tryed like above but I cant
update [products] set Stock=Stock-number
WHERE products_id IN (
SELECT cb.products_id,number FROM [pay] cb
INNER JOIN [products] p ON cb.products_id = p.products_id
WHERE cb.situation=1)
situation=1 means paid
Member-2338430 12-Feb-15 19:53pm View    
thanks I solved problem
Member-2338430 12-Feb-15 17:31pm View    
giving error this =you cant specify target table [customer basket]for update in from clause
Member-2338430 12-Feb-15 8:38am View    
I am trying...