AboutSyed Rizwan Muhammad Rizvi Expertise I can answers questions regarding web based and desktop based programming in VB.Net. Which can include SOAP, XML, Custom Controls, COM Interoperability etc.
Experience Have been working in this specific area for last 2 years previously I was a VB 6 Developer with experties in other languages as well. Total 10 years of programming experience.
Question I have a stored procedure that returns a number of records. I need to cycle through these records (datarows now?) and use the info from the fields to populate an Excel spreadsheet. The Excel part i have down. But I am new to .NET and my experience was with Record Sets. First, How do I call a stored Procedure from my SQL Server DB and Second how do I loop through the results like i used to with the recordsets using the movenext command? Thanks for any consideration in advance.
Answer The things in .Net are pretty similar to ADO in VB.
System.Data.OleDB and other native Database namespaces are what you need to research into
They all have a Connection,Command, And DataReader classes.
Search for OLEDBCommand and OLEDBConnect and OLEDBDataReader
