Re: want to allow the user to enter ' but shows error - C# Discussion Boards

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

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.

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?

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.

want to allow the user to enter ' but shows error

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

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

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

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]
}

half-life3-Jun-09 21:03

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

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

half-life3-Jun-09 23:13

3-Jun-09 23:13

Sorry, i've tried it already
and it did'nt work Frown | :(

but thanks anyway Smile | :)

Have Fun
Never forget it

bsaksida4-Jun-09 6:54

bsaksida

4-Jun-09 6:54

I got what the problem is:

example:
[0] Item 1
[1] Item 2
[2] Item 3

If [1] and [2] are checked:

After first delition:
[0] Item 1
[] Deleted Item2
[1] Item 3

In other words, when you delete items you have less items in Datagrid view. make another count within For and make sure it count++ when you delete items. and you do like [k-count]. at first count is 0, and more items you delete, higher count woud get and correct problem

half-life6-Jun-09 19:32