public List<lEntity> selectEntry(Entity)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand command = new SqlCommand("sp_proc", con);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@transid", obect_Entity.Transid);
List<lEntity> objEntities = new List<Entity>();
try
{
SqlDataReader sqlDataReader = command.ExecuteReader();
while (sqlDataReader.Read())
{
AccessoryPurchaseBillEntity obj = new AccessoryPurchaseBillEntity();
if (!Convert.IsDBNull(sqlDataReader["transid"]))
obj.Transid = sqlDataReader.GetString(sqlDataReader.GetOrdinal("transid"));
if (!Convert.IsDBNull(sqlDataReader["receiveqty"]))
{
try
{
obj.ReceiveQty = float.Parse(sqlDataReader["receiveqty"].ToString());
}
catch (Exception e) { obj.ReceiveQty = 0; }
}
objEntities.Add(obj);
}
}
catch (Exception e)
{
}
finally
{
con.Close();
}
return objEntities;
}
Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator