HostelsClub is one of the worlds larges search engine to search hotels, hostels, rooms and also provide booking of it. so if you want to integrate such a functionality in your website then you will have to take authentication from hostelclub and he will provide you Authentication id and password for Test (free of cost) and later you can upgrade to "Production" version (it will take some percentage in booking cost's profit).HostelsClub...
Tuesday, December 29, 2009
How to send/recive XML file through HTTP Post
If you want to send a XML file through HTTP using POST to any web service which may /may not build in .net. this example can help u: string targetUri = "http://www.targeUrl.com"; System.Xml.XmlDocument reqDoc = new System.Xml.XmlDocument(); reqDoc.Load(Server.MapPath("~\\myfile.xml"));//xml file which you want to send string formParameterName = "OTA_request";//request type string xmlData = reqDoc.InnerXml;...
Thursday, November 26, 2009
Set Cursor Position in TextBox.
If we want to set position of cursor to any character index in textbox by using following property:TextBox1.SelectionStart= 2; //this will set cursor after 2nd character in textb...
Make textbox numeric only with negative value accept
Lets we want to create a textbox which should take only numeric (double/decimal) value and the value can also be in negativeSolution:Private Sub txt_KeyPressWithNegative(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtothercharges.KeyPress, txtfreight.KeyPress Dim decexist As Boolean = False If (CType(sender, TextBox).Text.IndexOf(".") > 0) And e.KeyChar.Equals("."c)...
Wednesday, November 25, 2009
Difference between <%# Bind(””) %> and <%# Eval(””) %>
EVal is one way binding, Bind is two wayIf you bind a value using Eval, it is like a read only. You can only view the data.If you bind a value using Bind, and if you do some change on the value it will reflect on the database alsoso when ever you just want to show metter on grid that time you should use Eval and if you want that user should be able to change the content and that should be reflect in database then we should use...
Monday, November 23, 2009
Difference between website project and webapplication project in VS2008
n the web**site** project, you typically work off a directory on your disk. There is no "project" file that defines the project's structure. Anything that's in that directory and any of its subdirectories automatically becomes part of your site - which can be a good or a bad thing.A website project usually doesn't live inside a namespace, e.g. any code in your App_Code subdirectory will typically not have a namespace associated...
Why constructor not returns value
What actually happens with the constructor is that the runtime uses type data generated by the compiler to determine how much space is needed to store an object instance in memory, be it on the stack or on the heap. This space includes all members variables and the vtbl. After this space is allocated, the constructor is called as an internal part of the instantiation and initialization process to initialize the contents of the...
Multiple Combobox with same datasource
One day Mr. Jodha asked me for solution for his prolem.Problem: -he used select query and got all data in datatable.-then he made that datatable as datasource for two combobox which will show differentfields of that table-but the proble is that when he select value from one combobox then the value of same record in secondcombobox get selected.and that is main problem.Solution:Their exist very simple solution for this kind of...
Tuesday, November 17, 2009
Difference between JScript, JScript.NET and Managed JScrip
Difference between JScript, JScript.NET and Managed JScriptThere are three different types of JScript engines that MS currently offers to the users. In this blog I would like to discuss more about the differences between them and would go into the reasoning for three different types sometime later. JScript (or native JScript)Read the intro about this in my previous blog here. The native JScript engine relies primarily on Microsoft's...
VB.NET/C#.NET Communication with JavaScript
This article will help you to learn how to do communication between javascript and (vb.net/c#.net)To start off, we'll start with a very simple example; all this will do is call a JavaScript function from VB.NET to display an alert with message 'Hello world'. Similarly, from the HTML page using JavaScript, we'll call a VB.NET function which will again display a messagebox with the message 'Hello world'. These are the steps you...
Learn Object Oriented JavaScript
Learn Basic JavaScript If you are beginner.This Article is for Learning Advanced JavaScript and how to use it in Asp.netASP.NET and Visual Studio 7.0 are making important contributions to the improvement of the web development experience. Unfortunately, there is also a tendency created among developers to limit their interaction with JavaScript. Clearly JavaScript is valuable for adding client-side functionality to web pages....
Basic JavaScripts
As we all know in web application development the javascript is very important so lets learn some basic javaScript. < html >< head >< title >This is a JavaScript example< /title >< script language="JavaScript" >< !--document.write("Hello World!");//-- >< /script >< /head >< body > Hi, man! < /body >< /html >Usually, JavaScript code starts with the tag < script...
Monday, November 16, 2009
How to detect browser close button is clicked ?
call this function from page_unload() so when user will close the browser either by [X] button or by alt+f4 or from exit (from file menu). by using this function you can detect that browser is going to close and you can perform any of your choice operation just before browser get close.function CheckBrowser(){ // Check Browser Close [X] , Alt+F4 , File -> Close if(window.event.clientX < 0 && window.event.clientY...
Wednesday, November 4, 2009
What is use of "SET XACT_ABORT" in SQL
When SET XACT_ABORT is ON, if a Transact-SQL statement raises a run-time error, the entire transaction is terminated and rolled back.When SET XACT_ABORT is OFF, in some cases only the Transact-SQL statement that raised the error is rolled back and the transaction continues processing. Depending upon the severity of the error, the entire transaction may be rolled back even when SET XACT_ABORT is OFF. OFF is the default setting.Compile...
Monday, November 2, 2009
Primary Key , Foreign Key Column Name for Key Constraint
Query written below will give you result as shown in image.SELECT [constraint_name] = f.[name], [child_table] = OBJECT_NAME(f.parent_object_id), [child_column] = cc.name, [parent_table] = OBJECT_NAME(f.referenced_object_id), [parent_column] = pc.nameFROM sys.foreign_keys fINNER JOIN( SELECT c.[object_id],...
Thursday, October 29, 2009
What is Difference between ScriptManager & ScriptManagerProxy
ScriptManager
A server control that makes script resources available to the browser, including the Microsoft AJAX Library and the functionality that enables partial-page rendering.
ScriptManagerProxy
A server control that enables nested components to add script and service references if the page already contains a ScriptManager contro...
What is Use of Scriptmanager in asp.net AJAX
The ScriptManager control manages client script for Microsoft ASP.NET AJAX pages. By default, the ScriptManager control registers the script for the Microsoft AJAX Library with the page. This enables client script to use the type system extensions and to support features such as partial-page rendering and Web-service calls.BackgroundWhen a page contains one or more UpdatePanel controls, the ScriptManager control manages partial-page...
Friday, October 23, 2009
What is the CHECK constraint in SQL Server?
Business rule validation can be applied to a table by using CHECK constraint. CHECK constraint must be specified as a logical expression that evaluates either to TRUE or FALSE.A CHECK constraint takes longer to execute as compared to NOT NULL, PRIMARY KEY, FOREIGN KEY or UNIQUE constraints. Thus CHECK constraint must be avoided if the constraint can de defined using NOT NULL, PRIMARY KEY, FOREIGN KEY constraint...
What are the types of constraints in SQL Server?
There are three types of constraints in SQL Server -1. Domain Constraint - deals with one are more columns. 2. Entity Constraint - are all about individual rows. 2. Referential Integrity Constraint - are created when a value in one column must match the value in another column - in either the same table or in a different tabl...
What is the DEFAULT constraint in SQL Server?
A DEFAULT constraint, like all constraints, becomes an integral part of the table definition. It defines what to do when new row is inserted that does not include data for the column on which you have defined the DEFAULT constraint. You can either define it as a literal value(like default salary to zero or UNKNOWN for a string column) or as one of several values such as GETDATE().The main things to understand about a DEFAULT...
How to find out column names and their datatypes in a given table using a query in SQL Server?
Using the table tablename, write the query as follows - Select * from information_schema.columns where table_name = tablena...
What is the DEADLOCK ?
A deadlock is a situation in which two transactions conflict with each other and the only resolution is to cancel one transactio...
What is a Subquery ?
A Subquery is a normal T-SQL query that is nested inside another query. They are created using parentheses when you have a SELECT statement that serve as the basis for the either part of the data or the condition in another query.Subqueries are generally used to fill one of couple of needs -1. Break a query up into a series of a logical steps. 2. Provide a listing to be the target of a WHERE clause together with [IN|ESISTS|ANY|ALL]....
What is the EXISTS operator in SQL Server ? OR What is the EXISTS keyword in SQL Server ?
When you use EXISTS, you do not really returned data - instead you return a simple TRUE/FALSE regarding the existence of data that meets the criteria established in the query that the EXISTS statement is operated against.EXISTS simply test whether the inner query returns any row. If it does, then the outer query proceeds, if not, the outer query does not executes, and the entire SQL statement returns nothing.The EXISTS condition...
How to find nth highest salary from Employee table in SQL Server?
SELECT TOP 1 salary FROM (SELECT DISTINCT TOP n salary FROM employee ORDER BY salary DESC) a ORDER BY sala...
How to convert timestamp data to date data (datetime datatype) in SQL Server?
The name timestamp is a little misleading. Timestamp data has nothing to do with dates and times and can not be converted to date data. A timestamp is a unique number within the database and is equivalent to a binary(8)/varbinary(8) datatype. A table can have only one timestamp column. Timestamp value of a row changes with every update of the row. To avoid the confusion, SQL Server 2000 introduced a synonym to timestamp, called...
What is the IDENTITY property in SQL Server?
The IDENTITY property enables you to use system generated values in your tables column. It is similar to the auto number datatype in MS ACCESS. You are allowed a single column in each table with the IDENTITY property. Typically, IDENTITY column generates system assigned keys. To enforce entity integrity, you must uniquely identify each row in a table. If no natural column or set of column does this, you might went to create an...
What is the CASCADE action in SQL Server?
By default, you can not delete a record or update the referenced column in a referenced table if that record is referenced from the dependent table. If you want to be able to delete or update such records, then you need to set up a CASCADE action for the delete and/or updat...
What is the FOREIGN KEY in SQL Server?
FOREIGN KEYs are both a method of ensuring data integrity and a manifestation of the relationships between tables. When you add a FOREIGN KEY to a table, you create a dependency between the table for which you define the FOREIGN KEY (the referencing table) and the table your FOREIGN KEY references (the referred table). After adding a FOREIGN KEY, any record you insert into the referencing table must have a matching record in...
What is the use of CASCADE CONSTRAINTS?
When this clause is used with the DROP command, a parent table can be dropped even when a child table exist...
Get Current System Date Format
To get short date pattern of your system:messagebox.show(System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern())To get long date pattern of your system:messagebox.show(System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.LongDatePattern(...
Change Format of Date in VB.NET
Dim departDate As DatedepartDate = Date.NowDim d As String = Format(departDate, "dd/MM/yyyy")MsgBox(d)'Above Example shows how to convert date format according to our requirement...
Tuesday, October 20, 2009
Restricting numeric entries only in a DataGridView column
At times we have a requirement where we need to restrict the user to enter only numbers in a column of a DataGridView to achieve this we need to use EditingControlShowing event of DataGridView, this event is new in .Net framework 2.0 and it occurs when a control for editing a cell is showing. Following sample shows a implementation of it:private void dataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs...
Tuesday, October 13, 2009
Transposing Column to Row Through Select Query
My student Mr. Bhupendra Asked me that how can i show values of my columns of table as a ROW. To do so: (we also require such query while creating cross-tab reportlets we have following table:CREATE TABLE [vehical_type]( [unqid] [uniqueidentifier] primary key, [vname] [varchar](100) NULL)we can get our desired result from below query:-- It will be better to create Stored Procedure of it.declare @st varchar(max)set @st='create...
Friday, October 9, 2009
How to set required field validator for dropdownlist
My colleague Sweta asked me to how to set required field validator for doopdownlist.so to set required field validator for doopdownlist we need to follow these steps.1. let your dropdown list in such format that first item of it is "--Select--" as in example give below.2. if your valumember is integer type then set value '0' of valuemamber for "--Select--"3. take required field validator and select your dropdownlist as control...
Tuesday, October 6, 2009
How to implement keyword "Limit" like functionality in MS SQL Server
select * from mytable limit 10, 20 the equivalent in MS SQL Server would be: select top 20 * from mytable where pk not in (select top 10 pk from mytable order by pk) order by ...
Evaluate Rows one by one
through qry written below we will get 1 record at a time and in random order.SELECT TOP 1 * FROM TabCountryMast ORDER BY newid...
Thursday, October 1, 2009
Create Control at runtime using JavaScript
through code written below we can create control at runtime using javascript< %@ Page Language="C#" AutoEventWireup="true" CodeFile="AddRemoveJavascript.aspx.cs" Inherits="AddRemoveJavascript" % >< !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >< html xmlns="http://www.w3.org/1999/xhtml" >< head runat="server" > < title ><...
Wednesday, September 30, 2009
Check/ Uncheck all child nodes of a node in TreeView
when we need to Check/ Uncheck all chield nodes of anynode in TreeView we need to create a recursive function which will do check all to all child nodes of the current node and voice-versa. Private Sub tvrights_AfterCheck(ByVal sender As System.Object, ByVal e As System.Windows.Forms.TreeViewEventArgs) Handles tvrights.AfterCheck RemoveHandler tvrights.AfterCheck, AddressOf tvrights_AfterCheck CheckChildNode(e.Node)...
Visit all Nodes of TreeView
when we need to traverse all nodes of a treeview then we will have to create a recursive function.In below example we are showing how to visit all nodes of treeview.eg:- Private Sub TraverseTreeView(ByVal tview As TreeView) Dim temp As New TreeNode For k As Integer = 0 To tview.Nodes.Count - 1 temp = tview.Nodes(k) messagebox.show(temp) 'this will show node text For i As Integer...
Monday, September 28, 2009
Custom Page Size Crystal Report by Code
Dim oRpt As New CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt.Load(Server.MapPath("CrystalReport.rpt")) oRpt.PrintOptions.PaperOrientation = [Shared].PaperOrientation.Portrait oRpt.PrintOptions.PaperSize = [Shared].PaperSize.PaperEnvelope10 CrystalReportViewer1.ReportSource = oR...
Tuesday, September 22, 2009
Repair a database
Repair a databaseTo determine whether a database needs to be repaired run:dbcc checkdb('DB-NAME') with no_infomsgsreplacing 'DB-NAME' with the name of the database.If this completes without displaying any errors then the database does not need to be repaired.If the errors that come back contain lines saying:... Run DBCC UPDATEUSAGEThen the database does not need to be repaired, simply run:dbcc updateusage('DB-NAME') with no_infomsgsIf...
Monday, September 14, 2009
Static Class
Static classes are used when a class provides functionality that is not specific to any unique instance. Here are the features of static classes in C# 2.0.Static classes can not be instantiated.Static classes are sealed so they can not be inherited.Only static members are allowed.Static classes can only have static constructor to initialize static members.AdvantagesCompiler makes sure that no instance of static class is created....
Subscribe to:
Posts (Atom)