Dynamic controls in asp.net

SOURCES:
http://www.singingeels.com/Articles/Dynamically_Created_Controls_in_ASPNET.aspx

using System;
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;
using System.Xml.Linq;

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

private TextBox [ ] m_dynamicTextBoxes; //this is class variable
public string msg = "";


protected override void OnInit ( EventArgs e )
{ //HUOMI THIS FIRST
base.OnInit ( e );

c_button.Click += new EventHandler ( ButtonClick ); //add the event handelr for all textboxes !!!
m_dynamicTextBoxes = new TextBox [ 5 ]; //populate the array of TextBoxes

for (int i = 0; i < 5; i++)
{
TextBox textBox = new TextBox ( );
textBox.ID = "c_textBox" + i.ToString ( );
c_placeholder.Controls.Add ( textBox );
m_dynamicTextBoxes [ i ] = textBox;
} //eof for





} //eof OnInit

protected void ButtonClick ( object sender, EventArgs e )
{
GUIBuilder.GenerateEmptyForm ( ref msg , ref sender , ref e , ref m_dynamicTextBoxes, ref c_label );
} //eof ButtonClick





protected void Page_Load(object sender, EventArgs e)
{

} //eof Page_Load
} //eof class Page



using System;
using System.Data;
using System.Configuration;
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;


///

/// Take the logic of building out from the web page class
///

public class GUIBuilder
{
public GUIBuilder()
{
//
// TODO: Add constructor logic here
//
} //eof cons


public static void GenerateEmptyForm ( ref string msg , ref object sender , EventArgs e ,
ref TextBox [ ] m_dynamicTextBoxes , ref Label c_label )
{
foreach (TextBox textBox in m_dynamicTextBoxes)
{
c_label.Text += "the text was " + textBox.Text + " -- ";
}

} //eof GenerateEmpty Form




} //eof GUIBuilder

Allmost there


SELECT
-- OBJECT_name(c.object_id) TableName
c.name AS [COLUMN_NAME]
-- ,SCHEMA_NAME(t.schema_id) AS SchemaName
, t.name AS [DATA_TYPE]
-- ,t.is_user_defined
-- ,t.is_assembly_type
,c.max_length
-- ,c.precision
-- ,c.scale
,c.is_nullable AS [OBLIGATORY]
-- ,value as [DESCRIPTION]
FROM sys.columns AS c
JOIN sys.types AS t ON c.user_type_id=t.user_type_id
-- left join sys.extended_properties AS ep on ep.major_id = c.object_id AND ep.minor_id = c.column_id

ORDER BY DATA_TYPE

SELECT DISTINCT t.name from sys.types as t

select value from sys.extended_properties


how to find recursively controls in C# asp.net

private Control FindControlRecursive ( Control root, string id )
{
try
{
if (root.ID == id)
{
return root;
} //eof if

foreach (Control c in root.Controls)
{
Control t = FindControlRecursive ( c, id );
if (t != null)
{
return t;
} //eof if
} //eof foreach
} //eof try
catch (Exception e)
{
Debugger.WriteIf ( "The following Exception occured : \n" + e.Message );
this.Master.Error_label.ForeColor = System.Drawing.Color.Red;
this.Master.Error_label.Text = e.Message;
return success;
} //eof catch

return null;
} //eof FindControlRecursive

how to Get table name , Column name , data type , Description from a table in sql server 2005

-- Courtesy of Heikki Kauranen


SELECT c.name AS [Column Name], value AS
[Description], sc.data_type
FROM sys.extended_properties AS ep
INNER JOIN sys.tables AS t ON ep.major_id = t.object_id
INNER JOIN sys.columns AS c ON ep.major_id = c.object_id AND ep.minor_id
= c.column_id
INNER JOIN INFORMATION_SCHEMA.COLUMNS sc ON t.name = sc.table_name and
c.name = sc.column_name
WHERE class = 1 and t.name = 'Project_tb'

How to create dynamically controls in C#

Create a class dedicated for the purpose - the code will take a lot of space ; ) - in this example I ll use GUIGenerator.cs
put it in some namespace - herewith Utils
put all the methods so that you will pass the parameters by reference to them - all the parameters - gui controls , datasets , etc.
so the classs will look like this:



using System;
using System.Data;
using System.Configuration;
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;
using System.Xml.Linq;

