Make this function with Ado.net code
public DataTable selectstudent()
{
com.Connection = con;
con.Open();
com.CommandText = "select StudentId,StudentName,StudentFees from Student inner join Fees on student.StudentId=fees.StudentId Where StudentFees=0";
com.CommandType=CommandType.Text;
SqlDataReader sdr= com.ExecuteReader();
DataTable dt=new DataTable();
dt.Load(sdr);
con.Close();
return dt;
}
Then..
in The Load Form
make An object With The Class Which Contain The Function
And..
DataTable Dt=ClassObject.selectstudent();
ListView.DataSource=Dt;