New Reply 
Marks Entry Form.cs
seminar class Offline
SP Deserved Member
**********
Posts: 5,362
Threads: 2,998
Joined: Feb 2011
#1
07-05-2011, 02:59 PM

Marks Entry Form.cs

[code]using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Diagnostics;

namespace SchoolManagementSystem
{
public partial class MarksEntryForm : Form
{
OleDbConnection con = new OleDbConnection(ConnectionStringForSMS.MyConnectionString());
public MarksEntryForm()
{
InitializeComponent();
}
int classid, sectionid, exam, count;
string result;
double total;
double avg;
string grade;
string examname, rollno;
double telugu1, telugu2, hindi, eng1, eng2, maths1, maths2, science1, science2, social1, social2, GK, sub13, sub14, sub15;
int max, min;
private bool variable;
int min1, min2, min3, min4, min5, min6, min7, min8, min9, min10, min11, min12, min13, min14, min15;
int max1, max2, max3, max4, max5, max6, max7, max8, max9, max10, max11, max12, max13, max14, max15;

private void cmbClass_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbClass.SelectedIndex != -1 && cmbClass.SelectedIndex != 0)
{
btnSubmit.Visible = true;
btnEdit.Visible = false;
btnUpdate.Visible = false;

cmbSection.Items.Clear();
cmbRollno.Items.Clear();
cmbExamid.Items.Clear();
cmbSection.Text = "--Select";
cmbRollno.Text = "--Select--";
cmbExamid.Text = "--Select--";
lblName.Text = "";


OleDbDataAdapter da1 = new OleDbDataAdapter("SELECT ClassID FROM Class WHERE (ClassName = '" + cmbClass.SelectedItem.ToString() + "') and Medium='" + cmbMedium.SelectedItem.ToString() + "'", con);
DataSet ds1 = new DataSet();
da1.Fill(ds1);

if (ds1.Tables[0].Rows.Count != 0)
{
classid = Convert.ToInt32(ds1.Tables[0].Rows[0][0].ToString());
OleDbDataAdapter da = new OleDbDataAdapter("SELECT [Section] FROM [Section] WHERE (ClassId = " + classid + ") and Medium='" + cmbMedium.SelectedItem.ToString() + "'", con);
DataSet ds = new DataSet();
da.Fill(ds);
cmbSection.Items.Clear();
cmbSection.Items.Add("--Select--");
if (ds.Tables[0].Rows.Count != 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
cmbSection.Items.Add(ds.Tables[0].Rows[i].ItemArray[0].ToString());
}
cmbSection.SelectedIndex = 0;
}
OleDbDataAdapter da3 = new OleDbDataAdapter("SELECT ExamName FROM Exam WHERE (ClassID = " + classid + " ) and Medium='" + cmbMedium.SelectedItem.ToString() + "'", con);
DataSet ds3 = new DataSet();
da3.Fill(ds3);
cmbExamid.Items.Clear();
cmbExamid.Items.Add("--Select--");
for (int j = 0; j < ds3.Tables[0].Rows.Count; j++)
{
cmbExamid.Items.Add(ds3.Tables[0].Rows[j].ItemArray[0].ToString());
}
cmbExamid.SelectedIndex = 0;
}
textbox1.Text = "";
...(1-15)
textbox15.Text = "";

enable();
}

}

public void enable()
{
if (count == 1)
{
textbox1.Enabled = true;
}
else if (count == 2)
{
textbox1.Enabled = true;
textbox2.Enabled = true;
}
else if (count == 3)
{
textbox1.Enabled = true;
textbox2.Enabled = true;
textbox3.Enabled = true;
}
else if (count == 4)
{
textbox1.Enabled = true;
..
textbox4.Enabled = true;
}
else if (count == 5)
{
textbox1.Enabled = true;
..
textbox5.Enabled = true;
}
else if (count == 6)
{
textbox1.Enabled = true;
...
textbox6.Enabled = true;
}
else if (count == 7)
{
textbox1.Enabled = true;
..
textbox7.Enabled = true;
}
else if (count == 8)
{
textbox1.Enabled = true;
...
textbox8.Enabled = true;
}
else if (count == 9)
{
textbox1.Enabled = true;
...
textbox9.Enabled = true;
}
else if (count == 10)
{
textbox1.Enabled = true;
...
textbox10.Enabled = true;
}
else if (count == 11)
{
textbox1.Enabled = true;
...
textbox11.Enabled = true;
}
else if (count == 12)
{
textbox1.Enabled = true;
...
textbox12.Enabled = true;
}
else if (count == 13)
{
textbox1.Enabled = true;
...
textbox13.Enabled = true;
}
else if (count == 14)
{
textbox1.Enabled = true;
..
textbox14.Enabled = true;
}
else if (count == 15)
{
textbox1.Enabled = true;
...
textbox15.Enabled = true;
}

}

