How to Submit data on DropDown Selection changed in MVC Razor

Submitting the form by button, programmer have to assign only the type of that button and on click this button all the data can be get on the server side. On drop-down change we have manually submit the form by either specifying "OnSelectionChanged" event or some jquery functions.

In earlier article I have created DropDownList in MVC, to submit the form we can simply use only submit function on change event of the list.

@Html.DropDownList("ddlname", "List to bind", "--default title--", new { onchange = "submit();" })

After writing this code on change it will post all the data on the form to server-side but programmer have to use same name in action method as used here “ddlname”. When we use view-model to bind the data then dropdown list’s code will be changed as:

@Html.DropDownListFor(model => model.Property , "List to bind", "--default title--", new { onchange = "submit();" })

This code will contains the value of the property of model as used here. The value will submit on change the selection of this drop-down list. Programmer can change other controls value by using this code.

Suppose we have to select country, state and city on the form in hierarchy manner. On change the country, states drop-down list should change and on change of state, city drop-down list should change. By implement this functionality we can use this submit functionality.

How to Use Multiple Submit Button in MVC Razor

The most common method to get the data on server from client side. Submit button on the form can be used to post all the form data to be used further by programmer. Generally one form only have a single submit because of user want to post data only once.

To submit data in different ways programmer can use more than one submit button. A form can have multiple submit buttons as per the requirement of programmer. We can send the button’s name on the button click.

The action should have the same name of the button to get the value of clicked button. Suppose all the button’s have same name as submit as written below:

<input type = "submit" name = "btnsubmit" value= "submit1" />
<input type = "submit" name = "btnsubmit" value= "submit2" />
<input type = "submit" name = "btnsubmit" value= "submit3" />

Now in controller’s action the variable should be of string type and name as “submit” as below:

[HttpPost]
public ActionResult SubmitData(string btnSubmit)
{
If (btnSubmit == "submit1")
{
//code to execute
}

If (btnSubmit == "submit2")
{
//code to execute
}

If (btnSubmit == "submit3")
{
//code to execute
}
}

According to this code we can implement different functionality on each submit button with all the data posted on the form. These button will only post the data containing as input on the form and also inside the form element.

How to add Hyperlink button control by using code in windows phone

In previous article we have already learned about  Hyperlink Button control.  Using the HyperlinkButton control you can navigate one page to another in windows phone. The following example creates a HyperlinkButton control named hyper and then adds it to ContentPanel grid.

To add the Hyperlink Button control by using code

Open MainPage.xaml.cs.

Add the following code in the constructor.
C#

public MainPage()
        {
            InitializeComponent();
            HyperlinkButton h1 = new HyperlinkButton();
            h1.Content = "My Button";
            ContentPanel.Children.Add(h1);
            h1.Click += new RoutedEventHandler(HyperlinkButton_Click);


            // Sample code to localize the ApplicationBar
            //BuildLocalizedApplicationBar();

        }

 private void HyperlinkButton_Click(object sender, EventArgs e)

        {

            NavigationService.Navigate(new Uri("/secondpage.xaml", UriKind.Relative));

        }

Create Hyperlink Button control instance , assign string to the content property of Hyperlink Button. Now add this control into Content Panel. When we click on it then page navigate to other page. The name of other page is "secondpage.xaml". So raise click event for that, using NavigationService.Navigate ( ) method you can move one page to another.

Code generate the following code

How to add a Hyperlink Button control to a page in Windows Phone 8

This topic describes the various ways to add a Hyperlink Button control to a Windows Phone 8 project. The Hyperlink Button control is part of the libraries in Windows Phone SDK 8.0.
This topic contains the following sections.

1. Adding a Hyperlink Button control by using the Toolbox.
2. Adding the Hyperlink Button control by using XAML.
3. Adding the Hyperlink Button control by using code.

Adding a Hyperlink Button control by using the Toolbox

The easiest way to add a Hyperlink Button control and reference it properly is to drag it from the Toolbox and drop it to your XAML designer or XAML view.

To add a Hyperlink Button control from the Toolbox

1. In the HyperlinkApplication project, open the Toolbox, and then open the All Windows Phone Controls.
2. From the Toolbox, drag the HyperlinkButton control to the XAML or designer view.Visual Studio performs the following tasks automatically.

In the <phone:PhoneApplicationPage> start tag of the XAML page.

Adds the following XAML if you drag the control to the design view.

<HyperlinkButton Content="HyperlinkButton" HorizontalAlignment="Left" Margin="103,213,0,0" Grid.Row="1" VerticalAlignment="Top"/>

    3. Add single attribute in HyperlinkButton tag, which is NavigateUri="http://www.google.com".

    4. Must Add TargetName property with the NavigateUri property, if you use this for external url. It does not matter what value you use for this property.  Now your complete code look like

