I have a problem when i want to read data from Access table using this code:-


public void insert()
{
MyCommand.Comma ndText = "Select UserName from User_Login Where ID=' 1 ';
MyCommand.Comma ndType = CommandType.Tex t;
MyCommand.Conne ction = MyConnection;

MyAdapter.Selec tCommand = MyCommand;
MyAdapter.Fill( MyTable);

...