namespace Utils {
//comm -- /

//comm -- / Summary description for Utils.GUIBuilder
//comm -- /

public class GUIGenerator
{
public void GenerateSomething (ref Panel panel_obj , ref DataSet ds )
{
//iterate over a dataset with param values :
foreach (DataTable dt in ds.Tables) //comm -- we have only one table
{
Utils.Debugger.WriteIf ( "The name of the table is " + dt.TableName );
foreach (DataRow dr in dt.Rows)
{
//comm -- this is complete mess - hint enable css colors debugging to see the boxes
//comm -- debug Debug.WriteLine ( "dr[0] is " + dr [ 0 ] );
//comm -- debug Debug.WriteLine ( "dr[1] is " + dr [ 1 ] );
//comm -- take the NameOf the control
string nameOfControl = System.Convert.ToString(dr [ 0 ]);
//comm -- take the Name of the Type as string
string typeOfControl = System.Convert.ToString ( dr [ 1 ] );
Panel glb_panel = new Panel ( );

glb_panel.ID = nameOfControl + "_glb";
glb_panel.ToolTip = "fill in here the " + nameOfControl;

HtmlInputCheckBox cb = new HtmlInputCheckBox ( );
cb.ID = nameOfControl + "_cb";
cb.Checked = (bool)dr [ 2 ];
glb_panel.Controls.Add ( cb );

Label lb = new Label ( );
lb.Text = nameOfControl;
glb_panel.Controls.Add ( lb );

glb_panel.CssClass = "glb";
glb_panel.Wrap = true;
glb_panel.Visible = true;
if ((string)dr [ 3 ] != null)
{
filledValue = (string)dr [ 3 ]; //comm -- the fourth columns contains the values of the controls
}
else
{
filledValue = "";
}
//string filledValue = "fakeValue";
this.GenerateFilledControl ( ref nameOfControl, ref typeOfControl, ref glb_panel , ref filledValue);


panel_obj.ContentTemplateContainer.Controls.Add ( glb_panel );

/*
DropDownList drop = new DropDownList ( );
drop.Items.Add ( "OR" );
drop.Items.Add ( "AND" );
drop.Items.Add ( "LIKE" );
drop.ID = dt.ToString ( ) + "row" + rowNum; //comm -- mark this row number
drop.CssClass = "connector_class";
panel_obj.ContentTemplateContainer.Controls.Add ( drop );
*/


} //eof foreach2
} //eof foreach1

} //eof method

} //eof class GUIGenerator

how to read byte stream from database in C#

while (dbDr_obj.HasRows == true)
{
dbDr_obj.Read ( );
someString = dbDr_obj.GetString ( 0 );

byte[] buffer = new byte[8192];
long read= 0;
long index = 0;

do
{
read = dbDr_obj.GetBytes ( 1, index, buffer, 0, buffer.Length );
m.Write(buffer, 0, (int)read);
index += read;
} //eof while
while (read > 0) ;


if (dbDr_obj.IsClosed == false)
{
dbDr_obj.Close ( ); //comm -- remember to close the DbReader obj otherwise
} //eof if (dbDr_obj.IsClosed == false)
break;
} //eof while

Encryption , Decryption in

/*
* Author : Nidheesh T.Mani
* Version : 1.0
*/

using System;
using System.Security.Cryptography;
namespace Utils
{
///

/// This class provide static methods for encryption and decryption.
///

public class DataEncryption
{
///

/// Method which does the encryption using Rijndeal algorithm
///

/// Data to be encrypted
/// The string to used for making the key.The same string
/// should be used for making the decrpt key
/// Encrypted Data
public static string EncryptString ( string InputText, string Password )
{
RijndaelManaged RijndaelCipher = new RijndaelManaged ( );

byte [ ] PlainText = System.Text.Encoding.Unicode.GetBytes ( InputText );
byte [ ] Salt = System.Text.Encoding.ASCII.GetBytes ( Password.Length.ToString ( ) );

//This class uses an extension of the PBKDF1 algorithm defined in the PKCS#5 v2.0
//standard to derive bytes suitable for use as key material from a password.
//The standard is documented in IETF RRC 2898.

PasswordDeriveBytes SecretKey = new PasswordDeriveBytes ( Password, Salt );
//Creates a symmetric encryptor object.
ICryptoTransform Encryptor = RijndaelCipher.CreateEncryptor ( SecretKey.GetBytes ( 32 ), SecretKey.GetBytes ( 16 ) );
System.IO.MemoryStream memoryStream = new System.IO.MemoryStream ( );
//Defines a stream that links data streams to cryptographic transformations
CryptoStream cryptoStream = new CryptoStream ( memoryStream, Encryptor, CryptoStreamMode.Write );
cryptoStream.Write ( PlainText, 0, PlainText.Length );
//Writes the final state and clears the buffer
cryptoStream.FlushFinalBlock ( );
byte [ ] CipherBytes = memoryStream.ToArray ( );
memoryStream.Close ( );
cryptoStream.Close ( );
string EncryptedData = Convert.ToBase64String ( CipherBytes );
return EncryptedData;

} //eof private static string EncryptString ( string InputText, string Password )

///

/// Method which does the encryption using Rijndeal algorithm.This is for decrypting the data
/// which has orginally being encrypted using the above method
///

/// The encrypted data which has to be decrypted
/// The string which has been used for encrypting.The same string
/// should be used for making the decrypt key
/// Decrypted Data
public static string DecryptString ( string InputText, string Password )
{

RijndaelManaged RijndaelCipher = new RijndaelManaged ( );
byte [ ] EncryptedData = Convert.FromBase64String ( InputText );
byte [ ] Salt = System.Text.Encoding.ASCII.GetBytes ( Password.Length.ToString ( ) );
//Making of the key for decryption
PasswordDeriveBytes SecretKey = new PasswordDeriveBytes ( Password, Salt );
//Creates a symmetric Rijndael decryptor object.
ICryptoTransform Decryptor = RijndaelCipher.CreateDecryptor ( SecretKey.GetBytes ( 32 ), SecretKey.GetBytes ( 16 ) );
System.IO.MemoryStream memoryStream = new System.IO.MemoryStream ( EncryptedData );
//Defines the cryptographics stream for decryption.THe stream contains decrpted data
CryptoStream cryptoStream = new CryptoStream ( memoryStream, Decryptor, CryptoStreamMode.Read );
byte [ ] PlainText = new byte [ EncryptedData.Length ];
int DecryptedCount = cryptoStream.Read ( PlainText, 0, PlainText.Length );
memoryStream.Close ( );
cryptoStream.Close ( );
//Converting to string
string DecryptedData = System.Text.Encoding.Unicode.GetString ( PlainText, 0, DecryptedCount );
return DecryptedData;

} //eof private static string DecryptString (string InputText , string Password )

} //eof class

} //eof namespace Utils

Generate member accessors , properties for C# asp.net with textpad

// Generate member accessors , properties for C# asp.net with textpad
/// find:^(.*)$
/// replace:private string s\1 ; \n public string \1 { \n \t\t get { return s\1 ; } \n \t\t set { s\1 = value ; } \n } //comm -- eof \1 property \n\n

how to compress and decompress DataSet

SOURCES:
http://www.eggheadcafe.com/articles/20041128.asp
URL
URL
URL

using System;
using System.Collections.Generic;
using System.Text;

namespace CompressDecompressDataSet
{
#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.
namespace DSCompression
{
public class DataSetCodec
{

#region Main Function
static void Main(string[] args)
{
DataSetCodec dsc = new DataSetCodec();
DataSet ds = new DataSet();
ds.Tables.Add("Table");
ds.Tables["Table"].Columns.Add("include");
ds.Tables["Table"].Columns.Add("filledValues");

DataRow row = ds.Tables[0].NewRow();
row["include"] = true;
row["filledValues"] = "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)
{
System.Diagnostics.Debug.Write(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;
}

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 public static byte [] ReadFullStream
} //eof class
} //eof namespace DSCompression



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace CompressDecompressDataSet
{


public class Debugger
{
public Debugger ( )
{
//
// TODO: Add constructor logic here
//
}
///

/// This method outputs on values of the passed dataset objects for easier debugging
///

/// the string passed containng usual info
/// the dataset , which content one should debug
/// call it this way Utils.Debugger.DebugDataSet ( System.Reflection.MethodInfo.GetCurrentMethod().Name() , , ref ds );
public static void DebugDataSet ( string msg, ref System.Data.DataSet ds )
{
System.Diagnostics.Debug.WriteLine ( msg );
foreach (System.Data.DataTable dt in ds.Tables)
{
System.Diagnostics.Debug.WriteLine ( "================= Table " +
dt.TableName + " ========================= START" );
foreach (System.Data.DataColumn dc in dt.Columns)
{
System.Diagnostics.Debug.Write ( " | " );
System.Diagnostics.Debug.Write ( dc.ColumnName + " | " );
} //eof foreach (DataColumn dc in dt.Columns)
int rowNumber = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
System.Diagnostics.Debug.Write ( "\n row " + rowNumber + " --- " );
int colNumberInRow = 0;
foreach (System.Data.DataColumn dc in dt.Columns)
{
System.Diagnostics.Debug.Write ( " |" + colNumberInRow + "| " );
System.Diagnostics.Debug.Write ( dr [ dc ].ToString ( ) + " " );
colNumberInRow++;
} //eof foreach (DataColumn dc in dt.Columns)
rowNumber++;
} //eof foreach (DataRow dr in dt.Rows)
System.Diagnostics.Debug.Write ( " \n" );
System.Diagnostics.Debug.WriteLine ( "================= Table " +
dt.TableName + " ========================= END" );
} //eof foreach (DataTable dt in ds.Tables)

} //eof public static void DebugDataSet ( string msg , ref System.Data.DataSet ds )

public static void WriteLine ( string msg )
{
System.Diagnostics.Debug.WriteLine ( msg );
} //eof WriteLine


public static void Write ( string msg )
{
System.Diagnostics.Debug.Write ( msg );
} //eof Write

public static void WriteByte(byte b)
{
System.Diagnostics.Debug.Write(b.ToString());
} //eof WriteByte

} //eof class Debugger
} //eof namespace

debugging datasets in C#

///

/// This method outputs on values of the passed dataset objects for easier debugging
///

/// the string passed containng usual info
/// the dataset , which content one should debug
/// call it this way Debugger.debugDataSet ( System.Reflection.MethodInfo.GetCurrentMethod().Name() , , ref ds );
public static void debugDataSet ( string msg , ref System.Data.DataSet ds )
{
System.Diagnostics.Debug.WriteLine ( msg );
foreach (System.Data.DataTable dt in ds.Tables)
{
System.Diagnostics.Debug.WriteLine ("================= Table " +
dt.TableName + " ========================= START");
foreach (System.Data.DataColumn dc in dt.Columns)
{
System.Diagnostics.Debug.Write(" | ");
System.Diagnostics.Debug.Write(dc.ColumnName + " | ");
} //eof foreach (DataColumn dc in dt.Columns)
int rowNumber = 0 ;
foreach (System.Data.DataRow dr in dt.Rows)
{
System.Diagnostics.Debug.Write ( "\n row " + rowNumber + " --- " );
int colNumberInRow = 0 ;
foreach (System.Data.DataColumn dc in dt.Columns)
{
System.Diagnostics.Debug.Write(" |" + colNumberInRow + "| ");
System.Diagnostics.Debug.Write(dr[dc].ToString() + " ");
colNumberInRow ++ ;
} //eof foreach (DataColumn dc in dt.Columns)
rowNumber ++ ;
} //eof foreach (DataRow dr in dt.Rows)
System.Diagnostics.Debug.Write ( " \n" );
System.Diagnostics.Debug.WriteLine ( "================= Table " +
dt.TableName + " ========================= END" );
} //eof foreach (DataTable dt in ds.Tables)

} //eof public static void debugDataSet ( string msg , ref System.Data.DataSet ds )

clever debugging in css

/*debug start*/
border: 1px dashed #333;
background-color:aaaaaa;
/*end debug*/

tabless form using css

CSS Forms

This page is based entirerly on CSS. No tables whatsoever. It's fast, accessible, and probably the most elegant way to make table-less forms today. Check it out yourself...

Personal details

Name:

Email:

Telephone:

Personal details

Name:

Email:

Telephone:

SQL SERVER 2005 CHEAT SHEET

GO
SELECT f.name AS ForeignKey,
OBJECT_NAME(f.parent_object_id) AS TableName,
COL_NAME(fc.parent_object_id, fc.parent_column_id) AS ColumnName,
OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,
COL_NAME(fc.referenced_object_id, fc.referenced_column_id) AS ReferenceColumnName
FROM sys.foreign_keys AS f
INNER JOIN sys.foreign_key_columns AS fc
ON f.object_id = fc.constraint_object_id


-- SELECT * FROM INFORMATION_SCHEMA.TABLES


-- select all the columns from the SomeTable_tb table
-- SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SomeTable_tb'
SELECT COLUMN_NAME , DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SomeTable_tb'
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SomeTable_tb'
-- SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SomeTable_tb'

-- SELECT * FROM sys.tables

-- used to gather statistics stored in memory but not persistent on disk such as thread information, memory usage, and connection details
-- SELECT * FROM sys.dm_exec_query_stats

-- EXEC sys.sp_columns 'SomeTable_tb'

-- SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_DEFAULT
-- FROM POC.INFORMATION_SCHEMA.COLUMNS
-- WHERE TABLE_NAME = N'SomeTable_tb';
-- SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SomeTable_tb'