C#

<br />
private void open_Database(string XML_DB_Name)<br />
{<br />
	dataSet.ReadXml(XML_DB_Name);<br />
	DataTable dt = dataSet.Tables[0];<br />
	string tblName = dt.TableName;<br />
	currentTable = dataSet.Tables[tblName];<br />
	dataGrid1.SetDataBinding(dataSet, tblName);<br />
	dataGrid1.CaptionText = tblName;<br />
<br />
	DataRow MyRow = currentTable.Rows[0];          <---- Problem when currentTable is empty, i get an exception...probably i can get the RowCount in another way?<br />
	int RowCount = MyRow.Table.Rows.Count;<br />
<br />
	// By default there is no DataGridTableStyle object.<br />
	// Add all DataSet table's style to the DataGrid<br />
	foreach(DataTable dTable in dataSet.Tables)<br />
	{<br />
		DataGridTableStyle dgStyle = new DataGridTableStyle();<br />
		dgStyle.MappingName = dTable.TableName;<br />
		if(RowCount < 8)<br />
		{<br />
			dgStyle.PreferredColumnWidth = 120;<br />
		}<br />
		else<br />
		{<br />
			dgStyle.PreferredColumnWidth = 110;<br />
		}<br />
		dataGrid1.TableStyles.Add(dgStyle);<br />
	}<br />
}<br />

System.Diagnostics.Debug.WriteLine("I am debugging");
System.Diagnostics.Trace.WriteLine("I am Tracing");

//Create the variables and arrays need only for Creating the table<br />
string[] skills = new string[1];<br />
skills[0] = "attack";<br />
//skills[1] = "strength";<br />
//skills[2] = "defence";<br />
<br />
//The creation of the table that shows the user their stats from the database<br />
//Dynamic Creation of the datatable<br />
<br />
///Also sets up the new datatable<br />
DataTable dtshowskills = new DataTable("USkills");<br />
<br />
DataColumn userSkill = new DataColumn("Skill");<br />
dtshowskills.Columns.Add("userSkill");<br />
DataColumn userLevel = new DataColumn("Level");<br />
dtshowskills.Columns.Add("userLevel");<br />
<br />
foreach (string skill in skills)<br />
{<br />
DataRow drskill = dtshowskills.NewRow();<br />
drskill["userSkill"] = skill;<br />
drskill["userLevel"] = 0;<br />
dtshowskills.Rows.Add(drskill);<br />
}<br />
<br />
dgSkills.DataSource = dtshowskills;<br />
dgSkills.DataBind();

//This is on my actual web page<br />
<asp:DataGrid ID="dgSkills" Runat="server" />