Common Methods use in asp.net/mvc
using Microsoft.VisualBasic; using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Diagnostics; using System.Web.UI; using System.IO; using System.Web.Security; using System.Collections.Specialized; using System.Text; using System.Data.SqlClient; using System.Configuration; using ASPSnippets.SmsAPI; using System.Net.Mail; using System.Net; public class CommonMethods { #region "Short Query Functions" public static string GetTextData(string SqlStr) { string functionReturnValue = null; SqlConnection OAF = default(SqlConnection); OAF = new SqlConnection(ConfigurationManager.ConnectionStrings["SCon"].ConnectionString); SqlCommand myCom = new SqlCommand(SqlStr, OAF); myCom.Connection.Open(); if ((myCom.ExecuteScalar() == null)) { functionReturnValue = string.Empty; } else { functionReturnValue = myCom.Exec