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

Abraham Olatubosun

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Karthik Elumalai10y ago
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 Srivastava10y ago
You can try this,Best example of stored procedure and c# class.
https://msdn.microsoft.com/en-us/data/gg699321.aspx
Midhun Tp10y ago
Hi,
Please use this method in class-
publicDataSetgetdata(stringParam1)
{
DataSetds=newDataSet();
using(SqlConnectionconn=newSqlConnection("ConnectionString"))
{
SqlCommandsqlComm=newSqlCommand("ProcedureName",conn);
sqlComm.Parameters.AddWithValue("@param1",Param1);
sqlComm.CommandType=CommandType.StoredProcedure;
SqlDataAdapterda=newSqlDataAdapter();
da.SelectCommand=sqlComm;
da.Fill(ds);
}
returnds;
}