SqlClientPermis sion error

[mmb]

hi all
i used this below function to connect to sql server 2k

[SqlClientPermis sion (SecurityAction .Assert ,Unrestricted=t rue)]
private void button1_Click(o bject sender, System.EventArg s e)
{
try
{
SqlClientPermis sion myPerm = new SqlClientPermis sion(Permission State.Unrestric ted);
myPerm.Assert() ;
myPerm.AllowBla nkPassword=true ;
string str;
str= "data source=sniper;i nitial catalog=newzolf ;persist security info=False;user id=zolf;" +
"password=1;pac ket size=4096";
SqlConnection cnn=new SqlConnection(s tr);
SqlCommand cmd=new SqlCommand("sel ect * from article",cnn);
cnn.Open();
MessageBox.Show ("3");
DataSet ds=new DataSet();
MessageBox.Show ("4");
SqlDataAdapter da=new SqlDataAdapter( cmd);
MessageBox.Show ("5");
da.Fill(ds);
MessageBox.Show ("Sucess");
}
catch(Exception ex)
{
MessageBox.Show (ex.Message);
}
}
when run application on own computer work truly
but when copy the EXE file to shred folder this error accoured

Request for the permission of type System.Data.Sql Client.SqlClien tPermission, System.Data, Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9 failed.

why this error accour?

"i am used SqlClientPermis sion "

thanx in advance.

[Jon Skeet [C# MVP]]

mmb <my***@yahoo.co m> wrote:
<snip>

Request for the permission of type
System.Data.Sql Client.SqlClien tPermission, System.Data,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9
failed.

why this error accour?

When you run code from the network, by default it won't be trusted as
much as purely local apps. If you want to change that, go into your
administrative tool for the computer and change the .NET configuration.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Jon Skeet]

Thanx for your answe
but how can set .net SqlClientPermis sion in runtime
my code not wor
[SqlClientPermis sion (SecurityAction .Assert ,Unrestricted=t rue)
private void button1_Click(o bject sender, System.EventArg s e

tr

SqlClientPermis sion myPerm = new SqlClientPermis sion(Permission State.Unrestric ted)
myPerm.Assert() ;
myPerm.AllowBla nkPassword=true
string str
str= "data source=sniper;i nitial catalog=newzolf ;persist security info=False;user id=zolf;"
"password=1;pac ket size=4096"
SqlConnection cnn=new SqlConnection(s tr)
SqlCommand cmd=new SqlCommand("sel ect * from article",cnn)
cnn.Open()
MessageBox.Show ("3")
DataSet ds=new DataSet()
MessageBox.Show ("4")
SqlDataAdapter da=new SqlDataAdapter( cmd)
MessageBox.Show ("5")
da.Fill(ds)
MessageBox.Show ("Sucess")

catch(Exception ex

MessageBox.Show (ex.Message)

[mmb]

Thanx for your answe
but how can set .net SqlClientPermis sion in runtime
my code not wor
[SqlClientPermis sion (SecurityAction .Assert ,Unrestricted=t rue)
private void button1_Click(o bject sender, System.EventArg s e

tr

SqlClientPermis sion myPerm = new SqlClientPermis sion(Permission State.Unrestric ted)
myPerm.Assert() ;
myPerm.AllowBla nkPassword=true
string str
str= "data source=sniper;i nitial catalog=newzolf ;persist security info=False;user id=zolf;"
"password=1;pac ket size=4096"
SqlConnection cnn=new SqlConnection(s tr)
SqlCommand cmd=new SqlCommand("sel ect * from article",cnn)
cnn.Open()
MessageBox.Show ("3")
DataSet ds=new DataSet()
MessageBox.Show ("4")
SqlDataAdapter da=new SqlDataAdapter( cmd)
MessageBox.Show ("5")
da.Fill(ds)
MessageBox.Show ("Sucess")

catch(Exception ex

MessageBox.Show (ex.Message)