protected void Page_Load(object sender, EventArgs e) |
{ |
|
DataTable myTable = new DataTable(); |
|
|
myTable.Columns.Add("galleryImageID1"); |
myTable.Columns.Add("galleryImage1"); |
myTable.Columns.Add("galleryImageID2"); |
myTable.Columns.Add("galleryImage2"); |
myTable.Columns.Add("galleryImageID3"); |
myTable.Columns.Add("galleryImage3"); |
myTable.Columns.Add("galleryImageID4"); |
myTable.Columns.Add("galleryImage4"); |
myTable.Columns.Add("galleryImageID5"); |
myTable.Columns.Add("galleryImage5"); |
|
int[] galleryImageID = new int[6]; |
string[] galleryImage = new string[6]; |
|
SqlDataReader myDataReader; |
SqlConnection myConnection = new SqlConnection(Session["strConn"].ToString()); |
myConnection.Open(); |
|
SqlCommand myCommand; |
SqlCommand myCommandCount; |
|
myCommand = new SqlCommand("SELECT * FROM gallerytb"); |
myCommandCount = new SqlCommand("SELECT COUNT(*) as Counter FROM gallerytb"); |
|
myCommandCount.Connection = myConnection; |
int bicyleItems = Convert.ToInt16(myCommandCount.ExecuteScalar()); |
|
myCommand.Connection = myConnection; |
myDataReader = myCommand.ExecuteReader(); |
|
int maxcolumns = 5; |
int maxrows = (Convert.ToInt16(bicyleItems) / Convert.ToInt16(maxcolumns)); |
|
|
|
if (maxrows > 0) |
{ |
for(int rows = 1; rows <= maxrows; rows++) |
{ |
for(int columns = 1; columns <= maxcolumns; columns++) |
{ |
if (myDataReader.Read()) |
{ |
//bicycleImageID[columns] = 15; |
//Response.Write("Reader: " + myDataReader["galleryImageID"].ToString() + " ... "); |
galleryImageID[columns] = Convert.ToInt16(myDataReader["galleryImageID"].ToString()); |
galleryImage[columns] = myDataReader["galleryImage"].ToString(); |
//myTable.Rows.Add(new string[] { myDataReader["galleryImageID"].ToString(), myDataReader["galleryImage"].ToString() }); |
} |
//Response.Write(myDataReader["galleryImageID"].ToString() + " " + myDataReader["galleryImage"].ToString()); |
} |
myTable.Rows.Add(new string[] { galleryImageID[1].ToString(), galleryImage[1].ToString(), galleryImageID[2].ToString(), galleryImage[2].ToString(), galleryImageID[3].ToString(), galleryImage[3].ToString(), galleryImageID[4].ToString(), galleryImage[4].ToString(), galleryImageID[5].ToString(), galleryImage[5].ToString() }); |
} |
|
// Now fill in the last row |
int ItemsLeft = bicyleItems - (maxrows * 5); |
//Response.Write("Items left: " + ItemsLeft); |
switch (bicyleItems - (maxrows * 5)) |
{ |
case 4: |
for (int columns = 1; columns <= 5; columns++) |
{ |
if (myDataReader.Read()) |
{ |
//bicycleImageID[columns] = 15; |
//Response.Write("Reader: " + myDataReader["galleryImageID"].ToString() + " ... "); |
galleryImageID[columns] = Convert.ToInt16(myDataReader["galleryImageID"].ToString()); |
galleryImage[columns] = myDataReader["galleryImage"].ToString(); |
//myTable.Rows.Add(new string[] { myDataReader["galleryImageID"].ToString(), myDataReader["galleryImage"].ToString() }); |
} |
else |
{ |
galleryImageID[columns] = 0; |
galleryImage[columns] = "imgPlcHldr.jpg"; |
} |
//Response.Write(myDataReader["galleryImageID"].ToString() + " " + myDataReader["galleryImage"].ToString()); |
} |
//myTable.Rows.Add(new string[] { galleryImageID[1].ToString(), galleryImage[1].ToString(), galleryImageID[2].ToString(), galleryImage[2].ToString(), galleryImageID[3].ToString(), galleryImage[3].ToString(), galleryImageID[4].ToString(), galleryImage[4].ToString() }); |
myTable.Rows.Add(new string[] { galleryImageID[1].ToString(), galleryImage[1].ToString(), galleryImageID[2].ToString(), galleryImage[2].ToString(), galleryImageID[3].ToString(), galleryImage[3].ToString(), galleryImageID[4].ToString(), galleryImage[4].ToString(), galleryImageID[5].ToString(), galleryImage[5].ToString() }); |
break; |
case 3: |
for (int columns = 1; columns <= 5; columns++) |
{ |
if (myDataReader.Read()) |
{ |
//bicycleImageID[columns] = 15; |
//Response.Write("Reader: " + myDataReader["galleryImageID"].ToString() + " ... "); |
galleryImageID[columns] = Convert.ToInt16(myDataReader["galleryImageID"].ToString()); |
galleryImage[columns] = myDataReader["galleryImage"].ToString(); |
//myTable.Rows.Add(new string[] { myDataReader["galleryImageID"].ToString(), myDataReader["galleryImage"].ToString() }); |
} |
else |
{ |
galleryImageID[columns] = 0; |
galleryImage[columns] = "imgPlcHldr.jpg"; |
} |
//Response.Write(myDataReader["galleryImageID"].ToString() + " " + myDataReader["galleryImage"].ToString()); |
} |
//myTable.Rows.Add(new string[] { galleryImageID[1].ToString(), galleryImage[1].ToString(), galleryImageID[2].ToString(), galleryImage[2].ToString(), galleryImageID[3].ToString(), galleryImage[3].ToString() }); |
myTable.Rows.Add(new string[] { galleryImageID[1].ToString(), galleryImage[1].ToString(), galleryImageID[2].ToString(), galleryImage[2].ToString(), galleryImageID[3].ToString(), galleryImage[3].ToString(), galleryImageID[4].ToString(), galleryImage[4].ToString(), galleryImageID[5].ToString(), galleryImage[5].ToString() }); |
break; |
case 2: |
for (int columns = 1; columns <= 5; columns++) |
{ |
if (myDataReader.Read()) |
{ |
//bicycleImageID[columns] = 15; |
//Response.Write("Reader: " + myDataReader["galleryImageID"].ToString() + " ... "); |
galleryImageID[columns] = Convert.ToInt16(myDataReader["galleryImageID"].ToString()); |
galleryImage[columns] = myDataReader["galleryImage"].ToString(); |
//myTable.Rows.Add(new string[] { myDataReader["galleryImageID"].ToString(), myDataReader["galleryImage"].ToString() }); |
} |
else |
{ |
galleryImageID[columns] = 0; |
galleryImage[columns] = "imgPlcHldr.jpg"; |
} |
//Response.Write(myDataReader["galleryImageID"].ToString() + " " + myDataReader["galleryImage"].ToString()); |
} |
//myTable.Rows.Add(new string[] { galleryImageID[1].ToString(), galleryImage[1].ToString(), galleryImageID[2].ToString(), galleryImage[2].ToString() }); |
myTable.Rows.Add(new string[] { galleryImageID[1].ToString(), galleryImage[1].ToString(), galleryImageID[2].ToString(), galleryImage[2].ToString(), galleryImageID[3].ToString(), galleryImage[3].ToString(), galleryImageID[4].ToString(), galleryImage[4].ToString(), galleryImageID[5].ToString(), galleryImage[5].ToString() }); |
break; |
case 1: |
for (int columns = 1; columns <= 5; columns++) |
{ |
if (myDataReader.Read()) |
{ |
//bicycleImageID[columns] = 15; |
//Response.Write("Reader: " + myDataReader["galleryImageID"].ToString() + " ... "); |
galleryImageID[columns] = Convert.ToInt16(myDataReader["galleryImageID"].ToString()); |
galleryImage[columns] = myDataReader["galleryImage"].ToString(); |
//myTable.Rows.Add(new string[] { myDataReader["galleryImageID"].ToString(), myDataReader["galleryImage"].ToString() }); |
} |
else |
{ |
galleryImageID[columns] = 0; |
galleryImage[columns] = "imgPlcHldr.jpg"; |
} |
//Response.Write(myDataReader["galleryImageID"].ToString() + " " + myDataReader["galleryImage"].ToString()); |
} |
//myTable.Rows.Add(new string[] { galleryImageID[1].ToString(), galleryImage[1].ToString() }); |
myTable.Rows.Add(new string[] { galleryImageID[1].ToString(), galleryImage[1].ToString(), galleryImageID[2].ToString(), galleryImage[2].ToString(), galleryImageID[3].ToString(), galleryImage[3].ToString(), galleryImageID[4].ToString(), galleryImage[4].ToString(), galleryImageID[5].ToString(), galleryImage[5].ToString() }); |
break; |
} |
} |
|
|
myDataReader.Close(); |
myConnection.Close(); |
|
|
RadRotator1.DataSource = myTable; |
RadRotator1.DataBind(); |
|
|
} |