Answer to problem 1 ------------------- 1. Add a datagridview to your form. 2. Dont add any column to it add a quote to retrieve data from the database 1. connectionstring e.g string conStr="Add the relevent connection to the database" 2. a function to retrieve the data. Create a class called it DataAccess
using system.data;
using system.data.oleddb;
public class DataAccess
{
public void Show(string sql, string con, datagridview dt)
{
//add logic to retieve record from database
}
}
Then you can call this class to pupulate any datagridview with any number of rows or columns without any modifications. If you want a complete quote let me know (lnkgoeng@webmail.co.za)