C# Discussion Boards - CodeProject

Re: How can we stop, execution of method in C# ?

Christian Graus23-Jun-08 12:42

23-Jun-08 12:42

I don't understand. What other method ? You stop execution of any method by logic that returns from it, or avoids it.

You should not catch ANY exception and just ignore it. If you have a specific exception you're willing to catch and ignore, catch that type only.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: How can we stop, execution of method in C# ?

Mohammad Dayyan23-Jun-08 12:59

Mohammad Dayyan

23-Jun-08 12:59

Christian Graus wrote:
I don't understand. What other method ? You stop execution of any method by logic that returns from it, or avoids it.

other type of methods. for example we have this code :

private bool export_XML(object sender, EventArgs e)
{
	bool result;
    try
    {
        //...
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
        //stop here, but maybe result is null
    }
    return result;
}

Freshman

Re: How can we stop, execution of method in C# ?

Christian Graus23-Jun-08 13:01

Christian Graus

23-Jun-08 13:01

M-Dayyan wrote:
//stop here, but maybe result is null

No, a bool cannot be null.

I still don't get it. If an exception is thrown, then you need to write code so that your return value is what you want it to be. If you need to write code to check if a class is null, then you need to write it.

Re: How can we stop, execution of method in C# ?

Mohammad Dayyan23-Jun-08 13:56

Mohammad Dayyan

23-Jun-08 13:56

Thank you Christian Graus.
I got it .

Freshman

How can we open an external application from C# form ?

Mohammad Dayyan23-Jun-08 12:14

Mohammad Dayyan

23-Jun-08 12:14

Hi all.
I want to open an external application from C# form.
for example when user clicked the button, IE browser open and goes to the Google site.

Can you help me ?

Freshman

modified on Monday, June 23, 2008 6:22 PM

Re: How can we open an external application from C# form ?

Colin Angus Mackay23-Jun-08 12:23

Colin Angus Mackay

23-Jun-08 12:23

Look at the Process class. You can use tne Start method on the Process class to start the external application.

Recent blog posts:
* Introduction to LINQ to XML (Part 1) - (Part 2) - (part 3)

My website | Blog

Re: How can we open an external application from C# form ?

Mohammad Dayyan23-Jun-08 12:26

Mohammad Dayyan

23-Jun-08 12:26

Thanks Mackay.
Can you write a sample code Rose | [Rose]

Freshman

Re: How can we open an external application from C# form ?

Christian Graus23-Jun-08 12:59

Christian Graus

23-Jun-08 12:59

Why do you people always address us by surname ? It's kind of rude.

Process.Start("IDontKnowHowToUseGoogle.exe")

Re: How can we open an external application from C# form ?

MarkB77723-Jun-08 14:54

MarkB777

23-Jun-08 14:54

Different countries maybe? They are probably not aware that we refer to people by their first name in the west.

Mark Brock

Click here to view my blog

System.Runtime.InteropServices.COMException (0x80040112):

Robert Nesbitt23-Jun-08 11:32

Robert Nesbitt

23-Jun-08 11:32

I am getting the following error when I try to run this application on another CPU

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.TypeInitializationException: The type initializer for 'ZMap_Tester.Util' threw an exception. ---> System.Runtime.InteropServices.COMException (0x80040112): Creating an instance of the COM component with CLSID {648A5600-2C6E-101B-82B6-000000000014} from the IClassFactory failed due to the following error: 80040112.
at ZMap_Tester.Util..cctor() in C:\ZMap Tester\Program\Util.vb:line 13
--- End of inner exception stack trace ---
at ZMap_Tester.Testcontrol.Connect_Click(Object eventSender, EventArgs eventArgs) in C:\ZMap Tester\Program\Testcontrol.vb:line 23
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Line13 is Public MSComm1 As New MSCommLib.MSComm
line23 is MSComm1.CommPort = t

I have tried registering MSCOMM32.ocx and it did not fix the problem

any suggestions??
Bob Nesbitt

Re: System.Runtime.InteropServices.COMException (0x80040112):

Arjun Marwaha23-Jun-08 19:03

Arjun Marwaha

23-Jun-08 19:03

Is this application converted from vb6 to .Net?
Do you receive the mentioned error on all the machines or just this specific?

~Dave

Dave Traister
Software Engineer
ComponentOne LLC
www.ComponentOne.com

Re: System.Runtime.InteropServices.COMException (0x80040112):

Frank Horn23-Jun-08 20:24

Frank Horn

23-Jun-08 20:24

Looks like this "ZMap_Tester" library needs to be licensed

NEED HELP..............Binding Parameter fields in Crystal Reports directly to a Combobox value...........NEED HELP

