Click here to Skip to main content
15,888,816 members
Home / Discussions / C#
   

C#

 
GeneralRe: Plot line graph from database Pin
Syafiqah Zahirah20-May-14 9:24
Syafiqah Zahirah20-May-14 9:24 
QuestionDeleting Read Bytes Pin
computerpublic10-May-14 23:49
computerpublic10-May-14 23:49 
AnswerRe: Deleting Read Bytes Pin
OriginalGriff11-May-14 0:49
mveOriginalGriff11-May-14 0:49 
GeneralRe: Deleting Read Bytes Pin
computerpublic11-May-14 5:58
computerpublic11-May-14 5:58 
GeneralRe: Deleting Read Bytes Pin
OriginalGriff11-May-14 6:22
mveOriginalGriff11-May-14 6:22 
GeneralRe: Deleting Read Bytes Pin
Richard MacCutchan11-May-14 7:17
mveRichard MacCutchan11-May-14 7:17 
GeneralRe: Deleting Read Bytes Pin
Richard MacCutchan11-May-14 7:17
mveRichard MacCutchan11-May-14 7:17 
QuestionHow Do I Select Particular Data From Sql Database In C#? Pin
hahaahahaahahhahahahhahaha10-May-14 18:29
hahaahahaahahhahahahhahaha10-May-14 18:29 
hello guys,
below is my sql select statement :

SELECT product.P_ID, Product.P_Name,Product.Leadtime, Product.SafetyStockamount,
Monthlysales.Month, Monthlysales.totalsalesamount, (totalsalesamount/30) as Averagedailysales, ((totalsalesamount/30) * Leadtime + SafetyStockamount) as reorderpoint
FROM Product, Monthlysales
where Product.P_ID = Monthlysales.P_ID

in product table there are product id, name, lead time, safety stock column, meanwhile in monthly sales table, there are productid, month (in int), and totalsalespermonth.

the problem is :

i want to retrieve the reorder point result from the select statement above in visual studio c#
the interface will include product id , month options, button and label to show the result.
the reorder point result will be based on the month, for example
if the user choose
pid 1 : 1
month options: 2 (february)
then label result will show the reorder point amount for pid 1 in february.

i also wondering whether i can directly calculate the reorder point result based on product id and its month in sql server and directly call it in c#.

how could i do it?? please help me
thank you
AnswerRe: How Do I Select Particular Data From Sql Database In C#? Pin
OriginalGriff10-May-14 21:31
mveOriginalGriff10-May-14 21:31 
QuestionUpdating UI from Task Pin
GrooverFromHolland10-May-14 5:40
GrooverFromHolland10-May-14 5:40 
AnswerRe: Updating UI from Task Pin
Eddy Vluggen12-May-14 8:31
professionalEddy Vluggen12-May-14 8:31 
GeneralRe: Updating UI from Task Pin
GrooverFromHolland13-May-14 10:31
GrooverFromHolland13-May-14 10:31 
GeneralRe: Updating UI from Task Pin
Eddy Vluggen14-May-14 7:19
professionalEddy Vluggen14-May-14 7:19 
QuestionEditing values in List? Pin
Member 1044193910-May-14 4:16
professionalMember 1044193910-May-14 4:16 
AnswerRe: Editing values in List? Pin
Wes Aday10-May-14 4:25
professionalWes Aday10-May-14 4:25 
AnswerRe: Editing values in List? Pin
pradeep surya10-May-14 5:19
pradeep surya10-May-14 5:19 
AnswerRe: Editing values in List? Pin
Member 1044193910-May-14 6:33
professionalMember 1044193910-May-14 6:33 
AnswerRe: Editing values in List? Pin
Wes Aday10-May-14 14:08
professionalWes Aday10-May-14 14:08 
AnswerRe: Editing values in List? Pin
BillWoodruff10-May-14 13:31
professionalBillWoodruff10-May-14 13:31 
AnswerRe: Editing values in List? Pin
Emre Ataseven11-May-14 7:05
professionalEmre Ataseven11-May-14 7:05 
QuestionError : Expected class,delegate,enum, interface,or struct Pin
Member 104511519-May-14 16:02
Member 104511519-May-14 16:02 
AnswerRe: Error : Expected class,delegate,enum, interface,or struct Pin
BillWoodruff9-May-14 16:44
professionalBillWoodruff9-May-14 16:44 
QuestionError : Expected class,delegate,enum, interface,or struct Pin
Member 104511519-May-14 16:01
Member 104511519-May-14 16:01 
AnswerRe: Error : Expected class,delegate,enum, interface,or struct Pin
Richard MacCutchan9-May-14 21:38
mveRichard MacCutchan9-May-14 21:38 
QuestionI want to learn how to make in C# only Stock bar chart Pin
Member 107434229-May-14 11:47
Member 107434229-May-14 11:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.