C# Discussion Boards - CodeProject

Re: How to figure out whether an enum is defined in an assembly.

S. Senthil Kumar4-Jun-09 2:15

4-Jun-09 2:15

Are you trying to write a generic attribute or one that only works with MyEnum? If it's the former, I can't see any way around passing typeof(MyEnum) to the constructor of SomeEnumAttribute.

Regards
Senthil [MVP - Visual C#]
_____________________________
My Home Page |My Blog | My Articles | My Flickr | WinMacro

Re: How to figure out whether an enum is defined in an assembly.

_AnsHUMAN_ 4-Jun-09 20:11

_AnsHUMAN_

4-Jun-09 20:11

there is a way though:
SomeEnum[Description(typeof(MyEnum),"value")]
write a constructor in SomeEnum attribute derived class and lo and behold you have the MyEnum type in the attribute class.

You need to google first, if you have "It's urgent please" mentioned in your question.
Wink | ;-)

_AnShUmAn_

Re: How to figure out whether an enum is defined in an assembly.

S. Senthil Kumar4-Jun-09 20:41

S. Senthil Kumar

4-Jun-09 20:41

Um, isn't that what I said in my previous post?

I can't see any way around passing typeof(MyEnum) to the constructor of SomeEnumAttribute.

Regards
Senthil [MVP - Visual C#]
_____________________________
My Home Page |My Blog | My Articles | My Flickr | WinMacro

Oracle connection problem in C#

mariamkhaqan3-Jun-09 21:59

mariamkhaqan

3-Jun-09 21:59

Hi I am unable to connect to oracle using c# , its giving me exception like "Connection not open" and sometimes TNS error , i have tried several methods which are as under

string oradb = "Data Source=(DESCRIPTION="
               + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ORASRVR)  (PORT=1521)))"
               + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=mariam)));"
               + "User Id=system;Password=mariam;";
OracleConnection conn = new OracleConnection(oradb);  // C#
               conn.Open();

and

string strCon = "Driver={Microsoft ODBC for Oracle};SERVER = 10.17.18.62; Uid=system;Pwd=mariam;";
              OdbcConnection odbc_Con = new OdbcConnection("Driver={Microsoft ODBC for Oracle};Server=DEDICATED; UID=system;PWD=mariam;");
                odbc_Con.ConnectionString = "Driver={Microsoft ODBC for Oracle};Server=DEDICATED; UID=system;PWD=mariam;";
              odbc_Con.Open();

and

string strCon = "Driver={Microsoft ODBC for Oracle};SERVER = 10.17.18.62; Uid=system;Pwd=mariam;";
               OleDbConnection  oracleConn = new OleDbConnection();
               oracleConn.ConnectionString = "Provider=\"OraOLEDB.Oracle.1\";User ID=system;Password=mariam; Data Source=XE; Extended Properties=\"\"; Persist Security Info=False ";
            oracleConn.Open();

help will be appreciated

regards,

help

Rajdeep.NET3-Jun-09 21:50

Rajdeep.NET

3-Jun-09 21:50

Hi friends,

I want to get the path of the current executable using C#.

In VB.NET, we do it something like this:

Dim aPath As String = Application.ExecutablePath()

Was wondering how to do this using C#!

Help needed,
ShreeR

Re: help [modified]

musefan3-Jun-09 21:51

musefan

3-Jun-09 21:51

string aPath = Application.ExecutablePath;

maybe that's what you want

Life goes very fast. Tomorrow, today is already yesterday.

modified on Thursday, June 4, 2009 4:04 AM

Re: help

0x3c03-Jun-09 22:01

0x3c0

3-Jun-09 22:01

There's no need for the brackets; ExecutablePath is a property, not a method

Between the idea
And the reality
Between the motion
And the act
Falls the Shadow

Re: help

musefan3-Jun-09 22:04

musefan

3-Jun-09 22:04

That's what happens when you try to think so early in the morning Laugh | :laugh:

Life goes very fast. Tomorrow, today is already yesterday.

Re: help

Rajdeep.NET3-Jun-09 22:31

Rajdeep.NET

3-Jun-09 22:31

Hi Musefan,

This code throws an error.

Error	1	The name 'Applicaton' does not exist in the current context	C:\Documents and Settings\ShreeR.Bhattacharjee.MICROSOF-A84B6D\Local Settings\Application Data\Temporary Projects\ConsoleApplication1\Program.cs	14	28	ConsoleApplication1<br />

