TechnoBlogy

Retrieving domain information through ASP.NET

There are many  domain checking websites available that gives all the information regarding domains. WhoIs is one of them. Following is a sample asp.net code that connects to one of WhoIs servers and retrieve information of a specific website.
using System; using System.Collections.Generic; using System.Linq; [...]

Add meta data dynamically

Add meta-data dynamically to your page by adding a HtmlMeta control to your Header. In this example I dynamically add a keyword string to the page.
string keyWords = “metatags, html, dynamic, generate”;
HtmlMeta keywords = new HtmlMeta();
keywords.Name = “keywords”;
keywords.Content = keyWords;
Page.Header.Controls.Add(keywords);

Date Time string formatting in ASP.NET

With the following code you can format a DateTime within a Databind.
<%# DateTime.Parse(Eval("DateModified").ToString()).ToString("MM-dd-yyyy")%>

Some more format specifiers that can change format of datetime objects the way it is required.

Format specifier
Name

d
Short date pattern

D
Long date pattern

t
Short time pattern

T
Long time pattern

f
Full date/time pattern ( short time )

F
Full date/time pattern ( long time )

g
General date/time pattern ( short time [...]

Easy way to Export dataset in Excel

Fastest way to export dataset in excel format is:

DataSet dsExport = new DataSet();
System.IO.StringWriter tw = new System.IO.StringWriter();
HTMLTextWriter hw = new HTMLTextWriter(tw);
DataGrid dg = new DataGrid();
dg.DataSource = "Dataset to be exported"
hw.WriteLine ("<b><font size=’3′>Exported report</font></b>");
dg.DataBind();
Response.ContentType = "application/vnd.ms-excel";
EnableViewState = false;
Response.Write(tw.ToString());
Response.End();

Crystal Report Viewer width – Visual Studio

By default Crystal report viewer width is fixed according to it toolbar, but changes due to amount of data present in the report. And the width is not editable (as it is seen). Because of this reason if a crystal report has good amount of data then it goes past page width and disturbs the [...]

Calculating difference of dates in Oracle

How to calculate difference between two dates in oracle, as subtraction of dates returns numeric value as difference. With some slight changes/enhancements we can track back the subtraction values to some readable date formats:
Here are some examples, these can also be amended for user convenience:
SQL> SELECT floor(((date1-date2)*24*60*60)/3600)
2 [...]

ORA-38029 : object statistics are locked Recently

This error comes when analyzing tables in oracle. Basic issue in this error is  when you import table without data i.e structure/schema only, oracle will lock table statistics.
You can view all the locked tables in schema by executing following query:
select table_name, stattype_locked
from dba_tab_statistics
where owner = ‘MBS’ and stattype_locked is not null;

Then how to [...]

Creating Table dynamically in Oracle Procedure

How can we create a table inside an Oracle procedure.
"CREATE TABLE tableName AS". We cannot execute this statement in procedures because upon creation of procedure it would give syntax error.
We can implement this with the help of EXECUTE IMMEDIATE command and then dynamically create table.
create or replace procedure Proc1 as [...]

Killing Locked Sessions in Oracle

Many a times user sessions are locked in some DML/DDL operation, than how to unlock those sessions because a new step or operation could not be done on the specific object that is locked.
Some really easy steps to unlock an object or kill a session in oracle are as follows:
To view locked sessions in oracle:

select [...]

Creating Custom Functions in Oracle

Here it is a simple procedure to create and call a custom function in Oracle. A custom function is a simple PL/SQL subprogram that is used to calculate a value. It creation syntax is almost same as of procedure except it has a RETURN clause that is used to return the computed value.
Syntax of creating [...]

SqlBulkCopy – Bulk Insertion in SQL Server from .NET

Many a times there come a scenario when you have to insert large number of records in sql server. There are number of ways to implement this scenario:

through looping techniques to call insert statements for one record at a time.
Serialize the data in CSV or XML format and send them as a parameter to a [...]

Write a Custom SQL Scripter (Generating bulk insert, update statements)

There are always some static tables in our database that needs to always have some default values in them, for our custom application development. Usually a huge amount of data resides in these tables because they are slowly changing dimension fields. So when it is time to transfer this data the question arises how to [...]

Validating string for numeric values in SQL Server

What to do when you have a large string and you have to validate whether this string only contain digits or not. A straight thing that comes in our mind is to use a looping technique to traverse all the characters in the string and validate each character to be a digit. But how could [...]

SQL Server permissions

Permissions on data are one of the most critical aspects of database administration. If you’re too strict as a database administrator then your users will not be able to do their jobs. If you’re not lenient, then data can be compromised or even leaked. It is a very fine balance to control. The ability to [...]

How To Calculate the Number of Week Days Between two Dates

If the start date and end date are both week days, then the total number of week days in between is simply:
(total difference in days) – (total difference in weeks) * 2

DateDiff(dd, @start, @end) – DateDiff(ww, @start, @end)*2

… since the DateDiff() function with weeks returns the number of week "boundaries" that are crossed; i.e., [...]

How to make XP look like Vista-Longhorn

So, how many of us are bored of looking at user interface of XP? Most of us, because Microsoft has only released 2-3 themes for XP from its launch. There are many different websites that allows to download themes for XP that are not developed by Microsoft. But by downloading them and adding them in [...]

Disable UAC in Windows 7

User Access control was a new feature introduced in windows vista, but has become increasingly annoying due to extra security clicks on performing simple windows operations.
Microsoft has changed User Access control features a little bit in Windows 7, and now it is some what better than its previous version of windows vista. Windows 7 UAC [...]

Configuring SSL for a website on IIS

To remove the issue of sending/receiving data on http, SSL (Secure Sockets Layer) is used to encrypt data for transmission.
In order to implement SSL successfully on your IIS, you need to get a Server Certificate. Server Certificates can be obtained from a trusted 3rd party CA such as VeriSign or Thawte.
Steps for Configuring SSL
To configure [...]

Hibernate – Insufficient system resources exist to complete the API

This annoying error comes up when a user tries to hibernate its system, and this error pops up and now the hibernation option is not available until system restarts.

 
 
 
 
This problem occurs because the Windows kernel power manager cannot obtain the memory resources that are required to prepare the computer to hibernate.
A Microsoft KB article [...]

Service Unavailable – Error message

When you configure your IIS webserver and find the following message Service Unavailable Then the first solution to the above error is http://support.microsoft.com/default.aspx?id=823552 but if this does not solve the problem try doing the following stuff. Open the IIS Manager, right click Web Sites [...]