private void cmbSection_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbSection.SelectedIndex != 0 && cmbSection.SelectedIndex != -1)
{
lblName.Text = "";
btnSubmit.Visible = true;
btnEdit.Visible = false;
btnUpdate.Visible = false;


OleDbDataAdapter da = new OleDbDataAdapter("SELECT SectionID FROM [Section] WHERE ([Section] = '" + cmbSection.SelectedItem.ToString() + "') and (ClassId = " + classid + ") and Medium='" + cmbMedium.SelectedItem.ToString() + "'", con);
DataSet ds = new DataSet();
da.Fill(ds);

if (ds.Tables[0].Rows.Count != 0)
{
sectionid = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
OleDbDataAdapter da2 = new OleDbDataAdapter("SELECT Admission.RollNo FROM ((Admission INNER JOIN [Section] ON Admission.SectionID = [Section].SectionID) INNER JOIN Class ON Admission.ClassID = Class.ClassID)WHERE ([Section].[Section] = '" + cmbSection.SelectedItem.ToString() + "') AND (Class.ClassName = '" + cmbClass.SelectedItem.ToString() + "') and Admission.Medium='" + cmbMedium.SelectedItem.ToString() + "' and Admission.Active='Yes' order by Admission.RollNo asc", con);
DataSet ds2 = new DataSet();
da2.Fill(ds2);
cmbRollno.Items.Clear();
cmbRollno.Items.Add("--Select--");
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
cmbRollno.Items.Add(ds2.Tables[0].Rows[i].ItemArray[0].ToString());
}

cmbRollno.SelectedIndex=0;

if (ds2.Tables[0].Rows.Count == 0)
{
cmbRollno.Text = "";
}
}
}
}

private void cmbRollno_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbRollno.SelectedIndex != -1 && cmbRollno.SelectedIndex != 0)
{


OleDbDataAdapter da = new OleDbDataAdapter("SELECT Admission.StudentName FROM ((Admission INNER JOIN [Section] ON Admission.SectionID = [Section].SectionID) INNER JOIN Class ON Admission.ClassID = Class.ClassID) WHERE (Admission.ClassID = " + classid + ") AND (Admission.SectionID = " + sectionid + ") and Admission.Medium='" + cmbMedium.SelectedItem.ToString() + "' and Admission.RollNo='"+cmbRollno.SelectedItem.ToString()+"'", con);
DataSet ds = new DataSet();
da.Fill(ds);
lblName.Text = ds.Tables[0].Rows[0][0].ToString();

rollno = cmbRollno.SelectedItem.ToString();
}
}

private void cmbExamid_SelectedIndexChanged(object sender, EventArgs e)
{
btnSubmit.Visible = true;
btnEdit.Visible = false;
btnUpdate.Visible = false;

OleDbDataAdapter da2 = new OleDbDataAdapter("SELECT ExamID FROM Exam WHERE (ExamName = '" + cmbExamid.SelectedItem.ToString() + "') AND (ClassID = " + classid + ") and Medium='"+cmbMedium.SelectedItem.ToString()+"'", con);
DataSet ds2 = new DataSet();
da2.Fill(ds2);
if (ds2.Tables[0].Rows.Count != 0)
{
exam = Convert.ToInt32(ds2.Tables[0].Rows[0][0].ToString());

//OleDbDataAdapter da5 = new OleDbDataAdapter("SELECT MaxMarks, MinMarks FROM Exam WHERE (ClassID = " + classid + " ) AND (ExamName = '" + cmbExamid.SelectedItem.ToString() + "') and Medium='" + cmbMedium.SelectedItem.ToString() + "'", con);
examname = cmbExamid.SelectedItem.ToString();
int zer0 = 0;
# region displaying marks is already inserted
OleDbDataAdapter da1 = new OleDbDataAdapter("SELECT StudentMarks.S1, StudentMarks.S2, StudentMarks.S3, StudentMarks.S4, StudentMarks.S5, StudentMarks.S6, StudentMarks.S7, StudentMarks.S8, StudentMarks.S9, StudentMarks.S10, StudentMarks.S11, StudentMarks.S12, StudentMarks.S13, StudentMarks.S14, StudentMarks.S15, StudentMarks.ExamID FROM (((StudentMarks INNER JOIN [Section] ON StudentMarks.SectionID = [Section].SectionID) INNER JOIN Class ON StudentMarks.ClassID = Class.ClassID) INNER JOIN Exam ON StudentMarks.ExamID = Exam.ExamID) WHERE (Class.ClassID = " + classid + ") AND ([Section].SectionID = " + sectionid + ") AND (StudentMarks.RollNo = '" + rollno + "') AND (Exam.ExamID = " + exam + ") and Exam.Medium='" + cmbMedium.SelectedItem.ToString() + "'", con);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
if (ds1.Tables[0].Rows.Count != 0)
{
btnSubmit.Visible = false;
btnEdit.Visible = true;
btnUpdate.Visible = false;
textbox1.Text = ds1.Tables[0].Rows[0]["S1"].ToString();
textbox2.Text = ds1.Tables[0].Rows[0]["S2"].ToString();
textbox3.Text = ds1.Tables[0].Rows[0]["S3"].ToString();
textbox4.Text = ds1.Tables[0].Rows[0]["S4"].ToString();
textbox5.Text = ds1.Tables[0].Rows[0]["S5"].ToString();
textbox6.Text = ds1.Tables[0].Rows[0]["S6"].ToString();
textbox7.Text = ds1.Tables[0].Rows[0]["S7"].ToString();
textbox8.Text = ds1.Tables[0].Rows[0]["S8"].ToString();
textbox9.Text = ds1.Tables[0].Rows[0]["S9"].ToString();
textbox10.Text = ds1.Tables[0].Rows[0]["S10"].ToString();
textbox11.Text = ds1.Tables[0].Rows[0]["S11"].ToString();
textbox12.Text = ds1.Tables[0].Rows[0]["S12"].ToString();
textbox13.Text = ds1.Tables[0].Rows[0]["S13"].ToString();
textbox14.Text = ds1.Tables[0].Rows[0]["S14"].ToString();
textbox15.Text = ds1.Tables[0].Rows[0]["S15"].ToString();

OleDbDataAdapter da = new OleDbDataAdapter("SELECT SubjectName,MinMarks,MaxMarks FROM Subject WHERE (ClassID = " + classid + ") AND (Medium = '" + cmbMedium.SelectedItem.ToString() + "') and ExamID=" + exam + " ", con);
DataSet ds = new DataSet();
da.Fill(ds);
count = ds.Tables[0].Rows.Count;
if (count == 0)
{
textbox1.Visible = false;
...
textbox15.Visible = false;

label7.Visible = false;
..(7-46)
label46.Visible = false;

MessageBox.Show("No Subjects", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);

}
else if (count == 1)
{
label10.Visible = true;
label32.Visible = true;

textbox1.Visible = true;

textbox1.Enabled = false;

label10.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();

min1=Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[1].ToString());
max1=Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[2].ToString());
label32.Text = max1.ToString();

textbox2.Text = zer0.ToString();
...
label46.Visible = false;


}
else if (count == 2)
{
label10.Visible = true;
label11.Visible = true;

label32.Visible = true;
label33.Visible = true;

textbox1.Visible = true;
textbox2.Visible = true;

textbox1.Enabled = false;
textbox2.Enabled = false;

label10.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
label11.Text = ds.Tables[0].Rows[1].ItemArray[0].ToString();

min1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[1].ToString());
max1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[2].ToString());

