Re: Patching classes/codes - C# Discussion Boards

23-Jul-09 21:20

Hello,

How to check and patch your old installed program using c#?

Ex: I had installed program but after couple of months i do changes how can i check the version of the old software inruntime and how can i create patches of it?

thanks

Christian Graus23-Jul-09 21:36

Christian Graus

23-Jul-09 21:36

ClickOnce or your install program are the best way to do this. Otherwise, you need a patcher program that runs and overwrites your exe.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Member 143923423-Jul-09 22:48

23-Jul-09 22:48

sorry, Sir what is clickonce?

Tamer Oz23-Jul-09 21:48

Tamer Oz

23-Jul-09 21:48

The best way is publichingg your application with clickonce.

After completing development your application right click on your Windows application and select publish.
After that all you have to do is put published files to a location such as web site, ftp or file share that users may access.
To install users may open publish.htm and click install or double click the .application file at the root.

Member 143923423-Jul-09 22:47

23-Jul-09 22:47

what does it mean by clickonce? Is this a software?

Tamer Oz23-Jul-09 22:49

Tamer Oz

23-Jul-09 22:49

It's a deployment method.
For further information you can visit http://msdn.microsoft.com/en-us/library/t71a733d(VS.80).aspx[^]

Member 143923423-Jul-09 23:11

Namespace problem (no strong name)

23-Jul-09 23:11

Sir,

How about this scenario, i have one main big application under that i have application service, web services and plugins that are all .exe and installed in client server. If i have update on my domain server for one of my .EXE file, does the main app need to be updated also o can i just update the .EXE file.

Nigel Mackay23-Jul-09 21:07

Nigel Mackay

23-Jul-09 21:07

My app has a number of projects in it. They all use the same namespace (ClientServerTimesheet).

I need to print some grids, so I have added Printing.DataGridViewPrintProvider to the solution, without changing its namespace.

In the client part I have added a reference to it and I can print. But I have a problem with the height of the first row and so I want to look at the array of row heights.

I have a project Globals, with a class Lookup. Lookup contains a public static array of float rowHeights.

In DataGridViewPrintProvider I have added a reference to Globals.
In DataGridViewPrintProvider I use the line
global::ClientServerTimesheet.Lookup.rowHeights[row.Index] = GridView.Rows[row.Index].RowHeight(g);
but it won't build, saying that Globals does not have a strong name.

I supect that what I actually need is to qualify the above line better, or do I really need to create a strong name for Globals? Not sure how to do that with C# 2008 Express

PIEBALDconsult24-Jul-09 4:22

PIEBALDconsult

24-Jul-09 4:22

What Exception are you getting?

Nothing you've said would seem to indicate a problem.

I've never found a need for global:: and I don't think it's required here. Are you somehow confusing it with your Globals project?

Nigel Mackay24-Jul-09 5:39

Nigel Mackay

24-Jul-09 5:39

I just put the global in to see if it helped.

No exception - compile error: Assembly generation failed -- Referenced assembly 'Globals' does not have a strong name : Printing.DataGridViewPrint

