9 replies to this topic

[elizabethmwashuma]

guys lease help...i dont have data adapter in my toolbox under data...kindly tell me wat to do

[gokuajmes]

Huh DataAdapter ? :p
what are you using Visual Studio 2008 ? what sort of project are you working on Windows / ASP.NET ?
ASP.NET does not come with data adapter control.You need to create dataadapter's via Code.
Windows forms,then try resetting the toolbox once.
Right Click ToolBox --> [Reset ToolBox]

[elizabethmwashuma]

i am using visual studio 2005...ma trying to connect c# to access database but am having errors....object string not set to an instance of an object...ok thats problem number two but then my toolbox does not contain an oledb adapter, oledb connection .....how else will i connect the database to my application...am using ms access 2007...kindly help

regards

mwashuma

[Davide]

Visual Studio 2005 doesn't have the .NET Framework 3.5, and some components might be missing. I suggest using Visual C# Express 2008 or 2010. I am not sure on my answer, but you can try right-clicking on the toolbox and selecting "Choose Items". In the window that appears, search for your data adapter.

[gokuajmes]

OK this is what you need to do to get the OleDbAdapter back into the ToolBox.
1.Right Click in 'General' in Tool Box
2.Select 'Choose Items'
3.Wait for some time ,have a coffee
4.A dialog box is shown.
Select '.NET Framework Components' in the Tab
In the 'Filter' Textbox type 'Ole' now you will have 'OleDBDataAdapter' listed last in the above listview.
5.Put a Checkmark & click OK.

you are done

[Davide]

Keep in mind that you might need .NET Framework 3.5 though.

[Davide]

GokuaJmes's answer is good and more explicit indeed.

[Davide]

Good luck with the project!

[elizabethmwashuma]

hey you are the best...it worked.....VRY GREATFULL..................to the second problem, i cannot use the data adapter,i.e. when i create a new connection and i test the connection, i get invalid authorization specification.

wat do i do.....am trying to connect csharp to access database...kindly show me the steps especially on the design form. i also need help in knowing what to code ...am getting errors. unhandled exception especially object reference not set to an instance of an object, or System.InvalidCastException: Specified cast is not valid....please assist

regards

mwashuma

[Davide]

"object reference not set to an instance of an object"
This happens if you have an array and tried to get a value from an index that doesn't exist. Like, you have an array: string[] myArray = new string[5]; Obviously myArray[6] won't work.

On the design form, go to your dataGridView and click on DataSource. Select your database once you get there.

"System.InvalidCastException: Specified cast is not valid"
No idea, please past troublesome code.