Template for aspx page with dynamic controls

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;


public partial class template : System.Web.UI.Page
{


#region Introduction
private string msg; //this is the message you are going to show to your users


private TextBox [ ] holderForTxt; //holder for dynamic textboxes
private DropDownList [ ] holderForDdl;
private HtmlInputRadioButton [ ] holderForRdb;
private HtmlInputCheckBox [ ] holderForCkb;
private Label [ ] holderForAst;

DataSet ds; //dataset for metadata
DataSet pds; //parameter dataset
DataSet rds; //return set dataset


#endregion

#region Properties
//set here page properties to use with the viewstate
#endregion //Properties



protected override void OnInit ( EventArgs e )
{ //HUOMI THIS FIRST
//debug Utils.Debugger.WriteIf ( "template.aspx.cs OnInit method START " );
base.OnInit ( e );
Page.Load += new EventHandler ( Page_Load ); //this one has to be set if the page directive is AutoEventFireUp = "false"

if (this.IsPostBack == false)
{
//null here Session which are supposed to be null on first time loading the page
} //eof if (this.IsPostBack == false )
else
{
//debug Utils.Debugger.WriteIf ( "if (this.IsPostBack == true )" );
}

} //eof OnInit


protected override void CreateChildControls ( )
{
base.CreateChildControls ( );
CreateDynamicControls ( );
} //protected override void CreateChildControls ( )


protected override object SaveViewState ( )
{
return new Pair ( base.SaveViewState ( ), null );
}

protected override void LoadViewState ( object savedState )
{
base.LoadViewState ( ((Pair)savedState).First );
EnsureChildControls ( );
} //LoadViewState


protected void Page_Load ( object sender, EventArgs e )
{ //comm -- the controls should be generated at the init stage and the databinding happens here

if (this.IsPostBack == false)
{
} //only on post back
else
{
}
this.DataBind ();
} //eof Page_Load



private void CreateDynamicControls ()
{
if (Session [ "template.ClickSearchClicked" ] != null && (int)Session [ "template.ClickSeachClicked" ] == 1)
{
this.BuildDynamicControls ();
} //eof if

} //eof CreateDynamicControls

protected void ClickSearch ( object sender , EventArgs e )
{
//GO GET THE DATA FROM THE DATABASE
//PUT DATA INTO class variable and session
//ds = methodToGetDataFromDb ;
//Session [ "ds"] = ds ;
//Session [ "template.ClickSearchClicked" ] = 1;
this.BuildDynamicControls ();
} //eof ClickSearch

private void BuildDynamicControls()
{
//ds = Session [ "ds" ] ; //get the data from the Session obj
//use the ds to actually construct the controls

} //eof BuildDynamicControls
} //eof class template

How to generate programatically simple gridview from dataset

SOURCES:
Multiple sources

public static void PrepareGV ( ref System.Web.UI.WebControls.GridView table_list_gv,
ref System.Data.DataSet rds )
{

if (table_list_gv != null)
{

foreach (System.Data.DataColumn dc in rds.Tables[0].Columns)
{
BoundField nameColumn = new BoundField ( );
nameColumn.DataField = dc.ColumnName;
nameColumn.HeaderText = dc.ColumnName ;
nameColumn.SortExpression = dc.ColumnName;
table_list_gv.Columns.Add ( nameColumn );
} //eof foreach col in the ds

table_list_gv.DataSource = rds.Tables [ 0 ];
table_list_gv.AllowPaging = true;
table_list_gv.AllowSorting = true;
table_list_gv.EnableSortingAndPagingCallbacks = false;
table_list_gv.Visible = true;
table_list_gv.DataBind ( );
}
else
{
throw new Utils.CustomException ( "a null table_list_gv was passed !!!" );
}

} //eof private static void PrepareGV (ref System.Web.UI.WebControls.GridView table_list_gv )

how -to add extended properties to sql server 2005 programatically

B. Adding an extended property to a column in a table