<HyperlinkButton TargetName="Google" NavigateUri="http://www.google.com/" Content="HyperlinkButton" HorizontalAlignment="Left" Margin="103,213,0,0" Grid.Row="1" VerticalAlignment="Top"/>

Code generate the following output

How to get back date from current date in ASP.NET C#

If you want to find back date from current date then you should take DateTime Structure with add days method. Through this method we can add some days in existing date. But if we pass minus sign(-) with integer value  in add days method then you get back date. lets take a simple example.

Complete Code

<%@ Page Language="C#" %>

<!DOCTYPE html>

<script runat="server">

    protected void Button1_Click(object sender, EventArgs e)
    {
        DateTime currentdate = DateTime.Now;
        Label1.Text = currentdate.ToString()+"<br/>";
        Label1.Text += "before 3 days " + currentdate.AddDays(-3);
    }
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Get back Date</title>
</head>
<body>
    <form id="form1" runat="server">
  <div>
        <asp:Label ID="Label1" runat="server" Text=""></asp:Label>
        <br />
        <br />

        <asp:Button ID="Button1" runat="server" Text="Get Back Date" OnClick="Button1_Click" />
    </div>
    </form>
</body>
</html>

Code Generate the following output

Download Source Code

How to Perform Searching Data by Using a Full-Text Search

After the full-text index has been created on a table, you can query the table by using the full-text predicates. The full-text predicates are used to specify how the search string should be searched in the table.
Predicates can be used to enhance the search so that the result have so focus on the search criteria. Sql programming have a list of predicates to be used.

The following predicates can be used while performing the full-text search:

FREETEXT: When the search criteria are given, FREETEXT searches for any variation of a word or a group of words given in the search column. FREETEXT is used for the prefix searches.
Considering the previous scenario of the bike racing competition, you can use the FREETEXT predicate to obtain the desired output, as shown in the following statement:

SELECT Description FROM Production.ProductDescription WHERE FREETEXT (Description, ‘race winners’)

CONTAINS: This predicate is used in queries when you want to search for a specific phrase or for the exact match. It also searches for the proximity of words within a text. For example, you can use the following statement to search for the words ‘Ride’ near the word ‘Bike’ in the ProductDescription table:

SELECT Description FROM Production.ProductDescription
WHERE CONTAINS (Desctiption, ‘ride NEAR bike’)

Populating the Full-Text Index in Search: SQL Server

After creating the full-text index, you need to populate it with the data in the columns enabled for full-text support. The SQL Server full-text search engine populates the full-text index through a process called population. Population involves filling the index with words and their location in the data page. When a full-text index is created, it is populated by default. In addition, the SQL Server automatically updates the full-text index as the data is modified in the associated tables.

However, the SQL Server does not keep a list of changes made to the indexed data when the CHANGE_TRACKING option is off. This option is specified while creating the full-text index by using the CREATE FULLTEXT INDEX statement.

If you do not want the full-text index to be populated when it is created using the CREATE FULLTEXT INDEX statement, then you must specify NO POPULATION along with the CHANGE TRACKING OFF option. To populate the index, you need to execute the ALTER FULLTEXT INDEX command along with the START FULL, INCREMENTAL, or UPDATE POPULATION clause.

For example, to create an empty full-text index on the ProductDescription table, you can execute the following statement:

CREATE FULLTEXT INDEX ON Production. ProductionDescription (Description)
KEY INDEX PK_ProductDescription_ProductDescriptionID
WITH CHANGE_TRACKING OFF, NO POPULATION

To populate the index you need to execute the following statement:
ALTER FULLTEXT INDEX ON Production. ProductDescription START FULL POPULATION

The preceding statement will populate the full-text index created on the ProductDesctiption table.

Similar to regular SQL indexes, full-text indexes can also be updated automatically as the data is modified in the associated tables. This repopulation can be time-consuming and adversely affect the usage of resources of the database server during periods of high database activity. Therefore, it is better to schedule repopulation of full-text indexes during periods of low database activity. You can specify the following types of full-text index population methods to repopulate the index:

Full Population

You can use this method when you need to populate the full-text catalog or the full-text index for the first time. After that, you can the maintain the indexes by using change tracking or incremental populations.
During a full population of a full-text catalo, index entries are built for all the rows in all the tables covered by the catalog. If a full population is requested for a table, index entries are built for all the rows in that table.

Change Tracking-Based Population

The SQL Server maintains a record of the rows that have been modified in a table set up for full-text indexing. These changes are propagated to the full-text index.

Incremental Timestamp-Based Population

The incremental population method updates the full-text index with the data that has been changed since the last time the index was refreshed. For an incremental population refresh to work, the indexed table must have a column of the timestamp data type. If a table does not have a column of the timestamp data type, then only a full population refresh can be done.