Posts

Showing posts from March, 2013

Detailed Table using jQuery

Image
We have seen in many sites regarding detailed information of products below the row when we click on the downwards arrow and collapse when click on upwards arrow.

We have many plugin's for this type of functionality we can also do with jQuery simple logic also.

I have done some R&D regarding this and want to share information of detailed table using jQuery.

We need to download the latest jQuery File from this link http://jquery.com/download/

We have many CDN links also available for directly accessing the jQuery library files.

Google :

https://developers.google.com/speed/libraries/devguide#jquery


Micro-soft :

http://www.asp.net/ajaxlibrary/cdn.ashx

Git-hub:


https://github.com/jquery/jquery

How to use constants in .NET?

I have a written this Dev tip for the new folk who entered in this Dev World.

Normally in the development we use some of the success message's or failure messages in general common message's.We do have a habit of writing the messages as given below

MessageBox.Show("Successfully created a record!");

MessageBox.Show("Successfully deleted a record!");

We can make use of Constants in .NET which will be declared using the keyword "const".For the above scenario we can create a  class like "Messages.cs" and define constants as given below


 public class Messages
    {
        public const string strUserExist = "User Name already exists.";
        public const string strUserSaved = "User information saved successfully.";
        public const string strUserDeleted = "User deleted successfully.";

    }

Advantage :We can change the message text only in the Message.cs class which will be applicable through out the project where …

Difference between Debug and Release Modes in Visual Studio

Difference between Debug and Release Modes in Visual Studio


We have two options to build a application in production or development stage.Both have their own importance's and characteristics .


Debug:Developer use debug mode for debugging the web application on live/local server.Debug mode stores debug information so it takes time to execute.We can use F10,F11 function keys as well keep tracking the break point.In debug mode the *.pdb (Program debug database) file will be created which contains the debug steps in the binary format.Less optimized code.

Release: We can't do the debug in this mode ,hence no chance of creating *.pdb file.Scripts & images downloaded by webresource.axd are cached.It has small size, and runs fast.More optimized code.

I hope this information could help folks.

Happy coding :-)

Get the SQL Server Information from Query

Some times we need to get the information of the SQL Server where it is installed. Simply we can get the info from Query also

-- Get the version info


select @@version
We have a in-built stored procedure called 'xp_msver' to the Server information.
-- Get the Server Information
exec xp_msver


This is a basic information provided but may be useful to the SQL Server learners .

Good day :-)