Hi!
I have a pertinent question. Maybe will help in this forum (for those who have this problem).
I write code to read data from my database. What I did: I put on my form one textbox, two labels (label1 and label2).
Then when I focus my barecode on my object (for example a CD cover with barcode). Its appear naturally on my textbox.
After that its clean my textbox and push the code on label1... then the labe2 show me the name of the product. Until there its work well.
But there is a very, very big problem:
when appear the code on the textbox. This textbox should be quickly be cleaned and this code should appear on the label1. But before to appear on the label its take 5 seconds. What happen??? Very strange the behavour!!! Why so long time??? My computer have good and strong memory!
Please anyone can help???
My code:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
string lastScannedCode = "";
public Form1()
{
InitializeComponent();
}
private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Enter)
{
lastScannedCode = textBox1.Text;
label1.Text = lastScannedCode;
textBox1.Clear();
}
}
void ShowTheLastScannedCode()
{
MessageBox.Show(lastScannedCode);
}
private void label1_TextChanged(object sender, EventArgs e)
{
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\TestBarcodeReader\WindowsFormsApplication1\WindowsFormsApplication1\App_Data\office.mdb;Persist Security Info=False";
OleDbConnection sqlCon = new OleDbConnection(connectionString);
sqlCon.Open();
string commandString = "select * from barcode where code ='" + label1.Text + "'";
OleDbCommand sqlCmd = new OleDbCommand(commandString, sqlCon);
OleDbDataReader read = sqlCmd.ExecuteReader();
if (read.HasRows)
{
while (read.Read())
{
label2.Text = read["products"].ToString(); // it will show the code
}
}
else
{
MessageBox.Show("A record with a code of " + label1.Text + " was not found");
}
read.Close();
sqlCon.Close();
}
}
}
2 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
IsraelPosted Oct 18, 2014, 8:53 AM
These codes I wrote helped me to understand very well something. I do try it on other computer and its works very well. What was the problem?
The first computer had 1,30 GHZ and the second I had tryed have 2,50 GHZ.
The matter is the processor.
Arunava BhattacharjeePosted Oct 15, 2014, 12:55 AM