How to implement IOleCommandTarget and IOLEDocumentView interface in c#? - C# Discussion Boards

Re: Need help.

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

Re: Need help.

mjawadkhatri15-Jul-09 20:21

mjawadkhatri

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'

Re: Need help.

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

Re: Need help.

mjawadkhatri15-Jul-09 20:02

mjawadkhatri

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

Re: Need help.

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

How to Print a file in c#?

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.

Re: User Control and Button Click Issue.

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.

Re: User Control and Button Click Issue.

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.

Re: User Control and Button Click Issue.

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);

Re: User Control and Button Click Issue.

VivekUtsa15-Jul-09 19:33

VivekUtsa

15-Jul-09 19:33

Thank you d@nish,

I did it in a different way, I have added a property to my user control and then setting that property on every usage of the user control on the page and in the button click using that property able to know which controls button has been clicked.

System.NullReferenceException was unhandled by user code, Object reference not set to an instance of an object.

haleemasher15-Jul-09 17:04

haleemasher

15-Jul-09 17:04

cmd.CommandText = "UPDATE Vendor SET VendorId ='" + txtDate.Text + "',VendorFName ='" + txtFName.Text + "',

VendorLName ='" + txtLName.Text +"',VendorCity ='" + txtCity.Text + "',VendorState='" +

txtState.Text+"',VendorCountry='"+ txtCountry.Text+"',VendorDescription='"+txtDescription.Text+"' )";

i got an error message while update a gridview that "object reference not set to an instance of an object"

Re: System.NullReferenceException was unhandled by user code, Object reference not set to an instance of an object.

PIEBALDconsult15-Jul-09 18:06

PIEBALDconsult

15-Jul-09 18:06

That's not the worst of your problems.

A) Step into the code with the debugger and find out what is null.

B) Then completely rewrite your code. Use parameterized SQL command.

Re: System.NullReferenceException was unhandled by user code, Object reference not set to an instance of an object.

Vimalsoft(Pty) Ltd15-Jul-09 20:31

Vimalsoft(Pty) Ltd

15-Jul-09 20:31

You are Doing String Concatination. The only thing that might cause this error is the "cmd" if you dont hava a statement above this code that says

SqlCommand cmd = new  SqlCommand();

then that is a problem, because the incorect string concatination will not give this error descritption

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Which C# Book?

321Markus12315-Jul-09 16:07

321Markus123

15-Jul-09 16:07

Hi,

I'm a C++ programmer looking to learn C#, I have no experience with .NET, I bought "Essential C# 2.0" a few years back but never got a chance to read it.

Could somebody recommend a good C# book, preferably using the .NET 3.5 framework - these three all seem to be well rated so I don't know which (if any) to choose:

Apress - Pro C# 2008 and the .NET 3.5 Platform, Fourth Edition
Wrox - Professional C# 2008
C# 3.0 in a Nutshell: A Desktop Quick Reference

Thanks in advance for any suggestions.

Re: Which C# Book?

PIEBALDconsult15-Jul-09 17:09

PIEBALDconsult

15-Jul-09 17:09

321Markus123 wrote:
Wrox - Professional C# 2008

-- I have an older version (from 2003) that I had to buy for a class way back then, it seems pretty good.

Dynamic Types in Generics?

NandoMan15-Jul-09 11:49

NandoMan

15-Jul-09 11:49

Hello people,

Is it posible to declare the type of a generic at runtime?

I mean, you normaly would have to do something like this:
GenericMethod<Type>();

And I want to do something like this:
GenericMethod<(expression that evaluates to a type)>();

I have tried a few things but nothing seems to work.
MSDN's C# Programming Guide states that:

"client code must declare and instantiate a constructed type by specifying a type argument inside the angle brackets. The type argument for this particular class can be any type recognized by the compiler."

Thanks!

Re: Dynamic Types in Generics?

Pete O'Hanlon15-Jul-09 12:05

Pete O'Hanlon

15-Jul-09 12:05

You could always use a Func here. For instance:

GenericMethod<Func<T, TResult>>();

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Dynamic Types in Generics?

NandoMan15-Jul-09 12:14

NandoMan

15-Jul-09 12:14

Thanks Pete,

And what exactly would this Func be or do?

Thanks again!

Re: Dynamic Types in Generics?

Pete O'Hanlon15-Jul-09 12:17

Pete O'Hanlon

15-Jul-09 12:17

This[^] article should help. This type of functionality is the mojo behind Linq.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Dynamic Types in Generics?

DaveyM6915-Jul-09 13:30

DaveyM69

15-Jul-09 13:30

Good link Pete, very concise. Big Grin | :-D

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Re: Dynamic Types in Generics?

NandoMan16-Jul-09 6:34

NandoMan

16-Jul-09 6:34

Thanks Pete, I read your link and it seems this particular feature it's not for C# 2.0, which is preciselly the version i'm working Frown | :(

Re: Dynamic Types in Generics?

harold aptroot15-Jul-09 13:34

harold aptroot

15-Jul-09 13:34

What kind of expression that evaluates to a type would you have there? Something with reflection? You could probably use reflection to invoke the method with an expression of the type Type, but I'm not actually sure. Reflection can do a lot though, so why not..
edit: If all else fails, there is still the possibility to compile and run a piece of code that has been generated at runtime. But I wouldn't use that except in emergencies. It's not exactly fast, or a clean design.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.