common function for data process if u use query

16/06/2011 11:52

 

 internal SqlConnection getsqlcon()
        {
            return new SqlConnection(ConfigurationSettings.AppSettings["sitesql"].ToString());
        }
        internal SqlConnection getsqlconlogin()
        {
            return new SqlConnection(ConfigurationSettings.AppSettings["sitesqllogin"].ToString());
        }

        DataTable dt = new DataTable();
        internal DataTable dtexe(string query)
        {
            try
            {
                SqlCommand cmd = new SqlCommand(query, getsqlcon());
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                dt = new DataTable();
                da.Fill(dt);               
            }
            catch
            {
                DataTable dt2 = new DataTable();
                dt2 = dt;
            }
            return dt;
        }
        internal DataTable dtloginexe(string query)
        {

            SqlCommand cmd = new SqlCommand(query, getsqlcon());
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            return dt;
        }

        internal string strscalar(string query)
        {
            string result = string.Empty;
            SqlConnection con = getsqlcon();
            SqlCommand cmd = new SqlCommand(query, con);
            con.Open();
            try
            {
                result = cmd.ExecuteScalar().ToString();
            }
            catch { }
            con.Close();
            return result;
        }

        internal int intscalar(string query)
        {
            int result = 0;
            SqlConnection con = getsqlcon();
            SqlCommand cmd = new SqlCommand(query, con);
            con.Open();
            try
            {
                result = Int32.Parse(cmd.ExecuteScalar().ToString());
            }
            catch { }
            con.Close();
            return result;
        }
        //Mahadevan

        internal int Get_Single_Value(string query)
        {
            int result = 0;
            SqlConnection con = getsqlcon();
            SqlCommand cmd = new SqlCommand(query, con);
            con.Open();
            result = (int)cmd.ExecuteScalar();
            con.Close();

            return result;

        }
        public void MessageBox(string Message)
        {
            System.Web.HttpContext.Current.Response.Write("<script type=text/javascript>alert('" + Message + "')</script>");

        }

        //
        public void vdexe(string query)
        {
            SqlConnection con = getsqlcon();
            SqlCommand cmd = new SqlCommand(query, con);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }

        //suguna
       
        public void execute_SP(string procName, SqlParameter[] param)
        {
            SqlConnection con = getsqlcon();
            SqlCommand cmd = new SqlCommand(procName, con);

            cmd.CommandType = CommandType.StoredProcedure;
            con.Open();

            foreach (SqlParameter prms in param)
            {

                cmd.Parameters.Add(prms);

            }
            cmd.ExecuteNonQuery();
            con.Close();
  
        }

 

        public DataTable getdatavalues(string query)
        {

            SqlConnection con = getsqlcon();
            SqlCommand cmd = new SqlCommand(query, con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            return dt;
        }

        public int Returnint(string query)
        {

            SqlConnection con = getsqlcon();
            SqlCommand cmd = new SqlCommand(query, con);
            con.Open();
            int i = (int)cmd.ExecuteScalar();// for converting object into int;
            con.Close();

            return i;

        }

Back