ALTER TABLE tableName 
 
DROP foreignKeyName

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.IO.Compression;
 
namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
 
        private void Form1_Load(object sender, EventArgs e)
        {
            
            FileStream inFileStream = new FileStream(@“c:\cal.JPG”, FileMode.Open);
            byte[] buffer = new byte[inFileStream.Length];
            inFileStream.Read(buffer, 0, buffer.Length);
            inFileStream.Close();
 
            FileStream outFileStream = new FileStream(@“c:\cal.gz”, FileMode.Create);
            GZipStream compressedStream = new GZipStream(outFileStream, CompressionMode.Compress);
            compressedStream.Write(buffer, 0, buffer.Length);
            compressedStream.Close();
            outFileStream.Close();
 
 
        }
    }
}

< %@ Page Language=“c#” ContentType=“text/html” %>
< %
	string useragent = Request.ServerVariables[“HTTP_USER_AGENT”];
   
	System.Text.RegularExpressions.Regex r = new System.Text.RegularExpressions.Regex(“.NET CLR [0-9.]*”);
	bool flag = false;
	foreach (Match m in r.Matches(useragent))
    {
        Response.Write(“<br><li>” + m.Value.Replace(“CLR”, “Framework”));
        flag = true;
    } 
    if (!flag) 
    {
        Response.Write(“You have NO .NET frameworks installed”);
    }
%></li>