C# Discussion Boards - CodeProject

15-Jul-09 19:07

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 Jana15-Jul-09 19:31

Abhijit Jana

15-Jul-09 19:31

Did you tried anything to implement it ?

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

mjawadkhatri15-Jul-09 19:37

15-Jul-09 19:37

No I not tried to implement any thing.

K030615-Jul-09 19:44

K0306

15-Jul-09 19:44

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...

mjawadkhatri15-Jul-09 19:46

15-Jul-09 19:46

I Am using oracle database
using same codeing???

K030615-Jul-09 20:20

K0306

15-Jul-09 20:20

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...

mjawadkhatri15-Jul-09 20:24

15-Jul-09 20:24

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

K030615-Jul-09 20:49

K0306

15-Jul-09 20:49

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...

mjawadkhatri15-Jul-09 20:21

15-Jul-09 20:21

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'

Mycroft Holmes15-Jul-09 19:44

Mycroft Holmes

15-Jul-09 19:44

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

mjawadkhatri15-Jul-09 20:02

15-Jul-09 20:02

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

How to Print a file in c#?

Mycroft Holmes15-Jul-09 20:58

Mycroft Holmes

15-Jul-09 20:58

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

Never underestimate the power of human stupidity
RAH

svt gdwl15-Jul-09 19:02

svt gdwl

15-Jul-09 19:02

If a text file is there on desktop.
How to print that file using one of the printer installed in my system.

How to set the printer settings?
At first how can we access the printer?

Re: How to Print a file in c#?

dan!sh 15-Jul-09 19:30

dan!sh

15-Jul-09 19:30

This[^] way.

How to implement IOleCommandTarget and IOLEDocumentView interface in c#?

svt gdwl15-Jul-09 18:41

svt gdwl

15-Jul-09 18:41

Hi I want a method which gives an object for each and every instance of Internet Explorer, such that I can catch the text of the web page displayed in IE. I want to catch that text before it displayed on screen.
How to do?

User Control and Button Click Issue.

VivekUtsa15-Jul-09 18:00

VivekUtsa

15-Jul-09 18:00

Hello all,

I have created an "User Control" and using it around 10times on the same page, displaying 10 different datasets it works fine.

Now I have a button on the same user control and have to generate a number from [ 1 to 10] each time to know on what control the button click event has happened [Say for example when user click on "User Control-1, button the click event has to generate 1, if he click on "User Control 2" button, 2 has to be generated and so on..]. I don't know how this can be achieved.

How is this possible.....any help is greatly appreciated.

Thank You
Bye.

dan!sh 15-Jul-09 18:56

dan!sh

15-Jul-09 18:56

IMO you should have a delegate and handle the button click event in the parent form. Or in the button click event, check for the parent control and execute code accordingly. Something like this:

switch(button.parent.tag){
// cases according to the tag
}

For this, you will need to set the tag property of the usercontrol in the form.

VivekUtsa15-Jul-09 19:16

VivekUtsa

15-Jul-09 19:16

Iam new to Asp.NET/C#. I know how to define a delegate and use event, but how I can use them in this case is confusing me. Can you elaborate little more on this.

Thank you very much.

dan!sh 15-Jul-09 19:26

dan!sh

15-Jul-09 19:26

Place this code in the user control. Here ClickOKButton handles click event of the button in the user control.

public event EventHandler OkButtonClick;

 protected void OnOKButtonClick(EventArgs e) {
   if (OkButtonClick != null) {
     OkButtonClick(this, e);
   }
 }

 protected void ClickOKButton(object sender, EventArgs e) {
   OnOKButtonClick(e);
 }

Now, when you add your control to the form, it will expose OkButtonClick which can be handled in the form itself. Like this:

YourUserControl.OKButtonclick += new EventHandler(SomeMethod);