Posts

Showing posts from 2014

Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

When you execute your procedure in your database then a very common error of MSSQL " Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). " comes often. Solution to this problem is when you execute your procedure then then use keyword 'Go' between final 'end' and exec procedure Like ALTER procedure [dbo].[test] ( @a nvarchar(50), @b nvarchar(50) ) as  declare @id int  declare @Aid2 int   declare @counter int     begin                     select 1       end     go   exec test 'starplus','starplus7' This will solve your problem.......  

Send Notification to selected users in Asp.Net

Image
Suppose in your website there is an admin control and you want to deliver a message to all or selected users i.e. after login only selected users or every user can see the notification or message from admin of website. How this task can be achieved? Follow the following steps.   1 .   Make separate table for message and in login table make another column with bullion type so that whenever it is true user can see the message and we will have to check at the time of login whether this field is true or false. If this is true then user is able to see message stored in database by admin.  2. On admin side. Make web page like this then admin can search user by name and primary key should be stored separately so that many users can be enabled to see notification. In the image when admin search user by name their primary key will appear to see how many person he want to send notification.                              When admin search name will be automatically

Send SMS on Mobile for Verification or Anything in ASP.Net

Image
To do this you will have to purchase SMS service , I don't know whether this service is free or not but you will have to purchase it. Okay, Take two textbox one for mobile no and one for some code you want to send and one button to click When user enters mobile no message automatically goes to it's mobile no you can dynamically assign random code for user but here I am using textbox to send code. now take an iframe and give it an id ' frame_id ' and in the button click event assign src attribute dynamically, it will send code to its corresponding mobile no. make a function protected void sms_send_method() { string string_of_connection =""; // here you will have to write connection of sms url given by company you purchased frame_id .Attributes["src"]= string_of_connection ; }

Infinite Scroll in Asp.Net C# using Javascript without Third party Plugin

Image
Infinite Scroll is very common today in website as we all see in facebook , google + , LinkedIn and many other sites, as we scroll down data from server automatically appears in our browser without clicking any button. How We will do it?  We first create a database and then after that we will apply a jquery that will execute when our scroll bar reaches bottom of the page. For demo I will fetch YouTube video link from local server and bind that in iframe when scrolled down..  Here I will define a variable or you can say in other word a counter that will increase according to our requirement when scroll down. and that value will pass to the server so that server can send data when scrolled down. Here in my example I am increasing counter by one and initial value is 14 since my table ID started from 14 (you know when you delete some data this happen when it is PK) How to pass data from a page to server using jquery ? Follow these Steps: 1. Create a new proje