The following example adds a caption property to column PostalCode in table Address.
USE AdventureWorks;
GO
EXEC sp_addextendedproperty
@name = N'Caption', @value = 'Postal code is a required column.',
@level0type = N'Schema', @level0name = Person,
@level1type = N'Table', @level1name = Address,
@level2type = N'Column', @level2name = PostalCode;
GO

SOURCES:
http://technet.microsoft.com/en-us/library/ms180047.aspx

Turn objects into byte arrays using effective compression in C#

#region Using directives
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Runtime.Serialization.Formatters.Binary;
using System.IO;
using System.IO.Compression;

#endregion
//courtesy of Peter A. Bromberg, Ph.D. http://www.eggheadcafe.com/articles/20041128.asp

namespace Utils
{

public class DataSetCodec
{
/*todo: remove
#region Main Function
static void Main ( string [ ] args )
{
DataSetCodec dsc = new DataSetCodec ( );
DataSet ds = new DataSet ( );
ds.Tables.Add ( "Table" );
ds.Tables [ 0 ].Columns.Add ( "include" );
ds.Tables [ 0 ].Columns.Add ( "filledValue" );

DataRow row = ds.Tables [ 0 ].NewRow ( );
row [ "include" ] = true;
row [ "filledValue" ] = "some value";
ds.Tables [ 0 ].Rows.Add ( row );
Debugger.DebugDataSet ( "ok?", ref ds );


//now start compression
byte [ ] compressedDataSetInBytes = DataSetCodec.CompressDataSet ( ref ds );
int lengthOfArray = compressedDataSetInBytes.Length;

//NOW SHOW THE BYTES
foreach (byte b in compressedDataSetInBytes)
{
Debugger.WriteByte ( b );
}


//now decompress
DataSetCodec.DecompressDataSet ( ref compressedDataSetInBytes, out lengthOfArray );
Debugger.DebugDataSet ( "ok?", ref ds );


} //eof main
#endregion
*/


// private ctor; all members are static
private DataSetCodec ( )
{
}

public static byte [ ] CompressDataSet ( ref DataSet ds )
{
ds.RemotingFormat = SerializationFormat.Binary;
BinaryFormatter bf = new BinaryFormatter ( );
MemoryStream ms = new MemoryStream ( );
bf.Serialize ( ms, ds );
byte [ ] inbyt = ms.ToArray ( );
System.IO.MemoryStream objStream = new MemoryStream ( );
System.IO.Compression.DeflateStream objZS =
new System.IO.Compression.DeflateStream ( objStream,
System.IO.Compression.CompressionMode.Compress );
objZS.Write ( inbyt, 0, inbyt.Length );
objZS.Flush ( );
objZS.Close ( );
return objStream.ToArray ( );
}


public static DataSet DecompressDataSet ( ref byte [ ] bytDs, out int len )
{
Utils.Debugger.WriteIf( bytDs.Length.ToString ( ) );
DataSet outDs = new DataSet ( );
MemoryStream inMs = new MemoryStream ( bytDs );
inMs.Seek ( 0, 0 );
DeflateStream zipStream = new DeflateStream ( inMs, CompressionMode.Decompress, true );
byte [ ] outByt = ReadFullStream ( zipStream );
zipStream.Flush ( );
zipStream.Close ( );
MemoryStream outMs = new MemoryStream ( outByt );
outMs.Seek ( 0, 0 );
outDs.RemotingFormat = SerializationFormat.Binary;
BinaryFormatter bf = new BinaryFormatter ( );
len = (int)outMs.Length;
outDs = (DataSet)bf.Deserialize ( outMs, null );
return outDs;
} //eof public static DataSet DecompressDataSet (ref byte [] bytDs , out int len)


public static byte [ ] ReadFullStream ( Stream stream )
{
byte [ ] buffer = new byte [ 32768 ];
using (MemoryStream ms = new MemoryStream ( ))
{
while (true)
{
int read = stream.Read ( buffer, 0, buffer.Length );
if (read <= 0)
return ms.ToArray ( );
ms.Write ( buffer, 0, read );
}

} //eof using
} //eof public static byte [] ReadFullStream
} //eof class
} //eof namespace CompressDecompress