generte cdo in sql new

ankit
$!--$%@ Page Language="C#" %#
$%@ Import Namespace="System.Data" %#
$!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"#


$script runat="server"#
//TODO:
// Create an Object of the DataTable You need class for
// Assign Connection string name from Web.config
// Assign Data Set Name
//public aspnetdb.ModulePermissionDataTable dt = new aspnetdb.ModulePermissionDataTable();
//dsProduction.TBL_PRODUCTION_PROCESS_DETAIL_MACHINEDataTable dt = new dsProduction.TBL_PRODUCTION_PROCESS_DETAIL_MACHINEDataTable();
DataSet1.LoginDataTable dt = new DataSet1.LoginDataTable();
//CodeGenerator.TBL_ITEMPROPERTIESDataTable dt = new CodeGenerator.TBL_ITEMPROPERTIESDataTable();
public string TableName
{
get
{
String tblName = dt.TableName.Replace("DataTable", "");
tblName = "cls"+tblName.Replace("TBL_", "")+"_CDO";
return tblName;
}
}
public string ConnectionStringName = "sdmsConnectionString";
public string DataSetName = "CodeGenerator";
public StringBuilder param = new StringBuilder();
$/script#
$html xmlns="http://www.w3.org/1999/xhtml" #
$head runat="server"#
$title#Untitled Page$/title#
$/head#
$body#
$form id="form1" runat="server"#
$div#
$pre#
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
/*
COMPANY NAME : DILIGENT INFOSYS, AHMEDABAD
PROJECT NAME : SALES AND DESTRUCTION MANAGEMENT SYSTEM
CREATE BY : MAULIK, MITESH, ANKIT, PARUL, TEJAS
CREATE DATE : $%= DateTime.Now %#
PURPOSE : FOR $%= dt.TableName%#
MODIFY BY :
MODIFY DATE :
MODIFY PURPOSE :
*/
namespace SDMClasslibrary.CDO.Master
{
public class $%=TableName%#
{
$%
foreach (DataColumn col in dt.Columns)
{
%#
private $%=col.DataType.Name %# _$%=col.ColumnName%#;
public $%=col.DataType.Name %# $%=col.ColumnName%#
{
get{ return _$%=col.ColumnName%#; }
set{ _$%=col.ColumnName%#=value; }
}
$%
}
%#
}
}
$/pre#
$/div#
$/form#
$/body#
$/html#