Sandeep Prajapati - Asp.net

Hello friends Here are few Database Specific Queries Select All Database list   1: SELECT [name] FROM sys.databases 2: SELECT [name] FROM sys.sysdatabases This will Result Select All Tables of particular Database.   1: SELECT Name, type,type_desc FROM sys.objects 2: where Type= 'u' This will Result Here Fields Type and Type_Desc are Type Type_Desc C CHECK_CONSTRAINT D DEFAULT_CONSTRAINT F FOREIGN_KEY_CONSTRAINT FN SQL_SCALAR_FUNCTION IF SQL_INLINE_TABLE_VALUED_FUNCTION IT INTERNAL_TABLE P ...

As i Committed in my previous post , that i will post code for ReportDataPass. it is Quite difficult to pass Data from one Application to another application, because here Cookie , Session variable will not help. now a very simple way it Query string ,  But as our previous condition, we don’t want to use Query string . so the last way.. Post Method as we know, in any server side scripting languages, like asp, jsp, PHP.. on submit button, the Data is posted to another page or to itself. and using Request[“Filedname”] we can have its Value. the same logic we are going to apply.. but as we are using VS, where we have facilities of Masterpages and Content page,so when we are using any ContentPage, in that case we can not have form and its Post method. So we are going to make a dynamic Html Page, and  using dynamic Javascript we will post Data to another page. So create a Class like this 1: public class RemoteDataPass 2: { 3: 4: priva...

A very Common trick Open a new window as Popup by javascript… Clicking on any Server Button 1: < asp:Button ID ="Button1" 2: runat ="server" 3: OnClientClick ="window.open('Page2.aspx',null,'height=200,width=400 4: ,status=yes,toolbar=no,menubar=no,location=no,scroll=no'); 5: return false;" 6: Text ="Button" /> All The Best..