C# Programming
07-16-2009, 11:51 AM
Hi
please check my coding and guide me why record not insert
my coding is
OdbcConnection cn;
OdbcCommand cmd;
OdbcDataReader odr;
string MyString;
MyString = "Select empid , sysdte from timemgmt";
if (radioin.Checked == true)
{
cn = new OdbcConnection("Driver={Microsoft ODBC for Oracle};Server=orcl8i;UID=itehad;PWD=creative;");
cmd = new OdbcCommand(MyString, cn);
cn.Open();
cmd.CommandText = "Select empid , sysdte from timemgmt where empid = '"+textBox1.Text+"' and sysdte ='"+label19.Text+"'";
//MessageBox.Show("Connected");
//cmd.CommandText = "select empid,sysdteinsert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";//,'" + label18.Text + "','" + label18.Text + "')";
//MessageBox.Show(cmd.CommandText);
//cmd.ExecuteNonQuery();
odr = cmd.ExecuteReader();
while (odr.Read())
{
if (textBox1.Text == (odr["empid"].ToString()) && label19.Text == (odr["sysdte"]).ToString())
{
MessageBox.Show("You Already IN this ID Today");
}
else
{
cmd.CommandText = "insert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
}
}
cn.Close();
please check my coding and guide me why record not insert
my coding is
OdbcConnection cn;
OdbcCommand cmd;
OdbcDataReader odr;
string MyString;
MyString = "Select empid , sysdte from timemgmt";
if (radioin.Checked == true)
{
cn = new OdbcConnection("Driver={Microsoft ODBC for Oracle};Server=orcl8i;UID=itehad;PWD=creative;");
cmd = new OdbcCommand(MyString, cn);
cn.Open();
cmd.CommandText = "Select empid , sysdte from timemgmt where empid = '"+textBox1.Text+"' and sysdte ='"+label19.Text+"'";
//MessageBox.Show("Connected");
//cmd.CommandText = "select empid,sysdteinsert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";//,'" + label18.Text + "','" + label18.Text + "')";
//MessageBox.Show(cmd.CommandText);
//cmd.ExecuteNonQuery();
odr = cmd.ExecuteReader();
while (odr.Read())
{
if (textBox1.Text == (odr["empid"].ToString()) && label19.Text == (odr["sysdte"]).ToString())
{
MessageBox.Show("You Already IN this ID Today");
}
else
{
cmd.CommandText = "insert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
}
}
cn.Close();