C# Discussion Boards - CodeProject

Re: General question Class Library project

18-Nov-07 8:10

You would normally have your class library project in the same solution as the other projects you are working on. The debgging is seamless and flows through from one project to another.

Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland

My website

Khoramdin18-Nov-07 8:33

Khoramdin

18-Nov-07 8:33

Hello Colin,

Thanx for the reply. You are absolutly correct if the Class Library was created for an exsisting project. I am not able to do so since the Class Library is for creating a Browser Helper Object (BHO). That is why I am using Attach Process to attach it to IE Browser.

I am trying to undrestand the way Class Library works in Visual Studio, so I can solve the issue I am currently facing.

Thank you for taking the time and respond. Any information in regard with this is greatdly appriciated, Colin.

Have a great weekend.

Khoramdin

checking, is row exists in table?

Xmen Real 18-Nov-07 5:04

Xmen Real

18-Nov-07 5:04

hi all,
i have problem that i m unable to use ExecuteNonQuery() and "EXISTS" of sql

i want to check in my table that the required row is exists or not
i used ExecuteNonQuery() but it always returns -1
codes

dataCommand.CommandText = "select * from tabel1 where id = '" + label1.Text + "'";
            int check = dataCommand.ExecuteNonQuery();
            if (check > 0)
            {
                MessageBox.Show("this is already exists");
                return;
            }

for temporary i m using SQLDataReader's HasRows bool

can someone have another best solution?

Becoming Programmer...

Colin Angus Mackay18-Nov-07 5:18

18-Nov-07 5:18

SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT COUNT(*) FROM table1 WHERE id = @id";
cmd.Parameters.AddWithValue("@id", label1.Text);
cmd.Connection = myConnection;
int count = cmd.ExecuteScalar();
if (count > 0)
{
    // Do stuff
}

Please also note that the above uses a parameterised query thus reducing the posibility of a SQL Injection attack. You may also like to read SQL Injection Attacks and Tips on How To Prevent Them[^]

Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland

My website

Xmen Real 18-Nov-07 14:23

Xmen Real

18-Nov-07 14:23

yeah it will work but why microsoft made "EXISTS" function in sql ...?? Confused | :confused:

Becoming Programmer...

Colin Angus Mackay18-Nov-07 14:25

18-Nov-07 14:25

xmen_xwk wrote:
yeah it will work but why microsoft made "EXISTS" function in sql ...??

So you can do this:

IF EXISTS (SELECT * FROM MyTable WHERE SomeColumn = @SomeValue)
BEGIN
    -- Do stuff here based on whether any rows exist.
END

Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland

My website

Page Setup in ReportViewer

Xmen Real 18-Nov-07 14:32

Xmen Real

18-Nov-07 14:32

oh yeah, i tried this and in body i tried to return 0 or 1
but it gave errors, but now i have a good way that you told
thanks CAM

Becoming Programmer...

Next Questions...

Jeffrey Walton18-Nov-07 3:21

Jeffrey Walton

18-Nov-07 3:21

Hi All/Luc,

Is there a Big Integer package in C#? I don't want to jump through API hoops to do big math (nothing like the suffering of attaching an image list to a tree view Smile | :)

). Next, is there a Bas64 Encoder/Decoder available in C#?

I seem to be pulling lower quality suggestions from Google. So rather than jump into it, I'll wait for the advice.

Thanks,
Jeff

Re: Next Questions...

Luc Pattyn18-Nov-07 3:43

Luc Pattyn

18-Nov-07 3:43

Hi Jeff/All,

1.
there are several big integer packages publicly available. Maybe the most acclaimed one is
GMP (GNU Multi-Precision). IIRC its written in C++, I haven't seen a .NET wrapper for it though.

And there are some articles on CodeProject[^] covering this (with different capabilities and
qualities). Much depends on what it is you want to achieve.

2.
Not sure what you mean, maybe Convert.FromBase64String() and its sibblings will help you.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

this months tips:
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use PRE tags to preserve formatting when showing multi-line code snippets

Re: Next Questions...

Jeffrey Walton18-Nov-07 9:37

Jeffrey Walton

18-Nov-07 9:37

Luc Pattyn wrote:
And there are some articles on CodeProject[^]

I wrote the first article.... I'll get a port together to C#. Do you want to coauthor? I'll have problems with the Managed/Unmanaged thunk. (This is my third day on C#.)

Luc Pattyn wrote:
Maybe the most acclaimed one is GMP (GNU Multi-Precision).

I'm a Crypto++ man myself. Years ago (circa 1998), I was never able to get a clean port of GMP to Windows.

Luc Pattyn wrote:
Not sure what you mean, maybe Convert.FromBase64String()

Perhaps - I'll have to look at it.

Luc Pattyn wrote:
Much depends on what it is you want to achieve.

This is going to be an article on Crypo++ interoperability with other Crypto Libraries and standards. The first article in this series is (somewhat out of order) is ASN.1 Object Identifier Encoding and Decoding[^]. It became such a large topic, it was spun off. In reality, it was supposed to be part of a Cryptographic Certificate Parser (*.CER, *.P7B, etc).

The TreeView is used for displaying results of the parser - the icons are a UI element aiding in vidualization of the message structure.

Jeff

Re: Next Questions...

Luc Pattyn18-Nov-07 9:56

Luc Pattyn

18-Nov-07 9:56

Jeffrey Walton wrote:
I'll get a port together to C#. Do you want to coauthor? I'll have problems with the Mnanaged/Unmanaged thunk

Hi Jeff, that's something we can look into. I'll send you an e-mail...

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Davood Riazi18-Nov-07 2:54

Davood Riazi

18-Nov-07 2:54

Hi,when i run my project in C# it dosen't define ReportViewer1.BorderStyle="solid" code that i have wrote in my ReportForm.Cs source file.How can i write code like this with out using ReportViewer Toolbar before running the project to define my Report Page setup as like as Border Style seting ,page setup setting for example my papaer size to be A4 and margin setting and other properties of my Report without defining these properties at running time or design time only with writing code in source file in my report from ?

thanks

D.Riazi

-- modified at 8:40 Sunday 18th November, 2007

D.Riazi

How can I run exe file?

ahawari0918-Nov-07 0:32

ahawari09

18-Nov-07 0:32

Hi,

I am trying to run the exe file that was generated by vs.net in another computer, but it posts an error message and I can not run it. How can I do this please. Thanks.

Hawari

hawari

Anthony Mushrow18-Nov-07 0:42

Anthony Mushrow

18-Nov-07 0:42

What is the error message?

My current favourite word is: PIE!

Good ol' pie, it's been a while.

ahawari0918-Nov-07 1:13

ahawari09

18-Nov-07 1:13

Hi,
This is the error message "The application failed to initialize property (0xc0000135)". Thanks

hawari

hawari

Luc Pattyn18-Nov-07 1:28

Luc Pattyn

18-Nov-07 1:28

That is the cryptic message Microsoft has designed to tell you you don't have
(the right version of) the .NET Framework. So decide which version you need,
look for the download site and install it.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Colin Angus Mackay18-Nov-07 2:46