min2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[1].ToString());
max2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[2].ToString());

label32.Text = max1.ToString();
label33.Text = max2.ToString();

textbox3.Text = zer0.ToString();
...
label46.Visible = false;
}
else if (count == 3)
{
label10.Visible = true;
label11.Visible = true;
label12.Visible = true;

label32.Visible = true;
label33.Visible = true;
label34.Visible = true;

textbox1.Visible = true;
textbox2.Visible = true;
textbox3.Visible = true;

textbox1.Enabled = false;
textbox2.Enabled = false;
textbox3.Enabled = false;

label10.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
label11.Text = ds.Tables[0].Rows[1].ItemArray[0].ToString();
label12.Text = ds.Tables[0].Rows[2].ItemArray[0].ToString();

min1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[1].ToString());
max1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[2].ToString());

min2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[1].ToString());
max2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[2].ToString());

min3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[1].ToString());
max3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[2].ToString());

label32.Text = max1.ToString();
label33.Text = max2.ToString();
label34.Text = max3.ToString();

textbox4.Text = zer0.ToString();
...
label46.Visible = false;
}
else if (count == 4)
{
label10.Visible = true;
..
label13.Visible = true;

label32.Visible = true;
..
label35.Visible = true;

textbox1.Visible = true;
..
textbox4.Visible = true;

textbox1.Enabled = false;
...
textbox4.Enabled = false;

label10.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
label11.Text = ds.Tables[0].Rows[1].ItemArray[0].ToString();
label12.Text = ds.Tables[0].Rows[2].ItemArray[0].ToString();
label13.Text = ds.Tables[0].Rows[3].ItemArray[0].ToString();


min1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[1].ToString());
max1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[2].ToString());

min2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[1].ToString());
max2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[2].ToString());

min3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[1].ToString());
max3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[2].ToString());

min4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[1].ToString());
max4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[2].ToString());

label32.Text = max1.ToString();
..
label35.Text = max4.ToString();

textbox5.Text = zer0.ToString();
..
label46.Visible = false;
}
else if (count == 5)
{
label10.Visible = true;
..
label36.Visible = true;

textbox1.Visible = true;
..
textbox5.Visible = true;

textbox1.Enabled = false;
..
textbox5.Enabled = false;

label10.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
label11.Text = ds.Tables[0].Rows[1].ItemArray[0].ToString();
label12.Text = ds.Tables[0].Rows[2].ItemArray[0].ToString();
label13.Text = ds.Tables[0].Rows[3].ItemArray[0].ToString();
label14.Text = ds.Tables[0].Rows[4].ItemArray[0].ToString();

min1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[1].ToString());
max1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[2].ToString());

min2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[1].ToString());
max2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[2].ToString());

min3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[1].ToString());
max3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[2].ToString());

min4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[1].ToString());
max4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[2].ToString());

min5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[1].ToString());
max5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[2].ToString());

label32.Text = max1.ToString();
label33.Text = max2.ToString();
label34.Text = max3.ToString();
label35.Text = max4.ToString();
label36.Text = max5.ToString();

textbox6.Text = zer0.ToString();
..
label46.Visible = false;
}
else if (count == 6)
{
label10.Visible = true;
..
label15.Visible = true;

label32.Visible = true;
..
label37.Visible = true;

textbox1.Visible = true;
..
textbox6.Visible = true;

textbox1.Enabled = false;
..
textbox6.Enabled = false;

label10.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
label11.Text = ds.Tables[0].Rows[1].ItemArray[0].ToString();
label12.Text = ds.Tables[0].Rows[2].ItemArray[0].ToString();
label13.Text = ds.Tables[0].Rows[3].ItemArray[0].ToString();
label14.Text = ds.Tables[0].Rows[4].ItemArray[0].ToString();
label15.Text = ds.Tables[0].Rows[5].ItemArray[0].ToString();

min1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[1].ToString());
max1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[2].ToString());

min2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[1].ToString());
max2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[2].ToString());

min3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[1].ToString());
max3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[2].ToString());

min4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[1].ToString());
max4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[2].ToString());

