Click here to Skip to main content
16,006,707 members
Home / Discussions / C#
   

C#

 
GeneralRe: Problem inserting records Pin
rich_wenger12-Sep-05 13:26
rich_wenger12-Sep-05 13:26 
GeneralRe: Problem inserting records Pin
Christian Graus12-Sep-05 13:35
protectorChristian Graus12-Sep-05 13:35 
QuestionHow to use this in another handler?? Pin
Anonymous11-Sep-05 12:08
Anonymous11-Sep-05 12:08 
AnswerRe: How to use this in another handler?? Pin
Mohamad Al Husseiny11-Sep-05 12:15
Mohamad Al Husseiny11-Sep-05 12:15 
AnswerRe: How to use this in another handler?? Pin
Christian Graus11-Sep-05 15:27
protectorChristian Graus11-Sep-05 15:27 
QuestionTemplateColumn for DataTable Pin
Expert Coming11-Sep-05 11:13
Expert Coming11-Sep-05 11:13 
AnswerRe: TemplateColumn for DataTable Pin
Andy Brummer11-Sep-05 12:53
sitebuilderAndy Brummer11-Sep-05 12:53 
GeneralRe: TemplateColumn for DataTable Pin
Expert Coming11-Sep-05 13:26
Expert Coming11-Sep-05 13:26 
Now my problem is different. Now I can't get the datatable to add my template column, it won't actually add the textbox into it. And also, how do I get the program to call InitializeComponent first? This is my updated code.

private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);

// Make the Datagrid
CreateTable();
}

