Need help.

[mjawadkhatri]

I want to run this type of query in c# how i do please tell me. select empid,sysdte from timemgmt,if the select returns 0 rows then insert row else don't insert.

[Abhijit Jana]

Did you tried anything to implement it ?

cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net My Latest Article : IIS Remote Debugging

[mjawadkhatri]

No I not tried to implement any thing.

[K0306]

Try the sample code

        SqlConnection con = new SqlConnection("your connection string");
        SqlDataReader dr;
        string str = "your query";
        SqlCommand cmd = new SqlCommand(str, con);
        dr = cmd.ExecuteReader();
        if (dr.HasRows== false)
        {
            //insert new row
        }

Regards, Karthik K...

[Mycroft Holmes]

mjawadkhatri wrote:

No I not tried to implement any thing.

Why not. What are you going to run the select against, a List<> or datatable/view. You can use Linq or Rowfilter for the first part and the second is standard CRUD work.

Never underestimate the power of human stupidity RAH

[mjawadkhatri]

I Am using oracle database using same codeing???

[mjawadkhatri]

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. 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(); xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx textbox1.text = employe ID label19.text = System Date label18.text = System Time

[K0306]

For Oracle, replace SqlConnection,SqlCommand,SqlDatareader to odbcConnection,odbccommand and odbcdatareader

        odbcConnection con = new odbcConnection("your connection string");
        odbcDataReader dr;
        string str = "your query";
        odbcCommand cmd = new odbcCommand(str, con);
        dr = cmd.ExecuteReader();
        if (dr.HasRows== false)
        {
            //insert new row
        }

Regards, Karthik K...

[mjawadkhatri]

Sir When I Use Ur Above Coding In my Aplication show error Error Is 'Microsoft.Data.Odbc.OdbcDataReader' does not contain a definition for 'HasRows'

[mjawadkhatri]

Yes I M doing Same But give error 'Microsoft.Data.Odbc.OdbcDataReader' does not contain a definition for 'HasRows'

[K0306]

Then instead of Hasrow,use like this replace the below code

        if (dr.HasRows == false)
        {
            //insert new row
        }

new code

        if (!dr.Read())
        {
            MessageBox.Show("No records");
        }
        else
        {
            MessageBox.Show("Records Found");
        }

Regards, Karthik K...

[Mycroft Holmes]

You need to read this article on SQL Injection[^]

Never underestimate the power of human stupidity RAH