public string[] ValidateUser(string user_name, string password)
    {

        try
        {
          string  SqlCon = "xczxx";
          using (SqlCon)
            {

                SqlCon.Open();

                SqlDataAdapter da = new SqlDataAdapter("EXEC MASTER.WEB_OF_CHECKUSERNAMEPWD " + "'" + user_name.Trim().ToString() + "'" + "," + "'" + password.Trim().ToString() + "'", SqlCon);

                DataTable dt = new DataTable();

                da.Fill(dt);

                string[] items = new string[dt.Rows.Count];

                int i = 0;

                foreach (DataRow dr in dt.Rows)
                {

                    items.SetValue(dr[

                    "USER_LEVEL_NAME"].ToString(), i);

                    i++;

                }

                //error = null;

                //return items.ToArray();

                return items;

            }

        }

        catch (Exception e)
        {

            //return (e.Message);

            return null;

        }

        finally
        {

           SqlCon.Close();

        }
       

    }