Anything to overcome this?

Re: help

musefan3-Jun-09 22:35

musefan

3-Jun-09 22:35

So it's a console application, try this...

string aPath = Environment.GetCommandLineArgs()[0];

Life goes very fast. Tomorrow, today is already yesterday.

Re: help

0x3c03-Jun-09 22:35

0x3c0

3-Jun-09 22:35

Your spelling of Application is wrong

Between the idea
And the reality
Between the motion
And the act
Falls the Shadow

want to allow the user to enter ' but shows error

Mehul_qaz3-Jun-09 21:15

Mehul_qaz

3-Jun-09 21:15

hi!

i want user can enter single cot(')in textbox.
i m using SQL yog but it display error as the insert query become
('dgfd dfg ddf_'','','',8) u can see here actually there are for paramerte but it shows error

Re: want to allow the user to enter ' but shows error

Blue_Boy3-Jun-09 21:26

Blue_Boy

3-Jun-09 21:26

Use Replace function from C# code.

Something like:

TextBox1.Text.Replace("'","''");

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: want to allow the user to enter ' but shows error

Guffa3-Jun-09 21:55

Guffa

3-Jun-09 21:55

Note: That is the correct way to escape a string for some specific databases, like MS SQL Server and MS Access. For other databases you need to do it differently.

It's important to use the correct escaping method for the specific database, otherwise the code is still wide open for SQL injections.

If you use a parameterised query instead, there is no need for escaping.

Despite everything, the person most likely to be fooling you next is yourself.

Re: want to allow the user to enter ' but shows error

Blue_Boy5-Jun-09 1:33

Blue_Boy

5-Jun-09 1:33

I agree with you.
I just didn't have enought time to explain more in my first reply of this question.

I appreciate your additional answer.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: want to allow the user to enter ' but shows error

Guffa3-Jun-09 21:52

Guffa

3-Jun-09 21:52

Your application is wide open for SQL injection attacks.

Please instruct your users not to enter this in the text field:

','','',8);drop table Users;--

Alternatively, you can correct the code. Use parameterised queries instead of concatenating the data into the query.

Despite everything, the person most likely to be fooling you next is yourself.

Re: want to allow the user to enter ' but shows error

musefan3-Jun-09 21:56

musefan

3-Jun-09 21:56

well the solution you should take, and not just to solve you issue but make it more secure, is to use parameters[^] with the sql queries

Life goes very fast. Tomorrow, today is already yesterday.

Advanced ToolTip.

bsaksida3-Jun-09 20:40

bsaksida

3-Jun-09 20:40

Hello, here is what i want to do:

I Have created ListView. I have added Some items.
Now i want to have ToolTip on those items. Not on Control, but every item woud have diffrent tooltip.

Thank you in advance

Re: Advanced ToolTip.

0x3c03-Jun-09 21:42

0x3c0

3-Jun-09 21:42

If you set the ShowItemToolTips property of the ListView control, then you can add a ListViewItem with has the ToolTip property set

Between the idea
And the reality
Between the motion
And the act
Falls the Shadow

Error in Page.RegisterClientScriptBlock

Murtuza Husain Miyan Patel3-Jun-09 20:39

Murtuza Husain Miyan Patel

3-Jun-09 20:39

Dear Friends,

I want to execute below java script from code behind of C# .NET

string url="/AssetItems"+"/frm"+assetitem+".aspx";

str="<script type=text/javascript language=javascript>";
str=str+"parent.frames[main3].location.href = "+url;
str=str+"</script>";
Page.RegisterClientScriptBlock("Message1",str);

it gives me java script error as "syntax error"

two frames named as top and main3. In top frame I have some search criteria in which I need to do some C# coding and as per result I want to display a page in main3 frame.

Your quick help would be highly appreciated

Thanks and Regards
Murtuza Patel

Problem in UnInstalling a BHO setup?

svt gdwl3-Jun-09 20:24

svt gdwl

3-Jun-09 20:24

I had a BHO appliaction (in-process dll injected in IE) which was developed in Vs2005 c#.

I had made an msi setup with the help of Setup and Deployment Project.
This was the installer class I had added in my project which generates the required dll...

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration.Install;
using Microsoft.Win32;
using System.IO;


namespace BHOPDF
{
    [RunInstaller(true)]
    public partial class Installer1 : Installer
    {
        public Installer1()
        {
            InitializeComponent();
        }

       [System.Security.Permissions.SecurityPermission(System.Security.Permissions.SecurityAction.Demand)]
        public override void Commit(System.Collections.IDictionary savedState)
        {
                base.Commit(savedState);
        }



        [System.Security.Permissions.SecurityPermission(System.Security.Permissions.SecurityAction.Demand)]
        public override void Install(System.Collections.IDictionary stateSaver)
        {
            base.Install(stateSaver);
        }
      
       
        [System.Security.Permissions.SecurityPermission(System.Security.Permissions.SecurityAction.Demand)]
        protected override void OnCommitting(System.Collections.IDictionary savedState)
        {
            // Get the location of regasm
            string regasmPath = System.Runtime.InteropServices.RuntimeEnvironment.GetRuntimeDirectory() + @"regasm.exe";
            // Get the location of our DLL
            string componentPath = typeof(Installer1).Assembly.Location;
              // Execute regasm
            System.Diagnostics.Process.Start(regasmPath, "/codebase \"" + componentPath + "\"");
            base.OnCommitting(savedState);
        }

    
       
        [System.Security.Permissions.SecurityPermission(System.Security.Permissions.SecurityAction.Demand)]
        protected override void OnAfterInstall(System.Collections.IDictionary savedState)
        {
            base.OnAfterInstall(savedState);
        }

     
       
        [System.Security.Permissions.SecurityPermission(System.Security.Permissions.SecurityAction.Demand)]
        protected override void OnBeforeUninstall(System.Collections.IDictionary savedState)
        {   string regasmPath = System.Runtime.InteropServices.RuntimeEnvironment.GetRuntimeDirectory() + @"regasm.exe";
            // Get the location of our DLL
            string componentPath = typeof(Installer1).Assembly.Location;
            // Execute regasm
            System.Diagnostics.Process.Start(regasmPath, "/u \"" + componentPath + "\"");
          
            base.OnBeforeUninstall(savedState);

        }

       
       
        [System.Security.Permissions.SecurityPermission(System.Security.Permissions.SecurityAction.Demand)]
        public override void Uninstall(System.Collections.IDictionary savedState)
        {
         
            base.Uninstall(savedState);
        }

    }
}

The problem is after I uninstall my setup, and If I check the registry
"Software\Microsoft\Windows\CurrentVersion\Explorer\Browser Helper Objects"
my dll gets un-injected.

After uninstalling, and after sometime, If I check the registry again there my dll is visible as injected. How this is happened?

What was the mistake in the code, can anyone suggest something to solve this?

Datagridview delete problem

half-life3-Jun-09 20:03

half-life

3-Jun-09 20:03

hi,

here's the layout:
- datagridview with 5 columns, last column is CheckBox Column.

the purpose :
- by pressing a button = deleting each row that has a marked CheckBox

the current algorithem :

if (dataGridView1.RowCount > 0)
{
for (int k = 0; k < dataGridView1.RowCount; k++)
{

if ((bool)dataGridView1.Rows[k].Cells[5].Value)
{
dataGridView1.Rows.RemoveAt(k);
}
}
}

the problem :

after the first deletion, the

"(bool)dataGridView1.Rows[k].Cells[5].Value"
throws this excption :
Object reference not set to an instance of an object.

anybody ???

THANKS Smile | :)

Have Fun
Never forget it

Re: Datagridview delete problem

bsaksida3-Jun-09 20:54

bsaksida

3-Jun-09 20:54

The problem is:
You count the rows. and pass as k, but the .rows[k] is zero based index, so you need to "Count -1"

Another method is:

foreach(DataGridViewRowsCollection dvrc in dataGridView1.Rows)
{
// To show how to contiune
// dvrc.cell[5]
}

Re: Datagridview delete problem

half-life3-Jun-09 21:03

half-life

3-Jun-09 21:03

1. for (int k = 0; k < dataGridView1.RowCount; k++)
is'nt tha problem becase :

k < dataGridView1.RowCount
if i have 7 rows it'll start at 0 and at 6 becase 7<7 is false

2.
i've tried to change it to foreach, but still the same problem

3. thanks Smile | :)

Have Fun
Never forget it

Re: Datagridview delete problem

Mycroft Holmes3-Jun-09 22:18

Mycroft Holmes

3-Jun-09 22:18

Do it in reverse
dataGridView1.RowCount: i=0; i--

Never underestimate the power of human stupidity
RAH

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