But Code Completion worked when entering the line. And other places in my code I can access variables and constants in Lookup (although I don't need the ClientServerTimesheet. as they are in the same namespace.)

I renamed he project that contains Lookup to SolutionGlobals as well as its Assembly Name and the compile error follows the change.!!
If I comment out the line code compiles and runs.

I checked the Build Order and Dependencies. Printer.DataGrisViewPrintProvider is only dependant on SolutionGlobals (Lookup) which is compiled first, and only the client is dependant on it, and client is compiled later in the order.

PIEBALDconsult24-Jul-09 10:57

PIEBALDconsult

24-Jul-09 10:57

Hmmm, well there are situations where an assembly needs a strong name. And as I recall, a strong-named assembly must refer to only strong-named assemblies. So, basically, if any of your assemblies will be strong-named they all must be. I use one strong name file thingy for all the projects in my solutions and that takes care of it.

Outlook 2003 addin not working in outlook 2007

Nigel Mackay24-Jul-09 21:45

Nigel Mackay

24-Jul-09 21:45

After giving all 17 projects a strong name it now compiles!!

Zafar A khan 23-Jul-09 20:40

Zafar A khan

23-Jul-09 20:40

Hi Friend,
I have developed addin for outlook 2003. It installing and working fine with outlook 2003.
and it is installing for outlook 2007 but when i go to enable the addin it is not loading.

any idea ..

Re: Outlook 2003 addin not working in outlook 2007

Abhishek Sur23-Jul-09 21:40

Abhishek Sur

23-Jul-09 21:40

Are you using outlook InterOp services. If so, the API will be different in outlook2003 and outlook2007.

Abhishek Sur

My Latest Articles
Working with Excel using MDAC

Basics on LINQ and Lambda Expressions

Create .NET Templates

Re: Outlook 2003 addin not working in outlook 2007

Zafar A khan 24-Jul-09 0:38

Zafar A khan

24-Jul-09 0:38

Hi Abhishek
Thank you for Reply.
I am not using Interop services.
if used .
then their should be exception when i run the plug in.
but actually installing successfully and not loading when i add it from the view..Trust Center..Addin

ASTVisitor in Visual Studios for C#

u060509423-Jul-09 19:34

u0605094

23-Jul-09 19:34

Hi,

Has anyone done sth in ASTVisitor for C#? Can help me in the following?
I am working on a project regarding reverse engineering, that requires me to write a ASTVisitor using the Visitor method.

I am looking for an something equivalent to this Java API for Eclipse in the C# .NET Framework Class Library for Visual Studios:
http://help.eclipse.org/help33/index.jsp?topic=/org.eclipse.cdt.doc.isv/reference/api/org/eclipse/cdt/core/dom/ast/ASTVisitor.html[^]

Also I found this link (below) which looks related, but I don't know what is it about.
There is a piece of code that says abt a class AstVisitor which inherits fr IAstVisitor.
Not sure whether IAstVisitor is what I need, but I can't find it in the .NET Framework Class Library.
http://www.nootaikok.com/2009/01/c-code-generation-using-mgrammar.html[^]

Can someone show me some light on this issue? Would be v grateful...

The datatypes text and nvarchar are invompatible in the equal to operator

haleemasher23-Jul-09 18:21

Re: The datatypes text and nvarchar are invompatible in the equal to operator

23-Jul-09 18:21

when i update a gridview in transaction column it show error"The datatypes text and nvarchar are invompatible in the equal to operator"
transaction has nvarchar datatype

protected void btnSubmit_Click(object sender, EventArgs e)
    {
        try
        {

            ErrorMessage.Text = "";
            cnx.Open();
            SqlCommand insertCmd = new SqlCommand("INSERT INTO TransactionType([Transaction],Description,Category,Active) VALUES(@Transaction,@Description,@Category,@Active)", cnx);
            insertCmd.Parameters.Add("@Transaction", SqlDbType.NVarChar, 50);
            insertCmd.Parameters["@Transaction"].Value = txtProgram.Text;

            insertCmd.Parameters.Add("@Description", SqlDbType.Text );
            insertCmd.Parameters["@Description"].Value = txtdescrip.Text;

            insertCmd.Parameters.Add("@Category", SqlDbType.NVarChar ,50);
            insertCmd.Parameters["@Category"].Value = DdlCategory.Text;

            insertCmd.Parameters.Add("@Active", SqlDbType.NChar ,10);
            insertCmd.Parameters["@Active"].Value = DdlActive.Text;

            insertCmd.ExecuteNonQuery();
            ErrorMessage.Text = "Successful";
            cnx.Close();
        }
        catch (Exception ex)
        { 
            ErrorMessage.Text = ex.Message;
        }
    }

Christian Graus23-Jul-09 19:32

Christian Graus

23-Jul-09 19:32

The error means what it says. Your column is of the text type, not nvarchar.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: The datatypes text and nvarchar are invompatible in the equal to operator

Tamer Oz23-Jul-09 22:15

Tamer Oz

23-Jul-09 22:15

Check your parameters types with table scheme

Re: The datatypes text and nvarchar are invompatible in the equal to operator

haleemasher23-Jul-09 23:27

Incorrect syntax near the keyword 'Transaction'

23-Jul-09 23:27

i check the parameters it is of nvarchar

haleemasher23-Jul-09 17:48

Re: Incorrect syntax near the keyword 'Transaction'

23-Jul-09 17:48

i want to insert data into the sql database when i click on submit button it show error that incorrect syntax near the keyword 'Transaction'. i cann't find this error plz help

protected void btnSubmit_Click(object sender, EventArgs e)
    {
        try
        {

            ErrorMessage.Text = "";
            cnx.Open();
            SqlCommand insertCmd = new SqlCommand("INSERT INTO TransactionType(Transaction,Description,Category,Active) 
VALUES(@Transaction,@Description,@Category,@Active)", cnx);
            insertCmd.Parameters.Add("@Transaction", SqlDbType.NVarChar, 50);
            insertCmd.Parameters["@Transaction"].Value = txtProgram.Text;

            insertCmd.Parameters.Add("@Description", SqlDbType.Text );
            insertCmd.Parameters["@Description"].Value = txtdescrip.Text;

            insertCmd.Parameters.Add("@Category", SqlDbType.NVarChar ,50);
            insertCmd.Parameters["@Category"].Value = DdlCategory.Text;

            insertCmd.Parameters.Add("@Active", SqlDbType.NChar ,10);
            insertCmd.Parameters["@Active"].Value = DdlActive.Text;

            insertCmd.ExecuteNonQuery();
            ErrorMessage.Text = "Successful";
            cnx.Close();
        }
        catch (Exception ex)
        { 
            ErrorMessage.Text = ex.Message;
        }
    }

Curtis Schlak.23-Jul-09 18:07

Curtis Schlak.

23-Jul-09 18:07

In Microsoft SQL Server (and probably any other RDBMS that supports transactions), TRANSACTION is a reserved keyword.

Change your SQL to read

INSERT INTO TransactionType([Transaction],Description,Category,Active)
VALUES(@Transaction,@Description,@Category,@Active)

The square brackets indicate a name rather than a keyword.

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

Re: Incorrect syntax near the keyword 'Transaction'

haleemasher23-Jul-09 18:10