Re: Need no setup... - C# Discussion Boards

How to customize the printPreviewDialog?

11-Nov-03 7:06

Besides the .NET Framework (which MUST be installed), you can use touchless deployment by writing your application correctly, i.e. rely on .config files only (no registry).

The application I architected runs both from local or LAN machines, or from across the Internet or an intranet with no change. The assembly binding uses the current codebase of the application plus any private paths your config files specifies (see the <runtime> section documentation in the .NET Framework SDK).

You also need to worry about code access permissions, though. In .NET 1.0, the default Internet Zone allows no code to run. In .NET 1.1 some basic permissions are granted to code running from the Internet. You can change or add these code policies, though. There is plenty of documentation about code access security in the .NET SDK Documentation. Just look for "code access security". I'm also working on an extensive article or chain of articles but it'll be some time.

It's important to read, though, because you really must understand them before using them. You don't want to open someone's machine to attach by accident, and you want to make your application work with different permissions granted, i.e. some are required and some are optional. Take a look at the System.Security.Permissions namespace classes for more information about this stuff, as well as the documentation for code access security.

If you don't need to run from a remote source, you don't necessarily have to worry about it (although it's still a good idea to check permissions in your app before executing an action that requires them, otherwise a SecurityException is thrown). Just use COPY/XCOPY to copy your apps and dlls to the local machine and make sure they are in the right place. You can leave all the exes and dlls together with no problem. You can use the application configuration file to specify additional paths, similar to what ASP.NET Web Matrix does.

-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----

Member 67887511-Nov-03 4:39

Member 678875

11-Nov-03 4:39

For example,to add a new toolButton in the ToolBar of printPreviewDialog ,or add a new label or textBox in it.
thanks a lot.
Smile | :)

Re: How to customize the printPreviewDialog?

Heath Stewart11-Nov-03 7:00

11-Nov-03 7:00

You'll need to derive from PrintPreviewDialog and use a combination of adding and removing controls with the Controls collection property, and overriding the WndProc to handle lower-level functions.

protect my program

eafares26511-Nov-03 3:56

eafares265

11-Nov-03 3:56

i have to protect my program so please if some one know any way to protect it from being coppied to another computer maybe( we use the computer number).

Re: protect my program

Heath Stewart11-Nov-03 6:57

extended procedure for sql server

11-Nov-03 6:57

Take a look at my article at http://www.codeproject.com/dotnet/xmldsiglic.asp[^]

mhmoud rawas11-Nov-03 1:20

mhmoud rawas

11-Nov-03 1:20

HI ,
I have made a procedure for sql server with visual c++ and i have test it on my computer and it is well but when i have move it to the server it could not work and it give me the following error

ODBC: Msg 0, Level 16, State 1
Cannot load the DLL sim.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

can any body help me

Heath Stewart11-Nov-03 3:10

11-Nov-03 3:10

First, make sure it's in the Binn directory for the appropriate SQL server instance. I'm sure you've problem done that.

The big thing to remember is that servers often don't have the latest and greater technologies - only that which is required to run. My common mistake (I seem to make it every time but quickly realize what's wrong) is that I developed XP's in VS.NET 2002 or 2003 which uses the VC++ runtime 7.0 or 7.1 respectively. Our SQL Server doesn't have either of those runtimes. This is most likely your problem.

You can either "blindly" copied msvcr70.dll or msvcr71.dll and any other dependencies to %WINDIR%\System32 or to the appropriate Binn directory (or anywhere else in the %PATH%, although those two places are the logical choices). To make sure you get all the dependencies, run depends.exe (from the Platform SDK which was probably installed with your Visual Studio or is available for free online) on your XP (extended proc, not Windows XP Smile | :)

) and see what is required. Make sure those files exists on the server somewhere in the %PATH%. You could also copy depends to the server and run it on your XP from there - it'll tell you what's missing.

mhmoud rawas11-Nov-03 18:43

mhmoud rawas

11-Nov-03 18:43

thanks v.much it was the msvcr71.dll missing file on the server, but the strange thing that i have use wise installer to install that library from it, i have make an installation file which contain the merge module of VC++ library and it did not work so when i have copy the file to the server it works so thank you for your help and in the next time i will write this question in the SQL section

Heath Stewart11-Nov-03 18:55

11-Nov-03 18:55

The merge module probably doesn't contain the right version of the VC++ runtime. To my knowledge (and I've beta tested and used WFWI since before 1.0), they have not yet released MSMs for newer runtimes (???). If they have, make sure you use the right MSMs. If nothing else, nothing special is needed to just copy them to the [SystemFolder] directory.

