Sunday, May 19, 2019

Postman beginner Tutorial

Hi , I have started new video series of postman tutorial hope it will be helpful:Please give me your feed back in comments and like and subscribe.

Tuesday, May 8, 2018

Asp Classic Upload File Issue

Recently I have migrated asp classic application from old server to new server . I found file upload is not working in new IIS 7 Server . I found the solution from here "In IIS 7, click your site and expand it then click the ASP icon. Expand the Limits Properties icon, and change the value in the “Maximum Requesting Entity Body Limit” to a value larger than 200000"


 I fixed it by adding limit in applicationhost file C:\Windows\System32\inetsrv\config\applicationHost.config 
looked for asp tag
      
and update it like this

       


           

       

       

Monday, April 18, 2016

Conver String Split Comma separated Columns value into row


I have a table that save comma separated values in column

col_Name
aa,bb,cc
dd
 
I need output like this
 aa
 bb
 cc
 dd

To achieve this I create below view :

CREATE OR REPLACE FORCE VIEW "VU_COMMA_STRING_TO_ROW" ("col_Name") AS
  select "col_Name" from (WITH     cntr     AS
(
     SELECT     LEVEL     AS n
     FROM     dual
     CONNECT BY  LEVEL <= 1 + ( SELECT  MAX ( LENGTH ( REGEXP_REPLACE ( col_Name
                                                                             , '[^,]'
                                 )     )                  )
                       FROM    table_Name
                     )
)
SELECT         REGEXP_SUBSTR ( table_Name.col_Name
                , '[^,]+'          -- Use + here, not *
                , 1
                , cntr.n
                ) AS FINENUMBER
FROM     table_Name
JOIN     cntr     ON     cntr.n     <= LENGTH ( REGEXP_REPLACE (col_Name|| ',', '[^,]'))

);

Hope It will be useful for someone.

Wednesday, March 9, 2016

Only One first Page Printing of a Web Application in Internet Explorer Problem Fix

My form have 7 pages to print after a transaction but only 1 page prints from Internet Explorer. I resolved this issue by removing a style "position:absolute" from one of my DIV tags. I think 
After I made this change the page prints all the seven pages correctly.
I hope this will help to someone .

Tuesday, September 8, 2015

Problems in Hosting Asp.Net 3.5 Arabic website Oracle DB and Crystal Report in IIS 7 Windows Server 2012 R2 Machine

In this post I want to share my experiences during the environment setup: We have a very old application developed back in 2012 , this application was deployed in windows server 2003 machine ,suddenly machine crash this month and client request us to deploy same application in Windows Server 2012 R2 Machine, in two days I have successfully deployed our application. Below are some issues that I have face, may be it will be helpful for someone or for me in future :) 1) I have installed Oracle 10g client an it runs smoothly , then I deployed Asp.net web application , when I run the app Arabic text was nor showing properly after some hour of R & D I found the solution I have change the systems from control panel > Region and Language >Administrative Tab 2) After this Restart the application and now Arabic character comes properly :) 3)Now Crystal report was not working properly because I forgot to put TNS Name in Oracle Client directory ,after TNS name file reports also work fine 4) But Crystal report is not print out from print button neither it export in PDF I am still looking for the solution :) 5)Another issue some of my request contain arabic characters that was setting values in database as ?????? .The work around was simple 6)I have put NS_LAND in my environment variable AMERICAN_AMERICA.WE8MSWIN1256. and restart my machine . 7)Now request strings are showing correct arabic text . Now every thing is working fine :)

Wednesday, May 27, 2015

Add Image in Navigation Drawer Android Studio Template

I have to add Image in one of my project in slider Menu ,
I have used Android Studio Template Navigation Drawer  for material design .
For adding header on top of the list I have modified few lines in code: below are the simple steps:

Create an Android Studio project and select  Navigation Drawer Activity as shown below
Now your project structure is like this:


Now open activity_main.xml  and add LinearLayout and image view as shown below highlighted lines


<android.support.v4.widget.DrawerLayout xmlns:android="http://schemas.android.com/apk/res/android"    xmlns:tools="http://schemas.android.com/tools" android:id="@+id/drawer_layout"    android:layout_width="match_parent" android:layout_height="match_parent"
tools:context=".MainActivity">
 <FrameLayout android:id="@+id/container" android:layout_width="match_parent"

    android:layout_height="match_parent" />


