How to convert XML file into dataset in C# programming?In this blog I will show you how we can get XML data into a dataset. What is XML? XML is a markup language developed by the World Wide Web Consortium (W3C). The full form of XML is Extensible Markup Language. The way to write code … Read more
Few important questions for SQL Server asked ASP.Net Developer. Part- 2 Indexes-Indexes are used to query data faster from a table. Indexing avoids full table scan. Create Index IX_customer_amount on tblcustomer (purchase_amount ASC) So this index will store purchase amount in ascending order.Purchase amount20005000550075009000 To view all indexes on a table either go to object … Read more
How to crawl a public website content into a SharePoint site?Just now i developed this module, the scenario is:I have a page in SharePoint and I want to search content from other public websites and want to show the result in a data source into my Page.First you need to configure search service.Create scope, each … Read more
In this blog, we will see some of the important SQL Interview Questions and Answers. 1. What is a Primary Key? The primary key is used to uniquely identify a record. A table can not have more than one primary key.If a table has userid, email, passport no. and userid is the primary key then how to maintain the … Read more
What is JQuery? · Jquery is a light weight java script library.· JQuery is cross browser.· Easy to write compare to java script. $(document).ready is a jquery event. It fires as soon as the DOM is loaded.This event is fired before all the images, css are fully loaded. $(window).load event fires when DOM and all … Read more
In this blog, I have collected Interview questions and answers of OOPS (Object Oriented Programming System). Q. What are OOPS principles? Object-oriented is an approach to programming in C#, Java etc.OOPS Principals – 1. Abstraction2. Encapsulation3. Inheritance4. Polymorphism Q. Is inheritance possible if a private constructor is declared in parent class? Answer – No. Q. What is Early Binding and … Read more
If you are working on a website then there might be a chance to handle a large amount of data on a public site. Generally, we are binding code with Gridview like this: Gridview1.Datasource = dataset;GridView.DataBind(); After that our page loads data and it looks ok, but when we look into view source of the … Read more
In this blog, We will perform operations with Active Directory with C# Programming. Some of the operations such as enabling users, and disabling users. Before moving ahead, We will first understand – What is an Active Directory. What is Active Directory? Active Directory is a central database for an organization. It keeps the record in … Read more
sp_addlinkedserver linked 2 servers. Once sp_addlinkedserver query executes, query can be run against these servers. Run below queries one by one to link, to provide login credentials and to access data EXEC sp_addlinkedserver @server=’ServerName’ EXEC sp_addlinkedsrvlogin ‘ServerName‘, ‘false’, NULL, ‘username’, ‘password’ select * from [ServerName].[DBName].[DBO].[TableName] Once your requirement is done, you may drop the linking by … Read more
As you know pagination is very important for any data control for eg Gridview if you have large amount of data. Server load on pagination is also a big concern.Below is the code for pagination in gridview using client side. It means no page load/ server post back operation will be performed. To implement this … Read more
