//private void fill_Engine_Details() //{ // String Str = ""; // Global.CStopTm = DateTime.Now.ToString("hh:mm:ss tt"); // for (int x = 0; x <= 19; x++) EngData[x] = null; // //string Str = null; // EngData[0] = Global.Eng_FileNm; // EngData[1] = Global.EngType; // EngData[2] = Global.TestRef; // EngData[3] = Global.FipNo; // EngData[4] = Global.EngNo; // EngData[5] = Global.NCyl; // EngData[6] = Global.Bor; // EngData[7] = Global.Strk; // EngData[8] = Global.Svol; // if (Global.flg_Radiator == true) EngData[9] = "YES"; else EngData[9] = "NO"; // if (Global.flg_Fan == true) EngData[10] = "YES"; else EngData[10] = "NO"; // if (Global.flg_AirCln == true) EngData[11] = "YES"; else EngData[11] = "NO"; // if (Global.flg_Silincer == true) EngData[12] = "YES"; else EngData[12] = "NO"; // EngData[13] = "EDB- 200"; // EngData[14] = Global.OperatorNm; // EngData[15] = Global.EnginerNm; // EngData[16] = Global.T_CellNo; // EngData[17] = Global.CStrtTm; // EngData[18] = Global.CStopTm; // if (Global.ErrorMatrix == null) Global.ErrorMatrix = "*******"; // EngData[19] = Global.ErrorMatrix; // Str = ""; // for (int i = 0; i <= 18; i++) // { // if ((EngData[i] == null) || (EngData[i] == "")) // { // EngData[i] = "****"; // } // Str = Str + EngData[i] + "', '"; // } // Global.Open_DataConn("Data", "conData"); // SqlCommand cmd2 = new SqlCommand("Insert into EngDetails values('" + Str + EngData[19] + "' )", Global.conData); // cmd2.ExecuteNonQuery(); // Global.conData.Close(); //} private void ExportData() { try { if (Global.flg_RecorsPmData == true) { Global.Open_PMConn(Global.CDate, "conPM"); MySqlDataAdapter adp = new MySqlDataAdapter("select * from " + Global.Eng_PMFileNm, Global.conPM); DataSet ds = new DataSet(); adp.Fill(ds); prgT.Maximum = ds.Tables[0].Rows.Count - 1; if (ds.Tables[0].Rows.Count != 0) { for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++) { prgT.Value = i; string str = ""; string str1 = "'" + ds.Tables[0].Rows[i].ItemArray[0].ToString() + "'"; for (int j = 1; j <= ds.Tables[0].Columns.Count - 2; j++) { str = str + ds.Tables[0].Rows[i].ItemArray[j].ToString() + ", "; } string str2 = "'" + ds.Tables[0].Rows[i].ItemArray[13].ToString() + "'"; MySqlCommand cmd = new MySqlCommand("Insert into " + Global.Eng_PMFileNm + "values(" + str1 + "," + str + "" + str2 + " )", Global.conPM); cmd.ExecuteNonQuery(); } Global.conPM.Close(); MessageBox.Show("Data Transfer Over"); this.Close(); } else { MessageBox.Show("No Data ......"); this.Close(); } } else { this.Close(); } } catch (Exception ex) { MessageBox.Show("Error Code:-15006", ex.Message); Global.Create_OnLog(ex.Message + " : Export Data....", "Alart"); this.Close(); } }