Wednesday, 20 September 2017

DATABASE APPLICATION # 2.1 (Return a single value form database )

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Configuration;

namespace WindowsFormsApplication4
{
    class returnclass
    {
        private string connstring = ConfigurationManager.ConnectionStrings["TESTDB"].ConnectionString;
     
       
        public string scalarReturn(string q)
        {string s=" ";
            SqlConnection conn = new SqlConnection(connstring);
            conn.Open();

            try
            {
                SqlCommand cmd = new SqlCommand(q, conn);
                s = cmd.ExecuteScalar().ToString();
         
            }
            catch (Exception)
            {
                s = " ";  
           
            }
         
            return s;

        }




    }
}

No comments:

Post a Comment

Pass Dynamically Added Html Table Records List To Controller In Asp.net MVC

Controller Code: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using ...