|
Hi Heath!
ok, thanks,
the code will remain like that...
by the way delegates are very convinient :P I can combine them with DirectX 
There is no spoon.
|
|
|
|
|
I did a windows usercontrol,when I put it to a webapplication, a error was happened what "System.Security.Permissions.FileIOPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed."
Because I had some file operations in my windows usercontrol. It may be something question of framework's config?
|
|
|
|
|
Hello jzb, I never saw this error but I know that wincontrol cannot get client machine information for security reasons. Maybe .NET thinks that your try to manipulate files isn't safe.
Good luck...
Wender Oliveira
.NET Programmer
|
|
|
|
|
This is not true at all. See my reply to the original post.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
You mean you embedded the Windows Forms UserControl in a web page? If you simply use it on the server, it won't matter.
If you embedded it in the web page (client-side), then the client's machine's code access security for .NET must be configured. Obviously you're using .NET 1.1 (since .NET 1.0 didn't grant applications in the Internet zone any permissions; thank you're truly as one of the people that asked Microsoft to change this in 1.0). You are only granted the following permissions, though:- Open File Dialog
- 10240 bytes of domain-isolated user storage
- Code execution
- Safe top-level windows
- Own clipboard
- Safe printing
So, you must add a code group to the user's machine. It is absolutely not recommended to chance the existing Internet_Zone code group, as this applies to all code run from the Internet, including that which you do not know and probably wouldn't trust.
Instead, add a code group. You can do this through a custom installer or running a command-line like so:
caspol.exe -m -ag All_Code -url http: Now, it's recommended you don't require FullTrust, but instead create a permission set with the privileges necessary. You can do this with XML files, custom actions, or other methods during installation.
For example, the GotDotNet Workspaces have a .NET UserControl that requires that you download a Windows Installer package (.msi; Visual Studio .NET can make these, as well as the Microsoft .NET Framework Configuration 1.1 snap-in, which is available in Administrative Tools). This installs a code group that allows the control to run. Restart Internet Explorer (since the CLR was already loaded by an unsuccessful attempt to load the control) and the control will load.
You can read more about code access security here on this site. Read Understanding Code Access Security[^]. You should also read the documentation in the .NET Framework SDK about code access security (although that article is comprehensive and very well-written, it's also good to hear straight from the horse's mouth). Read Securing Applications[^] and Configuring Security[^] in the .NET Framework SDK.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Hi gurus,
According to MS in the .NET Framework documentation, when they declare a delegate, they declare the parameters like that:
<br />
public delegate void AlarmEventHandler(object sender, AlarmEventArgs e);<br />
Is it an obligation that the parameter must be a derived class from the EventArgs class?
Are such declarations valid?
<br />
internal delegate void GameStatusChangedEventHandler(object sender, GameStatus gameStatus, int score, int level, int linesDone);<br />
<br />
internal delegate void LevelChangedEventHandler(object sender, int level);<br />
<br />
public delegate void ReceivedMessageEventHandler(object sender, String message);<br />
Should I create a derived EventArgs class for each delegates?
Thanks.
There is no spoon.
|
|
|
|
|
It's common to use the sender-eventargs-pattern, but it's not binding.
Also your custom eventargs doesn't have to be derived from the System.EventArgs class, but again this is a common approach.
www.troschuetz.de
|
|
|
|
|
ok, thanks. 
There is no spoon.
|
|
|
|
|
I have a panel which is located in a AutoScroll-enabled panel. The
problem is when I click in the panel, the contining panel
automatically scrolls to position (0,0).
How can I get around this annoying behaviour?
|
|
|
|
|
i want to create a form and show it in a thread. Like this code:
Thread th = new Thread(new ThreadStart(t));
t.Start();
void t()
{
Form2 f2 = new Form2();
f2.Show();
}
-----------------------
But it doesnt work. How to deal with it ?
|
|
|
|
|
what is happening is your thread starts and shows the form and then it's done showing the form and the thread "dies". Do you see the form flash real fast?
I believe you have to make your form modial.
AND to do this, use .ShowDialog() instead of .Show()
happy birthday
/\ |_ E X E GG
|
|
|
|
|
Hi, I'm going to need to execute SQL statement against MySQL, Oracle and MS SQL, just wondering if there's anything from Source Forge which help abstract away the detail.
Thanks.
Norman Fung
|
|
|
|
|
norm wrote:
just wondering if there's anything from Source Forge
Then why not look there ?
Personally, I'd write stored procedures for each database, and then have the differences of SQL version within the stored procedures. Then your data access code does not have to change, the changes are within the layer that requires it: the database itself.
Christian
I have drunk the cool-aid and found it wan and bitter. - Chris Maunder
|
|
|
|
|
That'd be ADO.NET itself. It already is an abstract API. In .NET 2.0, a provider pattern will make it more abstract, but for now you can simply use the System.Data.OleDb namespace. MySQL, Oracle, SQL Server, and many others (including Excel, Fox Pro, ...) all have OLE DB drivers, so all that would change is your connection string (although some providers don't provide all the same features, so make sure you do some exception handling).
So, just for a crude example:
public enum DbProvider
{
MySQL,
Oracle,
MSSQL
}
public OleDbConnection GetConnection(DbProvider provider)
{
OleDbConnection conn = null;
switch (provider)
{
case DbProvider.MySQL:
conn = new OleDbConnection("Provider=MySQLProv;Data Source=mydb;" +
"User ID=me;Password=12345;");
break;
case DbProvider.Oracle:
conn = new OleDbConnection("Provider=msdaora;Data Source=oradb;" +
"User ID=sa;Password=;");
break;
case DbProvider.MSSQL:
conn = new OleDbConnection("Provider=SQLOLEDb;Data Source=DBSERV1;" +
"Initial Catalog=northwind;Integrated Security=SSPI;");
break;
}
return conn;
}This isn't the best way to do it, though. By using an enum, you basically hard-code the choices (unless you want to). A better way might be to put the connection string in the .config file so you can change it to use a different provider at any time (though changes to the .config file in all but ASP.NET requires that you restart the application; even the ASP.NET web application must be restarted, though this happens automatically by a worker process).
You can also use the typed classes (like System.Data.SqlClient for SQL Server, System.Data.OracleClient for Oracle, etc.) and refer to them by their abstract base classes, or the interfaces (like IDbConnection and IDbCommand). You can find more providers online by doing a google search.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Hi,
I am using a C# code to insert a data in SQL Server.
Stored Procedure which inserts data is created as :
-----------------------------------------
CREATE PROCEDURE spAddNewAddress
@AddressID char, @AddressType char, @HomeAddress varchar,
@City varchar, @State varchar, @Zip varchar, @Country varchar
AS
INSERT INTO Address VALUES(@AddressID, @AddressType, @HomeAddress,
@City, @State, @Zip, @Country)
GO
-----------------------------------------
Then C# code which inserts data is :
public void insertNewData(Address a)
{
try
{
//create sql string
sqlAddress = "spAddNewAddress";
//Open the connection
scAddress.Open();
//create the cmdAddress
cmdAddress = new SqlCommand(sqlAddress, scAddress);
cmdAddress.CommandType = CommandType.StoredProcedure;
//adding parameters for command
cmdAddress.Parameters.Add("@AddressID",SqlDbType.Char,10);
cmdAddress.Parameters["@AddressID"].Value = a.getAddressID();
cmdAddress.Parameters.Add("@AddressType",SqlDbType.Char,1);
cmdAddress.Parameters["@AddressType"].Value=a.getAddressType();
cmdAddress.Parameters.Add("@HomeAddress",SqlDbType.VarChar,100);
cmdAddress.Parameters["@HomeAddress"].Value=a.getHomeAddress();
cmdAddress.Parameters.Add("@City",SqlDbType.VarChar,25);
cmdAddress.Parameters["@City"].Value=a.getCity();
cmdAddress.Parameters.Add("@State",SqlDbType.VarChar,25);
cmdAddress.Parameters["@State"].Value=a.getState();
cmdAddress.Parameters.Add("@Zip",SqlDbType.VarChar,25);
cmdAddress.Parameters["@Zip"].Value=a.getZip();
cmdAddress.Parameters.Add("@Country",SqlDbType.VarChar,70);
cmdAddress.Parameters["@Country"].Value=a.getCountry();
cmdAddress.ExecuteNonQuery();
//clean up code
cmdAddress.Dispose();
scAddress.Close();
}
catch(Exception ex) { Console.WriteLine(ex.ToString() ); }
-----------------------------------------
Code executes with out any trouble (no breaks/errors or exceptions).
Only problem is when i try to view this data in SQL Server's Enterprise Manager, only first letter of the inserted data appears.
e.g : If inserted AddressCode = A03C0001 then in the EnterPrise Managers it appears as :
"A".
Another strange thing, if try to query database with AddressCode="A", it generates error (that data don't exists).
Although If you try to query database with AddressCode="A03C0001", then it extracts complete information as inserted.
any suggestions!!!!!
|
|
|
|
|
ronin1770 wrote:
cmdAddress.Parameters.Add("@AddressID",SqlDbType.Char,10);
cmdAddress.Parameters["@AddressID"].Value = a.getAddressID();
cmdAddress.Parameters.Add("@AddressType",SqlDbType.Char,1);
cmdAddress.Parameters["@AddressType"].Value=a.getAddressType();
I didn't see AddressCode from your code, is it AddressID? You may have mixed up the order of the columns AddressID and AddressType. To prevent this, your insert statement should look like the following:
insert into Address(FieldName1,FieldName2,...) values(FileValue1,FieldValue2,...)
My articles and software tools
|
|
|
|
|
HI,
i tried the way u suggested... it was never the order of fields
but no success so far...
it is beyond my understanding... probably problem with SQL Server Instance
|
|
|
|
|
If the database returns the data you asked it to insert, then it is there, the problem can only be in how you are viewing the data within SQL server. If you do a select of everything in the table, what does that look like ?
Christian
I have drunk the cool-aid and found it wan and bitter. - Chris Maunder
|
|
|
|
|
Since You Have Given DataType As Char For AddressCode and AddressType, It will store Only one char. Better user Varchar(size) in the creation of Store proc, It will Execute fine and u can see what u have inserted.
|
|
|
|
|
The problem isn't your code but your procedure. When you declared "varName varchar" SQL see it like one char variable. If you want to use more than one char you must to declare "varName varchar(10)" for a 10 chars variable.
Cya
Wender Oliveira
.NET Programmer
|
|
|
|
|
|
The last two replies are correct, in that you're not declaring your field as a string, but are instead declaring it as a char.
I wanted to add that the above code can be made much more efficient by not using the indexer to access your param. The SqlParameterCollection.Add overload you're using returns a SqlParameter, so you can either type .Value = value; immediately after your closing parenthesis, or store the return value from Add to a SqlParameter variable and assign the value from there. The latter way works best when executing a batch of statements (add the parameters to the command and loop to add each iteration's values without re-adding the params again; execute the command with each iteration).
This will result in better performance, since a string lookup on a collection can be very slow (mO(n) processing time, where n is the number of items in a collection and m is the number of iterations; compare that to O(m)).
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
CREATE PROCEDURE spAddNewAddress
@AddressID char, @AddressType char, @HomeAddress varchar,
@City varchar, @State varchar, @Zip varchar, @Country varchar
AS
INSERT INTO Address VALUES(@AddressID, @AddressType, @HomeAddress,
@City, @State, @Zip, @Country)
GO
In the above parameters, a size needs to be added:
@AddressID char(nn), @AddressType char(nn), @HomeAddress varchar(nn),
@City varchar(nn), @State varchar(2), @Zip varchar(9), @Country varchar(nn)
where the "nn" is the size of the field.
|
|
|
|
|
I have a struct explicitly defined in C# as
[
Guid("FE9814A3-D198-4bd0-8475-D055DAA7C659"),
StructLayout(LayoutKind.Sequential)
]
public struct _alloc
{
public _alloc(short a,short b)
{
sx= a;sy=b;
}
public short sx;
public short sy;
}
The following struct contains a pointer member to _alloc in COM IDL
typedef
[
uuid(649B2720-373B-46a4-BC1F-6B53CC38755D),
version(1.0),
helpstring("A Demo struct typedef for Marshal")
]
struct _groupalloc {
_alloc* lx;
short ly;
} _GroupAlloc;
I tried to define it as follows in C#
[
Guid("649B2720-373B-46a4-BC1F-6B53CC38755D"),
StructLayout(LayoutKind.Sequential)
]
public struct _groupalloc
{
public _alloc[] sx;
public short sy;
}
This is to be used in a method definition as follows,to marshal it to COM
int GetComplexStruct(ref _groupalloc _pc);
I get the runtime error - 'cannot marshal field sx of _groupalloc - it cannot be marshalled as member of struct'.
What is the principle behind this?Why cant an array be marshalled as member of a struct - if someone could give pointers to related articles too,apart from the answer to the above;that would be appreciated.
thanks and regards.
|
|
|
|
|
You could declare the member as an IntPtr, then use GCHandle and the Marshal class (specifically it's PtrToStructure method).
If you want to marshal an array, you must also use the MarshalAsAttribute to provide additional information, like the size or size param. When marshaling from unmanaged to managed code, the size of an array is known so this information is needed for the marshaler to construct the managed array.
For more information on marshaling, read Interop Marshaling[^] in the .NET Framework SDK.
If you want more information, read about the classes and methods I mentioned above and continue this thread if you have additional questions.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