<LinearLayout    android:layout_width="@dimen/navigation_drawer_width"    android:layout_height="match_parent"    android:orientation="vertical"    android:layout_gravity="start"    android:id="@+id/slider_list_with_image"    >

<ImageView    android:layout_width="match_parent"    android:layout_height="wrap_content"
    android:src="@drawable/ic_launcher">
</ImageView>


<fragment android:id="@+id/navigation_drawer"    android:layout_width="@dimen/navigation_drawer_width" android:layout_height="match_parent"    android:layout_gravity="start"    android:name="com.naushad.navigationdrawersliderimage.NavigationDrawerFragment"    tools:layout="@layout/fragment_navigation_drawer" />

</LinearLayout>

</android.support.v4.widget.DrawerLayout>

Now open NavigationDrawerFragment.java and modify highlighted lines
  
public class NavigationDrawerFragment extends Fragment {

private static final String STATE_SELECTED_POSITION = "selected_navigation_drawer_position";
  
private static final String PREF_USER_LEARNED_DRAWER = "navigation_drawer_learned";

private NavigationDrawerCallbacks mCallbacks;

private ActionBarDrawerToggle mDrawerToggle;

    private DrawerLayout mDrawerLayout;
    private ListView mDrawerListView;
    //private View mFragmentContainerView;
   //Replace it whereever it used in this class with linear layout    

    private LinearLayout mlinearLayout;

    private int mCurrentSelectedPosition = 0;
    private boolean mFromSavedInstanceState;
    private boolean mUserLearnedDrawer;

    public NavigationDrawerFragment() {
    }

    @Override    
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        SharedPreferences sp = PreferenceManager.getDefaultSharedPreferences(getActivity());
        mUserLearnedDrawer = sp.getBoolean(PREF_USER_LEARNED_DRAWER, false);

        if (savedInstanceState != null) {
            mCurrentSelectedPosition = savedInstanceState.getInt(STATE_SELECTED_POSITION);
            mFromSavedInstanceState = true;
        }

