How to get constraint of a table
You can get the constraints of a table from the database. SELECT t.name AS table_name,o.name Using above query you can get all the constraint of a particular table. |
You can get the constraints of a table from the database. SELECT t.name AS table_name,o.name Using above query you can get all the constraint of a particular table. |
You can get the columns detail of a table from the database. SELECT t.name AS table_name,c.name AS column_name,c.is_identity,c.is_nullable,c.max_length,ty.name Using above query you can get table columns and columns properties like Column Name, |
You can get the entire table name from the database. SELECT name AS table_name FROM sys.Tables Using above query you can find entire table name. Suppose In Database there are Table A Table B Table C |
Unique Temple in PehowaPehowa is 26 Km away from Kurukshetra. The town of Pehowa was named after the famous The town of "Pehowa" is blessed with a famous and unique temple of Lord Kartikkya. When Lord Shiva and Mata Parvati told both children to perform “Trilok parikarma” then When Kartikkya reached back and saw that Ganesha already won, then he had doubt |
<!--Put this code in Head Section -->
<script language='Javascript' type='text/Javascript'> //<![CDATA[ function changeUsername() { document.getElementById('divUsername').style.display = ''; document.getElementById('divDummyUsername').style.display = 'none'; document.getElementById('<% =txtEmail.ClientID %>').focus(); } function changePassword() { document.getElementById('divPassword').style.display = ''; document.getElementById('divDummyPassword').style.display = 'none'; document.getElementById('<% =txtPassword.ClientID %>').focus(); } function restoreUsername() { if (document.getElementById('<% =txtEmail.ClientID %>').value == '') { document.getElementById('divUsername').style.display = 'none'; document.getElementById('divDummyUsername').style.display = ''; } } function restorePassword() { if (document.getElementById('<% =txtPassword.ClientID %>').value == '') { document.getElementById('divPassword').style.display = 'none'; document.getElementById('divDummyPassword').style.display = ''; } } //]]> </script>
C#
if (IsPostBack)
{
if (txtPassword.Text.Trim() != "")
{
txtPassword.Attributes["value"]= txtPassword.Text;
}
}
VB
If IsPostBack Then If txtPassword.Text.Trim() <> "" Then txtPassword.Attributes("value") = txtPassword.Text End If End If
You can still however do this with a DataGrid or DataList. it's just a little trickier. |
ASP.NET 2003 | ASP.NET 2005 |
---|---|
When you compile the application in .NET 1.x, Visual Studio 2003 would automatically compile only certain file types such as ASP.NET pages, Web services, user controls, HTTP handlers, Resource files, and Global.asax class files. The rest of the files needed to be explicitly compiled before finally publishing your code to the web server. | In Visual Studio 2005, you no longer need to compile all the files into an assembly. The ASP.NET dynamic compilation engine allows to automatically compile applications, that includes .aspx, .cs, .vb files. That means, simply create an application and publish it. All the files in the App_Code folder are dynamically compiled to a single assembly, named code.dll. The assembly has an application scope and is created in the Temporary ASP.NET Files folder, well outside the Web application space. |
There is no option to create dll of single page so if you modify a single code behined page still you have to upload entire project dll | Giving option to make dll of single page so that if you modify a code behind page then you can only upload/change that page dll. |
The code-behind model requires an IIS virtual directory. | The code-behind model can directly access the local installation of IIS. |
The code-behind model lacks support for FTP, local file systems, and direct IIS access. | The code-behind model has multiple ways to open Web sites. |
It requires IIS on the development computer. | It already has a built-in Web server. |
Unable to open individual pages outside the project. | Need not open the entire project; you can open individual pages outside the project, it is achieved through the compile-on-demand feature. |
It requires explicit addition of files to the project. | It eliminates the need to explicitly add files to the project. |
In ASP.NET 1.x presentation page (aspx) and the code behind page are linked by inheritance aspx page inherit from the code behind page. But if you want to access any aspx control then it must be declare in code behind page(when you drag any control then it automatically generate code into the code behind page but some time it does not create code when you write html rather then drag the control for that you have to open design view so that it generate code into the code behind page) | n asp.net 2.0 the presentation page (aspx) and the code behind page are interact with inheritance same as that of asp.net 1.0 but with additional feature which is partial class. Partial classes enable you to declare a class in more than one physical file. When the class gets compiled, one class is generated from all the partial classes. The advantage of using partial classes is that you don’t need to worry about declaring a control in both the presentation page and code-behind file. Anything that you declare in the presentation page is available automatically in the code-behind file, and anything you declare in the code-behind file is available automatically in the presentation page. |