Verghese23-Jun-08 11:02

Verghese

23-Jun-08 11:02

I have created parameter fields in Crystal Reports using Field Explorer, and everytime I execute my program, a prompt appears asking for the parameter values.........instead I want it to be loaded directly from the user defined Combobox selection...........pls help..........TIA

Re: NEED HELP..............Binding Parameter fields in Crystal Reports directly to a Combobox value...........NEED HELP

leppie23-Jun-08 11:19

leppie

23-Jun-08 11:19

I am pretty sure that will be one of the first help topics in the documentation (well I know this, because I had to look for it myself the other day, sorry no link).

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Re: NEED HELP..............Binding Parameter fields in Crystal Reports directly to a Combobox value...........NEED HELP

Verghese24-Jun-08 3:01

Verghese

24-Jun-08 3:01

so how did u resolved it...........any idea abt it...........thanks leppie.........!!!

C# Access DB Example without DataGrids

kruegersck23-Jun-08 10:47

kruegersck

23-Jun-08 10:47

Hello All -

I am looking for a C# Example using an Access DB without DataGrids.

Any Help would be appreciated.

Thanks!

Re: C# Access DB Example without DataGrids

Christian Graus23-Jun-08 11:25

Christian Graus

23-Jun-08 11:25

It's hard to work out hwat you're asking here. Do you want to show one record per page ? Do you want to create a grid without using the control ( and if so, why ) ?

Once you've called your data source, be it access or whatever, you can display your data any way you want. What is it you're looking for here ?

Re: C# Access DB Example without DataGrids

kruegersck23-Jun-08 12:01

kruegersck

23-Jun-08 12:01

I am want to update one record at a time. I am looking to do a very simple and small maintenance program for contacts.

Thanks!

Re: C# Access DB Example without DataGrids

Christian Graus23-Jun-08 12:04

Christian Graus

23-Jun-08 12:04

OK - so you add controls to show the data for the contact, whatever that is, and a button that calls SQL to update that contact with whatever the user types in.

Re: C# Access DB Example without DataGrids

kruegersck23-Jun-08 12:14

kruegersck

23-Jun-08 12:14

Here is the issue that I am having:

When I fill out the form and leave some of the fields blank I get an SQL Error message that states this: No value given for one or more required parameters.

Here is the code block that does the update:

conProspect.Open();
OleDbCommand cmd = conProspect.CreateCommand();
cmd.CommandText = "Update Contacts set Last_Name=" + "'" + txtLastName.Text + "'" + ", " + "First_Name=" + "'" + txtFirstName.Text + "'" + ", " + "Company_Name=" + "'" + txtCompany.Text + "'" + ", " + "Job_Title='" + txtJobTitle.Text + "'" + ", " + "Business_Phone='" + txtBusPhone.Text + "'" + " Where Contact_ID =" + lngContactId;
cmd.ExecuteNonQuery();
conProspect.Close();

Thanks for the help

Re: C# Access DB Example without DataGrids

Christian Graus23-Jun-08 12:41

Christian Graus

23-Jun-08 12:41

you need to read up on SQL injection attacks, unless you trust everyone who will use this code.

kruegersck wrote:
+ "'"

Why put this seperately ?

You should take the string you generate, copy it into Access and run it from there, or at least look at it to see why it's wrong. Stuff like Company_Name = '' shouldn't cause an error unless the DB does not allow the strings to be empty.

Re: C# Access DB Example without DataGrids

kruegersck23-Jun-08 12:45

kruegersck

23-Jun-08 12:45

This was one sample I found on the net. I am new to c# so I am looking for a good example to work off of.

If you know of one please add to post.

Thanks!

Re: C# Access DB Example without DataGrids

Christian Graus23-Jun-08 12:53

Christian Graus

23-Jun-08 12:53

OK - how much of this code do you understand ? Copying examples from the web is not a good way to learn, you should work through a book first, then look for examples, but also look to fully understand any code you use.

There's a good article on SQL injection on code project, just search for it.

So, when you say you found an example, does this code match with your database schema at all ?

Re: C# Access DB Example without DataGrids

kruegersck23-Jun-08 13:00

kruegersck

23-Jun-08 13:00

I understand all the code just fine. I found the issue with one of my data base fields. What is the best practice for updating my table? This application will run on user desktop and it is not web based?

Re: C# Access DB Example without DataGrids

Christian Graus23-Jun-08 13:02

Christian Graus

23-Jun-08 13:02

Well, best practice is to use a parameterised query or a stored proc. I suggest searching for hte article on SQL injection and reading it.

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