Code

Re: accessing sql server in C# code on form load

rajkumar.bathula — Mon, 16 Jul 2012 08:19:09 GMT

as Jimmy said, give full trust by navigating to Form options-->Security--> and select full trust.

Re: accessing sql server in C# code on form load

Jimmy — Wed, 04 Jul 2012 14:45:32 GMT

As far as I know, the only way to use code like the above to access a database is for your form to be full trust.

Instead, you should set up a data connection to the SQL server, and if necessary, manipulate that from code.

Re: accessing sql server in C# code on form load

RodrigoBR — Wed, 04 Jul 2012 14:16:27 GMT

Hi raj,

I am facing the same situation, have you solve it?

accessing sql server in C# code on form load

rajkumar.bathula — Sun, 08 Jan 2012 18:45:09 GMT

Hi, I am unable to connect to MS SQL server database in form load code in C#. I am using infopath 2010. It gives permission exception(Detailed exception given below).

Please help me out in geting rid of this issue.

Below is code i am using in my Form load:

using (SqlConnection conn = new SqlConnection("Data Source=systemName\\servername;Initial Catalog=SharePoint_DB;User ID=admin;Password=Pass01*;Integrated Security=true;"))

{

conn.Open();

emailAlias.SetValue("xyz");

conn.Close();

}

Exception at connection Open() statement :

[System.Security.SecurityException] = {"Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed."}

thanks beforehand

raj