min5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[1].ToString());
max5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[2].ToString());

min6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[1].ToString());
max6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[2].ToString());

label32.Text = max1.ToString();
label33.Text = max2.ToString();
label34.Text = max3.ToString();
label35.Text = max4.ToString();
label36.Text = max5.ToString();
label37.Text = max6.ToString();

textbox7.Text = zer0.ToString();
..
textbox15.Text = zer0.ToString();

textbox7.Visible = false;
...
label46.Visible = false;
}
else if (count == 7)
{
label10.Visible = true;
...
label38.Visible = true;

textbox1.Visible = true;
..
textbox7.Visible = true;

textbox1.Enabled = false;
..
textbox7.Enabled = false;

label10.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
label11.Text = ds.Tables[0].Rows[1].ItemArray[0].ToString();
label12.Text = ds.Tables[0].Rows[2].ItemArray[0].ToString();
label13.Text = ds.Tables[0].Rows[3].ItemArray[0].ToString();
label14.Text = ds.Tables[0].Rows[4].ItemArray[0].ToString();
label15.Text = ds.Tables[0].Rows[5].ItemArray[0].ToString();
label16.Text = ds.Tables[0].Rows[6].ItemArray[0].ToString();

min1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[1].ToString());
max1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[2].ToString());

min2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[1].ToString());
max2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[2].ToString());

min3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[1].ToString());
max3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[2].ToString());

min4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[1].ToString());
max4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[2].ToString());

min5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[1].ToString());
max5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[2].ToString());

min6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[1].ToString());
max6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[2].ToString());

min7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[1].ToString());
max7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[2].ToString());

label32.Text = max1.ToString();
label33.Text = max2.ToString();
label34.Text = max3.ToString();
label35.Text = max4.ToString();
label36.Text = max5.ToString();
label37.Text = max6.ToString();
label38.Text = max7.ToString();

textbox8.Text = zer0.ToString();
textbox9.Text = zer0.ToString();
textbox10.Text = zer0.ToString();
textbox11.Text = zer0.ToString();
textbox12.Text = zer0.ToString();
textbox13.Text = zer0.ToString();
textbox14.Text = zer0.ToString();
textbox15.Text = zer0.ToString();

textbox8.Visible = false;
..
textbox15.Visible = false;

label17.Visible = false;
label18.Visible = false;
label19.Visible = false;
label20.Visible = false;
label22.Visible = false;
label23.Visible = false;
label24.Visible = false;
label26.Visible = false;
label8.Visible = false;
label7.Visible = false;

label39.Visible = false;
..
label46.Visible = false;
}
else if (count == 8)
{
label10.Visible = true;
label11.Visible = true;
label12.Visible = true;
label13.Visible = true;
label14.Visible = true;
label15.Visible = true;
label16.Visible = true;
label17.Visible = true;
label7.Visible = true;
label8.Visible = true;

label32.Visible = true;
..
label39.Visible = true;

textbox1.Visible = true;
..
textbox8.Visible = true;

textbox1.Enabled = false;
..
textbox8.Enabled = false;

label10.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
label11.Text = ds.Tables[0].Rows[1].ItemArray[0].ToString();
label12.Text = ds.Tables[0].Rows[2].ItemArray[0].ToString();
label13.Text = ds.Tables[0].Rows[3].ItemArray[0].ToString();
label14.Text = ds.Tables[0].Rows[4].ItemArray[0].ToString();
label15.Text = ds.Tables[0].Rows[5].ItemArray[0].ToString();
label16.Text = ds.Tables[0].Rows[6].ItemArray[0].ToString();
label17.Text = ds.Tables[0].Rows[7].ItemArray[0].ToString();

label32.Text = max1.ToString();
label33.Text = max2.ToString();
label34.Text = max3.ToString();
label35.Text = max4.ToString();
label36.Text = max5.ToString();
label37.Text = max6.ToString();
label38.Text = max7.ToString();
label39.Text = max8.ToString();

min1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[1].ToString());
max1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[2].ToString());

min2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[1].ToString());
max2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[2].ToString());

min3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[1].ToString());
max3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[2].ToString());

min4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[1].ToString());
max4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[2].ToString());

min5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[1].ToString());
max5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[2].ToString());

min6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[1].ToString());
max6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[2].ToString());

min7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[1].ToString());
max7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[2].ToString());

min8 = Convert.ToInt32(ds.Tables[0].Rows[7].ItemArray[1].ToString());
max8 = Convert.ToInt32(ds.Tables[0].Rows[7].ItemArray[2].ToString());

textbox9.Text = zer0.ToString();
..
textbox15.Text = zer0.ToString();

textbox9.Visible = false;
..
label46.Visible = false;
}
else if (count == 9)
{
label10.Visible = true;
label11.Visible = true;
label12.Visible = true;
label13.Visible = true;
label14.Visible = true;
label15.Visible = true;
label16.Visible = true;
label17.Visible = true;
label18.Visible = true;
label7.Visible = true;
label8.Visible = true;

label32.Visible = true;
..
label40.Visible = true;

textbox1.Visible = true;
..
textbox9.Visible = true;

textbox1.Enabled = false;
..
textbox9.Enabled = false;

label10.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
label11.Text = ds.Tables[0].Rows[1].ItemArray[0].ToString();
label12.Text = ds.Tables[0].Rows[2].ItemArray[0].ToString();
label13.Text = ds.Tables[0].Rows[3].ItemArray[0].ToString();
label14.Text = ds.Tables[0].Rows[4].ItemArray[0].ToString();
label15.Text = ds.Tables[0].Rows[5].ItemArray[0].ToString();
label16.Text = ds.Tables[0].Rows[6].ItemArray[0].ToString();
label17.Text = ds.Tables[0].Rows[7].ItemArray[0].ToString();
label18.Text = ds.Tables[0].Rows[8].ItemArray[0].ToString();

min1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[1].ToString());
max1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[2].ToString());