public void CreateTable ()
{
//Make the 'askills' array dynamically set

///Sets all of the Skills to the array 'askills'
askills[0] = "Attack";
askills[1] = "Strength";
askills[2] = "Defense";
askills[3] = "Ranged";
askills[4] = "Prayer";
askills[5] = "Magic";
askills[6] = "Runecrafting";
askills[7] = "Hitpoints";
askills[8] = "Agility";
askills[9] = "Herblore";
askills[10] = "Thieving";
askills[11] = "Crafting";
askills[12] = "Fleching";
askills[13] = "Slayer";
askills[14] = "Mining";
askills[15] = "Smelting";
askills[16] = "Fishing";
askills[17] = "Cooking";
askills[18] = "Firemaking";
askills[19] = "Woodcutting";
askills[20] = "Farming";

///Our connection string to the DB and open it
string szConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\inetpub\\kenkemkalrisell\\runescape\\databases\\runescapestats.mdb";
cn = new OleDbConnection(szConn);
///Open the database
OpenDB(cn);

StringBuilder szMyQuery = new StringBuilder ();
szMyQuery.AppendFormat ("SELECT User.Username, realStats.Attack, realStats.Strength, realStats.Defense, realStats.Ranged, realStats.Prayer, realStats.Magic, realStats.Runecrafting, realStats.Hitpoints, realStats.Agility, realStats.Herblore, realStats.Thieving, realStats.Crafting, realStats.Fleching, realStats.Slayer, realStats.Mining, realStats.Smelting, realStats.Fishing, realStats.Cooking, realStats.Firemaking, realStats.Woodcutting, realStats.Farming FROM [User] INNER JOIN realStats ON User.ID = realStats.ID WHERE (((User.Username)='{0}'))", szUsername);

OleDbCommand cmd = new OleDbCommand(szMyQuery.ToString (), cn);

rdr = cmd.ExecuteReader();

while (rdr.Read())
{
int iAttackOrdinal = rdr.GetOrdinal("Attack");
int intAttack = rdr.GetInt32(iAttackOrdinal);
int iStrengthOrdinal = rdr.GetOrdinal("Strength");
int intStrength = rdr.GetInt32(iStrengthOrdinal);
int iDefenseOrdinal = rdr.GetOrdinal("Defense");
int intDefense = rdr.GetInt32(iDefenseOrdinal);
int iRangedOrdinal = rdr.GetOrdinal("Ranged");
int intRanged = rdr.GetInt32(iRangedOrdinal);
int iPrayerOrdinal = rdr.GetOrdinal("Prayer");
int intPrayer = rdr.GetInt32(iPrayerOrdinal);
int iMagicOrdinal = rdr.GetOrdinal("Magic");
int intMagic = rdr.GetInt32(iMagicOrdinal);
int iRunecraftingOrdinal = rdr.GetOrdinal("Runecrafting");
int intRunecrafting = rdr.GetInt32(iRunecraftingOrdinal);
int iHitpointsOrdinal = rdr.GetOrdinal("Hitpoints");
int intHitpoints = rdr.GetInt32(iHitpointsOrdinal);
int iAgilityOrdinal = rdr.GetOrdinal("Agility");
int intAgility = rdr.GetInt32(iAgilityOrdinal);
int iHerbloreOrdinal = rdr.GetOrdinal("Herblore");
int intHerblore = rdr.GetInt32(iHerbloreOrdinal);
int iThievingOrdinal = rdr.GetOrdinal("Thieving");
int intThieving = rdr.GetInt32(iThievingOrdinal);
int iCraftingOrdinal = rdr.GetOrdinal("Crafting");
int intCrafting = rdr.GetInt32(iCraftingOrdinal);
int iFlechingOrdinal = rdr.GetOrdinal("Fleching");
int intFleching = rdr.GetInt32(iFlechingOrdinal);
int iSlayerOrdinal = rdr.GetOrdinal("Slayer");
int intSlayer = rdr.GetInt32(iSlayerOrdinal);
int iMiningOrdinal = rdr.GetOrdinal("Mining");
int intMining = rdr.GetInt32(iMiningOrdinal);
int iSmeltingOrdinal = rdr.GetOrdinal("Smelting");
int intSmelting = rdr.GetInt32(iSmeltingOrdinal);
int iFishingOrdinal = rdr.GetOrdinal("Fishing");
int intFishing = rdr.GetInt32(iFishingOrdinal);
int iCookingOrdinal = rdr.GetOrdinal("Cooking");
int intCooking = rdr.GetInt32(iCookingOrdinal);
int iFiremakingOrdinal = rdr.GetOrdinal("Firemaking");
int intFiremaking = rdr.GetInt32(iFiremakingOrdinal);
int iWoodcuttingOrdinal = rdr.GetOrdinal("Woodcutting");
int intWoodcutting = rdr.GetInt32(iWoodcuttingOrdinal);
int iFarmingOrdinal = rdr.GetOrdinal("Farming");
int intFarming = rdr.GetInt32(iFarmingOrdinal);

alevel[0] = intAttack;
alevel[1] = intStrength;
alevel[2] = intDefense;
alevel[3] = intRanged;
alevel[4] = intPrayer;
alevel[5] = intMagic;
alevel[6] = intRunecrafting;
alevel[7] = intHitpoints;
alevel[8] = intAgility;
alevel[9] = intHerblore;
alevel[10] = intThieving;
alevel[11] = intCrafting;
alevel[12] = intFleching;
alevel[13] = intSlayer;
alevel[14] = intMining;
alevel[15] = intSmelting;
alevel[16] = intFishing;
alevel[17] = intCooking;
alevel[18] = intFiremaking;
alevel[19] = intWoodcutting;
alevel[20] = intFarming;
}
rdr.Close();
CloseDB(cn);

///The creation of the table that shows the user their stats from the database
///Dynamic Creation of the datatable

///Also sets up the new datatable
DataTable dtshowskills = new DataTable("USkills");

DataColumn dcuserSkill = new DataColumn("Skill");
dcuserSkill.DataType = System.Type.GetType("System.String");
dtshowskills.Columns.Add(dcuserSkill);
DataColumn dcuserLevel = new DataColumn("Level");
dcuserLevel.DataType = System.Type.GetType("System.Int32");
dtshowskills.Columns.Add(dcuserLevel);
DataColumn dcgoalLevel = new DataColumn("Goal");
dcgoalLevel.DataType = System.Type.GetType("System.Int32");
dtshowskills.Columns.Add(dcgoalLevel);

int i = 0;
while (i <= 20)
{
DataRow drskill = dtshowskills.NewRow();
drskill["Skill"] = askills[i];
drskill["Level"] = alevel[i];
drskill["Goal"] = agoal[i];
dtshowskills.Rows.Add(drskill);
i++;
}
TemplateColumn tcTextBoxes = new TemplateColumn();
tcTextBoxes.HeaderTemplate = new DataGridTemplate(ListItemType.Header, "Change Goals");
//tcTextBoxes.ItemTemplate = new DataGridTemplate(ListItemType.Item, "Change Goals");
tcTextBoxes.EditItemTemplate = new DataGridTemplate(ListItemType.EditItem, "Change Goals");
tcTextBoxes.FooterTemplate = new DataGridTemplate(ListItemType.Footer, "Change Goals");
dgSkills.Columns.Add(tcTextBoxes);

dgSkills.DataSource = dtshowskills;
dgSkills.DataBind();
}

