Get Asp.Net Original Unhandled Exception Error Message in JQuery AJAX error Function in C#.Net VB.Net

In my previous articles I have explained how we can invoke or call server side method using JQuery AJAX. Here in this article I will explain “How we can handle ASP.Net WebMethod Unhandled Exception from JQuery AJAX error Function in C#.Net and VB.Net Web Applications“. It’s very important to catch or handle unhandled exceptions from JQuery AJAX function because using this function we can display error message properly to user, Log errors properly as well as it will help us a lot to pin point the error through the ASP.Net server error message and stacktrace. In many forums I found that developers more often confused whenever they did not get proper error message from JQuery error function. It’s for you. Try it. Hope it will resolve your debugging issues.

Read more ›

Posted in .Net, Ajax, Asp.net, C#, Client, JQuery, VB.Net

JQuery AJAX Example Code in Asp.net to Insert or Save Data into SQL Server Database without Postback in C#.Net VB.Net

In almost each and every web application we need to save or insert data into database. To save or insert data into database we need to postback into the server. Using AJAX we can provide the functionality without refreshing the browser. JQuery Ajax provides us an easier option to easily integrate Ajax functionality in ASP.Net web applications. In this article I will discuss “How to Save or Insert Data into SQL Server Databse using JQuery AJAX in ASP.Net C# and VB.Net Application“. By reading this article one can also learn how to integrate JQuery AJAX in ASP.Net applications.

Read more ›

Posted in .Net, Ajax, Asp.net, C#, Client, Database, JQuery, SQL Server, VB.Net

How to Check or Handle NULL Values in Where Clause in SQL Server

NULL is an interesting value in any relational Database. Sometimes its same (for Grouping), some times not (for equality). In many cases we need to identify records those contains NULL value. Some times we need to discard records if any specific column contains NULL values. So as a developer handling NULL values in WHERE clause is common. Here I will discuss how we can “Handle NULL values in SQL WHERE clause“.

Read more ›

Posted in Database, SQL Server

Efficient way to Save or Insert TextBox Value into MS Access DataBase Table In Asp.net Using C#.Net VB.Net

We can use MS Access Database for small scale applications. Asp.net Ado.Net provides us an easy, efficient way to develop Database driven application using MS Access as back end. To start an application here I have described “How to Insert or Save TextBox Data into MS Access Database Table in an efficient way“. Hope this example will help you to go further.

Read more ›

Posted in .Net, Asp.net, C#, Database, MS Access, VB.Net

Runtime Bind Data from SQL Server Table to Datagridview in Windows Application in C# VB.NET

DataGridView is an essential control for windows applications. This control can be used in both C#.Net windows applications as well as VB.Net Applications. Specially we use this control for tabular data representation. Here in this article I will show “How to Bind SQL Server Table Data to Datagridview in Windows Applications“. To do the example we need to create a Table first. After that from run time we will bind the SQL Server Table Data into the DataGridView control.

Read more ›

Posted in .Net, C#, Database, DataGridView, SQL Server, VB.Net

How to Create RDLC Report Step by Step Example in ASP.net using C# and VB.net

Now a days for reporting purposes we have a lots of choice. RDLC report is one of the most popular reporting engine for Asp.net developers. Using RDLC report you can easily represent data to the end user. You can also export the report in Excel, PDF & MS Word format. Print functionality also in built in this ReportViewer control. This a very basic RDLC report tutorial for beginners. In my next articles I will also provide more example on RDLC report. Here I am providing “Creating RDLC report Step by Step in Asp.Net C# & VB.Net“. Hope it will help you.

Read more ›

Posted in .Net, Asp.net, C#, Database, RDLC Report, SQL Server, VB.Net

SQL SERVER – SQL CASE Statement Conditions Examples Syntax and Explanation

The SQL CASE statement is used as a conditional operator that considers a value or expression, examines it, and return values if matched. CASE is used to provide if-then-else type of logic or Switch Case type of logic to SQL. There are two formats: The first is a Simple CASE expression, where we compare an expression to static values. The second is a Searched CASE expression, where we compare an expression to one or more logical conditions. We can replace resource hungry Cursor/Looping SQL and can provide better performance using CASE statement.

One can use CASE expressions anywhere in the SQL Query like within SELECT statement, WHERE clause, Order by clause, HAVING clause,Insert, UPDATE and DELETE statements.

Read more ›

Posted in Database, SQL Server

Using SQL Server SUBSTRING Function

SUBSTRING() function is one of the most useful and popular string manipulation function of SQL Server. This function allows you to extract a specific substring or a portion of substring from a string. In this SQL Server Tutorial I will explain how to use the SUBSTRING function in SQL Server (Transact-SQL/TSQL) with syntax and examples.

Read more ›

Posted in Database, SQL Server

How to TRIM a String in SQL Server

TRIM is a very popular string function in many SQL. But SQL Server does not have TRIM function directly. Instead of TRIM string function SQL Server provides us LTRIM and RTRIM function to remove specified prefix or suffix from a string. which is more sophisticated. You can also do the same functionality by using both LTRIM() and RTRIM() function together. To make you a good understand her I will show some example on TRIM string function. Hope it will help you.

Read more ›

Posted in Database, SQL Server

How to Create and Use a GUID in Asp.net C# VB.Net Application

What is a GUID:
If you don’t know about GUID, a GUID (Globally unique identifier) is a 128-bit integer that can be used to uniquely identify a record or data. Specially we use GUID as a prefix or post-fix while we gave users to upload images or files in a same folder. Another common usage is to create a auto increment integer. So finally A GUID is a 128-bit integer (16 bytes) that can be used across all computers and networks wherever a unique identifier is required. Such an identifier has a very low probability of being duplicated.

Read more ›

Posted in .Net, Asp.net, C#, VB.Net