min2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[1].ToString());
max2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[2].ToString());

min3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[1].ToString());
max3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[2].ToString());

min4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[1].ToString());
max4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[2].ToString());

min5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[1].ToString());
max5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[2].ToString());

min6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[1].ToString());
max6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[2].ToString());

min7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[1].ToString());
max7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[2].ToString());

min8 = Convert.ToInt32(ds.Tables[0].Rows[7].ItemArray[1].ToString());
max8 = Convert.ToInt32(ds.Tables[0].Rows[7].ItemArray[2].ToString());

min9 = Convert.ToInt32(ds.Tables[0].Rows[8].ItemArray[1].ToString());
max9 = Convert.ToInt32(ds.Tables[0].Rows[8].ItemArray[2].ToString());

label32.Text = max1.ToString();
label33.Text = max2.ToString();
label34.Text = max3.ToString();
label35.Text = max4.ToString();
label36.Text = max5.ToString();
label37.Text = max6.ToString();
label38.Text = max7.ToString();
label39.Text = max8.ToString();
label40.Text = max9.ToString();


textbox10.Text = zer0.ToString();
..
textbox15.Text = zer0.ToString();

textbox10.Visible = false;
..
textbox15.Visible = false;

label19.Visible = false;
..
label26.Visible = false;

label41.Visible = false;
..
label46.Visible = false;
}
else if (count == 10)
{
Label7.Visible = true;
..
Label19.Visible = true;

label32.Visible = true;
..
label41.Visible = true;

textbox1.Visible = true;
..
textbox10.Visible = true;

textbox1.Enabled = false;
..
textbox10.Enabled = false;

label10.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
label11.Text = ds.Tables[0].Rows[1].ItemArray[0].ToString();
label12.Text = ds.Tables[0].Rows[2].ItemArray[0].ToString();
label13.Text = ds.Tables[0].Rows[3].ItemArray[0].ToString();
label14.Text = ds.Tables[0].Rows[4].ItemArray[0].ToString();
label15.Text = ds.Tables[0].Rows[5].ItemArray[0].ToString();
label16.Text = ds.Tables[0].Rows[6].ItemArray[0].ToString();
label17.Text = ds.Tables[0].Rows[7].ItemArray[0].ToString();
label18.Text = ds.Tables[0].Rows[8].ItemArray[0].ToString();
label19.Text = ds.Tables[0].Rows[9].ItemArray[0].ToString();

min1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[1].ToString());
max1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[2].ToString());

min2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[1].ToString());
max2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[2].ToString());

min3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[1].ToString());
max3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[2].ToString());

min4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[1].ToString());
max4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[2].ToString());

min5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[1].ToString());
max5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[2].ToString());

min6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[1].ToString());
max6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[2].ToString());

min7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[1].ToString());
max7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[2].ToString());

min8 = Convert.ToInt32(ds.Tables[0].Rows[7].ItemArray[1].ToString());
max8 = Convert.ToInt32(ds.Tables[0].Rows[7].ItemArray[2].ToString());

min9 = Convert.ToInt32(ds.Tables[0].Rows[8].ItemArray[1].ToString());
max9 = Convert.ToInt32(ds.Tables[0].Rows[8].ItemArray[2].ToString());

min10 = Convert.ToInt32(ds.Tables[0].Rows[9].ItemArray[1].ToString());
max10 = Convert.ToInt32(ds.Tables[0].Rows[9].ItemArray[2].ToString());

label32.Text = max1.ToString();
..
label46.Visible = false;
}
else if (count == 11)
{
Label7.Visible = true;
..
Label19.Visible = true;


label32.Visible = true;
..
label42.Visible = true;

textbox1.Visible = true;
..
textbox11.Visible = true;

textbox1.Enabled = false;
..
textbox11.Enabled = false;

label10.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
label11.Text = ds.Tables[0].Rows[1].ItemArray[0].ToString();
label12.Text = ds.Tables[0].Rows[2].ItemArray[0].ToString();
label13.Text = ds.Tables[0].Rows[3].ItemArray[0].ToString();
label14.Text = ds.Tables[0].Rows[4].ItemArray[0].ToString();
label15.Text = ds.Tables[0].Rows[5].ItemArray[0].ToString();
label16.Text = ds.Tables[0].Rows[6].ItemArray[0].ToString();
label17.Text = ds.Tables[0].Rows[7].ItemArray[0].ToString();
label18.Text = ds.Tables[0].Rows[8].ItemArray[0].ToString();
label19.Text = ds.Tables[0].Rows[9].ItemArray[0].ToString();
label20.Text = ds.Tables[0].Rows[10].ItemArray[0].ToString();

min1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[1].ToString());
max1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[2].ToString());

min2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[1].ToString());
max2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[2].ToString());

min3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[1].ToString());
max3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[2].ToString());

min4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[1].ToString());
max4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[2].ToString());

min5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[1].ToString());
max5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[2].ToString());

min6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[1].ToString());
max6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[2].ToString());

min7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[1].ToString());
max7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[2].ToString());

