Help on C# tutorials, VB.Net, AJAX, Javascript, ASP.Net, SQL server, Win form

The LIKE condition allows you to use wildcards in the where clause of an SQL statement. This allows you to perform pattern matching. The LIKE condition can be used in any valid SQL statement - select, insert, update, or delete. The patterns that you can choose from are: % allows you to match any string of any length (including zero length) _ allows you to match on a single character Examples using % wildcard The first example that we'll take a look at involves using % in the where clause of a select statement. We are going to try to find all of the suppliers whose name begins with 'Hew'. SELECT * FROM suppliers WHERE supplier_name like 'Hew%'; You can also using the wildcard multiple times within the same string. For example, SELECT * FROM suppliers WHERE supplier_name like '%bob%'; In this example, we are looking for all suppliers whose name contains the characters 'bob'. You could also use the LIKE condition to find suppliers ...

The SQL ALTER TABLE command is used to modify the definition (structure) of a table by modifying the definition of its columns. The ALTER command is used to perform the following functions. 1) Add, drop, modify table columns 2) Add and drop constraints 3) Enable and Disable constraints Syntax to add a column ALTER TABLE table_name ADD column_name datatype; For Example: To add a column "address" to the student table, the query would be like ALTER TABLE employee ADD address varchar(500); Syntax to drop a column ALTER TABLE table_name DROP column_name; For Example: To drop the column "age" from the student table, the query would be like ALTER TABLE employee DROP age;  Syntax to modify a column ALTER TABLE table_name MODIFY column_name datatype; For Example: To modify the column fees in the student table, the query would be like ALTER TABLE employee MODIFY fees number(15,2); SQL RENAME Command The SQL RENAME command is used to change the na...

You can call this function to clear content of  controls such as TextBox, CheckBox and  DropDownList. You can further add on other ASP.Net controls to clear their content. public void ClearFields(System.Web.UI.Page page, string defaultDropDownValue) { ArrayList all = GetControls(page.Controls); for (int i = 0; i Many Asp.Net new programmer do it by clear  control content by setting their property one by one . For Ex. TextBox1.Text=""; checkBox1.checked=False;

Web Services, a technology that is part of ASP.NET. Through Web Services you can make your processing methods available and executable by others on the Web, and you can execute methods on your pages that are made available by others. The general idea is that Web page processing can be handled by your scripts or by scripts housed anywhere on the Web. Web Services Development Process In its most simple form, a Web Service is a Visual Basic function that can be called from anywhere on the Web. The function is created and accessed through the following steps. As the supplier of a Web Service,  Create a Visual Basic class that encapsulates your processing function, much as you would for a local function designed for use from your own Web pages.  Convert the class to a Web Service by including special code to identify it as such,saving the class as a .asmx file in a Web-accessible directory. Make the URL to your Web Service available to others who wish to use it.In this way...

This is very simplest way to submit your blogspot blog  sitemap to webmaster. Login into your google webmaster click on submit a sitemap and copy this line into the given input box. atom.xml?redirect=false&start-index=301&max-results=100 for 300+posts. But 300 posts nicely have indexed by Google,but more than 300,it is not indexing.

1. What is CLR? The .NET Framework provides a runtime environment called the Common Language Runtime or CLR (similar to the Java Virtual Machine or JVM in Java), which handles the execution of code and provides useful services for the implementation of the program. CLR takes care of code management at program execution and provides various beneficial services such as memory management, thread management, security management, code verification, compilation, and other system services. The managed code that targets CLR benefits from useful features such as cross-language integration, cross-language exception handling, versioning, enhanced security, deployment support, and debugging. 2. What is CTS? Common Type System (CTS) describes how types are declared, used and managed in the runtime and faci...

Introduction of SharekhanMini https://strade.sharekhan.com/rmmweb/mini/   SharekhanMini intend to give our Low Bandwidth Users  a complete (NSE/BSE/NSEFO) solution on the handsets , hence we call it “Sharekhan Mini” aka Low Bandwidth Web Site. What SharekhanMini wish to present is the extremely user friendly UI and rocking speedy website. This might look contradictory to the above statement as it was meant for people having sorry internet connectivity. “Yes” But on a free way like a broadband/corporate internet this website works faster than the classic one’s, reason being its customized to work on low fuel and when you put it on nitro it glides.These are basic facts about Sharekhanmini. Low bandwidth can be due to: 1) Rural areas where high speed connections are not available or 2) Financial situation- that is, expensive high-speed connection 3) Some older technologies load pages very slowly and do not support features used on newer s...