How to use a class to read data from SQL stored procedure

Question

Dear C-sharpcorner Team I want to appreciate you all for assist me when i have a coding challenge. I was giving a task to use a class written by my ex-colleaque to read data from a store procedure i am to generate an XML file from that class which i can use DataSet or DataTable. Can any one from the team share how to start reading the data with the class i know how to reference the methods in the class but don't know how to use it to collect data from the store procedure Attached is the class and the store procedure files. please don't disable my question as i have done many tries with no positive result so i need your help to speed my output as this part of my performance report. thank you all as i await you usual assistance

Karthik Elumalai · Answer

Hi Abraham Olatubosun Hope the below link will surely helpful for you. http://www.c-sharpcorner.com/article/using-stored-procedures-with-Asp-Net/ kindly let me know your thoughts. thanks karthik

Bikesh Srivastava · Answer

You can try thisBest example of stored procedure and c# class. https://msdn.microsoft.com/en-us/data/gg699321.aspx

Midhun T P · Answer

Hi Please use this method in class- public DataSetgetdata( string Param1) { DataSetds= new DataSet(); using (SqlConnectionconn= new SqlConnection( ConnectionString )) { SqlCommandsqlComm= new SqlCommand( ProcedureName conn); sqlComm.Parameters.AddWithValue( @param1 Param1); sqlComm.CommandType=CommandType.StoredProcedure; SqlDataAdapterda= new SqlDataAdapter(); da.SelectCommand=sqlComm; da.Fill(ds); } return ds; }