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.
CoderSight
Sight of Coders
Sunday, May 19, 2019
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
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
Sunday, April 8, 2018
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
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
Subscribe to:
Posts (Atom)
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...

-
this app is not collecting any users data
-
after 30mins of struggle i found a solution:) 1)Click on Layout Button. 2)Click on Edit HTML. 3) Now, in code given below go at the botto...
-
I have to display amount in Words with decimal values in my report for achieving this i wrote small formula in Crystal Report here is the...