Torna al Thread

SqlConnection sqlConnection = new SqlConnection("Data Source=connessione;Initial Catalog=db;uid=a;pwd=b"); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select dbo.CAP(@valore1,@valore2,@valore3,@valore4,@valore5,@valore6)"; cmd.CommandType = CommandType.Text; SqlParameter parameterValore1 = new SqlParameter("@valore1", SqlDbType.Decimal); parameterValore1.Value = _valore1; parameterValore1.Direction = ParameterDirection.Input; cmd.Parameters.Add(parameterValore1); SqlParameter parameterValore2 = new SqlParameter("@valore2", SqlDbType.Decimal); parameterValore2.Value = _valore2; parameterValore2.Direction = ParameterDirection.Input; cmd.Parameters.Add(parameterValore2); SqlParameter parameterValore3 = new SqlParameter("@valore3", SqlDbType.SmallInt); parameterValore3.Value = _valore3Int; parameterValore3.Direction = ParameterDirection.Input; cmd.Parameters.Add(parameterValore3); SqlParameter parameterValore4 = new SqlParameter("@valore4", SqlDbType.SmallInt); parameterValore4.Value = _valore4Int; parameterValore4.Direction = ParameterDirection.Input; cmd.Parameters.Add(parameterValore4); SqlParameter parameterValore5 = new SqlParameter("@valore5", SqlDbType.SmallInt); parameterValore5.Value = _valore5; parameterValore5.Direction = ParameterDirection.Input; cmd.Parameters.Add(parameterValore5); SqlParameter parameterValore6 = new SqlParameter("@valore6", SqlDbType.Int); parameterValore6.Value = _valore6; parameterValore6.Direction = ParameterDirection.Input; cmd.Parameters.Add(parameterValore6); cmd.Connection = sqlConnection; sqlConnection.Open(); var result = cmd.ExecuteScalar(); sqlConnection.Close(); return (double)result;
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5