C#

cmd.CommandText = "insert into timemgmt(empid,sysdte,intime,outtime) values ('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";

mjawadkhatri wrote:

cmd.CommandText = "Select empid ,sysdte from timemgmt where empid = '" + textBox1.Text + "' and sysdte ='" + label19.Text + "'";

if(odr.read())
{
 MessageBox.Show("You Already IN this ID Today");
}
else
{
 cmd.CommandText = "insert into timemgmt empid, sysdte, intime, outtime) values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
cmd.ExecuteNonQuery();
}

1. Give your variables meaningful names. At a glance, what does textBox1 do?
2. Your code is wide open to a SQL Injection attack. You need to look into using parameterised queries here.
3. Your insert statement does nothing. You create the command text and then close the connection - you need to execute the command using cmd.ExecuteNonQuery();
4. You have no exception handling. What happens if you can't connect the database, for instance?

Liya Kebede wrote:

is there any way I can access the pin pad remotely?

Case 0:<br />
Case 1:<br />
   status = "Single"<br />
   break;<br />
case 2:

namespace ExerciseInt
{
    public partial class Form1 : Form
    {
      int newNumber;
        
        public Form1()
        {
            InitializeComponent();
           
        }

        public void button1_Click(object sender, EventArgs e)
        {
            Random myRandom = new Random
            myNumber = myRandom.Next(1,10);
        }

        private void button2_Click(object sender, EventArgs e)
        {
            MessageBox.Show(myNumber.ToString());
        }
    }
}

		public clsLimitValue oValue { get; set; }<br />
		private BindingSource oBS = new BindingSource();<br />
<br />
		private void frmNewLimit_Load(object sender, EventArgs e)