public class DataGridTemplate : ITemplate
{
ListItemType templateType;
string columnName;

public DataGridTemplate(ListItemType type, string colname)
{
templateType = type;
columnName = colname;
}

public void InstantiateIn(System.Web.UI.Control container)
{
Literal lc = new Literal();
switch(templateType)
{
case ListItemType.Header:
lc.Text = "" + columnName + "";
container.Controls.Add(lc);
break;
case ListItemType.Item:
lc.Text = "Item " + columnName;
container.Controls.Add(lc);
break;
case ListItemType.EditItem:
TextBox tb = new TextBox();
tb.Text = "Hello";
container.Controls.Add(tb);
break;
case ListItemType.Footer:
lc.Text = "" + columnName + "";
container.Controls.Add(lc);
break;
}
}
}

Thanks for all your help.
QuestionUnhandled Ex..Param Null: Value pen??? Pin
Anonymous11-Sep-05 10:22
Anonymous11-Sep-05 10:22 
AnswerRe: Unhandled Ex..Param Null: Value pen??? Pin
Anonymous11-Sep-05 10:38
Anonymous11-Sep-05 10:38 
QuestionRe: Unhandled Ex..Param Null: Value pen??? Pin
Guffa11-Sep-05 10:42
Guffa11-Sep-05 10:42 
AnswerRe: Unhandled Ex..Param Null: Value pen??? Pin
Anonymous11-Sep-05 10:47
Anonymous11-Sep-05 10:47 
GeneralRe: Unhandled Ex..Param Null: Value pen??? Pin
Guffa11-Sep-05 10:57
Guffa11-Sep-05 10:57 
GeneralRe: Unhandled Ex..Param Null: Value pen??? Pin
Anonymous11-Sep-05 11:03
Anonymous11-Sep-05 11:03 
AnswerRe: Unhandled Ex..Param Null: Value pen??? Pin
Mohamad Al Husseiny11-Sep-05 11:32
Mohamad Al Husseiny11-Sep-05 11:32 
GeneralRe: Unhandled Ex..Param Null: Value pen??? Pin
Anonymous11-Sep-05 12:17
Anonymous11-Sep-05 12:17 
GeneralRe: Unhandled Ex..Param Null: Value pen??? Pin
Mohamad Al Husseiny11-Sep-05 12:19
Mohamad Al Husseiny11-Sep-05 12:19 
Questionproblem in DLL calling Pin
Jassim Rahma11-Sep-05 10:01
Jassim Rahma11-Sep-05 10:01 
QuestionRe: problem in DLL calling Pin
Guffa11-Sep-05 10:43
Guffa11-Sep-05 10:43 
QuestionDevelopment of setup and deployment projects(MSI files)! Pin
lata07mahi11-Sep-05 9:55
lata07mahi11-Sep-05 9:55 
AnswerRe: Development of setup and deployment projects(MSI files)! Pin
Mohamad Al Husseiny11-Sep-05 10:06
Mohamad Al Husseiny11-Sep-05 10:06 
QuestionConst vars Pin
Niklas Ulvinge11-Sep-05 9:26
Niklas Ulvinge11-Sep-05 9:26 
AnswerRe: Const vars Pin
Guffa11-Sep-05 9:41
Guffa11-Sep-05 9:41 
GeneralRe: Const vars Pin
Niklas Ulvinge11-Sep-05 21:43
Niklas Ulvinge11-Sep-05 21:43 
AnswerRe: Const vars Pin
S. Senthil Kumar12-Sep-05 0:24
S. Senthil Kumar12-Sep-05 0:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.