How To’s, Tech Software, Utilities, Tutorials, Gadgets

Here’s the algorithm:Make sure you’ve installed Oracle Client firstOpen Visual Studio .NET and choose in design viewClick Toolbox, Data, and drag SqlDataSource.Choose Configure Data SourceAnd then New ConnectionChange Data Source into Oracle DatabaseEnter Server Name with your database nameDon’t forget to fill Username and PasswordTo check whether connection successfull or not, click button Test Connection.If you see information message box: “Test connection succeeded”, it means that you’re successfully connected to Oracle and ready to work.Then click NextConfigure the Select Statement. Select table name or view you wanna show and also some columns too. There’re some options like Where, Order by, and AdvancedClick Next and Test Query if you wanna check whether it works well or not.Finish!Ready to work!What about the code? Maybe you can help me to switch it to the code ….Read more at: Knowledge to Share (http://studiawan.blogspot.com/2007/06/asp-net-to-oracle-try-this.html)