public speed_tabe_info ViewSpeed_Category(string trip_category) { con.Open(); SqlCommand cmd = new SqlCommand("ViewSpeed_Category", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter p = new SqlParameter(); p = cmd.Parameters.Add("@trip_category", SqlDbType.VarChar); p.Value = trip_category; SqlDataReader read = cmd.ExecuteReader(); speed_tabe_info info = new speed_tabe_info(); if (read.Read()) { info.Speed = float.Parse(read["speed"].ToString()); info.Trip_Category = read["trip_category"].ToString(); } else { info.Speed = 1000.1000F; } read.Close(); con.Close(); return(info); }
public void UpdateSpeed(speed_tabe_info info) { con.Open(); SqlCommand cmd = new SqlCommand("Update_speed", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter p = new SqlParameter(); p = cmd.Parameters.Add("@trip_category", SqlDbType.VarChar); p.Value = info.Trip_Category; p = cmd.Parameters.Add("@speed", SqlDbType.Float); p.Value = info.Speed; cmd.ExecuteNonQuery(); con.Close(); }