Comments by Member 12235586

Member 12235586 17-Feb-16 2:02am View

yes. i already using | to split the line. but i want to know is there an of method that can append data directly. not the line by line of cell by cell.

Member 12235586 8-Feb-16 0:09am View

yes. the pc s are connected via switch

Member 12235586 7-Feb-16 23:17pm View

can u describe the instructions that i have to follow connect two pc and retrieve data. i already connected pc s via cat6 cable..

Member 12235586 5-Feb-16 1:37am View

ok. i'll study those and use them. thank you very much for your solution.

Member 12235586 5-Feb-16 1:16am View

could you can edit my code including Backgroundworker please??

Member 12235586 5-Feb-16 0:42am View

no. this is my full code. please check 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.Threading;

namespace thread_test_2
{
public partial class Form1 : Form
{
Thread t;
public Form1()
{
InitializeComponent();
}
public void tw()
{
for (int i = 0; i < 10000; i++)
{
textBox1.Text = i.ToString();
}
}
private void button1_Click(object sender, EventArgs e)
{
t = new Thread(tw);
t.Start();
}
}
}

Member 12235586 5-Feb-16 0:23am View

Cross-thread operation not valid: Control 'textBox1' accessed from a thread other than the thread it was created on.

Member 12235586 27-Jan-16 4:27am View

like this
ex:- 1.xls, 3.xls, 5.xls creates by thread_odd
2.xls, 4.xls, 6.xls creates by thread_evan

Member 12235586 27-Jan-16 3:26am View

creating excel files.one thread creates odd numbers excel files.other one creates even numbers files.

Member 12235586 13-Jan-16 1:04am View

thanks friend. i will try it.

Member 12235586 13-Jan-16 1:00am View

i used this for create array.= "string[] bbb=new string[5];"
but i want something like this ="int size = 50;
string[] words = new string[size];" or
string[] bbb=new string[textbox1.text];

Member 12235586 11-Jan-16 4:50am View

is there any option to change that value to numaric in programaticaly

Member 12235586 11-Jan-16 4:49am View

my actual value is 3100151196920.but display value is 3.10015E+12. i want to display 3100151196920 and as normal data i mentioned that value.

Member 12235586 11-Jan-16 0:19am View

is there were no option to display that contents as a normal data??

Member 12235586 30-Dec-15 5:32am View

Deleted

{ Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
FileInfo theSourceFile = new FileInfo(@"" + file); //reading text file
StreamReader reader = theSourceFile.OpenText();
int raw = 1; int column = 1; string s0 = "";
string heading = "";
string column_heading="";
heading = reader.ReadLine();
column_heading = reader.ReadLine();
string[] ch = column_heading.Split('|');
String text = "";
do
{
text = reader.ReadLine();
if (text != null)
{
string[] ss = text.Split('|');
int index = 0; double result;

if (raw < 4)
{
xlWorkSheet.Rows[1].EntireRow.Font.Bold = true;
xlWorkSheet.Cells.Merge(raw);
xlWorkSheet.Cells[raw, 1] = heading; raw++;
xlWorkSheet.Rows[2].EntireRow.Font.Bold = true;
xlWorkSheet.Cells.Merge(raw);
xlWorkSheet.Cells[raw, 1] = "As at " + textBox3.Text; raw++;
xlWorkSheet.Rows[3].EntireRow.Font.Bold = true; int hx = 0;
for (int i = 1; i < ch.Length; i++)
{

xlWorkSheet.Cells[raw, column] = ch[hx]; hx++; column++;
xlWorkSheet.Columns.AutoFit();

}
raw++; column = 1;
for (int i = 1; i < ss.Length; i++)
{
if (!ss[index].Contains('.'))
{
xlWorkSheet.Cells[raw, column] = ss[index];
index++; column++; xlWorkSheet.Columns.AutoFit();
}
else if (double.TryParse(ss[index], out result))
{ xlWorkSheet.Cells[raw, column] = String.Format("{0:n}", result);
index++; column++; xlWorkSheet.Columns.AutoFit();
}
else
{
xlWorkSheet.Cells[raw, column] = ss[index];
index++; column++; xlWorkSheet.Columns.AutoFit();
}
}
//raw++;

}
else
{
for (int i = 1; i < ss.Length; i++)
{

if (!ss[index].Contains('.'))
{
xlWorkSheet.Cells[r

Comments by Member 12235586 (Top 15 by date)