Dear All,

 Please, I have Visual Studio 2005 , How Can I use Gridview in Web Site to Retreive Data from MSACCESS 2002 Database without using (AccessDataSource) Control , Only using C# Code? Can I do that?

Hi....

I dont understand what you meant by "without using AccessDataSource control"

Yes... u can do that

But u need to create an object of type AccessDataSource at Runtime

like this....

    protected void Page_Load(object sender, EventArgs e)
    {
        AccessDataSource shyam=new AccessDataSource("c:\\shyam.mdb","SELECT * FROM shyam");
        GridView1.DataSource = shyam;
        GridView1.DataBind();
    }

Thanks Much,
Shyam

The .NET Underground Portal
www.pureportals.com/developers