C#

BobJanova wrote:

Polling isn't really any less complex than persistent sockets,

When you create the folder in the path: Environment.SpecialFolder.ProgramFiles
it always comes up to the error UnauthorizedAccessException do not know how I can handle it, unfortunately OS (Windows 7)

String idtoselect = row.Cells[0].Value.ToString();
String str1 = idtoselect.ToString();

string sql2 = "select NAME_Product from Product where  Product.ID_Product = '"+str1+"' ";

while (rdr.Read())
{
    test = rdr["NAME_Product"].ToString();
}

if (rdr.Read())

CultureInfo ci = new CultureInfo("th-TH");

string sql = "SELECT * FROM Order1 where ID_Product = '"+str1+"' AND DATE_Order BETWEEN '" + dateTimePicker1.Value.ToString("s") + "' AND '" + dateTimePicker2.Value.ToString("s") + "' ";

string sql = "SELECT * FROM Order1 where ID_Product = @ID AND DATE_Order BETWEEN @D1 AND @D2";
da = new SqlDataAdapter(sql, conn);
da.SelectCommand.Parameters.AddWithValue("@ID", idtoselect);
da.SelectCommand.Parameters.AddWithValue("@D1", dateTimePicker1.Value);
da.SelectCommand.Parameters.AddWithValue("@D2", dateTimePicker2.Value);

string test = "";

            foreach (DataGridViewRow row in dataGridView1.Rows)
            {
                if (row.Cells[1].Value != null && (bool)row.Cells[1].FormattedValue)
                {                       
                        String idtoselect = row.Cells[0].Value.ToString();
                        
                        try
                        {
                            string sql2 = "select NAME_Product from Product where  Product.ID_Product = '"+idtoselect+"' ";
                            SqlCommand testcommand2 = new SqlCommand(sql2, conn);
                            rdr = testcommand2.ExecuteReader();

                            if (rdr.Read())
                            {
                                test = rdr["NAME_Product"].ToString();
                            }
                            rdr.Close();

                            try
                            {
                                CultureInfo ci = new CultureInfo("th-TH");
                                string sql = "SELECT * FROM Order1 where ID_Product = @ID AND DATE_Order BETWEEN @D1 AND @D2";
                                da = new SqlDataAdapter(sql, conn);
                                da.SelectCommand.Parameters.AddWithValue("@ID", idtoselect);
                                da.SelectCommand.Parameters.AddWithValue("@D1", dateTimePicker1.Value);
                                da.SelectCommand.Parameters.AddWithValue("@D2", dateTimePicker2.Value);
                                
                                ds = new DataSet();
                                da.Fill(ds, "Order1");
                                chart1.DataSource = ds.Tables["Order1"];
                                chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
                                
                                chart1.Series.Add(test);
                                chart1.Series[test].ChartArea = "ChartArea1";
                                chart1.Series[test].BorderWidth = 4;
                                chart1.Series[test].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;                                
                                chart1.Series[test].YValueMembers += "QUANTITY_Order";
                                chart1.Series[test].XValueMember += "DATE_Order";

                                chart1.DataBind();
                                MessageBox.Show("test :" );
                            }
                            catch (Exception ex)
                            {
                                MessageBox.Show("test :" + ex);
                            }
       
                        }
                        catch
                        {
                            MessageBox.Show("Exception");
                        }
                

                }

datatb = new DataTable();
da.Fill(datatb);
chart1.DataSource = datatb;

// Create an empty table.
DataTable table = new System.Data.DataTable("Table1");

// Add three columns to the table.
table.Columns.Add("Category", typeof(String));
table.Columns.Add("Value", typeof(Double));
table.Columns.Add("SecondValue", typeof(Double));

// Add data rows to the table.
table.Rows.Add(new object[] { "Lost", 0, 17 });
table.Rows.Add(new object[] { "Very Good", 1, 5 });
table.Rows.Add(new object[] { "Good", 2, 0 });
table.Rows.Add(new object[] { "Unlikely", 3, 9 });
table.Rows.Add(new object[] { "Firm Order", 4, 1 });
DataSet set = new DataSet();

set.Tables.Add(table);
chart1.DataSource = set.Tables[0].DefaultView;
//chart1.DataSource = dv3;

chart1.Series["Series1"].XValueMember = "Category";
chart1.Series["Series1"].YValueMembers = "Value";
chart1.Series.Add("Series2");
chart1.Series["Series2"].XValueMember = "Category";
chart1.Series["Series2"].YValueMembers = "SecondValue";
chart1.DataBind();

select NAME_Product from Product where  Product.ID_Product IN ( '"+str1+"' ",  '"+str2+"' ",  '"+str3+"' )