|
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
|
|
|
|
|
And?
What help do you need?
You know how to use SQL from C# I assume, or you wouldn't be writing complicated SQL...so what do you need help with?
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
Hi All,
In a tutorial I found a a new way (new for me)of updating a control from a thread.
In the example code the new way(AsyncParallel) is in button1_Click and what I am familiar with is in button2_Click.
They both do the job, but what is better, regarding performance and especially when more tasks are running that might update UI-thread?
Here is the example:
namespace Task_Compare
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string data = "";
Task Tf1 = Task.Factory.StartNew(() =>
{
data = GetData();
});
Task T2 = Tf1.ContinueWith((previousTask) =>
{
listBox1.Items.Insert(0, data);
}, TaskScheduler.FromCurrentSynchronizationContext());
}
private void button2_Click(object sender, EventArgs e)
{
string data = "";
Task Tf2 = Task.Factory.StartNew(() =>
{
data = GetData();
});
Tf2.Wait();
listBox1.Invoke(new EventHandler(delegate
{
listBox1.Items.Insert(0, data);
}));
}
private string GetData()
{
string temp = "";
{
temp = " Do something long running ......";
}
return temp;
}
}
}
Groover,
0200 A9 23
0202 8D 01 80
0205 00
|
|
|
|
|
GrooverFromHolland wrote: They both do the job, but what is better
They do the same; which one is 'better' is nitpicking. If you want to pick the nits (which can be fun and educational), download ILspy and decompile the class.
The Invoke-pattern is older than the Task-class, which was added in 4 (?). To some, the newer way is "more readable" as it does the same with less code (=fewer bugs). Others will be used to the old pattern.
I prefer not to have a wait or an extra task, but to invoke the UI from the thread using the classical invoke-pattern from MSDN;
1 using System;
2 using System.Collections.Generic;
3 using System.Linq;
4 using System.Text;
5 using System.Windows.Forms;
6 using System.Threading.Tasks;
7
8 namespace ConsoleApplication2
9 {
10 class Program
11 {
12 static void Main()
13 {
14 System.Threading.Thread.CurrentThread.Name = "Main thread";
15 using (var f = new SomeForm())
16 f.ShowDialog();
17 }
18 }
19 class SomeDataCollection : List<Guid> { }
20 class SomeForm: Form
21 {
22 ListBox _listBox1;
23 Button _button1;
24 public SomeForm()
25 {
26 _listBox1 = new ListBox() { Dock = DockStyle.Fill };
27 _button1 = new Button() { Dock = DockStyle.Top };
28 Controls.AddRange(new Control[] { _listBox1, _button1 });
29
30 _button1.Click += delegate
31 {
32 Task Tf2 = Task.Factory.StartNew(() =>
33 {
34 SomeDataCollection _data = getData();
35 showData(_data);
36 });
37 };
38 }
39 void showData(IList<Guid> whatData)
40 {
41 if (InvokeRequired)
42 {
43 Invoke(new Action<SomeDataCollection>(showData), new[] { whatData });
44 return;
45 }
46
47 _listBox1.DataSource = whatData;
48 }
49 SomeDataCollection getData()
50 {
51 var result = new SomeDataCollection();
52 for (int i = 0; i < 10; i++)
53 {
54 result.Add(Guid.NewGuid());
55 System.Threading.Thread.Sleep(150);
56 }
57 return result;
58 }
59 }
60 }
I keep preferring the old style as it makes for very predictable code-constructs. I would however add that it's beneficial during debugging to name each thread during coding! Put a breakpoint on line 35, run, and when the debugger hits it, choose "view, threads" from the menu in the VS-IDE. Each thread/task that you launch can have a unique name - which may even include spaces 
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi Eddy,
Thank You for the good explanation.
Regards,
Groover
0200 A9 23
0202 8D 01 80
0205 00
|
|
|
|
|
You're welcome
|
|
|
|
|
Hy @ everyone,
i have a Little Problem:
class Track
{
string Name;
string Artist;
string Album;
int SampleRate;
int BitRate;
public Track(string name, string artist, string album, int sampleRate, int bitRate)
{
Name = name;
Artist = artist;
Album = album;
SampleRate = sampleRate;
BitRate = bitRate;
}
}
Now i want to editing some values foreach Track:
List<Track> TracksOniTunes = new List<Track>();
foreach (Track item in TracksOniTunes)
{
}
Later, i have a Switch and I need depending on different values to compare from the List
switch (criteria)
{
case "":
break;
case "Qualität":
break;
case "Album":
break;
case "Compilation":
break;
}
My Problem is that i can't editing some items?
I can not access the objects.
Is there an easy way?
Thanks for help.
|
|
|
|
|
Simple. In the line:
List<Track> TracksOniTunes = new List<Track>();
You are creating a brand new empty List. So when you get to
foreach (Track item in TracksOniTunes)
there is nothing in your list. You have to put something in your list before you can change its properties.
|
|
|
|
|
Just Add some items to the list TracksOniTunes. Then u can edit the inner values.
|
|
|
|
|
Sorry, here is the line that add a Track to the list
for (int countForTrack = countTracks; countForTrack > 0; countForTrack--)
{
currentTrack = tracks[countTracks] as IITFileOrCDTrack;
countTracks--;
TracksOniTunes.Add(new Track(currentTrack.Name, currentTrack.Artist, currentTrack.Album, currentTrack.SampleRate, currentTrack.BitRate));
}
|
|
|
|
|
Okay... since you say that there are actually items in your List, the problem becomes more clear. In your foreach you need to say
item.SampleRate = 0; But to get to the variables, you either need to make your class level variables public or create public properties for your class exposing those variables to outside that class.
modified 10-May-14 20:30pm.
|
|
|
|
|
Member 10441939 wrote: My Problem is that i can't editing some items?
I can not access the objects.
What specific error message do you get, and where in the code does the error occur ?
I note in your second reply you do not use the for-loop index count variable to access the current Track, but instead use and decrement another variable: this is not an error, but, why not use the for-loop index variable ?
“I speak in a poem of the ancient food of heroes: humiliation, unhappiness, discord. Those things are given to us to transform, so that we may make from the miserable circumstances of our lives things that are eternal, or aspire to be so.” Jorge Luis Borges
|
|
|
|
|
Change your fields to auto-properties like that;
public string Name { get; set; }
public string Artist{ get; set; }
public string Album { get; set; }
Tim Toady Bicarbonate
|
|
|
|
|
Hep me Please. Where are wrong.Please fix it
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Hastane_Randevu_Sistemi
{
public partial class Giris : Form
{
public Giris()
{
InitializeComponent();
}
private void button2_Click(object sender, EventArgs e)
{
RandevuAl frm = new RandevuAl();
frm.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
comboBox1.Text = "";
comboBox2.Text = "";
comboBox3.Text = "";
comboBox4.Text = "";
cmbbolum.Text = "";
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
{
GetCountry();
}
}
private DataTable Connection(string commandType)
{
DataTable dataTable = new DataTable();
SqlConnection con = new SqlConnection("Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\vt.mdf;Integrated Security=True;Connect Timeout=30");
con.Open();
SqlCommand command = new SqlCommand(commandType);
command.Connection = con;
SqlDataAdapter dataAdapter = new SqlDataAdapter(command);
dataAdapter.Fill(dataTable);
con.Close();
return dataTable;
}
private void GetCountry()
{
DataTable dataTable = new DataTable();
dataTable = Connection("select * from IL");
comboBox1.DisplayMember = "COUNTRYNAME";
comboBox1.ValueMember = "GUID";
comboBox1.DataSource = dataTable;
}
private void GetCity(string CountryId)
{
DataTable dataTable = new DataTable();
dataTable = Connection("Select * from vt where IL ='" + CountryId + "'");
comboBox2.DisplayMember = "İlçe Adı";
comboBox2.ValueMember = "GUID";
comboBox2.DataSource = dataTable;
}
private void cboCountry_SelectionChangeCommitted(object sender, EventArgs e)
{
GetCity(comboBox1.SelectedValue.ToString());
}
}
private void Giris_Load(object sender, EventArgs e)
{
}
}
|
|
|
|
|
Please edit your first message, and remove this one. Re-posting is never a good idea.
You need to set break-points in your code, and then single-step (using F11 in Visual Studio) through the code. Identify the exact place the error occurs, and then edit your post to show (us) where that is.
Make an effort.
“I speak in a poem of the ancient food of heroes: humiliation, unhappiness, discord. Those things are given to us to transform, so that we may make from the miserable circumstances of our lives things that are eternal, or aspire to be so.” Jorge Luis Borges
|
|
|
|
|
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Hastane_Randevu_Sistemi
{
public partial class Giris : Form
{
public Giris()
{
InitializeComponent();
}
private void button2_Click(object sender, EventArgs e)
{
RandevuAl frm = new RandevuAl();
frm.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
comboBox1.Text = "";
comboBox2.Text = "";
comboBox3.Text = "";
comboBox4.Text = "";
cmbbolum.Text = "";
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
{
GetCountry();
}
}
private DataTable Connection(string commandType)
{
DataTable dataTable = new DataTable();
SqlConnection con = new SqlConnection("Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\vt.mdf;Integrated Security=True;Connect Timeout=30");
con.Open();
SqlCommand command = new SqlCommand(commandType);
command.Connection = con;
SqlDataAdapter dataAdapter = new SqlDataAdapter(command);
dataAdapter.Fill(dataTable);
con.Close();
return dataTable;
}
private void GetCountry()
{
DataTable dataTable = new DataTable();
dataTable = Connection("select * from IL");
comboBox1.DisplayMember = "COUNTRYNAME";
comboBox1.ValueMember = "GUID";
comboBox1.DataSource = dataTable;
}
private void GetCity(string CountryId)
{
DataTable dataTable = new DataTable();
dataTable = Connection("Select * from vt where IL ='" + CountryId + "'");
comboBox2.DisplayMember = "İlçe Adı";
comboBox2.ValueMember = "GUID";
comboBox2.DataSource = dataTable;
}
private void cboCountry_SelectionChangeCommitted(object sender, EventArgs e)
{
GetCity(comboBox1.SelectedValue.ToString());
}
}
private void Giris_Load(object sender, EventArgs e)
{
}
}
|
|
|
|
|
Member 10451151 wrote:
private void cboCountry_SelectionChangeCommitted(object sender, EventArgs e)
{
GetCity(comboBox1.SelectedValue.ToString());<br>
}
}
Too many closing braces.
You could have worked this out by looking at the line where the error occurred.
|
|
|
|
|
Somebody can Gide me please where I find something Tutorial , classes or something to learn how to make bars Stock chart with 6 points in Bar.
David
|
|
|
|
|
|
Thanks , don't have bar stock chart
|
|
|
|
|
Microsoft also supplies a free Chart Control for both ASP.NET and WinForms that supports bar graphs: [^].
“I speak in a poem of the ancient food of heroes: humiliation, unhappiness, discord. Those things are given to us to transform, so that we may make from the miserable circumstances of our lives things that are eternal, or aspire to be so.” Jorge Luis Borges
|
|
|
|
|
|
Greetings all
Been reading the news letters for months.
Was wondering if any one has ever gotten Haxe IAP for android apps to work.
We can buy but when already bought there is no way to catch the error and it crashes the code.
The game runs perfectly, true, cannot find any errors. just the store is broken.
So if you can actually show me code that works. looked over the iap and just doesn't work for us.
thanks all
Michelle Brodeur
Abyss Games inc.
|
|
|
|
|
Am doing this as a semester project. is there's anyone out there that could provide me with a complete application or program build in visual studio 2012/2010? Also using SQL server for maintaining database.
|
|
|
|
|
So you want someone to write your code for you so you can turn it in as your own work? That's just not going to happen.
Besides, you haven't said anything about what this program is supposed to do. You also haven't said anything about what you're done to write this yourself and what you've tried to solve your problem.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