min8 = Convert.ToInt32(ds.Tables[0].Rows[7].ItemArray[1].ToString());
max8 = Convert.ToInt32(ds.Tables[0].Rows[7].ItemArray[2].ToString());

min9 = Convert.ToInt32(ds.Tables[0].Rows[8].ItemArray[1].ToString());
max9 = Convert.ToInt32(ds.Tables[0].Rows[8].ItemArray[2].ToString());

min10 = Convert.ToInt32(ds.Tables[0].Rows[9].ItemArray[1].ToString());
max10 = Convert.ToInt32(ds.Tables[0].Rows[9].ItemArray[2].ToString());

min11 = Convert.ToInt32(ds.Tables[0].Rows[10].ItemArray[1].ToString());
max11 = Convert.ToInt32(ds.Tables[0].Rows[10].ItemArray[2].ToString());

label32.Text = max1.ToString();
label33.Text = max2.ToString();
label34.Text = max3.ToString();
label35.Text = max4.ToString();
label36.Text = max5.ToString();
label37.Text = max6.ToString();
label38.Text = max7.ToString();
label39.Text = max8.ToString();
label40.Text = max9.ToString();
label41.Text = max10.ToString();
label42.Text = max11.ToString();

textbox12.Text = zer0.ToString();
textbox13.Text = zer0.ToString();
textbox14.Text = zer0.ToString();
textbox15.Text = zer0.ToString();

textbox12.Visible = false;
textbox13.Visible = false;
textbox14.Visible = false;
textbox15.Visible = false;

label22.Visible = false;
label23.Visible = false;
label24.Visible = false;
label26.Visible = false;

label43.Visible = false;
label44.Visible = false;
label45.Visible = false;
label46.Visible = false;
}
else if (count == 12)
{
Label7.Visible = true;
..
Label19.Visible = true;

label32.Visible = true;
..
label43.Visible = true;

textbox1.Visible = true;
..
textbox12.Visible = true;

textbox1.Enabled = false;
..
textbox12.Enabled = false;

label10.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
label11.Text = ds.Tables[0].Rows[1].ItemArray[0].ToString();
label12.Text = ds.Tables[0].Rows[2].ItemArray[0].ToString();
label13.Text = ds.Tables[0].Rows[3].ItemArray[0].ToString();
label14.Text = ds.Tables[0].Rows[4].ItemArray[0].ToString();
label15.Text = ds.Tables[0].Rows[5].ItemArray[0].ToString();
label16.Text = ds.Tables[0].Rows[6].ItemArray[0].ToString();
label17.Text = ds.Tables[0].Rows[7].ItemArray[0].ToString();
label18.Text = ds.Tables[0].Rows[8].ItemArray[0].ToString();
label19.Text = ds.Tables[0].Rows[9].ItemArray[0].ToString();
label20.Text = ds.Tables[0].Rows[10].ItemArray[0].ToString();
label22.Text = ds.Tables[0].Rows[11].ItemArray[0].ToString();

min1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[1].ToString());
max1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[2].ToString());

min2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[1].ToString());
max2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[2].ToString());

min3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[1].ToString());
max3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[2].ToString());

min4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[1].ToString());
max4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[2].ToString());

min5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[1].ToString());
max5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[2].ToString());

min6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[1].ToString());
max6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[2].ToString());

min7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[1].ToString());
max7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[2].ToString());

min8 = Convert.ToInt32(ds.Tables[0].Rows[7].ItemArray[1].ToString());
max8 = Convert.ToInt32(ds.Tables[0].Rows[7].ItemArray[2].ToString());

min9 = Convert.ToInt32(ds.Tables[0].Rows[8].ItemArray[1].ToString());
max9 = Convert.ToInt32(ds.Tables[0].Rows[8].ItemArray[2].ToString());

min10 = Convert.ToInt32(ds.Tables[0].Rows[9].ItemArray[1].ToString());
max10 = Convert.ToInt32(ds.Tables[0].Rows[9].ItemArray[2].ToString());

min11 = Convert.ToInt32(ds.Tables[0].Rows[10].ItemArray[1].ToString());
max11 = Convert.ToInt32(ds.Tables[0].Rows[10].ItemArray[2].ToString());

min12 = Convert.ToInt32(ds.Tables[0].Rows[11].ItemArray[1].ToString());
max12 = Convert.ToInt32(ds.Tables[0].Rows[11].ItemArray[2].ToString());

label32.Text = max1.ToString();
label33.Text = max2.ToString();
label34.Text = max3.ToString();
label35.Text = max4.ToString();
label36.Text = max5.ToString();
label37.Text = max6.ToString();
label38.Text = max7.ToString();
label39.Text = max8.ToString();
label40.Text = max9.ToString();
label41.Text = max10.ToString();
label42.Text = max11.ToString();
label43.Text = max12.ToString();

textbox13.Text = zer0.ToString();
textbox14.Text = zer0.ToString();
textbox15.Text = zer0.ToString();

textbox13.Visible = false;
textbox14.Visible = false;
textbox15.Visible = false;

label23.Visible = false;
label24.Visible = false;
label26.Visible = false;

