i am trying to use this product but it does not allow me to specify and display more than five fields
I was able to add 25 fields:
using System;
// Generated by http://www.csharpfriends.com
namespace evilTwin
{
public class rottenEgg
{
// private members
string ZombiestrApe;
string ZombiestrGrape;
string ZombiestrShape;
string ZombiestrBlip;
string ZombiestrLip;
string ZombiestrClip;
string ZombiestrChip;
string ZombiestrVolume;
string ZombiestrTone;
string ZombiestrSelector;
bool ZombieboolAble;
bool ZombieboolUnable;
string ZombiestrChimp;
string ZombiestrImp;
string ZombiestrZipper;
string ZombiestrShoelace;
string ZombiestrShaker;
string ZombiestrSpeaker;
string ZombiestrTrombone;
string ZombiestrSlide;
string ZombiestrRide;
string ZombiestrBride;
string ZombiestrEagle;
string ZombiestrEmu;
string ZombiestrEgret;
// empty constructor
public rottenEgg ()
{
}
// full constructor
public rottenEgg (string Ape, string Grape, string Shape, string Blip, string Lip, string Clip, string Chip, string Volume, string Tone, string Selector, bool Able, bool Unable, string Chimp, string Imp, string Zipper, string Shoelace, string Shaker, string Speaker, string Trombone, string Slide, string Ride, string Bride, string Eagle, string Emu, string Egret)
{
this.ZombiestrApe = Ape;
this.ZombiestrGrape = Grape;
this.ZombiestrShape = Shape;
this.ZombiestrBlip = Blip;
this.ZombiestrLip = Lip;
this.ZombiestrClip = Clip;
this.ZombiestrChip = Chip;
this.ZombiestrVolume = Volume;
this.ZombiestrTone = Tone;
this.ZombiestrSelector = Selector;
this.ZombieboolAble = Able;
this.ZombieboolUnable = Unable;
this.ZombiestrChimp = Chimp;
this.ZombiestrImp = Imp;
this.ZombiestrZipper = Zipper;
this.ZombiestrShoelace = Shoelace;
this.ZombiestrShaker = Shaker;
this.ZombiestrSpeaker = Speaker;
this.ZombiestrTrombone = Trombone;
this.ZombiestrSlide = Slide;
this.ZombiestrRide = Ride;
this.ZombiestrBride = Bride;
this.ZombiestrEagle = Eagle;
this.ZombiestrEmu = Emu;
this.ZombiestrEgret = Egret;
}
// public accessors
public string Ape
{
get { return ZombiestrApe;}
set { ZombiestrApe = value; }
}
public string Grape
{
get { return ZombiestrGrape;}
set { ZombiestrGrape = value; }
}
public string Shape
{
get { return ZombiestrShape;}
set { ZombiestrShape = value; }
}
public string Blip
{
get { return ZombiestrBlip;}
set { ZombiestrBlip = value; }
}
public string Lip
{
get { return ZombiestrLip;}
set { ZombiestrLip = value; }
}
public string Clip
{
get { return ZombiestrClip;}
set { ZombiestrClip = value; }
}
public string Chip
{
get { return ZombiestrChip;}
set { ZombiestrChip = value; }
}
public string Volume
{
get { return ZombiestrVolume;}
set { ZombiestrVolume = value; }
}
public string Tone
{
get { return ZombiestrTone;}
set { ZombiestrTone = value; }
}
public string Selector
{
get { return ZombiestrSelector;}
set { ZombiestrSelector = value; }
}
public bool Able
{
get { return ZombieboolAble;}
set { ZombieboolAble = value; }
}
public bool Unable
{
get { return ZombieboolUnable;}
set { ZombieboolUnable = value; }
}
public string Chimp
{
get { return ZombiestrChimp;}
set { ZombiestrChimp = value; }
}
public string Imp
{
get { return ZombiestrImp;}
set { ZombiestrImp = value; }
}
public string Zipper
{
get { return ZombiestrZipper;}
set { ZombiestrZipper = value; }
}
public string Shoelace
{
get { return ZombiestrShoelace;}
set { ZombiestrShoelace = value; }
}
public string Shaker
{
get { return ZombiestrShaker;}
set { ZombiestrShaker = value; }
}
public string Speaker
{
get { return ZombiestrSpeaker;}
set { ZombiestrSpeaker = value; }
}
public string Trombone
{
get { return ZombiestrTrombone;}
set { ZombiestrTrombone = value; }
}
public string Slide
{
get { return ZombiestrSlide;}
set { ZombiestrSlide = value; }
}
public string Ride
{
get { return ZombiestrRide;}
set { ZombiestrRide = value; }
}
public string Bride
{
get { return ZombiestrBride;}
set { ZombiestrBride = value; }
}
public string Eagle
{
get { return ZombiestrEagle;}
set { ZombiestrEagle = value; }
}
public string Emu
{
get { return ZombiestrEmu;}
set { ZombiestrEmu = value; }
}
public string Egret
{
get { return ZombiestrEgret;}
set { ZombiestrEgret = value; }
}
}
}
using System;
using System.Data;
using System.Data.Client;
namespace evilTwin.Data
{
public class SqlDataProvider
{
public SqlDataProvider(){}
public void AddRottenEgg(RottenEgg RottenEgg)
{
// Initialize SPROC
SqlConnection conn = new SqlConnection(Globals.ConnectionString);
SqlCommand cmd = new SqlCommand("evilTwin_RottenEgg_Add", conn);
cmd.CommandType = CommandType.StoredProcedure;
// Add Parameters
cmd.Parameters.Add("@ape", RottenEgg.Ape);
cmd.Parameters.Add("@grape", RottenEgg.Grape);
cmd.Parameters.Add("@shape", RottenEgg.Shape);
cmd.Parameters.Add("@blip", RottenEgg.Blip);
cmd.Parameters.Add("@lip", RottenEgg.Lip);
cmd.Parameters.Add("@clip", RottenEgg.Clip);
cmd.Parameters.Add("@chip", RottenEgg.Chip);
cmd.Parameters.Add("@volume", RottenEgg.Volume);
cmd.Parameters.Add("@tone", RottenEgg.Tone);
cmd.Parameters.Add("@selector", RottenEgg.Selector);
cmd.Parameters.Add("@able", RottenEgg.Able);
cmd.Parameters.Add("@unable", RottenEgg.Unable);
cmd.Parameters.Add("@chimp", RottenEgg.Chimp);
cmd.Parameters.Add("@imp", RottenEgg.Imp);
cmd.Parameters.Add("@zipper", RottenEgg.Zipper);
cmd.Parameters.Add("@shoelace", RottenEgg.Shoelace);
cmd.Parameters.Add("@shaker", RottenEgg.Shaker);
cmd.Parameters.Add("@speaker", RottenEgg.Speaker);
cmd.Parameters.Add("@trombone", RottenEgg.Trombone);
cmd.Parameters.Add("@slide", RottenEgg.Slide);
cmd.Parameters.Add("@ride", RottenEgg.Ride);
cmd.Parameters.Add("@bride", RottenEgg.Bride);
cmd.Parameters.Add("@eagle", RottenEgg.Eagle);
cmd.Parameters.Add("@emu", RottenEgg.Emu);
cmd.Parameters.Add("@egret", RottenEgg.Egret);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public void UpdateRottenEgg(RottenEgg RottenEgg)
{
// Initialize SPROC
SqlConnection conn = new SqlConnection(Globals.ConnectionString);
SqlCommand cmd = new SqlCommand("evilTwin_RottenEgg_Update", conn);
cmd.CommandType = CommandType.StoredProcedure;
// Update Parameters
cmd.Parameters.Add("@ape", RottenEgg.Ape);
cmd.Parameters.Add("@grape", RottenEgg.Grape);
cmd.Parameters.Add("@shape", RottenEgg.Shape);
cmd.Parameters.Add("@blip", RottenEgg.Blip);
cmd.Parameters.Add("@lip", RottenEgg.Lip);
cmd.Parameters.Add("@clip", RottenEgg.Clip);
cmd.Parameters.Add("@chip", RottenEgg.Chip);
cmd.Parameters.Add("@volume", RottenEgg.Volume);
cmd.Parameters.Add("@tone", RottenEgg.Tone);
cmd.Parameters.Add("@selector", RottenEgg.Selector);
cmd.Parameters.Add("@able", RottenEgg.Able);
cmd.Parameters.Add("@unable", RottenEgg.Unable);
cmd.Parameters.Add("@chimp", RottenEgg.Chimp);
cmd.Parameters.Add("@imp", RottenEgg.Imp);
cmd.Parameters.Add("@zipper", RottenEgg.Zipper);
cmd.Parameters.Add("@shoelace", RottenEgg.Shoelace);
cmd.Parameters.Add("@shaker", RottenEgg.Shaker);
cmd.Parameters.Add("@speaker", RottenEgg.Speaker);
cmd.Parameters.Add("@trombone", RottenEgg.Trombone);
cmd.Parameters.Add("@slide", RottenEgg.Slide);
cmd.Parameters.Add("@ride", RottenEgg.Ride);
cmd.Parameters.Add("@bride", RottenEgg.Bride);
cmd.Parameters.Add("@eagle", RottenEgg.Eagle);
cmd.Parameters.Add("@emu", RottenEgg.Emu);
cmd.Parameters.Add("@egret", RottenEgg.Egret);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public void DeleteRottenEgg(RottenEgg RottenEggID)
{
// Initialize SPROC
SqlConnection conn = new SqlConnection(Globals.ConnectionString);
SqlCommand cmd = new SqlCommand("evilTwin_RottenEgg_Delete", conn);
cmd.CommandType = CommandType.StoredProcedure;
// Delete Parameters
cmd.Parameters.Add("@RottenEggID", RottenEggID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public RottenEgg GetRottenEggByID(RottenEgg RottenEggID)
{
// Initialize SPROC
SqlConnection conn = new SqlConnection(Globals.ConnectionString);
SqlCommand cmd = new SqlCommand("evilTwin_RottenEgg_GetByID", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = null;
RottenEgg rottenEgg = null;
// GetByID Parameters
cmd.Parameters.Add("@RottenEggID", RottenEggID);
// Execute
conn.Open();
reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if(reader.Read())
{
rottenEgg = SqlDataHelpers.PopulateRottenEggFromSqlDataReader(reader);
}
conn.Close();
return rottenEgg;
}
public static RottenEgg PopulateRottenEggFromSqlDataReader(SqlDataReader dr)
{
RottenEgg rottenEgg = new RottenEgg();
rottenEgg.Ape = Convert.ToString(dr["ape"]);
rottenEgg.Grape = Convert.ToString(dr["grape"]);
rottenEgg.Shape = Convert.ToString(dr["shape"]);
rottenEgg.Blip = Convert.ToString(dr["blip"]);
rottenEgg.Lip = Convert.ToString(dr["lip"]);
rottenEgg.Clip = Convert.ToString(dr["clip"]);
rottenEgg.Chip = Convert.ToString(dr["chip"]);
rottenEgg.Volume = Convert.ToString(dr["volume"]);
rottenEgg.Tone = Convert.ToString(dr["tone"]);
rottenEgg.Selector = Convert.ToString(dr["selector"]);
rottenEgg.Able = (dr["able"]);
rottenEgg.Unable = (dr["unable"]);
rottenEgg.Chimp = Convert.ToString(dr["chimp"]);
rottenEgg.Imp = Convert.ToString(dr["imp"]);
rottenEgg.Zipper = Convert.ToString(dr["zipper"]);
rottenEgg.Shoelace = Convert.ToString(dr["shoelace"]);
rottenEgg.Shaker = Convert.ToString(dr["shaker"]);
rottenEgg.Speaker = Convert.ToString(dr["speaker"]);
rottenEgg.Trombone = Convert.ToString(dr["trombone"]);
rottenEgg.Slide = Convert.ToString(dr["slide"]);
rottenEgg.Ride = Convert.ToString(dr["ride"]);
rottenEgg.Bride = Convert.ToString(dr["bride"]);
rottenEgg.Eagle = Convert.ToString(dr["eagle"]);
rottenEgg.Emu = Convert.ToString(dr["emu"]);
rottenEgg.Egret = Convert.ToString(dr["egret"]);
return rottenEgg;
}
}
}
am i am not dump. the application isnt working as it should. i had to reload the page. and the .parameter.add has been deprecated its suppose to be .parameter.addwithvalue
Guys–that thing is ancient. Really not worth using anymore. Somebody should probably unsticky this thread . . …
Nice tool. I had been looking for something to automate this kind of stuff.
yeah,really great!
It’d save 20 mins if you coded from scratch - but how much time would it save if you just copied an existing class?
This thread has become obsolete. Use the links and information at your own discretion.