المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : hi..



C# Programming
07-15-2009, 04:11 PM
Hi.
this is my coding

string MyString;
MyString = "Select * from timemgmt";
if (radioin.Checked == true)
{
cn = new OdbcConnection("Driver={Microsoft ODBC for Oracle};Server=orcl;UID=it;PWD=cr;");

cmd = new OdbcCommand(MyString, cn);
cn.Open();
cmd.CommandText = "insert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
cmd.ExecuteNonQuery();
cn.Close();

textbox1.text = employe ID
label19.text = System Date
label18.text = System Time

i want to do Accept employee ID in one time in a day 2nd time user give same Id in a same date not accepted
plzz give me some hints

thanks in Advance

Jawad Khatri