Auto Complete Search TextBox in MasterPage using JQuery and WebServices in Asp.Net using C#

Description:

In this example we explain that how to implement auto suggestion search textbox or auto complete textbox in master page in asp.net. Or auto complete textbox in asp.net master page using jQuery with web service.

Simply we already explain that how to autocomplete textbox or auto suggestion in textbox in asp.net but here we use master page with jQuery web service.so how to implement jQuery autocomplete in master page with its content page using web service in jQuery.

Import (Upload) CSV file data to SQL Server DataBase in ASP.Net using C#

Description:

In this example we explain that how to upload CSV file data to SQL Server database in asp.net application using C#.

Or how to Import CSV file data to SQL Server database in asp.net.generally we read the CSV file Data and inserted it into SQL Server Database. Sometimes we have requirement like we have thousands of record are available in CSV file so it is very time consuming if we inserted it manually to the Database by application so to overcome his we develop the code in which you have to just upload the CSV format file and it will automatically read the data (records) by separating delimiter and inserting it in SQL Server database.

Here we also use the SQLBulkCopy class to insert the data.

Get and Set Selected Text and Value of RadioButtonList using JavaScript or jQuery in ASP.Net

Description:

In this example we explain that how to Get or set the Text /value of the RadioButtonList using JavaScript and jQuery in asp.net.or get or set the selected Text and Value pair of the radioButtonList using JavaScript or jQuery.

Here below is the example of list of the Game defines with RadioButtonList and when you click on submit button it will display the alert message with the selected Text and value of the radioButtonList using client side JavaScript and jQuery.

Save (Insert) RadioButton value to SQL Server Database in ASP.Net using C#

Description:

in this example we explain that how to Save or Insert RadioButton value to Database in asp.net using C#.or how to insert RadiButton value into SQL Server database using C#.

as we know that generally we store the  RadioButton  value instead of text.because the text may be the changed so in future you have to just changed in design side not in backed or in SQL Server.

So how to access the value of RadioButton and save it into SQL Server Database.

Below is the example that demonstrate the store the Gender value in database.

Show Hide DIV with TextBox based on RadioButton selection using JavaScript or jQuery

Description:

In this example we explain that how to show or hide DIV or panel with Textbox and grouping of control based on RadioButton selection using JavaScript/jQuery in asp.net.

We all know that that’s type of requirement are daily work for the any software development like for example if we have two RadioButton like “self” and “other” in job application form in which if user selected or checked “other” RadioButton” then and then only show the below TextBox with DIV element.so how can you have implement.

There are many scenario in which that types of show or hide group of control based on RadioButton selection (checked/unchecked).

So here we explain that how to show hide DIV when RadionButton selection is changed.

Below is the JavaScript and jQuery to demonstrate the show or hide DIV or group of control based on RadioButton selection.

how to get disabled TextBox value in c#

Description:

In this example we explain that how to fetch value of disabled textbox in asp.net.or how to retrieving value of disabled Asp.Net textbox. Or how to get disabled textbox value in C#.

.net cannot get value from disabled or read-only textbox control so how to get new updated value of disabled textbox in asp.net in code behind.

For example suppose I have 3 textbox price, quantity and total. The value of the total textbox is disabled because of the total is automatically calculated based on the quantity and price.so when we update the quantity or price the total will be calculated proper but when we click on save button it will retrieve or fetch always its old or previous values because of the textbox disabled.so to overcome this problem we have to add one more HiddenField that will store the updated value of the disabled textbox(total textbox value) and when user click on save button at that time we have to insert HiddenField value so it will always save the latest or updated value of the disabled textbox.

How to Swap Values between Two Columns in SQL Server

Description:

In this example we explain that how to Swap values between two columns using SQL Server query. Or how to update column1 values to column2 and column2 values to column1 like vice versa in sql server using update statement.

As we all know that when we working with database moving, swapping and updating values between a column is a common task for the all the developer in IT industries because there is a routine work.

Here in the below example we have one table called test in which there are two column column1 and column2 in which we have to swap the data column1 to column2 and vice versa.

How to access shared Network drive file using C#

Description:

In this example we explain that how to access shared Network drive file using C# code. Or how to access file from remote computer with providing credential or how to access server file that is hosted on another network with same domain. Or how to access file on another computer shared folder. Or access network file using asap.net.or how to provide user name and password when connecting to a network share in asp.net.

There are many question that how to use network file that is located in another computer. Below is the code that demonstrate that how to use the network file with login with credential in remote computer. First you have to create a NetworkShareAccesser class to validate the user with credential.

How to add click event to rows in Gridview in asp.net

Description:

In this example we explain that how to add Row Click event in GridView in asp.net using C#.or how to add row click event to Gridview Rows in asp.net.

Sometime we have requirement like when user click on Gridview Row then it will display its related information on popup.

Here we demonstrate how to pass row index in the row click of the gridview and perform some operation.we used gridviews onSelectedIndexChanged event to perform the row click functionality of the gridview.

set cursor to first error when validation raise error in asp.net

Description:

In this example we explain that how to set cursor to first error when validation raise error in asp.net.or scroll to the first error when error is raised in asp.net.

We all know that for the user point of view if our application have a long form at that time user will fill up the form and then last when he/she click on the submit button and if the validation is fired at that time user doesn’t have any idea which filled are missing or incorrect because of the long form.

So avoid this type of mistake and provide nice layout to the user for the end user satisfaction we have to direct scroll user to the first error raised by the validator so user can easily understand that and solved that.

So below is the code that demonstrate how to scroll to first validator error when validation failed in asp.net.

Auto Refresh Update GridView In Asp.Net Ajax With Timer.

Description:

In this example we explain that how to refresh a Grid View automatically at regular intervals in asp.net.or refresh grid view after every 5 second in asp.net using C#.

Here we use we use Timer control to achieve this requirements. Simply we add the Grid view in the AJAX Update Panel control and set the timer interval in which we have to refresh the grid view automatically.

Below the code that demonstrate auto refresh grid view after specified interval in asp.net.

display confirmbox code behind (server side) in asp.net

Description:

In this example we explain that how to display Confirmation box in server side in asp.net. Or display confirm box in code behind in c# in asp.net.or how to build a confirm message or dialog box at server side or code behind in asp.net.

In client side using JavaScript it is possible to create confirm box simply but how can I call on server side because JavaScript only post back when we click on “OK” but when we click on “Cancel” it will not post back. So how can I perform operation when click on OK or Cancel as per click.

Below is the example that demonstrate display confirm box when click on button and display message to the user you press ok button or cancel button at server side or code behind in asp.net.

SQL Server query to group by with alias column name .

Description:

In this example we explain that how to group by with alias column name in SQL Server query. Or group by on alias column in SQL Server. Or SQL Server example to Group by alias column name in SQL query.

Sometime we have requirement like required or fetch data in SQL Server but in alias column name. Below is the query that demonstrates the Group by data in SQL Server with alias column name.