Heath Stewart11-Nov-03 3:12

Re: Right to left problem

11-Nov-03 3:12

Oh...and wrong forum! Smile | :)

This would be better in the VC++ or SQL forum (and more is more likely to get answered there). Just for future reference...

Right to left problem

Mohaqeq200211-Nov-03 0:41

Mohaqeq2002

11-Nov-03 0:41

When I try writing a mathematic expertion with a right to left language in textbox or list box arrange of words change and expertion left to right arrange (for mathematic expertion) change to rihgt to left and it will be more confusing and not readable please tell me how I can stop this conversion

Heath Stewart11-Nov-03 3:19

Is MS Access transaction-aware?

11-Nov-03 3:19

FWIW, I think you mean "expression".

The problem is simple. While every other control mode is a right-to-left reading order, simply make that TextBox read from left-to-right by setting TextBox.RightToLeft (inherited from Control) to RightToLeft.No. If you read the documentation for the RightToLeft enumeration, you'll see the "rules" for how the RightToLeft property is resolved. By setting this property to "No", it will always read from left-to-right.

If the TextBox could have other text besides a mathematical expression, then you'll need to do some checking. You could handle the TextChanged event and parse the text to see if it contains a methematical expression. If it does, then change the RightToLeft property accordingly.

CillyMe10-Nov-03 23:53

10-Nov-03 23:53

Is MS Access "Transaction Aware"?

Hesham Amin11-Nov-03 0:41

Hesham Amin

11-Nov-03 0:41

You can make transactions in access DB..
in classic ADO :

con.BeginTrans<br />
..if things go right :<br />
con.CommitTrans<br />
..else<br />
con.RollbackTrans

where con is a connetion object.

CillyMe11-Nov-03 2:02

11-Nov-03 2:02

so, I assume it can participate in a COM+ transaction?

CillyMe11-Nov-03 2:50

11-Nov-03 2:50

I meant to say, can it participate in a COM+ transaction in following manner:

[Transaction(TransactionOption.Required)]
... other stuff ...
public class AccessDbManager
{
...
public void UpdateClientProfile(...);
public void UpdatePosition(...);
public void GetPosition(...);
...
}

I'm asking this because there's a piece of code that worked perfectly fine in a C# console app, but failed mysteriously when I embed it inside one method of a Transaction enabled serviced component... Here's the code. I tested it many times. It worked in a C# console app.

int count = -1;
string db_username;
string db_passwd;
int db_numlogin;
string connString;
OleDbConnection connUsers;
OleDbDataAdapter daUsers;
DataSet dsUsers;

EventLog log = new EventLog("Application");
log.Source = "AccessDbMaster";

try
{ //try block

retcode = -1;

connString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Program Files\SomeDir\datasource\users.mdb; User ID=Admin; Password=";
Trace.WriteLine(connString);

connUsers = new OleDbConnection(connString);
daUsers = new OleDbDataAdapter("SELECT * FROM Users WHERE username='"+ username + "' AND passwd='" + passwd + "'", connUsers);
dsUsers = new DataSet();

**********************************************************************
daUsers.Fill(dsUsers, "Users"); //BOOM. Failed here. "No error information available: E_NOINTERFACE(0x80004002)."

**********************************************************************

count = dsUsers.Tables["Users"].Rows.Count;

if(count==0) {
log.WriteEntry("AccessDbMaster authentication failed. User not found");
return;
}

foreach(DataRow user in dsUsers.Tables["Users"].Rows)
{
db_username = user["username"].ToString();
db_passwd = user["passwd"].ToString();
db_numlogin = (int) user["numlogin"];

retcode = db_numlogin; //return value

//Increment number of login:
db_numlogin++;
user["numlogin"]=db_numlogin;
}

OleDbCommandBuilder cmdBuilder = new OleDbCommandBuilder(daUsers);
daUsers.Update(dsUsers, "Users");

connUsers.Close();

} //try block
catch(Exception err)
{
log.WriteEntry("AccessDbMaster authentication failed. Info: " + err.Message);
retcode=-1;
ContextUtil.SetAbort();
}

I'm not out of the woods yet. Any advice will be greatly appreciated.

Hesham Amin11-Nov-03 7:44

Hesham Amin

11-Nov-03 7:44

I believe it can Smile | :)

CillyMe11-Nov-03 16:47