Use ExecuteNonQuery to use DML statements like insert, update, delete etc. Use ExecuteReader to use select statement for fast and forward only data retirveal from the database. Either you love IT or leave IT...

Thank you very much   for helping ^^ It's useful and I'm having a problem with datagridview right but I gonna deal with it. :) Although it's so hurt ,I still choose love.

Actully I've get the code but it 's too longgg private void button4_Click(object sender, EventArgs e) { sql\_con = new SQLiteConnection("Data Source= " + info + ".db;Version=3;New=False;Compress=True;"); sql\_con.Open(); sql\_cmd = sql\_con.CreateCommand(); if ((radioButton1.Checked == true)) { if (textBox10.Text != "") { if (textBox7.Text != "") { string CommandText = "select \* from par where Time between '" + textBox7.Text + "%' and '" + textBox13.Text + "%' and Date like '" + textBox6.Text + "%' and Linein like'" + textBox8.Text + "%' and Lineout like '" + textBox9.Text + "%'and Duration >= " + textBox10.Text + " ;"; DB = new SQLiteDataAdapter(CommandText, sql\_con);//นำข้อมูลออกมา DS.Reset(); DB.Fill(DS);//นาม ข้อมูลปายส่ายนาย ดาต้าเซด DT = DS.Tables\[0\]; dataGridView1.DataSource = DT; int rowCount = ((DataTable)this.dataGridView1.DataSource).Rows.Count; textBox12.Text = rowCount.ToString(); sql\_con.Close(); MessageBox.Show("OK"); } else { string CommandText = "select \* from par where Date like '" + textBox6.Text + "%' and Linein like'" + textBox8.Text + "%' and Lineout like '" + textBox9.Text + "%'and Duration >= " + textBox10.Text + " ;"; DB = new SQLiteDataAdapter(CommandText, sql\_con);//นำข้อมูลออกมา DS.Reset(); DB.Fill(DS);//นาม ข้อมูลปายส่ายนาย ดาต้าเซด DT = DS.Tables\[0\]; dataGridView1.DataSource = DT; int rowCount = ((DataTable)this.dataGridView1.DataSource).Rows.Count; textBox12.Text = rowCount.ToString(); sql\_con.Close(); MessageBox.Show("OK"); } } else { if (textBox7.Text != "") { string CommandText = "select \* from par where Time between '" + textBox7.Text + "%' and '" + textBox13.Text + "%' and Date like '" + textBox6.Text + "%' and Line

I while back I wrote this method that you can use to replace Int32.Parse, and that is about ten times faster. That could help to speed up it a bit. public static int ParseInt32(string text) { long value = 0; long sign = 1; bool first = true; foreach (char c in text) { if (c >= '0' && c <= '9') { value = value * 10 + c - '0'; } else if (c == '-' && first) { sign = -1; } else { throw new FormatException(); } first = false; } value *= sign; if (value < int.MinValue || value > int.MaxValue) throw new OverflowException(); return (int)value; } Despite everything, the person most likely to be fooling you next is yourself.

I've already tried It's still "no such table: par" And what the problem with the # in sql_cmd.ExecuteNonQuery();

Forget about Fixed length it's not my point NOw I 've got the code String inputfilename = ""; private void Add(){ StreamReader reader = new StreamReader(inputfilename); //MessageBox.Show(inputfilename); string line = reader.ReadLine(); while (line != null) { string Date = line.Substring(12, 8); if (line.Substring(11, 1) == "=") { string Time = line.Substring(21, 5); string Linein = line.Substring(27, 10); string Lineout = line.Substring(38, 1); if ((string.Compare(Lineout, "0") > 0 || string.Compare(Lineout, "0") == 0) && (string.Compare(Lineout, "9") < 0 || string.Compare(Lineout, "9") == 0)) { //int g = line.Length; //string Number = line.Substring(40, g - 40); string Number = line.Substring(40, 20); string Status = line.Substring(61, 3); string Duration = line.Substring(65, 9); string Cost = line.Substring(75, 3); string Detail = line.Substring(79, 2); string Network = line.Substring(82, 8); // trim whitespace from both ends of the elements string txtSQLQuery = "insert into par values('" + Date + "','" + Time + "','" + Linein + "','" + Lineout + "','" + Number + "','" + Status + "','" + Duration + "','" + Cost + "','" + Detail + "','" + Network + "')"; ExecuteQuery(txtSQLQuery); //MessageBox.Show(line); textBox6.Text = textBox6.Text + "\\r\\n" + Date + " " + Time + " " + Linein + " " + Lineout + " " + Number + " "; } else { textBox5.Text = line + "\\r\\n" + textBox5.Text; } } else { textBox5.Text = line + "\\r\\n" + textBox5.Text; } line = reader.ReadLine(); } MessageBox.Show("End while loop"); } thx for all comment +_! :)