ASP.NET

chanu007 wrote:

plz reply quickly

chanu007 wrote:

System.Security.SecurityException: That assembly does not allow partially trusted callers.

chanu007 wrote:

thanks for ur novalue,nohelp,irritating suggestion

chanu007 wrote:

System.Security.SecurityException: That assembly does not allow partially trusted callers.

niki_nilu wrote:

but how to call stored procedure in asp.net 2.0 with c#.

using(SqlConnection connection = new SqlConnection("Your connection string here"))
{
    SqlCommand command = new SqlCommand();
    command.Connection = connection;
    command.CommandText = "Analyst";
    command.CommandType = CommandType.StoredProcedure;
    command.Parameters.AddWithValue("@UserId", theUserId);
    command.Parameters.AddWithValue("@StockName", theStockName);
    command.Parameters.AddWithValue("@NewUserId", theNewUserId);
    connection.Open();
    command.ExecuteNonQuery();
    connection.Close();
}

Colin Angus Mackay wrote:

SqlCommand command = new SqlCommand();

N a v a n e e t h wrote:

Will the SQLCommand instance automatically get disposed after the execution ?

Colin Angus Mackay wrote:

I never realised that SqlCommand even had a Dispose method

miauwmiauwmiauw wrote:

My company bought a software from other company and that company provides us an Apache Java Web Service.

I have to connect to that web service using C#. I use Http Web Request to do that ?