label44.Visible = false;
label45.Visible = false;
label46.Visible = false;
}
else if (count == 13)
{
Label7.Visible = true;
..
Label19.Visible = true;

label32.Visible = true;
..
label44.Visible = true;

textbox1.Visible = true;
..
textbox13.Visible = true;

textbox1.Enabled = false;
..
textbox13.Enabled = false;

label10.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
label11.Text = ds.Tables[0].Rows[1].ItemArray[0].ToString();
label12.Text = ds.Tables[0].Rows[2].ItemArray[0].ToString();
label13.Text = ds.Tables[0].Rows[3].ItemArray[0].ToString();
label14.Text = ds.Tables[0].Rows[4].ItemArray[0].ToString();
label15.Text = ds.Tables[0].Rows[5].ItemArray[0].ToString();
label16.Text = ds.Tables[0].Rows[6].ItemArray[0].ToString();
label17.Text = ds.Tables[0].Rows[7].ItemArray[0].ToString();
label18.Text = ds.Tables[0].Rows[8].ItemArray[0].ToString();
label19.Text = ds.Tables[0].Rows[9].ItemArray[0].ToString();
label20.Text = ds.Tables[0].Rows[10].ItemArray[0].ToString();
label23.Text = ds.Tables[0].Rows[11].ItemArray[0].ToString();
label22.Text = ds.Tables[0].Rows[12].ItemArray[0].ToString();

min1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[1].ToString());
max1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[2].ToString());

min2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[1].ToString());
max2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[2].ToString());

min3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[1].ToString());
max3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[2].ToString());

min4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[1].ToString());
max4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[2].ToString());

min5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[1].ToString());
max5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[2].ToString());

min6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[1].ToString());
max6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[2].ToString());

min7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[1].ToString());
max7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[2].ToString());

min8 = Convert.ToInt32(ds.Tables[0].Rows[7].ItemArray[1].ToString());
max8 = Convert.ToInt32(ds.Tables[0].Rows[7].ItemArray[2].ToString());

min9 = Convert.ToInt32(ds.Tables[0].Rows[8].ItemArray[1].ToString());
max9 = Convert.ToInt32(ds.Tables[0].Rows[8].ItemArray[2].ToString());

min10 = Convert.ToInt32(ds.Tables[0].Rows[9].ItemArray[1].ToString());
max10 = Convert.ToInt32(ds.Tables[0].Rows[9].ItemArray[2].ToString());

min11 = Convert.ToInt32(ds.Tables[0].Rows[10].ItemArray[1].ToString());
max11 = Convert.ToInt32(ds.Tables[0].Rows[10].ItemArray[2].ToString());

min12 = Convert.ToInt32(ds.Tables[0].Rows[11].ItemArray[1].ToString());
max12 = Convert.ToInt32(ds.Tables[0].Rows[11].ItemArray[2].ToString());

min13 = Convert.ToInt32(ds.Tables[0].Rows[12].ItemArray[1].ToString());
max13 = Convert.ToInt32(ds.Tables[0].Rows[12].ItemArray[2].ToString());

label32.Text = max1.ToString();
label33.Text = max2.ToString();
label34.Text = max3.ToString();
label35.Text = max4.ToString();
label36.Text = max5.ToString();
label37.Text = max6.ToString();
label38.Text = max7.ToString();
label39.Text = max8.ToString();
label40.Text = max9.ToString();
label41.Text = max10.ToString();
label42.Text = max11.ToString();
label43.Text = max12.ToString();
label44.Text = max13.ToString();

textbox14.Text = zer0.ToString();
textbox15.Text = zer0.ToString();

textbox14.Visible = false;
textbox15.Visible = false;

label24.Visible = false;
label26.Visible = false;

label45.Visible = false;
label46.Visible = false;
}
else if (count == 14)
{
Label7.Visible = true;
..
Label19.Visible = true;

label32.Visible = true;
..
label45.Visible = true;

textbox1.Visible = true;
..
textbox14.Visible = true;

textbox1.Enabled = false;
..
textbox14.Enabled = false;

label10.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
label11.Text = ds.Tables[0].Rows[1].ItemArray[0].ToString();
label12.Text = ds.Tables[0].Rows[2].ItemArray[0].ToString();
label13.Text = ds.Tables[0].Rows[3].ItemArray[0].ToString();
label14.Text = ds.Tables[0].Rows[4].ItemArray[0].ToString();
label15.Text = ds.Tables[0].Rows[5].ItemArray[0].ToString();
label16.Text = ds.Tables[0].Rows[6].ItemArray[0].ToString();
label17.Text = ds.Tables[0].Rows[7].ItemArray[0].ToString();
label18.Text = ds.Tables[0].Rows[8].ItemArray[0].ToString();
label19.Text = ds.Tables[0].Rows[9].ItemArray[0].ToString();
label20.Text = ds.Tables[0].Rows[10].ItemArray[0].ToString();
label24.Text = ds.Tables[0].Rows[11].ItemArray[0].ToString();
label22.Text = ds.Tables[0].Rows[12].ItemArray[0].ToString();
label23.Text = ds.Tables[0].Rows[13].ItemArray[0].ToString();

min1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[1].ToString());
max1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[2].ToString());

min2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[1].ToString());
max2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[2].ToString());

min3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[1].ToString());
max3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[2].ToString());

min4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[1].ToString());
max4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[2].ToString());

min5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[1].ToString());
max5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[2].ToString());

min6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[1].ToString());
max6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[2].ToString());

min7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[1].ToString());
max7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[2].ToString());

min8 = Convert.ToInt32(ds.Tables[0].Rows[7].ItemArray[1].ToString());
max8 = Convert.ToInt32(ds.Tables[0].Rows[7].ItemArray[2].ToString());

min9 = Convert.ToInt32(ds.Tables[0].Rows[8].ItemArray[1].ToString());
max9 = Convert.ToInt32(ds.Tables[0].Rows[8].ItemArray[2].ToString());

