This article shows how to display real time sql server database change notification in ASP.NET using SignalR and SqlDependency object which represents a query notification dependency between an application and an instance of SQL Server. Consider your database is updated or synchronized by windows service in background, you have to display real time updated data. This article explains how to implement it.
Our objective is to customize asp.net wizard control sidebar as stylish horizontal step navigation on top without any image. First, we will disable existing side bar and use header template to create own sidebar. See following screen-shot which we are going to implement:
This article explains how to add a pop-up control to a gridview in order to display drill-down (Master detail) information without using ajaxcontroltoolkit ModalPopup extender. let us take an example to display Northwind database’s customer table.
Naming conventions in programming languages have potential benefits to reduce the effort needed to read and understand source code and provide better understanding in case of code reuse after a long interval of time. It’s a initial step for beginner to learn any programming language and It later becomes a habit. Here are some good resources for .NET web developers.
Generally we need to convert stream as file attachment in asp.net to provide export functionality. The main objective is to convert stream as file attachment without creating any file on server side. So I created a common method which takes stream as input and gives as file attachment in response.
If you are working on DayOfWeek and saving it as integer in database then you need to convert integer to day of week(Sunday,Monday…) again to show data on page. This article explains how you can do this easily.
The DayOfWeek enumeration represents the day of the week in calendars that have seven days per week.
The HttpWebRequest and HttpWebResponse classes from the .NET Base Class Library make it easy to access Internet resources through a request/response model. The Httprequest object identifies the Web page to get and contains a GetResponse() method for obtaining a HttpWebResponse object. With a HttpWebResponse object, we retrieve a stream and extract page information using stream operations.
Approx one month ago, I launched BrijPad – An Online Fast Development Tool. First, I thank you all for giving feedback. I have received lots and it is wonderful of you to take the time to read and comment. I got some expected points and some new points to make it attractive. Being a weekly blogger, I can’t go fast, but have added some required functionality and new features. This post explains the new features and functionality.
Yesterday, I got following question:
Q: I have dropdownlist(say country) and the datasource is datatable having countryname, countrycode columns. I have to select proper country in dropdownlist from the text. I don’t have value(countrycode) to select. How can I do this?
I was updating database using DataAdapter.Update method and got following error:
System.Data.DBConcurrencyException: Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.
I was updating 2-3 columns of tables (having 20 columns) and expected to update those columns only. I fixed the problem and decided to write on it.
The object is to bind an array to particular column of asp.net gridview. Suppose we have a grid having 3 columns and an array say “data“. Now we have to bind data array to grid’s second column (binded by mycolumn). See following html code:
The world is continuously changing, A web developer should ready for the new technologies. To know the latest news and developments, gain knowledge, share information and give opinions, millions of people around the world follow blogs. Being an ASP.NET dev, Here is the list of my favorite ASP.NET blogs with twitter links
I have completed my PGDIT from SCDL and sharing my thoughts on final year project. Here are the instructions and guidelines by SCDL related to PGDIT final year project and about sample project.
In sharepoint, it is generally required to limit search to a particular list or document library and display metadata properties. The example below shows an example FullTextSql query using the PATH managed property to limit your search to a particular list, and then the results are used to create the list item. You can bind results to gridview and can show metadata properties.You need to pass document library url and search text in the following method: