public employee search(int i)
{
SqlConnection con = getconnection();
employee e = new employee();
SqlCommand sc = new SqlCommand("select * from emp where id = @abc", con);
con.Open();
sc.Parameters.AddWithValue("@abc", i);
SqlDataReader sd = sc.ExecuteReader();
if (sd.HasRows)
{
while (sd.Read())
{
e.Id = Convert.ToInt32(sd["id"]);
e.Name = sd["name"].ToString();
e.Salary = Convert.ToSingle(sd["salary"]);
break;
}
}
return(e);
}