Posts

Return DataSet from Npgsql with multiple result set as Tables

clsPSQLConnectionCreator dbHelper = new clsPSQLConnectionCreator();         NpgsqlCommand sc = dbHelper.GetSqlQueryCommand("select * from systemtracker_dbo.pr_get_dataset('parameter1','parameter2','ref_cursor1','ref_cursor1','ref_cursor1','ref_cursor1','ref_cursor1','ref_cursor1','ref_cursor1','ref_cursor1');FETCH ALL IN t1; FETCH ALL IN t2;FETCH ALL IN t3;FETCH ALL IN t4;FETCH ALL IN t5;FETCH ALL IN t6;FETCH ALL IN t7;FETCH ALL IN t8;");         DataSet ds = dbHelper.LoadDataSet(sc);         return ds; GetSqlQueryCommand function in helper class which consist connection as well      public NpgsqlCommand GetSqlQueryCommand (string query)     {         return PrepareCommand(CommandType.Text, query);     }  private NpgsqlCommand PrepareCommand (CommandType commandType, string commandText)     {         if (connection == n...

FIX: the webpage might be temporarily down or it may have moved permanently error in asp.net MVC web application.

It might be possible that you have run your application before the shut down of your system and overnight something happens and its showing either IIS 502.5 error or   "This Website Can't be Reached" and err_access_denied when using google chrome. There may be many reason for this ...either you have updated your windows , you have reset the google settings or you may have not copied the project from the source to your system . The solution for this problem is to again download the project or copy the project to refill the missing dll files in your projects. Then rebuild the solution and run it.

Data not retaining in the text box coming from database on JQuery button click in asp.net Application

Most of the time what happen is we are able to write back end code to fetch data for text box to get auto filled on button click but it does not appear on front end or toggle for seconds in text box . Solution to remove this problem is to give type to button as type="button" which is very necessary.  function getReportData() {                 $.ajax({                     "url": "ReportTable.aspx/GetReport",                     "contentType": "application/json; charset=utf-8",                     "type": "POST",                     "dataType": "JSON",                     "success": function (data) {                         data ...

Web.Config File

    The main benefits of having a config file in any web project is that it is a single file which contain Database connections Caching Settings Session states Error Handling Security     and if you want to change any configuration setting than you just need to change at a single place and need not to deploy the project again  and if you put all those code in different files like you are giving connection string in each file where you need and than you need a  change in the string than you need to change the code in all the  file at every place which will be a tedious task and Moreover  you  need to rebuild the solution and deploy it again.      

Skin Darkening and black moles even in lower temperature

Image

A life between age of 17-25

Age between 17-25 is the most difficult part of life. When you come to your youngster life which has to be the most adorable and energetic part goes deep down inside somewhere in the books .The real sense of humor which originate inside a person by feeling and exploring the world that fades in intimidating of your future happenings.You just want IIT's , AIMS even NIT's are not fulfilling but what you never keep courage to accept what you really want and finally what you got is some private college with a heavy fee for your father and a heavy decision that is needed to be accepted by you. When life rolls to you professional life,Guys lost between being a man and being a boy of  their life and Girls start a hurry life as such they need to prove themselves before there marriage deadline pass by.  while the reality is that you are just riding the wave and going with flow and had accepted that you belong nowhere in this world.You are not ready to accept that you are not so m...