min10 = Convert.ToInt32(ds.Tables[0].Rows[9].ItemArray[1].ToString());
max10 = Convert.ToInt32(ds.Tables[0].Rows[9].ItemArray[2].ToString());

min11 = Convert.ToInt32(ds.Tables[0].Rows[10].ItemArray[1].ToString());
max11 = Convert.ToInt32(ds.Tables[0].Rows[10].ItemArray[2].ToString());

min12 = Convert.ToInt32(ds.Tables[0].Rows[11].ItemArray[1].ToString());
max12 = Convert.ToInt32(ds.Tables[0].Rows[11].ItemArray[2].ToString());

min13 = Convert.ToInt32(ds.Tables[0].Rows[12].ItemArray[1].ToString());
max13 = Convert.ToInt32(ds.Tables[0].Rows[12].ItemArray[2].ToString());

min14 = Convert.ToInt32(ds.Tables[0].Rows[13].ItemArray[1].ToString());
max14 = Convert.ToInt32(ds.Tables[0].Rows[13].ItemArray[2].ToString());

label32.Text = max1.ToString();
label33.Text = max2.ToString();
label34.Text = max3.ToString();
label35.Text = max4.ToString();
label36.Text = max5.ToString();
label37.Text = max6.ToString();
label38.Text = max7.ToString();
label39.Text = max8.ToString();
label40.Text = max9.ToString();
label41.Text = max10.ToString();
label42.Text = max11.ToString();
label43.Text = max12.ToString();
label44.Text = max13.ToString();
label45.Text = max14.ToString();


textbox15.Text = zer0.ToString();

textbox15.Visible = false;

label26.Visible = false;
label46.Visible = false;

}
else if (count == 15)
{
Label7.Visible = true;
..
Label19.Visible = true;

label32.Visible = true;
..
label46.Visible = true;

textbox1.Visible = true;
..
textbox15.Visible = true;

textbox1.Enabled = false;
..
textbox15.Enabled = false;

label10.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
label11.Text = ds.Tables[0].Rows[1].ItemArray[0].ToString();
label12.Text = ds.Tables[0].Rows[2].ItemArray[0].ToString();
label13.Text = ds.Tables[0].Rows[3].ItemArray[0].ToString();
label14.Text = ds.Tables[0].Rows[4].ItemArray[0].ToString();
label15.Text = ds.Tables[0].Rows[5].ItemArray[0].ToString();
label16.Text = ds.Tables[0].Rows[6].ItemArray[0].ToString();
label17.Text = ds.Tables[0].Rows[7].ItemArray[0].ToString();
label18.Text = ds.Tables[0].Rows[8].ItemArray[0].ToString();
label19.Text = ds.Tables[0].Rows[9].ItemArray[0].ToString();
label20.Text = ds.Tables[0].Rows[10].ItemArray[0].ToString();
label26.Text = ds.Tables[0].Rows[11].ItemArray[0].ToString();
label22.Text = ds.Tables[0].Rows[12].ItemArray[0].ToString();
label23.Text = ds.Tables[0].Rows[13].ItemArray[0].ToString();
label24.Text = ds.Tables[0].Rows[14].ItemArray[0].ToString();

min1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[1].ToString());
max1 = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[2].ToString());

min2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[1].ToString());
max2 = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[2].ToString());

min3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[1].ToString());
max3 = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[2].ToString());

min4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[1].ToString());
max4 = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[2].ToString());

min5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[1].ToString());
max5 = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[2].ToString());

min6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[1].ToString());
max6 = Convert.ToInt32(ds.Tables[0].Rows[5].ItemArray[2].ToString());

min7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[1].ToString());
max7 = Convert.ToInt32(ds.Tables[0].Rows[6].ItemArray[2].ToString());

min8 = Convert.ToInt32(ds.Tables[0].Rows[7].ItemArray[1].ToString());
max8 = Convert.ToInt32(ds.Tables[0].Rows[7].ItemArray[2].ToString());

min9 = Convert.ToInt32(ds.Tables[0].Rows[8].ItemArray[1].ToString());
Find
Reply
New Reply 

Important Note..!

If you are not satisfied with above reply ,..Please

ASK HERE

So that we will collect data for you and will made reply to the request....OR try below "QUICK REPLY" box to add a reply to this page
Popular Searches: www 123seminar con, final b a 6 sem internal marks, mysore university ba ia marks, marks analysis srs, www lottarysongbad con, mysore university mba ia marks, mysour univarcity b a intranal marks,

[-]
Quick Reply
Message
Type your reply to this message here.
Image Verification
Please enter the text contained within the image into the text box below it. This process is used to prevent automated spam bots.
Image Verification
(case insensitive)

Possibly Related Threads...
Thread Author Replies Views Last Post
  What are steps involved in creating a form in Access? smart paper boy 0 1,244 29-07-2011, 12:15 PM
Last Post: smart paper boy
  Student Marks Report.cs seminar class 0 1,749 07-05-2011, 03:00 PM
Last Post: seminar class
  Entry Forms ,Admission Form: seminar class 0 1,286 07-05-2011, 02:53 PM
Last Post: seminar class
  Allot Roll No Form: seminar class 0 1,446 07-05-2011, 02:52 PM
Last Post: seminar class

Forum Jump:

Contact Us | Student Seminar Report & Project Report With Presentation (PPT,PDF,DOC,ZIP) | Return to Top | Lite (Archive) Mode | RSS Syndication