C#

Paramu1973 wrote:

string MyDtQry = "UPDATE MyTable SET exp_date='" + RegExp + "' where MyTable.id_no='" + AlmIDNo + "'";

DateTime dt = new DateTime(yr,mm,dd)

string MyDtQry = "UPDATE MyTable SET exp_date=@dt where MyTable.id_no=@id";

cmd.Parameters.AddWithVAlue("@dt", RegExp);
cmd.Parameters.AddWithVAlue("@id", AlmIDNo);
//where cmd is sql command object

DateTime RegExp = new DateTime(0);
try
{
    RegExp = new DateTime(yr, mn, dt);
    // or
    string dateStr = string.Format("{0}/{1}/{2}", yr, mn, dt);
    bool parsed = DateTime.TryParse(dateStr, out RegExp);
    if (parsed)
    {
        // success - do something else
    }
    else
    {
        error
    }
}
catch (Exception ex)
{
}

public void ADD_Chart_Style( ZedGraphControl ZGC, DataTable My_DT)
        {
            Graphics G= this.CreateGraphics() ;
            DataRow Dat_Row;
            DataColumn Dat_Colm;
            int Index = 0;

            //Save the value in our DataTable in a List
            List<DateTime> XDate = new List<DateTime>();
            List<double> Value = new List<double>();
            List<DataRow> My_Ro_List = new List<DataRow>();
            foreach (DataRow My_DT_Rows in My_DT.Rows)
            {
                My_Ro_List.Add(My_DT_Rows);
                foreach (var item in My_DT_Rows.ItemArray)

                    Value.Add(Convert.ToDouble(item));

            }
            String Temp = "Date";
            var Result = My_DT.AsEnumerable();
            foreach (var result in My_DT.Columns)
            {
                XDate.Add(Convert.ToDateTime(My_DT.Columns.IndexOf("Date")));
            }

            List<DataColumn> My_C_List = new List<DataColumn>();

            foreach (DataColumn MY_DT_COL in My_DT.Columns)
            {

                My_C_List.Add(MY_DT_COL);

            }
            //Draw Chart Area and PlotArea

            // make upe some Data Array BAsed on the sin function
            int len = My_DT.Columns.IndexOf("Date");
           
            DateTime[] X_ValData = new DateTime[len];
            PointPairList List1 = new PointPairList();
            for (int i = 0; i < My_DT.Rows.Count; i++)
            {
                
                List1.Add(Convert.ToDouble(XDate[i]), Convert.ToDouble(Value));
                X_ValData[i] = XDate[i];

                for (int j = 0; j < My_DT.Columns.Count; j++)
                {
                    //clear out  old Items
                    ZGC.MasterPane.PaneList.Clear();
                    GraphPane My_pane = new GraphPane();
                    My_pane.CurveList.Clear();
                    My_pane.GraphObjList.Clear();
                    // Set the Control GraphPane to my Pane
                    ZGC.GraphPane = My_pane;
                    // Get a new line Item and set it up

                    My_pane.Title.Text = "Auswerte Software Version 1.0";
                    My_pane.Title.FontSpec.Size = 14;
                    My_pane.XAxis.Title.Text = "DATE/Hour/Minutes";
                    My_pane.YAxis.Title.Text = "Value";
                    My_pane.Fill = new Fill(Color.White, Color.FromArgb(220,220,255),45F);
                    LineItem My_Curve = new LineItem("" , List1 , Color.DarkBlue , SymbolType.Diamond);
                    //My_Curve[j] = My_pane.AddCurve("", List1, Color.DarkBlue, SymbolType.Diamond);
                    My_Curve.Symbol.Size = 6;
                    My_Curve.Symbol.Fill.Color = Color.DarkBlue;
                    My_Curve.Symbol.Fill.IsVisible = true;
                    My_Curve.Line.IsVisible = false;

                    //Set the GraphicPhane Up Wit Tittle etc
                   
                    //Add the new Line Items to the GraphPane
                     
                     My_pane.CurveList.Add(My_Curve);
                    // Get the Axis to Update
                    My_pane.AxisChange();
                }
                using (Graphics g = this.CreateGraphics())
                {
                    ZGC.MasterPane.ReSize(g, ZGC.MasterPane.Rect);
                }
                ZGC.Invalidate();

ZedGraphControl My_ZGC = new ZedGraphControl();
       private void Form1_Load(object sender, EventArgs e)
       {

           string Use_Path = OpenFD.FileName;
           //Graphics Obj = this.CreateGraphics();

           DataTable MY_D = new DataTable();
           MY_D = BuildDataTable( Use_Path, ';');

           Cs.ADD_Chart_Style( My_ZGC, MY_D);

       }
       public void Set_SiZe()
       {
           My_ZGC.Location = new Point(10,10);
           My_ZGC.Size  = new Size(this.ClientRectangle.Width - 20,this.ClientRectangle.Height - 20);


       }
       public void Graph_load()
       {
           Form new_F = new Form();
           new_F.Controls.Add(My_ZGC);
           new_F.ShowDialog();

       }