public void Block_Details()
{
Console.WriteLine("Displaying Block details!!!");
sqlad = new SqlDataAdaptor("Seclect * from Block", conn);
db = new DataSet();
sqlad.Fill(db);
if (db != null)
{
for (int i = 0; i < db.Tables[0].Rows.Count; i++)
{
Console.WriteLine("Block ID: " + db.Tables[0].Rows[i]["BNo"] + " | Block Name: " + db.Tables[0].Rows[i]["BName"]);
}
}
}
public void Student_Details()
{
Console.WriteLine("Student Details!!!");
sqlad = new SqlDataAdaptor("Select * from Student", conn);
db = new DataSet();
sqlad.Fill(db);
if (db != null)
{
for (int i = 0; i < db.Tables[0].Rows.Count; i++)
{
Console.WriteLine("RollNo.: " + db.Tables[0].Rows[i]["RNo"] + " | Name: " + db.Tables[0].Rows[i]["Name"] + " | Block: " + db.Tables[0].Rows[i]["BNo"]);
}
}
}
public void assign_block()
{
Console.WriteLine("Assigning block!!!");
string query = "execute block_of_Student;";
sqlad = new SqlDataAdaptor(query, conn);
db = new DataSet();
sqlad.Fill(db);
if (db != null)
{
for (int i = 0; i < db.Tables[0].Rows.Count; i++)
{
Console.WriteLine("RollNo: " + db.Tables[0].Rows[i]["RNo"] + " | Name: " + db.Tables[0].Rows[i]["Name"] + " | Block_Name:" + ds.Tables[0].Rows[i]["BName"]);
}
}
}
