C# Discussion Boards - CodeProject

zecodela16-Sep-03 4:07

16-Sep-03 4:07

ha!
my boss requested me to make a single installer to deploy a db app. developed in both C# and C++. most difficult part is installing the mysql database. i am using some batch file to start the database service stuffs... quite trouble to deal with.

Re: deployment help

sumeat16-Sep-03 11:20

sumeat

16-Sep-03 11:20

Hi,

I recently had to build a installation program to install my application and I tried to do it using the "Deployment" project in Visual Studio.Net. After much research and help from the folks on this message board I was able to build the installation package.

There are 2 things to be done:

1. Create a new project of type "Deployment" and add all the components of your application to this project. You can specify the folders they need to be on the target computer, the icons/shortcuts on the desktop, the item in the Start->Program Menu, etc.

On building this project it will generate a .wsi file, a setup.exe along with other files. All the files generated in the Debug directory constitute the installation package.

The above package will run perfectly on any computer as long as it has .NET framework installed on it. If not then you have do the second thing.

2. Download the BootStrapper sample from the following link:

http://www.microsoft.com/downloads/details.aspx?FamilyId=BF253CFD-1EFC-4FC5-BA7E-6A6F21403495&displaylang=en

Its in unmanaged C++. Build it and it will generate a setup.exe. It also has a settings.ini file.

Copy the setup.exe and settings.ini into a folder, say, myfolder. Then copy the .wsi generated in step 1 above into myfolder. Then copy the dotnetfx.exe (the .net framework installer) into myfolder.

The dotnetfx.exe can be downloaded from here:
http://www.microsoft.com/downloads/details.aspx?FamilyId=D7158DEE-A83F-4E21-B05A-009D06457787&displaylang=en

All files in myfolder now constitute your new installation package. This installation will first check if .NET is installed or not on the target computer, if not, then it will silently install it and then it will install your application.

I hope this helps.

Suhas

Re: deployment help

zecodela16-Sep-03 13:48

zecodela

16-Sep-03 13:48

oh! really thanks! i have tried what you said... but, i need to do a bit more such as install mysql, startup mysql service... i am thinking to make a executable to do this and use a batch file to run it.

let me make such a "not so elegrant solution" first and see if my boss accept. otherwise, ask him to buy a deployment tools.

indeed, i don't know why detecting framework existance is so important but not included in the deployment tools.

problem with stringwriter

KSEI15-Sep-03 18:32

KSEI

15-Sep-03 18:32

Hi,

I have a problem with saving a long text with newline characters in richtextbox control to a txt file.
I'm using streamwriter to save the text. But the text in the file don't recognize the new line character.

Can anyone help solving this problem?

Re: problem with stringwriter

Daniel Turini16-Sep-03 1:01

Daniel Turini

16-Sep-03 1:01

Could you give us a small piece of code of what you are trying to do?

You can do it on anything you choose - from .bat to .net - A customer

Re: problem with stringwriter

KSEI16-Sep-03 17:08

KSEI

16-Sep-03 17:08

This is the example text of richtextbox that i want to save to a txt file :
1. xxx...(the new line)
xxx...(the new line)
2. xxx... (the new line)
xxx...(the new line)
.
.
.
(and so on)

The text in the txt file:
1. xxx...xxx...2. xxx...xxx...

So, this is the problem. Great thx for helping. Smile | :)

C# Web Message Box

gmhanna15-Sep-03 14:13

gmhanna

15-Sep-03 14:13

Hi,

I can't seem to locate a message box function for Web Based C#. Does anyone know how to do this, or have a Message Box control that I can add to my toolbox?

Thanks,

Glenn

Re: C# Web Message Box

Nick Seng15-Sep-03 15:42

Nick Seng

15-Sep-03 15:42

There are no server controls for messageboxes in Web Apps. The closest you can do is use the alert() javascript in the client-side scripting

Support Bone

Dialogs to Forms