        // Select either the default item (0) or the last selected item.        
        selectItem(mCurrentSelectedPosition);
    }

    @Override    
     public void onActivityCreated(Bundle savedInstanceState) {
        super.onActivityCreated(savedInstanceState);
        setHasOptionsMenu(true);
    }

    @Override    
     public View onCreateView(LayoutInflater inflater, ViewGroup container,
                             Bundle savedInstanceState) {
        mDrawerListView = (ListView) inflater.inflate(
                R.layout.fragment_navigation_drawer, container, false);
        mDrawerListView.setOnItemClickListener(new AdapterView.OnItemClickListener() {
            @Override            
            public void onItemClick(AdapterView parent, View view, int position, long id) {
                selectItem(position);
            }
        });
        mDrawerListView.setAdapter(new ArrayAdapter(
                getActionBar().getThemedContext(),
                android.R.layout.simple_list_item_activated_1,
                android.R.id.text1,
                new String[]{
                        getString(R.string.title_section1),
                        getString(R.string.title_section2),
                        getString(R.string.title_section3),
                }));
        mDrawerListView.setItemChecked(mCurrentSelectedPosition, true);
        return mDrawerListView;
    }

    public boolean isDrawerOpen() {
   return mDrawerLayout != null && 
      mDrawerLayout.isDrawerOpen(mlinearLayout);
     //*** MODIFIED by Naushad        
     //mDrawerLayout.isDrawerOpen(mFragmentContainerView);
    }

    public void setUp(int fragmentId, DrawerLayout drawerLayout) {
        //mFragmentContainerView = getActivity().findViewById(fragmentId);
        //*** MODIFIED by Naushad        
        mlinearLayout=(LinearLayout)getActivity().findViewById(R.id.slider_list_with_image);
        mDrawerLayout = drawerLayout;
       // set a custom shadow that overlays the main content when the drawer opens                  

      mDrawerLayout.setDrawerShadow(R.drawable.drawer_shadow, GravityCompat.START);
        // set up the drawer's list view with items and click listener
        ActionBar actionBar = getActionBar();
        actionBar.setDisplayHomeAsUpEnabled(true);
        actionBar.setHomeButtonEnabled(true);

          mDrawerToggle = new ActionBarDrawerToggle(
                getActivity(),                                 
               mDrawerLayout,                                  
              R.drawable.ic_drawer,            
               R.string.navigation_drawer_open,  
                R.string.navigation_drawer_close) {
            @Override            
             public void onDrawerClosed(View drawerView) {
                super.onDrawerClosed(drawerView);
                if (!isAdded()) {
                    return;
                }

                getActivity().supportInvalidateOptionsMenu(); 
               // calls onPrepareOptionsMenu()            
             }

            @Override            
             public void onDrawerOpened(View drawerView) {
                super.onDrawerOpened(drawerView);
                if (!isAdded()) {
                    return;
                }

                if (!mUserLearnedDrawer) {
                           
                    mUserLearnedDrawer = true;
                    SharedPreferences sp = PreferenceManager
                            .getDefaultSharedPreferences(getActivity());
                    sp.edit().putBoolean(PREF_USER_LEARNED_DRAWER, true).apply();
                }

                getActivity().supportInvalidateOptionsMenu(); 
               // calls onPrepareOptionsMenu()            
           }
        };
 
        if (!mUserLearnedDrawer && !mFromSavedInstanceState) {
            //mDrawerLayout.openDrawer(mFragmentContainerView); 
           //***MODIFIED by Naushad                     
              mDrawerLayout.openDrawer(mlinearLayout);
        }

           mDrawerLayout.post(new Runnable() {
            @Override            
            public void run() {
                mDrawerToggle.syncState();
            }
        });

        mDrawerLayout.setDrawerListener(mDrawerToggle);
    }

    private void selectItem(int position) {
        mCurrentSelectedPosition = position;
        if (mDrawerListView != null) {
            mDrawerListView.setItemChecked(position, true);
        }
        if (mDrawerLayout != null) {
           // mDrawerLayout.closeDrawer(mFragmentContainerView);  
           //*** MODIFIED by Naushad               
          mDrawerLayout.closeDrawer(mlinearLayout);
        }
        if (mCallbacks != null) {
            mCallbacks.onNavigationDrawerItemSelected(position);
        }
    }

    @Override    
    public void onAttach(Activity activity) {
        super.onAttach(activity);
        try {
            mCallbacks = (NavigationDrawerCallbacks) activity;
        } catch (ClassCastException e) {
            throw new ClassCastException("Activity must implement NavigationDrawerCallbacks.");
        }
    }

    @Override    public void onDetach() {
        super.onDetach();
        mCallbacks = null;
    }

    @Override    public void onSaveInstanceState(Bundle outState) {
        super.onSaveInstanceState(outState);
        outState.putInt(STATE_SELECTED_POSITION, mCurrentSelectedPosition);
    }

    @Override    public void onConfigurationChanged(Configuration newConfig) {
        super.onConfigurationChanged(newConfig);
        // Forward the new configuration the drawer toggle component.        
       mDrawerToggle.onConfigurationChanged(newConfig);
    }

    @Override    
    public void onCreateOptionsMenu(Menu menu, MenuInflater inflater) {
        
     if (mDrawerLayout != null && isDrawerOpen()) {
            inflater.inflate(R.menu.global, menu);
            showGlobalContextActionBar();
        }
        super.onCreateOptionsMenu(menu, inflater);
    }

    @Override    public boolean onOptionsItemSelected(MenuItem item) {
        if (mDrawerToggle.onOptionsItemSelected(item)) {
            return true;
        }

        if (item.getItemId() == R.id.action_example) {
            Toast.makeText(getActivity(), "Example action.", Toast.LENGTH_SHORT).show();
            return true;
        }

        return super.onOptionsItemSelected(item);
    }

     private void showGlobalContextActionBar() {
        ActionBar actionBar = getActionBar();
        actionBar.setDisplayShowTitleEnabled(true);
        actionBar.setNavigationMode(ActionBar.NAVIGATION_MODE_STANDARD);
        actionBar.setTitle(R.string.app_name);
    }

    private ActionBar getActionBar() {
        return ((ActionBarActivity) getActivity()).getSupportActionBar();
    }

   public static interface NavigationDrawerCallbacks {
            void onNavigationDrawerItemSelected(int position);
    }
}


Thats it here is the output :) make sure you have image in drawable folder You can get the source code from github here is the link

Postman beginner Tutorial

Hi , I have started new video series of postman tutorial hope it will be helpful:Please give me your feed back in comments and like and sub...