Today I came here to discuss a popular industrial issue with a work around, which hopefully, you will find useful. As the title depicts, we commonly have a large data set which needs to be display in DataGridView control and it is expected that the larger the dataset, the greater time it will take to … Continue reading
Are you looking for a way to find procedure in all databases? In this post you will find a way to search procedure in all databases. There are some other ways to do so but here it will be demonstrated by using dynamic SQL. The attached procedure will prepare a query with respect to all … Continue reading
While working with xml it is more meaningful to the user if xml could appear in a hierarchical manner which can increase understandability. For example the below sample is preferable from perspective of readability and understandability: <?xml version=”1.0″?> <note> <to>Tove</to> <from>Jani</from> <heading>Reminder</heading> <body> <name>abc</name> <message>Don’t forget me this weekend!</message> </body> </note> while this detracts the … Continue reading
INTRODUCTION: We often write ‘FOR XML PATH’ queries in SQL to get data in XML form. Also we can extract unlimited data from a table via XML queries. The problem I am going to discuss today is how to read FULL contents of “FOR XML Path” sql query. I will describe various techniques to retrieve … Continue reading
This happens when we do not assign name to each row as well as root element. So by default system takes DocumentElement as node name which at later stage throws error on validating node.Here is a snap shot: To resolve this issue, we must have to assign name to the ROOT element. for example this … Continue reading
This happens when we call WriteXml method of DataTable: This exception is raised when we serializes a DataTable when its TableName Property is not set. So, to stop getting this error you have to ensure that the DataTable have TableName property set. NOTE: This do not worth if you are using XMLDataDocument. But remember, XMLDataDocument … Continue reading
Overview: It seems strange when we look at the title that usually experts suggest to clone an object through implementation of IClonable interface. But as I have experience, it is good until we do not have a smart and big application where dozen of relations already exists among the objects and you just need this … Continue reading