User-1121304814 posted
I am building a web service api that gets data via Stored Procedures from a db and provides the result.
so my xamarin(android/iOS) mobile app can get the data from my web api current i able to get single row,
but i didn't know how to pull all data .
here the code can anyone help me with this and improve.
this my first time doing web api and totally new to me so hope you guys can show me some eg.
public class sEmployeeRecords
{
public string sName { get; set; }
public string sPay { get; set; }
}
public List<sEmployeeRecords> Get(int id,string iname)
{
List<sEmployeeRecords> employeeRecords = new List<sEmployeeRecords>();
var con1 = ConfigurationManager.ConnectionStrings["EmployeeDB"];
string strConn = con1.ConnectionString;
using (SqlConnection con = new SqlConnection(strConn))
{
con.Open();
SqlCommand cmd = new SqlCommand("vEmployeeData", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Mode", "VIEW BY ID");
cmd.Parameters.AddWithValue("@ID", id);
cmd.Parameters.AddWithValue("@Name", "");
cmd.ExecuteNonQuery();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
sEmployeeRecords f = new sEmployeeRecords();
f.sName = reader["FirstName"].ToString();
f.sPay = reader["Salary"].ToString();
employeeRecords.Add(f);
}
}
reader.Close();
con.Close();
}//END USING
return employeeRecords;
}
Thank You.
