ASP.NET

   public class database<br />
    {<br />
<br />
        public database()<br />
        {<br />
        }<br />
        public static object ExecuteScaler(string constr, string cmdText, params object[] paramValue)        {<br />
            if (paramValue != null && paramValue.Length > 0)<br />
            {<br />
                SqlParameter[] cmdParameter = SetParameter(constr, cmdText);<br />
                Assignparameter(cmdParameter, paramValue);<br />
                SqlConnection con = new SqlConnection(constr);<br />
                con.Open();<br />
                return ExecuteScaler(con, cmdText, CommandType.StoredProcedure, cmdParameter);<br />
             }<br />
            else<br />
                return ExecuteScaler(constr, cmdText, CommandType.StoredProcedure);<br />
        }<br />
<br />
<br />
public static SqlParameter[] SetParameter(string constr, string cmdtext)        {<br />
            using (SqlConnection con = new SqlConnection(constr))<br />
            using (SqlCommand cmd = new SqlCommand(cmdtext, con))<br />
            {<br />
                con.Open();<br />
                cmd.CommandType = CommandType.StoredProcedure;<br />
                SqlCommandBuilder.DeriveParameters(cmd);<br />
                cmd.Parameters.RemoveAt(0);<br />
                SqlParameter[] cmdparameter = new SqlParameter[cmd.Parameters.Count];<br />
                cmd.Parameters.CopyTo(cmdparameter, 0);<br />
                return cmdparameter;<br />
            }<br />
        }<br />
<br />
<br />
 public static void Assignparameter(SqlParameter[] cmdparameter, object[] ParameterValue)<br />
        {<br />
            if ((cmdparameter == null) || (ParameterValue == null))<br />
                return;<br />
            if (cmdparameter.Length != ParameterValue.Length)<br />
                throw new ArgumentException("Argument Error");<br />
            for (int i = 0, j = cmdparameter.Length; i < j; i++)<br />
                cmdparameter[i].Value = ParameterValue[i];<br />
<br />
        }<br />
<br />
<br />
        public static object ExecuteScaler(SqlConnection con, string cmdtext, CommandType cmdtype, params SqlParameter[] cmdparams)        {<br />
            SqlCommand cmd = new SqlCommand();<br />
            Preparecmd(cmd, con, (SqlTransaction)null, cmdtype, cmdtext, cmdparams);<br />
            object retval = cmd.ExecuteScalar();<br />
            cmd.Parameters.Clear();<br />
            return retval;<br />
<br />
        }<br />
<br />
<br />
        public static void Preparecmd(SqlCommand cmd, SqlConnection con, SqlTransaction sqlT, CommandType cmdType, string cmdtext, SqlParameter[] cmdParams)<br />
        {<br />
            if (con.State != ConnectionState.Open)<br />
                con.Open();<br />
            cmd.Connection = con;<br />
            cmd.CommandType = cmdType;<br />
            cmd.CommandText = cmdtext;<br />
            if (cmdParams != null)<br />
                AttachParameter(cmdParams, cmd);<br />
            return;<br />
        }<br />
<br />
<br />
        public static void AttachParameter(SqlParameter[] cmdparamsvalues, SqlCommand cmd)<br />
        {<br />
                        foreach (SqlParameter pp in cmdparamsvalues)<br />
            {<br />
                if (pp.Direction == ParameterDirection.InputOutput && pp.Value == null)<br />
                    pp.Value = DBNull.Value;<br />
                <br />
                cmd.Parameters.Add(pp);  //I got error here          }<br />
        }<br />
         <br />
}