dataset to formview

[Arif Liminto]

Hi, I am still a newbie in ASP.net, sorry if I am asking stupid message. I am trying to develop some website using asp.net 2.0 and I currently have some difficulity to use one of the ToolBox called FormView for displaying the data from database I want to transfer from microsoft access to FormView here is the code

OleDbConnection myConnection = new OleDbConnection(myConnectionString);
myConnection.Open();

OleDbCommand myCommand = new OleDbCommand();
myCommand.Conn = myConnection;
myCommand.CommandText = "SELECT * FROM [USER] WHERE UserName = @UserName";
myCommand.Parameters.AddWithValue("@UserName",sUserName);

OleDbDataAdapter myAdapter = new OleDbDataAdapter(myCommand);

myDataAdapter.Fill(myDataSet);

FORM_View_Users.DataSource = myDataSet;
FORM_View_Users.DataBind();

myConnection.Close();

I think I did with the correct way because when I tried to run the website, I did not get any exception error, However, I couldn't see the formview, it just blank . Is there any attribute that I need to fill in so I can see the data in the Form_View ? thanks

[Christian Graus]

Have you stepped through the code to make sure that there is data in the dataset ?

Christian Graus Driven to the arms of OSX by Vista.

[Arif Liminto]

yeah I've stepped through the code i also try to add some debug code

bool bResult = false;

if(myDataAdapter.Fill(myDataSet) > 0)
{
bResult = true;
}

and I monitor the value of bResult, the result is true. if I use GridView,it works perfectly, so I dont think there is a mistake in transferring from database to dataset, I suspect the problem when transfering from DataSet to FormView, which i use the same mechanism when i use GridView set the data source -> FormView.DataSource = DataSet; bind the data -> FormView.DataBind(); is there anything that I need to add more? Thanks so much