C# (CSharp) sqlData.ExecuteScalar Exemples

Exemple #1

        private void insertComment()
        {
            sqlData objDAL = new sqlData();

            int i = -1; int arrayLength = 1;

            string[,] inputParams = new string[arrayLength, 2];
            string[] outputString; //outputString (outputMessages)

            string megaSQL = "INSERT INTO bw_post_comment (uID, postID, commentText) VALUES (" + uID.ToString() + ", " + postID.ToString() + ",'" + comment + "'); SELECT @@IDENTITY;";

            i++; inputParams[i, 0] = megaSQL;
            inputParams[i, 1]      = "";

            string strID = objDAL.ExecuteScalar(inputParams, out outputString);

            Response.ContentType = "text/plain";
            Response.Clear();
            Response.Write(strID);
        }