C# : Read and Write File.txt

Post by Goborijung at 2020-10-03 16:12:58 | ID: 773

Ref:
https://www.c-sharpcorner.com/UploadFile/mahesh/how-to-read-a-text-file-in-C-Sharp/

>> Read
// Readfile.txt
private void readtxtToolStripMenuItem_Click(object sender, EventArgs e)
{
  string text = System.IO.File.ReadAllText(@"\" + "172.16.0.190	pf_projectITSpart.txt");
  Console.WriteLine("Contents of WriteText.txt = {0}", text);
}

>> Write
//Writefile.txt
private void writefiletxtToolStripMenuItem_Click(object sender, EventArgs e)
{
  //EX : https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/file-system/how-to-write-to-a-text-file
  string[] lines = { "First line", "Second line", "Third line" };
  System.IO.File.WriteAllLines(@"\" + "172.16.0.190	pf_projectITSpart2.txt", lines);
}

>> WriteAppen
//WritefileAppen.txt
private void writefileAppentxtToolStripMenuItem_Click(object sender, EventArgs e)
{
  using (System.IO.StreamWriter file = new System.IO.StreamWriter(@"\" + "172.16.0.190	pf_projectITSpart2.txt", true))
  {
    file.WriteLine("Fourth line");
  }
}

C# : Run Another exe into Panel Form

Post by Goborijung at 2020-09-15 16:58:40 | ID: 806

/**/
[DllImport("user32.dll", SetLastError = true)]
private static extern long SetParent(IntPtr hWndChild, IntPtr hWndNewParent);

[DllImport("user32.dll", SetLastError = true)]
private static extern long SetWindowPos(IntPtr hwnd, long hWndInsertAfter, long x, long y, long cx, long cy, long wFlags);

[DllImport("user32.dll", SetLastError = true)]
private static extern bool MoveWindow(IntPtr hwnd, int x, int y, int cx, int cy, bool repaint);      
/**/

private void testToolStripMenuItem_Click(object sender, EventArgs e)
{
  try
  {
    //string part = "~~" + "~~172.16.0.190~~tpf_project~~ITS~~ERP2020~~MDS~~MDS01.exe"; //Execute by Part
    //ProcessStartInfo ps1 = new ProcessStartInfo(part);                

    //ProcessStartInfo ps1 = new ProcessStartInfo("D:~~Support~~GETFBBar.exe"); //Execute by Local
    ProcessStartInfo ps1 = new ProcessStartInfo("notepad");
    ps1.WindowStyle = ProcessWindowStyle.Minimized;
    Process p1 = Process.Start(ps1);
    Thread.Sleep(1000); // Allow the process to open it's window
    IntPtr appWin1 = p1.MainWindowHandle;
    //Put it into this form
    SetParent(appWin1, this.panelMain.Handle);
    //MoveWindow(appWin1, 2, 2, this.Width/2, this.Height, true); //600, 423
    MoveWindow(appWin1, 2, 2, 600, 400, true); //600, 423
  }
  catch (Exception ex)
  {
    MessageBox.Show(this, ex.Message, "Error");
  }
}

C# : Excel > Import Excel to DataGridview :: Recommend

Post by Goborijung at 2021-04-24 09:02:53 | ID: 1138

// Add Reference
ref: http://csharpexamples.com/c-read-data-excel-file/
using Excel = Microsoft.Office.Interop.Excel;

// Create Function ReadExcel
private void readExcel(int sheetIndex, int rowHeaderIndex, int rowContentIndex, DataGridView dgvName) {
  string file = "";
  DataTable dt = new DataTable();
  DataRow row;
  OpenFileDialog opf = new OpenFileDialog();
  DialogResult result = opf.ShowDialog(); // Show the dialog.
  if (result == DialogResult.OK) // Check if Result == "OK".
  {
    file = opf.FileName; //get the filename with the location of the file
    try {
      //Create Object for Microsoft.Office.Interop.Excel that will be use to read excel file
      Excel.Application excelApp = new Excel.Application();
      Excel.Workbook excelWorkbook = excelApp.Workbooks.Open(file);
      Excel._Worksheet excelWorksheet = excelWorkbook.Sheets[sheetIndex];
      Excel.Range excelRange = excelWorksheet.UsedRange;
      int rowCount = excelRange.Rows.Count; //get row count of excel data
      int colCount = excelRange.Columns.Count; //get column count of excel data 

      //Get the first Column of excel file which is the Column Name (เอาหัว Columns ของ Excel มาตั้งเป็นหัว Columns ของ dataGridview)
      for (int i = rowHeaderIndex; i <= rowCount; i++) {
        for (int j = 1; j <= colCount; j++) {
          dt.Columns.Add(excelRange.Cells[i, j].Value.ToString());
        }
        break;
      }

      //Get Row Data of Excel   
      int rowCounter; //This variable is used for row index number
      for (int i = rowContentIndex; i <= rowCount; i++) //Loop for available row of excel data
      {
        row = dt.NewRow(); //assign new row to DataTable
        rowCounter = 0;
        for (int j = 1; j <= colCount; j++) //Loop for available column of excel data
        {
          //check if cell is empty
          if (excelRange.Cells[i, j] != null && excelRange.Cells[i, j].Value != null) {
            row[rowCounter] = excelRange.Cells[i, j].Value.ToString();
          } else {
            row[i] = "";
          }

          rowCounter++;
        }
        dt.Rows.Add(row); //add row to DataTable
      }

      dgvName.DataSource = dt; //assign DataTable as Datasource for DataGridview

      //Close and Clean excel process
      GC.Collect();
      GC.WaitForPendingFinalizers();
      Marshal.ReleaseComObject(excelRange);
      Marshal.ReleaseComObject(excelWorksheet);
      excelWorkbook.Close();
      Marshal.ReleaseComObject(excelWorkbook);

      //Quit 
      excelApp.Quit();
      Marshal.ReleaseComObject(excelApp);
    } catch (Exception ex) {
      MessageBox.Show(ex.Message);
    }
  }
}

// Action Click Event
private void btnImport_Click(object sender, EventArgs e) {
  //readExcel(sheetIndex,rowHeaderIndex,rowContentIndex,DataGridViewName);
  readExcel(1, 1, 2, dataGridView1);
}

C# : Excel >> Import Excel to Database (Version ใช้งานจริง)

Post by Goborijung at 2020-11-13 03:39:31 | ID: 876

// Import Excel Full Version 2 Part
// Add Reference : using Excel = Microsoft.Office.Interop.Excel;
// Step 1
private void btnImportExcel_Click(object sender, EventArgs e) {
  openFileDialog1.Title = "Excel File to Edit";
  openFileDialog1.FileName = "";
  openFileDialog1.Filter = "Excel File|*.xlsx;*.xls";

  if (openFileDialog1.ShowDialog() == DialogResult.OK) {
    string sFileName = openFileDialog1.FileName;
    //MessageBox.Show("Filename : "+sFileName);
    if (sFileName.Trim() != "") {
      readExcel(sFileName);
    }
  }
}

// Step 2
private void readExcel(string sFile) {
  // CREATE EXCEL OBJECTS.
  Excel.Application xlApp = new Excel.Application();

  Excel.Workbook xlWorkBook;
  Excel.Worksheet xlWorkSheet;
  Excel.Range excelRange;

  int iRow,
  iCol = 2;
  xlApp = new Excel.Application();
  xlWorkBook = xlApp.Workbooks.Open(sFile); // WORKBOOK TO OPEN THE EXCEL FILE.
  xlWorkSheet = xlWorkBook.Worksheets[1]; // NAME OF THE SHEET.

  for (iRow = 2; iRow <= xlWorkSheet.Rows.Count; iRow++) // START FROM THE SECOND ROW.
  {
    // ถ้า Columns แรกของแถวไม่มีข้อมูล หรือ ว่างให้หยุดและออกจาก Loop ทันที
    if (xlWorkSheet.Cells[iRow, 1].value == null) {
      break;
    }
    else {
      /* Check Data in Exist Table */
      //conn = dbc.LocalDB();
      string sql = "SELECT CuttingNo FROM BarcodeOrder WHERE CuttingNo = '" + xlWorkSheet.Cells[iRow, 7].value + "' ";
      Console.WriteLine("Sqlcheck : " + sql);
      if (dbq.get(sql, conn) == true) {
        obj.showInfoMessage("Cutting ซ้ำ ระบบจะไม่ทำการบันทึก CuttingNo : " + xlWorkSheet.Cells[iRow, 7].value + " เข้าสู่ระบบนะจ๊ะ");
      }
      else {
        /* Insert Excel to GSSv2_Prod.BarcodeOrder */
        //conn = dbc.LocalDB();
        //int i = 1;
        string customerItemName = xlWorkSheet.Cells[iRow, 10].value;
        customerItemName = customerItemName.Replace("'", "''");
        string sql2 = "INSERT INTO BarcodeOrder(Customer ,Season ,CustomerOrderNo ,Lot ,CostSheet ,CuttingNo ,Model ,CustomerItemCode ,CustomerItemName ,SKUCode ,Size ,Color ,QTYOrder ,Shipport ,LoadingDate)";
        sql2 += " Values(";
        sql2 += " (Select OID From Customer WHERE Name = '" + xlWorkSheet.Cells[iRow, 2].value + "') ";
        sql2 += " ,'" + xlWorkSheet.Cells[iRow, 3].value + "' ";
        sql2 += " ,'" + xlWorkSheet.Cells[iRow, 4].value + "' ";
        sql2 += " ,'" + xlWorkSheet.Cells[iRow, 5].value + "' ";
        sql2 += " ,'" + xlWorkSheet.Cells[iRow, 6].value + "' ";
        sql2 += " ,'" + xlWorkSheet.Cells[iRow, 7].value + "' ";
        sql2 += " ,'" + xlWorkSheet.Cells[iRow, 8].value + "' ";
        sql2 += " ,'" + xlWorkSheet.Cells[iRow, 9].value + "' ";
        sql2 += " ,'" + customerItemName + "' ";
        sql2 += " ,'" + xlWorkSheet.Cells[iRow, 11].value + "' ";
        sql2 += " ,'" + xlWorkSheet.Cells[iRow, 12].value + "' ";
        sql2 += " ,'" + xlWorkSheet.Cells[iRow, 13].value + "' ";
        sql2 += " ,'" + xlWorkSheet.Cells[iRow, 14].value + "' ";
        sql2 += " ,'" + xlWorkSheet.Cells[iRow, 15].value + "' ";
        sql2 += " ,'" + Convert.ToDateTime(xlWorkSheet.Cells[iRow, 16].value).ToString("yyyy-MM-dd") + "' ";
        sql2 += ")";
        Console.WriteLine("Sqlcmd : " + sql2);

        dbq.Query(sql2, conn);
      }
    } //end else check break row
  } //end for loop

  conn.Close();
  obj.showInfoMessage("Improt Excel is Successfull.");
  getDgv();

  xlWorkBook.Close();
  xlApp.Quit();
}

C# : Add Columns And Row to DataGridView :: ปิดการใช้งาน AllowUserToAddRows

Post by Goborijung at 2020-09-10 12:41:02 | ID: 776

private void Form1_Load(object sender, EventArgs e)
{
  DataTable dt = new DataTable();
  dt.Columns.AddRange(new DataColumn[3] 
  {
    new DataColumn("Id", typeof(int)),
    new DataColumn("Name", typeof(string)),
    new DataColumn("Country",typeof(string))
  });
  dt.Rows.Add(1, "John Hammond", "United States");
  dt.Rows.Add(2, "Mudassar Khan", "India");
  dt.Rows.Add(3, "Suzanne Mathews", "France");
  dt.Rows.Add(4, "Robert Schidner", "Russia");
  this.dataGridView1.DataSource = dt;
  this.dataGridView1.AllowUserToAddRows = false; //ปิดการใช้งาน AllowUserToAddRows
}

private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
  if (e.RowIndex >= 0)
  {
    DataGridViewRow row = dataGridView1.Rows[e.RowIndex];
    txtID.Text = row.Cells[0].Value.ToString();
    txtName.Text = row.Cells[1].Value.ToString();
    txtCountry.Text = row.Cells[2].Value.ToString();
  }
}

C# : Add CrystalReport

Post by Goborijung at 2020-12-22 14:03:34 | ID: 929

https://www.thaicreate.com/dotnet/crystal-report-dataset-datatable.html

>> ก่อนอื่น ให้ทำการสร้าง Form ใหม่ และเพิ่ม Object CrystalReportViewer เข้าไปดั้งนี้


1. Project > Add New Item > DataSet


เปลี่ยนชื่อ DataTable ใหม่ให้เป็น myDataTable จะได้จดทำง่ายหน่อย ถ้าเรียบร้อยแล้วให้ปิดหน้าจอนี้ไปได้เลย 
(ตอนนี้ได้สร้าง DataSet และ DataTable ชื่อ myDataTable ไว้แล้ว)

2. Project > Add New Item > Report > CrystalReport


อันนี้ให้เลือก Project Data-> ADO.NET DataSets -> myDataTable (ที่ได้สร้างไว้ในขั้นตอนการสร้าง DataSet และ DataTable)

เลือกฟิวด์ Fields ข้อมูลทีต้องการแสดงใน Report และคลิกที่ Finish เพื่อเสร็จสิ้นการออกแบบ 
แต่ถ้าหากต้องการกำหนดค่าอื่น ๆ ของ Report ลองคลิกที่ Next เพื่อปรับแต่ง Report

C# : Add Item to Array (Int)

Post by Goborijung at 2021-01-29 09:15:20 | ID: 921

int[] terms;

for(int runs = 0; runs < 400; runs++)
{
    terms[] = runs;
}

-----------------

List<int> add_list= new List<int>();
for (int i = 0; i < 400; i++)
{
   add_list.Add(value);
}

-----------------

foreach(int val in add_list)
{
  //
}

----------------

C# : Add Item to Array (String)

Post by Goborijung at 2020-12-23 13:41:28 | ID: 935

string[] barRange = new string[11]; //11 = จำนวนสมาชิกที่ต้องการจองไว้
for (int i = 0; i <= 10; i++) {
  barRange[i] = i + "xxx";
}

//ดึงข้อมูลใน Array ออกมา
for (int i = 0; i <= barRange.Length - 1; i++) {
  Console.WriteLine(barRange[i].ToString());
}

----------------------------- or -------------------------------

List < string > add_list = new List < string > ();
for (int i = 0; i <= 10; i++) {
  add_list.Add(i + "xxx");
}

//ดึงข้อมูลใน Array ออกมา
foreach(string val in add_list) {
  Console.WriteLine(val);
}

C# : Check Connection State

Post by Goborijung at 2020-09-02 11:44:01 | ID: 762

>> ConnectDB.cs
class ConnectDB
{
  //SQL Server
  public SqlConnection DBTest()
  {
    return new SqlConnection("Data Source=S410717NB0201MSSQLSERVER2;Initial Catalog=DBTest" + ";Persist Security Info=True;User ID=sa;Password=444555666");
  }
}


>> Form1.cs
SqlConnection conn = new ConnectDB().DBTest();
if (conn.State == ConnectionState.Closed)
{
  conn.Open();
}

C# : Check Type isNumber

Post by Goborijung at 2022-03-27 07:45:58 | ID: 1430

string a = "2";
bool isNumber = int.TryParse(a, out int n);
Console.WriteLine(isNumber);

//Output : True or False