gmhanna15-Sep-03 14:11

gmhanna

15-Sep-03 14:11

I have about 40 different dialogs that I would like to convert to a Form, because they are easier to work with and I don't have to write Win32 code to support them.

Does anyone know how to convert dialog boxes to C# Forms?

Thanks,

Glenn

Calling C routine from C#

gmhanna15-Sep-03 14:07

gmhanna

15-Sep-03 14:07

I have a fairly large application that I want to add a web interface to. The application is designed as a two layer application. The user interface and the so called API, which does all the work.

I would like to be able to call the API which is written in pure C with no operating system dependencies except for telecommunications.

I have tried to add a reference in VS.NET to the API's .DLL but it doesn't allow me to.

Is there an easy way to do this with out converting the entire application to C#? For fun, I tried to compile it using VS.NET 1.1 as a C++ application and the 1st program out of about 200 gave me 100+ errors.

Converting it to compile under VS.NET C++ I thought would be easy, but would take too long. Anyone have any ideas??

Oh BTW, my compiler that I'm currently using for my C development is Watcom 10.6B. I know its old and unsupported but I understand it. I'm trying to learn VS.NET...

Thanks,
Glenn

Re: Calling C routine from C#

Nick Seng15-Sep-03 15:50

Nick Seng

15-Sep-03 15:50

You could try using P/Invoke, which would involve some [DllImport] usage. P/Invoke[^]

Support Bone

SQL anyone ?

Frank Olorin Rizzi15-Sep-03 10:18

Frank Olorin Rizzi

15-Sep-03 10:18

So, ehr...
..hope you won't think that this question is in the wrong forum, but..

You remember all the good'ol'SQL APIs like SQLConnect, SQLFetch, ... ?
How can I access those from a C# app?

I've tried to use the System.Data.SqlClient namespace stuff,
but that is targetted for SQL Server DBs,
and I am just trying to do something more ODBC-oriented (i.e. that would
work with other DBMS as well).

To be specific: I really, really, **really** need to
execute an SQL<foo> call (rather than using Data Sets, and such).
Is it possible in C#, or should I just go back to C++ ?

Suggestions anyone?

Thanks in advance,
F.O.R.

Re: SQL anyone ?

Rob Graham15-Sep-03 11:02

Rob Graham

15-Sep-03 11:02

1. System.Data.OleDbClient

2. SqlConnection,SqlCommand and OleDbConnection,OleDbCommand can execute SQL statements. You can use an OleDbDataReader (SQlDataReader if MSSQL) to retun records in a fast forwar-only cursor and do as you wish with the data. xxxCommand and xxxConnection can also execute quries that have no return data or onlay a single scalar value.

Genius may have its limitations, but stupidity is not thus handicapped. - Elbert Hubbard

Re: SQL anyone ?

Frank Olorin Rizzi16-Sep-03 1:24

Frank Olorin Rizzi

16-Sep-03 1:24

Thanks Rob,
but that's not exactly what I was looking for.
I suspect I'll end up moving to C++ one way or the other Smile | :)

Thanks again,
F.O.R.

Re: SQL anyone ?

Arjan Einbu15-Sep-03 11:08

Arjan Einbu

15-Sep-03 11:08

Look at the System.Data.Odbc (only in 1.1) and System.Data.OleDb namespaces for setting up connections and executing commands etc.

The OdbcCommand and OleDbCommand objects both have the ExecuteNonQuery method (and more) to execute SQL statements without involving DataSet and DataTable objects...

Re: SQL anyone ?

Frank Olorin Rizzi16-Sep-03 1:24

Frank Olorin Rizzi

16-Sep-03 1:24

Hmmm...
..I didn't know that 1.1 had an Odbc namespace!

I'll take a look, thanks Smile | :)

F.O.R.

Re: SQL anyone ?

Daniel Turini16-Sep-03 0:54

Daniel Turini

16-Sep-03 0:54

While the previous answers were complete and technically correct, why do I still have the feeling you are using the wrong tool for the job?

You can do it on anything you choose - from .bat to .net - A customer

Re: SQL anyone ?

Frank Olorin Rizzi16-Sep-03 1:27

Frank Olorin Rizzi

16-Sep-03 1:27

Because indeed I am.

I am looking for something that has a 1:1 correspondence to the sql.h library from C/C++.
Now, while C# has alternatiuve ways to achieve the same goals (all of the Data namespace, for instance), I am not surprized to find that C# keeps you away from such low level kind of stuff.

It indeed makes much more sense for me to use a C++ (managed or not) app in this case,
but I figured I could look around for a bit before giving up on being more modern Smile | :)

F.O.R.

Re: SQL anyone ?

Frank Olorin Rizzi16-Sep-03 3:12

Frank Olorin Rizzi

16-Sep-03 3:12

OK, before I give up on this, let me rephrapse the question Smile | :)

Any way I can stick in a C# App the following lines?

<br />
sqlr = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &h_env);<br />
sqlr = SQLSetEnvAttr(h_env, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, SQL_IS_UINTEGER);<br />

and other statements like that ?
They are taken from a C/C++ app that includes <sql.h> and <sqlext.h>.

Maybe I can place them in an un-managed section?
It would solve soooo many problems !

Thanks in advance for any input,
F.O.R.

Re: SQL anyone ?

Jim MacDonald19-Sep-03 10:29

Jim MacDonald

19-Sep-03 10:29

This is just a shot in the dark but you could take a look at addng a COM reference to the Microsoft SQLDMO Object Library. You might find what you need in there.

html to image component

shaiotz115-Sep-03 7:07

shaiotz1

15-Sep-03 7:07

if anyone have a good idea about how to creat an html to image component
i tried :
A.
capture a web browser controll
prob
1. a win form app , we need to put the web controll inside A dll file. and that a little messy ...
2.when u capture it will only get what u c ...
and not the whole page.
B.
generating a url file on the server
then open this file with the windows shell getting the
image that gnerated by the server
prob. wont work on windows 2003 server.

Any help or idea would be most welcome ! Smile | :)

Re: html to image component

Jasper4C#15-Sep-03 8:28

Jasper4C#

15-Sep-03 8:28

try to start search from here:

Thumbnail Generator Web Service

Description: The Thumbnail Generator Web Service creates a .gif image of a specified URL.

<br />
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=836c770f-89eb-4041-ba7c-ff870a57cca1<br />
<br />
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/shellcc/platform/shell/reference/ifaces/iextractimage/iextractimage.asp<br />

Found from here:

<br />
http://www.gotdotnet.com/community/messageboard/Thread.aspx?id=75039&Page=1#75057<br />

"I have not failed.
I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)

Re: html to image component

shaiotz115-Sep-03 22:53

shaiotz1

15-Sep-03 22:53

thnx for the reply,
i alrady tried the web service , its very nice but wont work on the 2003 servers, or xp machine u get an exception when u try to extract the image with the iextractimage interface ,
the same code work with win 2000 wont work with 2003 ...

Re: html to image component

Jasper4C#16-Sep-03 5:17

Jasper4C#

16-Sep-03 5:17

Never saw this on work Frown | :(

Sorry - once I've searched the net for this info and this what I found. Never used it and didn't know if this work.

P.S. This is strange that some interfaces (!!!) doesn't work somewhere Cry | :((

May be it's depends on browser version ??

"I have not failed.
I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)

calling API dll functions - types?

Tym!15-Sep-03 7:02

Tym!

15-Sep-03 7:02

I have seen several helpful examples of how to call API functions but I am confused about translating the data types. For example, I have seen DWORD parameters translated to both int and uint in c#. I am using a function that has a char[] parameter which I think should be translated as sbyte, but I'm just not sure. Any direction on a good reference for this?

Tym!

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